December 10, 2008 at 1:21 pm
Hi Guys,
I have tried to change the SQL Server name and it changed to the one i wanted, but when i am connecting the database engine with the new name its not connecting, instead even now its connecting it with the old server name.
I have tried to see by executing Select @@ SERVERNAME
It shows the server name is changed.
Can you guys let me know what needs to be done to change the server name from the connecting point of view,
FYI
I have followed this http://blogs.techrepublic.com.com/datacenter/?p=192
Thanks
December 13, 2008 at 2:32 pm
Is server alias been configured on your server?
MJ
December 13, 2008 at 2:38 pm
And you restarted SQL?
Did you change the name in sysservers?
December 15, 2008 at 8:32 am
Yeah i changed the name in the sysservers, I tried to keep the alias name too but its not changing the server name when i connect with management studio.
Guys i want to make it clear again,
ex: The window server name is Win2k3 and default sql server name as Win2K3,
we want to change both the Windows server name and then the same name for the sql server.
Is it possible,
Thanks
December 15, 2008 at 9:03 am
If you check the error log what name is listed?
If I understand, you changed the Windows host name, correct? What was it and what is it? Then what did you run on the SQL Server instance?
Can you connect via IP? via (local)?
December 15, 2008 at 9:45 am
Guys, i think i got the solution,
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/bbaf1445-b8a2-4ebf-babe-17d8cf20b037.htm
check this out,
Thanks for your help..
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply