SQL 2008 Express trouble on Windows 7 HomeBasic

[AstroGuardian]

Hello all,

I have been deploying SQL servers for the past 10 years. I know SQL can be a pain but have always managed to succeed.

Now i have a small application that uses a small SQL database. I installed SQL 2008 Express + SP1 on a Windows 7 HomeBasic x86 OS (I have a license for that version). But i cant manage to allow the client computer (two computers should use the application and database) to connect to the database. Everything functions locally but the second computer says it can't find the SQL server. I am doing everything right, IP protocols, allowed remote access and everything. I cant make even Management studio express to connect to the server saying naming problem to the server and instance occurred.

Since i managed to install everything and get it to work on Windows Server 2008 + SQL2008, i am starting to think that there might be some problem with the Windows version. Do you have any knowledge whether the HomeBasic is screwing things up or is it just something i am missing?

 

[stlcardinals]

It shows up as supported http://technet.microsoft.com/en-us/library/ms143506(SQL.100).aspx

One thing you might try is disabling the firewall to see if that helps and also make sure all of the SQL services are running.

 

[AstroGuardian]

Of course i have disabled the firewall, so it's not an issue (both public and private).
Any more opinions?

 

[Emulex]

can you telnet to the port you opened for tcp? from local machine? from internet using ip? from internet use wins/dns?

answer and you will find your answer.

 

[AstroGuardian]

can you telnet to the port you opened for tcp? from local machine? from internet using ip? from internet use wins/dns?

answer and you will find your answer.

I only use local IP addresses. The ports are 1433 and 1434 but they are both open. I use the ISP's DNS currently but i browse for the server by it's IP and not server name. I have dont this many times but this is first time on HomeBasic. So i know how to deploy the SQL. I also tried in Vmware with virtual machines but no luck. I will try now with Windows Professional or HomePremium and will let you know.

 

[Emulex]

isp's block those ports like smtp if you are trying to direct net access them.

use a different port

 

[AstroGuardian]

isp's block those ports like smtp if you are trying to direct net access them.

use a different port

Dude, i don't access the SQL server over the WAN only locally in LAN. ISP has nothing to do, i don't even plan to have internet enabled there...

 

[AstroGuardian]

Dudes come on! Anyone? There's gotta be something!
Help please

 

[Fear No Evil]

I only use local IP addresses. The ports are 1433 and 1434 but they are both open. I use the ISP's DNS currently but i browse for the server by it's IP and not server name. I have dont this many times but this is first time on HomeBasic. So i know how to deploy the SQL. I also tried in Vmware with virtual machines but no luck. I will try now with Windows Professional or HomePremium and will let you know.

As one of the previous posters said, can you telnet to 1433 from the local machine?

 

[AstroGuardian]

I didn't try telneting it. Telnet is not recognized in the command prompt. How can i telnet the port?

 

[Emulex]

wow.
google how to get telnet for vista/win7 (microsoft/putty)
install it
telnet localhost 1433
telnet 127.0.0.1 1433
telnet machinename 1433
telnet machinerealip 1433