February 19, 2010 at 5:02 am
i have a sql authenticated login "event_test". i transfer this login from one Sql server to another.
but when i tried to login in to destination server . i got login failed error
script used to migrate
CREATE LOGIN [event_test] WITH PASSWORD=N'´ÂjPOjß³SÂàæ´L}\JGÃ)=Û&¥RÚ', DEFAULT_DATABASE=[tempdb], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC sys.sp_addsrvrolemember @loginame = N'event_test', @rolename = N'sysadmin'
GO
ALTER LOGIN [event_test] DISABLE
why its happening ?
And i dont want to reset it on dest. server then what should i do ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 19, 2010 at 9:22 am
A little more information would be helpful. When you say you can't login, are you saying you can't access a database on the second server that was restored from the first server?
February 19, 2010 at 9:32 am
You need to move the login to a different SQL Server using sp_help_revlogin
Follow the procedure here and choose only that login you need to move..
http://support.microsoft.com/kb/918992/[/url]
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply