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

Filed under:
|
|

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

Related posts about sql-server

Related posts about odbc