BookmarkSubscribeRSS Feed
RahulH
Calcite | Level 5

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

3 REPLIES 3
LinusH
Tourmaline | Level 20

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?

Data never sleeps
jakarman
Barite | Level 11

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?   

---->-- ja karman --<-----
ChrisHemedinger
Community Manager

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

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 848 views
  • 0 likes
  • 4 in conversation