programmer

[kessmiller]

We are in the process of bringing up a new server. We have a number of Access db's connected via ODBC to the old server. We need to change these to point to the new server. I thought we should be able to go to the Control Panel/Data Sources (ODBC) and just change the server ip address from the old server to the new server. All of the .dbd files are on the new server. This isn't working. What am I missing?

 

[ButtonMoon]

We are in the process of bringing up a new server. We have a number of Access db's connected via ODBC to the old server. We need to change these to point to the new server. I thought we should be able to go to the Control Panel/Data Sources (ODBC) and just change the server ip address from the old server to the new server. All of the .dbd files are on the new server. This isn't working. What am I missing?

Can you successfully connect to the server via SQL Server Management Studio? If not and you need more help then please post the error message(s) you get. Check the server config in SQL Server Configuration Manager. TCP/IP connectivity is disabled by default after installation.

 

[Rx_]

Good advice about the default.

Also consider when using a named instance of Database Engine with a firewall, use SQL Server Configuration Manager to configure the named instance to listen on a specific TCP port. You must pick a TCP port that is not used by another application running on the same computer or cluster.
see: http://msdn.microsoft.com/en-us/library/ms175483(v=sql.105).aspx

 

[kessmiller]

Thanks for the ideas. It looks like the main issue was we needed to install a new driver for our ODBC software. I still have several questions about this, but will talk to others on our staff about those.