connect to SQL server database through Access database project 1

[cdck]

I manage our online SQL Server database by using Microsoft Access.

On my Windows 2000 machine at work, I was able to set up a connection that allows me to open the project in Access and edit it in any way that I want. The connection is dynamic, by which I mean that it does not import the data from the source, it just accesses it and allows me to make use of it.

I'm now moving to an XP machine at another site, but still using Access 2000. From the new machine, everytime I try to connect to the database in Access, I get a "server does not exist or access denied" error. If I go into Enterprise Manager or Query Analyzer form that machine, however, it has no problem with connecting.

Can anyone help me figure out what's wrong with the Access connection? If this is an inappropriate forum for this question, can you point me to the correct one?

I've even tried emailing myself a copy of the database project on the old machine and opening it, but it gives methe same error.

The new machine connects to the internet through DSL, no firewall beyond the built-in in XP, no router, through the ethernet card. The old machine connects through cable, through a firewall.

Cheryl dc Kern

http://www.htowne.com

 

[dmcmunn]

...but first a few questions...
Are you using NT Authentication or SQL Server login authentication to connect to the database (via ODBC?) from CrapCess2K ?

I would setup a new ODBC SYSTEM DATASOURCE that connects to the Squirrel Server using TCP/IP, and train crapcess2k to use this connection. This will ensure that your connection will be routable (if that is SOMEHOW the problem).

Barring that...I assume your XP client machine is on a different network subnet, n'cest pa? Make sure it's firewall is not blocking the SQL Server tcpport...1433.

Also run the SQL Server tools "client network utility"...see SQL Books Online...to make sure the xp box has the right ports (1433 is the default) configured.

Best,
dmcmunn

 

[cdck]

H and P!

Thank you so much.

To clarify, I was using the SQL server login, just like in Enterprise Manager and Query ANalyzer, but it wasn't working.

I found a setting in the XP security settings that was disabled. I know, it's not a direct word for word part of your answer, but suggesting that the specific port could be blocked made me look in the security settings and find that my computer was set to not allow me to access databases across domains. For some reason, it didn't stop the Enterprise Manager, but it did stop Access.

Thanks a billion for getting me looking in the right direction.



Cheryl dc Kern