We help IT Professionals succeed at work.

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

SheahaST
SheahaST asked
on
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.
Comment
Watch Question

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

Commented:
>>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.

Author

Commented:
This is my home machine, and I am the system administrator.  Where in SQL Management Studio do I set these rights?   Thanks
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.

Author

Commented:
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
Commented:
Apparently I did a new instance of R2 instead of updating my old install.  Once I did the update I could see my database.