Create New DSN Database Does not Show in Dropdown

[icccapital]

When I create a new DSN to connect to a remote SQL Server Express Instance,
My database options in "Change the default database to" dropdown are: Master,
MSdb and Tempdb. I never created MSDB nor Tempdb so I don't know if these
are standard databases, but more importantly I don't see the database that i
created in the system. I can logon to Management Studio and see my database,
but it is not in that dropdown.

This is a new install of sql server express, which is set to use windows
authentication, so i wonder if it is a permission problem? Any ideas and
solutions? Thanks

 

[Daryl S]

Icccapital -

You need to have permissions on the SQL Server database using Windows
Authentication. Check with the database administrator. The Master and
TempDB are normal SQL Server databases, so it looks like you are connecting
to SQL Server, just not the database you want.