Unanswered: Connecting to SQL Server for Named Instances at client end
I have installed a named instance in my sql server. Am able to connect to the named instance at the server end. However, when i tried to register this named instance at my client end using sql enterprise manager, i have this error : Specified SQL Server not found. ConnectionOpen (Connect())
Let's say my servername is Intranet and the named instance is UAT.
Thus, i just have to supply the name to be --> Intranet\UAT . Am i correct? Please advise... have been figuring the whole morning still do not know what's wrong with it.
You must add an alias that points to
\\computername\pipe\MSSQL$instancename. If you use an alias name
of computername\instancename, clients can connect by specifying this name in the same way as SQL Server 2000 clients do.
For the TCP/IP Sockets andNWLink IPX/SPX Net-Libraries, you must use the Client Network Utility to define an alias on the client that specifies the port address on which the named instance is listening.