November 19, 2010 at 3:21 pm
One of the final steps after upgrading SQL Server from 2005 to 2008 says to register your servers. Can someone help me with how to do that. I know how to access the registry, but what settings need to be changed and what should they be?
Thanks very much for any help.
November 19, 2010 at 3:34 pm
Denise McMillan (11/19/2010)
One of the final steps after upgrading SQL Server from 2005 to 2008 says to register your servers. Can someone help me with how to do that. I know how to access the registry, but what settings need to be changed and what should they be?Thanks very much for any help.
Not sure what this means offhand but could probably get it from context. Can you post the link you're using as your checklist?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 19, 2010 at 4:05 pm
You might be referring to this link How to: Upgrade to SQL Server 2008 (Setup)?
I believe they are referring to registering your servers within SSMS:
New or Edit Server Registration (General Tab) (Database Engine)
Since the upgrade process removes registry keys and then writes out the new ones if you have a bunch of servers registered (like quick links) those are removed during the upgrade process. There are ways of exporting those (if you use it) to a file that should be able to import them after the upgrade.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
November 20, 2010 at 11:36 am
Denise McMillan (11/19/2010)
One of the final steps after upgrading SQL Server from 2005 to 2008 says to register your servers. Can someone help me with how to do that. I know how to access the registry, but what settings need to be changed and what should they be?
SSMS is prompting you to "Import the Settings of SSMS" from the previous version. If you wish you retain all the settings of SSMS (including already registered servers), click Yes.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 22, 2010 at 6:24 am
Ok, thanks. I understand that then. I was afraid it meant something in the Windows registry!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply