January 29, 2010 at 1:50 pm
I will be restoring a 2005 db to a new 2008 instance. I'm setting up logins on the new instance so they will be available when I restore the db to the new location.
in the process, I saw three groups added to the source instance logins:
SQLServer2005MSFTEUser$
SQLServer2005MSSQLUser$
SQLServer2005SQLAgentUser$
I have a couple of questions...
1) what is the purpose of adding these groups to the instance logins (my initial google attempts did not answer my question, but I will continue to google) and
2) the target server does not have a group called SQLServer2005MSFTEUser. Was this replaced with a different group in 2008?
Thank you for any information you can share with me.
February 2, 2010 at 4:56 pm
Those are 2005 groups and you will not need them with 2008.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 2, 2010 at 5:02 pm
Are these mapped to users in the databases? Keep in mind that a new instance has it's own logins. If these are used by some process or there is some reason to keep them because they are used, you could easily map the users to the new groups/logins.
February 2, 2010 at 5:02 pm
I understand those groups were specific to 2005, however, 2008 had equivalently named groups for two of the three groups that I listed so I believe they are still relevant....
February 2, 2010 at 5:05 pm
kstjacques (2/2/2010)
I understand those groups were specific to 2005, however, 2008 had equivalently named groups for two of the three groups that I listed so I believe they are still relevant....
Not saying that the 2008 logins/groups would be irrelevant. You will only need to import the 2005 versions if there are specific processes attached to those accounts - as Steve said. Otherwise, leave them in your 2005 instance and use the 2008 versions in your 2008 instance.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply