August 11, 2010 at 1:58 pm
Hi,
I have change the instance name by using
sp_dropserver 'SER1\INST1'
go
sp_addserver 'SER1\NEWINST1','local'
I am geting new name by
sp_helpserver and
select @@servername as well
and I have restarted server too.
But I am not able to connect with new name 'SER1\NEWINST1' from SSMS. (I am able to connect with old name 'SER1\INST1' from SSMS. )
I am getting following error
…...provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified…..
Is there I am missing anything?
Thanks in advance for your help.
Vinod
August 11, 2010 at 2:14 pm
Does the error log show the new name as being listed? Just a question, you did change the Windows host name, correct?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 12, 2010 at 8:33 am
Also I would suggest to run DNSFlush.
August 13, 2010 at 12:52 am
As Steve mentioned you need to change the machine name
or
Create an alias with ur desired name but using this still wont change the exact name of server.
August 13, 2010 at 1:17 am
My understanding of those procedures is that they are for renaming a server not the instance.
Thus it would be like the following:
When you have more than one instance of SQL Server on the computer, change the sysservers system table information by running the stored procedures this way:
sp_dropserver old_servername\instancenameGO
sp_addserver new_servername\instancename, local
GO
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
August 13, 2010 at 1:16 pm
That was my understanding too Cirq, about those proc's.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply