----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: ramaprasad Message 2 in Discussion Hi, Login mismatches always exist unless you use only Windows NT domain accounts and restore or attach the database to another server within the same domain trust structure (so that the NT SIDs are still recognized). SQL Server SIDs for SQL security logins are globally unique IDs (GUIDs), so they're unique each time they're created on each server. Thus, the SIDs won't be the same when you create a name on Server A and then create a name again on Server B. Local NT accounts have a similar problem except that their SIDs come from NT. If you have restored a backup and restored it in some other server and then u r getting this error then below is the solution for u r problem. 1. Open Query analyzer and connect to the database u restored. 2. Run below query in that database EXEC sp_change_users_login 'Update_One', 'Mary', 'NewMary' Where Merry is the User name of the db and NewMerry is pwd. Now u r code should work. Thanks and Regards, Ramaprasad Upadhyaya Wipro Technologies Bangalore MCAD | MS india community star ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
