December 6, 2010 at 10:46 pm
LocalServer i am created one database Name Sample.This Database includes Tables,Storedprocedure .I Want to change the locaServer To Main Server How do I Change?
January 6, 2011 at 3:35 pm
Is LocalServer the instance? If so you cannot easily rename the SQL instance after it has been installed...and it's not reccomended either
However, I did read an article once that says you can try this (at your own risk):
1. drop current instname (sp_dropserver)
2. add new instance name (sp_addserver 'new name','local')
3. stop sqlserver
4. modify hklm\software\microsoft\microsoft sql server\
5. modify hklm\system\currentcontrolset\services\mssql$inst"
6. use "sc create" to add new mssql$<inst>
7. start up with new inst_name - this should work
Hope it helps!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply