Posted by Erland Sommarskog on 11/15/05 00:30

(Danieltbt05@gmail.com) writes:
> Hi, i managed to make it connected by specifying alias in the server.
> I'm not sure why ? but after connected i still can't login , another
> error came out
>
> Server : Msg17,level 16, state1
> [Microsoft][ODBC SQL server driver][TCP/IP sockets] SQL server
> does not exist or denied access.

That's the same message as in you original post, save for the last
bracket. You still fail connect.

For further assistance, please anser these questions:

Have you verified that SQL Server is running?

Is SQL Server on the same machine you try to connect from?

Which protocols are SQL Server configured for? (You can view this
in the Server Network Utility).

If you changed which protocols SQL Servers uses, did you restart SQL Server
after this?

Is there a firewall on the SQL Server machine?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]