Access 2003 ADP and SQL 2000 db Server Connection

[Emma]

I have a Microsoft ADP application running from a network drive. It works
fine from other workstations. On one particular workstation, the title bar of
the application reads “(Disconnected) Project 2000 File Formatâ€. I am running
SQL Server 2000 and Office 2003 Pro. This works fine on other workstations.
On this particular workstation, when I click on File | connection I get the
following error message: “Access was not able to perform file operation
because the project is not connected to a SQL Server databaseâ€

Any idea what is going on here?

Thanks
Emma

 

[Sylvain L.]

Connection problems; take a look at:

1- instead of a real server name, you are using an alias and this alias has
not been set up on your local machine. Take a look at the SQL-Server
Network Client Utility.

Instead of using the network client utility, I heard in the past that
using the ODBC Data Source dialog window can achieve the same effect because
creating a DSN might also create a server alias with the same name.
However, I never verified this personally.

2- A firewall is blocking the port 1433 (or the port 1434 and above if you
are trying to access a named instance of SQL-Server or are using dynamically
allocated ports).

3- You are using the multiprotocol instead of a named pipe or even better,
the TCP protocol.

Solutions:

1- Create an alias.

2- Use the real server name.

3- Try with TCP: use the TCP/IP local address of the server or add tcp:
before the name of the server. Would be a good idea to add the port ,1433
too.

4- Check the firewall.

5- Take a look at the following articles (mostly for SQL-Server 2005 Express
but a lot of information there are still good for the 2000 version):

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

http://msdn2.microsoft.com/en-us/library/ms345318.aspx