«

3 workstations previously installed and able to access server.

4th workstation am able to map to server access files but when
attempting to log in receive the following error.

EXTERNAL DATABASE OPEN FAILURE
Error: -2147467259[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL
Server does not exist.

The workstation that is unable to connect is running XP SP2, MDAC 2.7..
the difference btwn this and the others is that it is running wireless.
Ruled out wirelss as being the problem because hooked LAN cable and
receive the same error.

Checked that TCP/IP is enabled and port is 1433

Went to Adminstrative Tools ODBC to access server and receive the
following error:
Connection failed
SQLState: '01000'
SQL Server Error: 20
[Microsoft][ODBC SQL Server Driver][TCP/IP
Sockets]ConnectionOpen(PreLoginHandshake()).
Connection failed;
SQLState: '08001'
SQL Server Error:20
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Encryption support
on SQL Server

Tried some other setting changes as well can someone help.. PLEASE !!

Jess wrote:
> 3 workstations previously installed and able to access server.
>

What does this have to do with ASP?
What application is being used to connect to the SQL Server?
You should try a more appropriate newsgroup. Maybe an ODBC or SQL Server
group. You'll have a better chance of receiving effective help.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

I apologize .. I clicked wrong grup. Thanx


*** Sent via Developersdex http://www.developersdex.com ***