October 12, 2014 at 5:25 pm
We had a sql server SRVDR
i was able to connect using sql studio using 'SRVDR' as Server Name.
Also other application was able to use server name 'SRVDR'
We changed the Computer Name to 'SRVLIVE' (To put it in Live Environment) . then ran the query
sp_dropserver 'SRVDR'
GO
sp_addserver 'SRVLIVE', local
GO
After doing this i restarted the sql server.
From SQL Studio and able to connect using SRVLIVE.
But other applications can not connect using server name 'SRVLIVE' .
The only way i can connect is SRVLIVE\SRVDR. Looks like its not a default instance anymore.
How i can configure sql server so that all the applications will be able to use just the server name - SRVLIVE?
October 12, 2014 at 10:34 pm
skb 44459 (10/12/2014)
We had a sql server SRVDRi was able to connect using sql studio using 'SRVDR' as Server Name.
Also other application was able to use server name 'SRVDR'
We changed the Computer Name to 'SRVLIVE' (To put it in Live Environment) . then ran the query
sp_dropserver 'SRVDR'
GO
sp_addserver 'SRVLIVE', local
GO
After doing this i restarted the sql server.
From SQL Studio and able to connect using SRVLIVE.
But other applications can not connect using server name 'SRVLIVE' .
The only way i can connect is SRVLIVE\SRVDR. Looks like its not a default instance anymore.
How i can configure sql server so that all the applications will be able to use just the server name - SRVLIVE?
Quick questions
1) What does the command "nslookup SRVLIVE" in a command prompt return?
2) Are there any host file entries for SRVDR on the systems?
3) Have you checked using CLICONFG.exe if there are any aliases set up for SRVDR?
4) Is the SQL Server Browser service running on SRVLIVE?
😎
October 13, 2014 at 8:31 am
Quick questions
1) What does the command "nslookup SRVLIVE" in a command prompt return?
returns me SRVLIVE.intranet.xxxxx.com
2) Are there any host file entries for SRVDR on the systems?
NO
3) Have you checked using CLICONFG.exe if there are any aliases set up for SRVDR?
NO
4) Is the SQL Server Browser service running on SRVLIVE?
YES
October 13, 2014 at 8:56 am
That's strange. If it was a default instance before, it still should be.
Have you restarted the host? Not that it matters, but just wondering. Otherwise, not sure why you're seeing this as a named instance. Was there only one instance before?
October 13, 2014 at 9:34 am
One more question, in cmd what does reg query "HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL" return?
😎
October 13, 2014 at 9:38 am
INSTANCE NAME IS SRVDR
October 13, 2014 at 10:00 am
looks like after renaming the server. it didn't chage it.
October 13, 2014 at 10:09 am
Quick suggestion, in SQL Server configuration Manager, Server Network Configuration, Protocols for SRVDR, Enable TCP/IP. Then in the properties window set TCP Dynamic Ports 0 or blank and all IP addresses TCP Port 1433. This way any request that resolves to the server's IP address will point to this instance.
😎
October 13, 2014 at 10:14 am
skb 44459 (10/13/2014)
looks like after renaming the server. it didn't chage it.
You cannot rename an instance, only the server
😎
October 13, 2014 at 10:54 am
I have already done TCP/IP changes. But still does not work.
October 13, 2014 at 11:17 pm
skb 44459 (10/13/2014)
I have already done TCP/IP changes. But still does not work.
Then everything is pointing to the name resolution, check the DNS, win host name etc.
😎
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply