setting up dsn for a sql server express database

sql-server-2008 odbc dsn
cableload picture cableload · Apr 10, 2012 · Viewed 12.6k times · Source

How do i set up a system dsn for a 64 bit sql server express 2008 R2 that is installed on the local machine?

I go to add a system dsn and select sql server native client 10 and follow the wizard. However on the dropdown that asks which sql server to connect, i dont see any option for the local machine. Is there something that i need to enable??

Thanks.

Answer

Chris Diver picture Chris Diver · Apr 10, 2012

Ignore the drop down and try typing in (local)\SQLEXPRESS and see if that works?

Related questions

Reverse Engineering for Database Diagramming in Visio with SQL Server 2008

I need to reverse engineer a Microsoft SQL Server 2008 in order to create a Microsoft Visio 2007 Database Model Diagram. So I choose "Reverse Engineer" from the Database menu to connect to the DB. I configured the Microsoft SQL Server Visio …

Read More
Unable to connect to SQL Server 2008 using ODBC connection via system dsn on windows 2012

I have Windows 2012 server and I am able to connect to a SQL Server 2008 instance through Visual Studio Server Explorer by creating a data connection. I can also use SQL Server Management Studio and connect to that SQL Server. But …

Read More
SQL Server: Native client vs. ODBC?

What is the difference between SQL Server Native Client connection and ODBC connection? What are the pros and cons of these two?

Read More