setting up dsn for a sql server express database

Question

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 1

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

Answer 2

you can connect informing the IP, localhost or the machine name. If you use the name, SQL Server browser must be running