Problem creating ODBC connection to SQL Server 2008 with Vista
Posted
by earlz
on Super User
See other posts from Super User
or by earlz
Published on 2010-04-06T20:48:06Z
Indexed on
2010/04/06
20:53 UTC
Read the original article
Hit count: 228
Well, I'm trying to get a database schema thing working, first I tried just doing it in Linux where I'm more comfortable, but ODBC seems to be a hack there and I couldn't get it to work. So I figured it shouldn't be too hard in Windows..
Ok, so I created a SQL Server Client Alias so that I can simply same windowsserver
to refer to my SQL server.
Then, I went to the ODBC configuration in Control Panel. I clicked Add in the User DSN section. I chose Native SQL Server (10), and then clicked next. Then I typed a short name and a description and gave the servername as windowsserver/SQLEXPRESS
Then, I click next, give it my user name and password and click next. Then, after like 2 minutes it says "Login Timeout Expired"
What can be wrong here? I know the server is configured cause I have SQL Server Management Studio opened up with that server in it.
I'm also just trying to connect over regular TCP/IP and my firewall is disabled.
© Super User or respective owner