Connecting a ADP Access Project to a remote computer running SQL 2005 Express.

Question

I have read several articles disscussing this, but I am still haveing an issue.  This is what I got!

Surface Area Configuation is set up to allow remote connections via tcp/ip or named pipes.
Windows Firewall is configured for exceptions for the SQL browser and the instance of the server.
I have allowed my router firewall to pass ports 1433 to the ip of the computer running SQL Server.
I have downloaded the Management Server Studio and tried many different configurations with the permissions and security settings.

Client Computer has access installed and the ADP file.
Maped network drives are working so a connection to shares are good.
Data Link Properties Dialog box in Access 2007 reconizes the server.

When trying to test the connection I get:
Test connection failed because of an error in initializing provider. Login failed for user '<SERVER COMPUTER>\Guest'.  
Guest with "Use Windows NT integrated security" is selected.  
When "Use a specific user name and password" is selected i get the same error, except "GUEST" is replaced with the user that i put in.
The user i put in has administrative priveliges on the server computer.  

Both computers are running Windows XP with all updates installed.

Thanks for any feedback!

 

Answer 1

Can you check whether the user is added to sql server and able to log on locally on the sql server and access the initial catalog database.?

---

Thanks, Leks

Answer 2

Yes, The user is able to log in locally, the computer where SQL Server is running <Computer/User>.  Also, Access connects fine to the SQL Server if run on the same computer.