highly appreciated.
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.
Thanks
.
Relevant Pages
- 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 ...
(microsoft.public.sqlserver.clients) - 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. ...
(microsoft.public.sqlserver.server) - 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 ...
(microsoft.public.sqlserver.security) - 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. ...
(microsoft.public.dotnet.framework.remoting) - 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) ...
(microsoft.public.sqlserver.msde) |
|
