SQL server manager error

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

When I try to connect via sql server manager I get the following error.

A connection could not be established to xxx.xxx.xxx.xxx - Specified SQL server not found. ConnectionOpen (CreateFile())..

Please verify SQL server is running.

I am trying to connect via cable internet and have had the same experience from another cable user ( on a different service )

But....If I connect to the internet through 2 other service providers (dial up) I then can connect to the Server.

Any help would be greatly appreciated...

David Barrett

-- Anonymous, July 05, 2001

Answers

Email Address TYPE-O Sorry ! davidb@maineconnect.net

-- Anonymous, July 05, 2001

David,

The sort of thing that causes this error is when the SQL Server cannot authenticate the user over the connection. The Microsoft Knowledge Base suggests these causes:

This problem occurs because of one or all of the following:

The user account IUSR_ (where is the name of your Internet Information Server) does not have the "Access this computer from the network" user right configured on the SQL Server.

The Internet Information Server and the SQL Server are on different domains and the IUSR_ account does not exist in the SQL Server's local user database or domain.

The Internet Information Server and SQL Server are on the same domain; however, the Internet Information Server is installed on a Server (non-domain controller) and the SQL Server is installed on a Domain Controller. The IUSR_ account does not exist on the domain.

In short, I'm guessing that the cable connections are coming in as a different user than the dial in connections and only the dial in user has the necessary privileges.

Hope this helps,

Eric

-- Anonymous, July 10, 2001


Moderation questions? read the FAQ