I am trying to connect the named instance from my client computer... I can
easily connect the default instance of my remote machine but when I tried to
connect through named instance it gave me an error that SQL Server doesn't
exist or access denied....
In the client network utility I have defined the IP and alias of that server
but failed to connect.
Can any one give their expert idea.
- Re: highly appreciated.
... First of all David, thanks for your reply.... ... I am at client computer and how client computer diagnose MY_COMPUTER\SQL2 ... I did findout the port No of named instance through SQL Server ...
- Re: connect to named instances
... Your client system likely has an older version of MDAC. ... higher to connect to a named instance without requiring an alias. ...
- Re: Using SSL with named instance
... I can connect to the named instance using Enterprise Manager but not through ... > I created the certificate on the target SQL Server. ... > CA' on client. ... Then I enabled 'Force PRotocol Encryption' on ...
- Re: Exposed Object vs Remoting server
... Allow the server to access the same object which is remoted to the clients ... Declare and instantiate a named instance of your remote object. ... > I have a remoting server which exposes a Singleton object to a client. ...
- Re: Connecting Dynamic Port from Client
... > Only named instances of SQL Server can use the dynamic port allocation ... > And I tried named instance network and that's successed... ... Alias to be defined on the client side and defining a static ... Andrea Montanari (Microsoft MVP - SQL Server) ...