SAS connect to Microsoft SQL Server database problems

[asabou01]

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;

[ChrisNZ · Accepted solution]

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

[Sajid01]

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

[asabou01]

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;