进行中

associating SQL database user to SQL Login

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

技能: 数据库管理, 工程, MySQL, PHP, 软件构架, 软件测试, SQL

查看更多: old database, msn engineering, access database expert, yahoo e mail login, STALL, move sql, e-mail database, access to sql, access 2000 database, sql created, expert machine, windows phone mssql, login msn yahoo, access sql expert, windows phone login, php sql 2000, sql select select, sql select, sql problem, mssql move database server, yahoo mail login, windows phone select, database mssql, windows phone database, yahoo user

About the Employer:
( 4 reviews ) United States

项目ID: #3072076

已悬赏给:

vw569064vw

See private message.

$5 USD 在1天内
(5条评论)
1.9

12名威客为此工作的平均竞标价是$25

psergei

See private message.

$42.5USD 在1天里
(449条评论)
8.6
relisolsolutions

See private message.

$4.25USD 在1天里
(24条评论)
5.2
jspsenthilvw

See private message.

$17USD 在1天里
(22条评论)
3.9
vw1073978vw

See private message.

$21.25USD 在1天里
(15条评论)
3.0
sabanayagamj

See private message.

$15.3USD 在1天里
(1条评论)
0.7
franja

See private message.

$25.5USD 在1天里
(0条评论)
0.0
muktimedial

See private message.

$38.25USD 在1天里
(0条评论)
0.0
auliavw

See private message.

$42.5USD 在1天里
(0条评论)
0.0
patdeve

See private message.

$42.5USD 在1天里
(0条评论)
0.0
villelm

See private message.

$12.75USD 在1天里
(0条评论)
0.0
mkimvw

See private message.

$29.75USD 在1天里
(0条评论)
0.0