Connection failure to SQL Server after upgrade from 2008 to 2012

[RahulH]

Hi everyone,

We're running SAS 9.3 on HP-UX. We used to connect to SQL Server 2008 running on Windows as our reporting database. We recently upgraded to SQL Server 2012 after which none of the SAS tools like Enterprise Guide etc are able to connect to SQL Server 2012.

I'd be very grateful for any pointers.

Many thanks!

Rahul

[LinusH]

To be able to connect to SQL Server from UNIX, you are using a 3rd party ODBC driver. Have you updated it after the upgrade?

[jakarman]

I guess there is new hardware and new ip-adresses to that new SQL-server?
Start checking you are not blocked by any firewall. That new SQL server should be reachable from your sas server.

Checks doing on the desktop odbc are just telling the new SQL server is working. Nothing about the server connection.

Theare is an ODBC.ini with settings involved with your 3-party  ODBC driver on the server side. (next to check).

That one should be able to verify without using SAS. When everything is working on that level than proceed to using SAS. How far did you come?   

[ChrisHemedinger]

Are you using File->Open->OLE DB from SAS Enterprise Guide?  Or are you using the SAS/ACCESS engine for SQL Server via your SAS session?  Either way, you may have connection-string adjustments to make after the upgrade, or you might require an updated driver/data provider.

Testing the basic connection from your PC is simple -- you can do this via EG or even Microsoft Excel (Data->Get External Data).  But if you're relying on the SAS library on the server, then you may need help from your SAS admin and/or DBA to verify the configuration.

Chris