topic Question regarding DNS name for accessing a SQL Server through SAS UNIX in SAS Procedures

Question regarding DNS name for accessing a SQL Server through SAS UNIX

Pramod_R — Wed, 16 Mar 2011 07:13:44 GMT

Hi,

I was trying to connect to a MS SQL server through SAS which is present in UNIX using passthrough. I wanted to know how do we configure the DNS name for this or is it ok if we just specify the Datasrc instead?

Thank you so much in Advance!

Re: Question regarding DNS name for accessing a SQL Server through SAS UNIX

LinusH — Wed, 16 Mar 2011 08:27:38 GMT

Your post does not tell much about your situation/configuration.
A good starting point is the configuration guide:

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/61994/PDF/default/config.pdf

/Linus

Re: Question regarding DNS name for accessing a SQL Server through SAS UNIX

Ksharp — Wed, 16 Mar 2011 09:14:45 GMT

Hi.

I think you can use ODBC to connect to sql server, Maybe DNS will not be used, you
can use IP address.

Ksharp

Re: Question regarding DNS name for accessing a SQL Server through SAS UNIX

Doc_Duke — Wed, 16 Mar 2011 14:40:31 GMT

ODBC is the only supported way. It's an add-on, so you will need to check with your site admin to see if you have it already or will need to license it.

Doc Muhlbaier
Duke