• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

SQL 2008 Express trouble on Windows 7 HomeBasic

A

AstroGuardian

Senior member
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?
 
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.
 
Emulex said:
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.
Click to expand...

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.
 
isp's block those ports like smtp if you are trying to direct net access them.

use a different port 🙂
 
Emulex said:
isp's block those ports like smtp if you are trying to direct net access them.

use a different port 🙂
Click to expand...

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 said:
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.
Click to expand...

As one of the previous posters said, can you telnet to 1433 from the local machine?
 
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
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top