Change Sqlserver name 
Author Message
 Change Sqlserver name
I have running Sqlserver Enterprise 7.0 aftet the change of computer name it's
sqlserver server is not start and i can not acces my database.
anybody know this issue kindly please Email me the salution,
thanks.
Noman


Sat, 15 Nov 2003 12:55:45 GMT
 Change Sqlserver name

Noman,

Setup, Upgrade. Then:
sp_dropserver <oldname>
sp_addserver <newname>, LOCAL

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com


I have running Sqlserver Enterprise 7.0 aftet the change of computer name it's
sqlserver server is not start and i can not acces my database.
anybody know this issue kindly please Email me the salution,
thanks.
Noman



Sat, 15 Nov 2003 14:19:28 GMT
 Change Sqlserver name
    You have to run SQL Server Setup again. It would come up with a screen
for Upgrade & it will update the required registry entries. Also remember to
do "sp_dropserver oldname" & "sp_addserver newname, local" to make SQL
Server use the new network name.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )


I have running Sqlserver Enterprise 7.0 aftet the change of computer name
it's
sqlserver server is not start and i can not acces my database.
anybody know this issue kindly please Email me the salution,
thanks.
Noman



Sat, 15 Nov 2003 22:00:55 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. I want to change SQLServers Name

2. Change Sqlserver name

3. DTS: Change sqlserver name in DTS

4. SQLServer Name Change

5. Change Sqlserver computer name

6. Server Name Change Breaks SQLServer

7. unable to start sqlserver after computer name changing

8. Changing The SQLServer Name

9. sql 2k named instance - how to change the instance's name , if possible

10. changing the name of sql2k named instance

11. ORA-04062: name of name has been changed

12. FTP Task: How Do You Dynamically Change the source file name and Destination File name


 
Powered by phpBB® Forum Software