associating SQL database user to SQL Login

Completed Posted Jan 18, 2004 Paid on delivery
Completed Paid on delivery

Need help from an SQL Coder/DB expert for 1 hour or so.

I am trying to move a database from one machine to another.

I have moved the mdf/log files to the NEW server under database name 'tibcodb'and attached the database. The NEW database has a user 'tibco' that owns most tables.

I have created new SQL Login 'tibco' on new database that has same name as user on old database. I then ran:

sp_change_users_login 'update_one', 'tibco', 'tibco'

This gave my new SQL login 'tibco' access to the database.

My problem is that if I go to database 'tibcodb' -> Users -> and select user tibco - there is stall no associated Login. Thisis a big problem for me.

Need help on how to solve this.

MSSQL 2000 on Windows 2000 database/server

## Deliverables

1) E-mail with steps to solve this problem.

2) Some time on phone and MSN or YAHOO Messenger to help me solve this problem.

## Platform

MS SQL Server 2000 on Windows 2000

Database Administration Engineering MySQL PHP Software Architecture Software Testing SQL

Project ID: #3072076

About the project

12 proposals Remote project Active Jan 20, 2004

Awarded to:

vw569064vw

See private message.

$5 USD in 1 day
(5 Reviews)
1.9

12 freelancers are bidding on average $25 for this job

psergei

See private message.

$42.5 USD in 1 day
(449 Reviews)
8.6
relisolsolutions

See private message.

$4.25 USD in 1 day
(24 Reviews)
5.2
jspsenthilvw

See private message.

$17 USD in 1 day
(22 Reviews)
3.9
vw1073978vw

See private message.

$21.25 USD in 1 day
(15 Reviews)
3.0
sabanayagamj

See private message.

$15.3 USD in 1 day
(1 Review)
0.7
franja

See private message.

$25.5 USD in 1 day
(0 Reviews)
0.0
muktimedial

See private message.

$38.25 USD in 1 day
(0 Reviews)
0.0
auliavw

See private message.

$42.5 USD in 1 day
(0 Reviews)
0.0
patdeve

See private message.

$42.5 USD in 1 day
(0 Reviews)
0.0
villelm

See private message.

$12.75 USD in 1 day
(0 Reviews)
0.0
mkimvw

See private message.

$29.75 USD in 1 day
(0 Reviews)
0.0