MS SQL Server ODBC - [TCP/IP Sockets]SQL Server does not exist or access denied.

Author

[TCP/IP Sockets]SQL Server does not exist or access denied.

Massimo

2005-08-26, 7:23 am

Hello everybody,

I would like to create a System DSN on a server (named IO running Windows
2003 SP1 and IIS 6) to connect to an SQL Server (named SATURN running
Windows 2003 SP1 and SQL Server 2000 SP4).

SATURN is using the Windows authentication and the account creating the DSN
has the 'System Administrator' role.

Windows firewall is off on both servers, nevertheless I get the following
error message.

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist
or access denied.

Thank you in advance for your help

Regards

Massimo

2005-08-26, 9:23 am

On the IO server I created an Alias for SATURN (the SQL Server) using
clicfg.exe and forcing the use of named pipes. This way it works (tith
TCP/IP) it doesn't, but I am concerned about the Windows authentication, will
it work anyway?

Actually I want to use the DSN that I have created in an ASP application but
I cannot figure out what the connection string has to look like.

This one does not work (intrastat is the name of the DSN)

Application("ConnectionString") = " PROVIDER=SQLOLEDB;DA
TA SOURCE=intrastat"

"Massimo" wrote:

> Hello everybody,
>
> I would like to create a System DSN on a server (named IO running Windows
> 2003 SP1 and IIS 6) to connect to an SQL Server (named SATURN running
> Windows 2003 SP1 and SQL Server 2000 SP4).
>
> SATURN is using the Windows authentication and the account creating the DSN
> has the 'System Administrator' role.
>
> Windows firewall is off on both servers, nevertheless I get the following
> error message.
>
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist
> or access denied.
>
> Thank you in advance for your help
>
> Regards

Sponsored Links