SQL Server 2000 connection problems after re-adding server to domain

Hi All,

We recently had a server fail and needed to use some hardware out of one of our other servers.
The server is running Windows 2003 Server SP1 and SQL Server 2000 SP3.

The problem we have is that we needed to remove and re-add the SQL server computer to the domain when we were fixing the problems with the crash and now it has broken some of our VBA connections to the server.  Nothing on the SQL server changed (I think) other than the remove and re-add to the domain.

We have a large amount of VBA for AutoCAD 2007 that writes to the SQL Server 2000 database and the connection keeps failing on the line below when they are VPN'ed in to the network.  This works from inside the network.

(the line the debugger opens on)
InitializeDatabase.Open "DRIVER={SQL Server};SERVER=" & strServer & ";UID=" & strUserID & ";PWD=" & strPassword & ";DATABASE=" & strDatabase & ""

(the error that comes up when trying to setup the ODBC connection)
I have tried to setup an ODBC connection from their site and get the message below...
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQLServer Driver][DNETLIB]ConnectionOpen(Connect()).
Connection failed:
SQLState:'08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DNETLIB]SQL Server does not exist or access denied.

If any other information is needed that I have not included or you think is relavent let me know,
Thanks in advance.
cn