topic SAS connect to Microsoft SQL Server database problems in SAS Programming

SAS connect to Microsoft SQL Server database problems

asabou01 — Thu, 15 Jul 2021 11:53:40 GMT

Hi - I have a script trying to connect to a MS-SQL Server. It only connects to the first DATABASE out of the 3 available (below #1: SYSTEM DATABASES).

I need to connect to #3 Database(AMS) below. Manually I can get on to the server so I have access to all 3. Any ideas why I can't get to AMS Database? Thank you.

libname db odbc

noprompt = "server=happp02vw\reporting;DRIVER=SQL Server Native Client 11.0;Trusted_Connection=yes"

DATABASE = AMS schema = dbo;

Re: SAS connect to Microsoft SQL Server database problems

ChrisNZ — Tue, 20 Jul 2021 22:51:08 GMT

Why is the icon different for AMS? Is it really a database?

Re: SAS connect to Microsoft SQL Server database problems

Sajid01 — Wed, 21 Jul 2021 00:22:07 GMT

Please check if you have access to the database.
What is your environment?

Re: SAS connect to Microsoft SQL Server database problems

asabou01 — Wed, 21 Jul 2021 11:43:29 GMT

This solution worked perfectly:
libname db odbc noprompt = "server=happp02vw\reporting;DRIVER=SQL Server Native Client 11.0;Trusted_Connection=yes;DATABASE=AMS" schema = dbo;