November 13, 2007 at 10:35 am
Hi All,
Recently, I installed the second SQL Server instance on the server.
I changed the named pipe settings as following:
From \\.\pipe\MSSQL$Instance_Name\sql\query
To \\Machine_Name\pipe\MSSQL$Instance_Name\sql\query
Right now, I cannot connect to that instance from either enterprise manager or query analyzer.
When I try to connect, both Enterprise Manager and Query Analyzer crushes.
Anyone knows how to set named pipes to the original settings from out side of the instance, please help me.
Thank you very much
November 13, 2007 at 11:03 am
I fixed the problem as following:
Start>All Programs>Microsoft SQL Server>Server Network Utility
Named pipes>Properties>
Changed path into previous settings.
My problem is I can see the instance on the server locally but I cannot
see it from the network clients.
Does anyone know how to set the multiple
instances for clients?
Thank you very much
November 13, 2007 at 11:09 pm
From the client machine run prompt type cliconfg.exe and then follow what you did for the server config.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
November 15, 2007 at 5:16 pm
I definitely agree!!
November 15, 2007 at 5:30 pm
I set the same configurations on the client side (cliconfg.exe)
For the new instance (Test Instance), client can connect to the server via Named pipes.
I could not get the connection working via TCP/IP.
"The Default Instance" is using TCP/IP dynamic port.
Can you explain me why "The Test Instance" only can connect via Named Pipes?
Should I be able connect via TCP/IP as well?
Thanks in advance
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply