SQL Server does not exist or access denied (after XP SP2)

V

Vincent Verheul

Hello,

I use MsAccess 2002 on a Windows XP platform, together with SQL Server 2000.
I installed SQL Server on my XP machine prior to installing Service Pack 2
for XP. Everything worked fine: could use the Upsize Wizard, ADP etc.

After installing Service Pack 2, I can no longer get a connection to SQL
Server from Access 2002. Using the upsize wizard I get the messages:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
The Upsizing Wizard only works with Microsoft SQL Server (versions
6.50 SP5 or higher). Please log in to a SQL Server data source.

SQL Server is running, and I can see the tables etc. via the SQL Server
Enterprise manager. I switched off the firewall, but no effect.

Any ideas?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upsizing to SQL Server 4
ADP conneciton issues, Link tables missing 2
upsizing wizard access 2000 MSDE 4
Cannot Connect to Server 4
SQL server does not exist or access is denied 3
upsizing wizard 11
Problem accessing SQL Server in upsizing wizard 1
"SQL Server does not exist or access denied" 2

Top