Does not exist or access denied

Newbie thing here. When you get the message (maybe not verbatim) "SQL Server
does not exist or access denied", is there a way to tell which one it is?
Problem is, client may type in the server name wrong, or may have wrong
password. It'd be nice to know if they had the correct instance name (Server
does not exist) or the wrong credentials (access denied).
Can I differentiate between the two?
TIA,
MikeMike,
That one means the machine was not found by that name.
If it was a login failure, you'd get "Login failed for user '%ls'"
%ls will be substituted by the login you supplied.
James Hokes
"Mike Hildner" <mhildner@.afweb.com> wrote in message
news:e7ZtDK01DHA.4060@.TK2MSFTNGP11.phx.gbl...
> Newbie thing here. When you get the message (maybe not verbatim) "SQL
Server
> does not exist or access denied", is there a way to tell which one it is?
> Problem is, client may type in the server name wrong, or may have wrong
> password. It'd be nice to know if they had the correct instance name
(Server
> does not exist) or the wrong credentials (access denied).
> Can I differentiate between the two?
> TIA,
> Mike
>

Does not exist or access denied

Newbie thing here. When you get the message (maybe not verbatim) "SQL Server
does not exist or access denied", is there a way to tell which one it is?
Problem is, client may type in the server name wrong, or may have wrong
password. It'd be nice to know if they had the correct instance name (Server
does not exist) or the wrong credentials (access denied).
Can I differentiate between the two?
TIA,
MikeMike,
That one means the machine was not found by that name.
If it was a login failure, you'd get "Login failed for user '%ls'"
%ls will be substituted by the login you supplied.
James Hokes
"Mike Hildner" <mhildner@.afweb.com> wrote in message
news:e7ZtDK01DHA.4060@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Newbie thing here. When you get the message (maybe not verbatim) "SQL

---

Server

quote:

---

> does not exist or access denied", is there a way to tell which one it is?
> Problem is, client may type in the server name wrong, or may have wrong
> password. It'd be nice to know if they had the correct instance name

---

(Server

quote:

---

> does not exist) or the wrong credentials (access denied).
> Can I differentiate between the two?
> TIA,
> Mike
>

---