I have a clustered server. Listening on same TCPIP port.
It's in mixed mode. I couldnt login to the analyzer from the server. I tried
using "sa" and "windows account". Both did not allow me to go thru.
It says "Unable to connect to server ABC. Server : Msg 17, Level 16, State
1. [Microsoft][ODBC SQL Server Driver][Shared Memory] SQL Server
does not
exist or access denied"
Another pair of the cluster also giving the same prob.
Any idea?
TIArupart
Try connect by specifying IP Address of the server or check if there is the
same name in the Client Network Utility
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:6AA6B712-A9CF-44A0-91B8-59DC38F55B65@.microsoft.com...
> I have a clustered server. Listening on same TCPIP port.
> It's in mixed mode. I couldnt login to the analyzer from the server. I
tried
> using "sa" and "windows account". Both did not allow me to go thru.
> It says "Unable to connect to server ABC. Server : Msg 17, Level 16, State
> 1. [Microsoft][ODBC SQL Server Driver][Shared Memory] SQL Serv
er does not
> exist or access denied"
> Another pair of the cluster also giving the same prob.
> Any idea?
> TIA
>|||Hi,
Try as Uri pointed out. If you still have issues; try creating a Server
Alias using Client Network utility using TCP/IP protocol
specifying IP address and Port
Thanks
Hari
SQL Server MVP
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e$jhA6rhFHA.1444@.TK2MSFTNGP10.phx.gbl...
> rupart
> Try connect by specifying IP Address of the server or check if there is
> the
> same name in the Client Network Utility
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:6AA6B712-A9CF-44A0-91B8-59DC38F55B65@.microsoft.com...
> tried
>|||Hi,
Try as Uri pointed out. If you still have issues; try creating a Server
Alias using Client Network utility using TCP/IP protocol
specifying IP address and Port
Thanks
Hari
SQL Server MVP
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e$jhA6rhFHA.1444@.TK2MSFTNGP10.phx.gbl...
> rupart
> Try connect by specifying IP Address of the server or check if there is
> the
> same name in the Client Network Utility
> "rupart" <rupart@.discussions.microsoft.com> wrote in message
> news:6AA6B712-A9CF-44A0-91B8-59DC38F55B65@.microsoft.com...
> tried
>|||Uri and Prasad,
I tried both ...still the same...
hmm...
"Hari Prasad" wrote:
> Hi,
> Try as Uri pointed out. If you still have issues; try creating a Server
> Alias using Client Network utility using TCP/IP protocol
> specifying IP address and Port
> Thanks
> Hari
> SQL Server MVP
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e$jhA6rhFHA.1444@.TK2MSFTNGP10.phx.gbl...
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment