Access 2003 - SQL Server 2005 Connectivity

G

Guest

I have an Access front end that connects to a SQL database. I recently
installed SQL Server 2005 on a WIN XP machine and successfully restored the
database etc. I am able to connect to the database if I am on the same
computer as the SQL Server install. However when attempting to access from a
remote computer I have problems. I am using both Windows and Sql Server
login and Allow Remote Connections is checked ( both verified in Server
Management Studio). I have never attempted to install SQL Server on WIN XP
machine as an actual server for clients.

I don’t know if the problem is Sql Server, IIS or WIN XP security.

My client does not wish to purchase a full server which is why the SQL
Server instance is on a Win XP machine.

Any hints, ideas or direction I should look?

Thanks in advance,
Rick
 
G

Guest

In my particular case I didn't have named pipes enabled. It all works just
fine now.
 

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

Connect to SQL Server from A2k 4
Reaching Access 2003 datas via SQL Server 2005 64 bits 2
Urgent Help about SQL Server Connection 1
Linking tables access - sql server 2005 4
SQL Server 2005 Standard can not install on my system AMD Athlon x3 425 2
use a SQLServer 2005 Express database from Access 2007 1
Access 2000 ADP and SQL Server 2005 2
Access 2007 can't connect to SQL Server 1

Top