Hi all,
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.
Refer to this
MSDN (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp) article for more information.
No comments:
Post a Comment