asked on

Database names not showing up in Administrative Tools Data Sources (ODBC)

I am running on Vista, 32 bit, SQL Server 2008 Express R2 with SQL Server Native Client 10.0 (4/3/2010). When I try to create a System DSN, I can not set the default database to my SQL database as it doesn't exist in the drop down. I can also not type it in. If I let the default remain master and test the connection everything works fine. Do I have to specify the Default Instance somewhere (MSSQLSERVER)? What about SQLExpress?

Thanks in advance.

TwisterOfTruth

On security level within SqlServer you can set the default instance of which db youn want to use.

If you don't see any other databases I think the user you are using to create the DSN doesn't have the rights in SqlServer to see the correct database. You should set it within the security details

geek_vj

>>When I try to create a System DSN, I can not set the default database to my SQL database as it doesn't exist in the drop down. I can also not type it in

This happens when you dont have enough rights at sql server level. So, please check if you have the right permissions for the same.

SheahaST

ASKER

This is my home machine, and I am the system administrator. Where in SQL Management Studio do I set these rights? Thanks

TwisterOfTruth

Start your management studio and expand the security folder. Then expand the logins folder.

Doubleclick the user who's rights you wish to change, go to the user mapping page and on the right side you can select to which databases the user has access.

SheahaST

ASKER

Sorry for my absence. I tried the security changes mentioned above using sa and its password, but I still only get the 4 system databases: master, model, msdb, and tempdb. Thanks

ASKER CERTIFIED SOLUTION

SheahaST

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial