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