question

sqlqa avatar image
sqlqa asked

After Migration Login problem even use sp_change_users_login

Hi, We Have Recently Migrated from SQL 2005 to SQL 2008 of one database for one machine to other. After use backup/restore method. I used sp_change_users_login 'report' method to find Orphan user. TestingDBuser---Orphan user. I have created login in SQL 2008 from SQL 2005 already saved script of that login as see below CREATE LOGIN [TestingDBuser] WITH PASSWORD=N'ë@á0Ðò?ú3 ™JôûçßCoµÜýÓåŒñ¿ºT', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO After created Login in SQL 2008 I checked as following in SQL 2008 as see below: USE MASTER GO SELECT name as SQLServerLogIn,SID as SQLServerSID FROM sys.syslogins WHERE [name] = 'TestingDBuser' GO USE TestingDB GO SELECT name DataBaseID,SID as DatabaseSID FROM sysusers WHERE [name] = 'TestingDBuser' Even SQLServerSID & DatabaseSID are EQUAL. But till now I cant able to login for TestingDBuser Can any one suggest me why it did not login? ![alt text][1] ![alt text][2] [1]: /storage/temp/1521-after+run+sp_change_users_login+see.jpg [2]: /storage/temp/1524-login+error.jpg
loginmigration
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.