July 8, 2011 at 9:28 am
Hi,
I migrated the sql server logins from 2000 to 2008. They got created with the same sid but not the passwords , I am testing the logins and I cannot login using them not the sql or windows. Can anyone please help?
Thanks
SVR
July 8, 2011 at 11:12 am
Did you use SSIS by any chance?
See if the method under section titled "A complete resolution to transfer logins and passwords between different versions of SQL Server" works out better for you:
http://support.microsoft.com/kb/246133
EDIT: Note, I have not tried this from 2000 to 2008 but worst case you could go from 2000 to 2005 and then migrate everything from 2005 to 2008 (http://support.microsoft.com/kb/918992).
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 8, 2011 at 1:55 pm
I did read those.
I have already migrated the logins, the problem is the passwords are not working. I tried to login with a different ID. the error that is logged is password mismatch.
July 9, 2011 at 10:40 am
Hi, I tried everything.
I tried using the scripts and also tried the ssis task .
But the sql logins are not working!!!!!!
This may sound silly, but I counted the number of characters in the pwd on both the servers , and the pwd on 2008 has 5 more characters than the old one. does it make any sense at all! Shouldn't the number of characters be same?
I am running out of time. Help please!!!:crying:
July 9, 2011 at 11:05 am
How did you migrate the logins?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2011 at 11:22 am
I tried the sp_helprevlogin scripts from different sites, and also tried creating ssis task and executing it.
SVR
July 9, 2011 at 12:10 pm
Alright, so which was the final one you used, that actually created these logins?
Have you checked the SQL error log for the reason why the logins are failing?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2011 at 12:17 pm
The last one I used is the sp_revlogin from http://support.microsoft.com/kb/246133.
The error is password mismatch.
SVR
July 9, 2011 at 2:00 pm
Which Method did you try? From the article:
Method 2
This method applies to the following scenarios:
You transfer logins and passwords from SQL Server 7.0 to SQL Server 2005.
You transfer logins and passwords from SQL Server 2000 to SQL Server 2005.
You assign logins to roles.
The article (http://support.microsoft.com/kb/246133) is specifically for migrating logins from 2000 to 2005. I'm not sure because I have not tried it, but it's possible the method still applies when going from 2000 to 2008. The article was last reviewed in July 2010 and 2000 to 2008 was not added as a migration option, although I'm not sure they would bother to test those migration paths after the fact and revise an article in that way.
If you did follow Method 2 you could always try the long way around and migrate the logins to 2005 per the article, then from there to 2008 per the second article I linked to in my initial post. Do you have a 2005 instance anywhere? If not you can download 2005 Express Edition and use that as your go-between.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 9, 2011 at 5:58 pm
Thank you. I tried the second method . But I did not realize I have to transfer the logins first to 2005. I was trying to to transfer the logins directly to 2008.
SVR
July 10, 2011 at 6:41 am
Thanks for posting back, happy you got it sorted 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 10, 2011 at 6:46 am
SVR (7/9/2011)
Thank you. I tried the second method . But I did not realize I have to transfer the logins first to 2005. I was trying to to transfer the logins directly to 2008.
You shouldn't have to. I don't recall there being any changes between 2005 and 2008 that would make a double-hop necessary.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 10, 2011 at 7:03 am
GilaMonster (7/10/2011)
SVR (7/9/2011)
Thank you. I tried the second method . But I did not realize I have to transfer the logins first to 2005. I was trying to to transfer the logins directly to 2008.You shouldn't have to. I don't recall there being any changes between 2005 and 2008 that would make a double-hop necessary.
I didn't think it would be necessary either but have not moved logins from 2000 to 2008 so had to fall back on what the articles stated.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 10, 2011 at 10:38 am
opc.three (7/9/2011)
If you did follow Method 2 you could always try the long way around and migrate the logins to 2005 per the article, then from there to 2008 per the second article I linked to in my initial post. Do you have a 2005 instance anywhere? If not you can download 2005 Express Edition and use that as your go-between.
method 2 works just fine for migrating a login from 2000 to 2008, no need for 2000 to 2005
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2011 at 12:51 pm
Perry Whittle (7/10/2011)
opc.three (7/9/2011)
If you did follow Method 2 you could always try the long way around and migrate the logins to 2005 per the article, then from there to 2008 per the second article I linked to in my initial post. Do you have a 2005 instance anywhere? If not you can download 2005 Express Edition and use that as your go-between.method 2 works just fine for migrating a login from 2000 to 2008, no need for 2000 to 2005
Good to know for sure, thanks Perry. I would have tried 2000 to 2008 first, and only bothered with 2005 if it did not work.
@svr, did you get it sorted or are you still having issues?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply