Connect Dababase from Windows7 to windows 2008
-
1. MS-sql 2008 Server(windows2008, firewall off) 2. Windows7 64bit(ms-sql2008) 3. Windows xp 32bit My Windows version is windows7 64bit. I can connect other ms-sql server which windows2003. But i can't connect ms-sql server which windows 2008. But other pc(windows xp) can connect ms-sql server which windows2008, 2003. So, I turn off firewall off windows 2008 server. But still now, i can't connect. Ping from my computer to windows 2008 is good. Also I can connect 80 port(but can't 1433 port.) How can i solve this problem?
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
-
1. MS-sql 2008 Server(windows2008, firewall off) 2. Windows7 64bit(ms-sql2008) 3. Windows xp 32bit My Windows version is windows7 64bit. I can connect other ms-sql server which windows2003. But i can't connect ms-sql server which windows 2008. But other pc(windows xp) can connect ms-sql server which windows2008, 2003. So, I turn off firewall off windows 2008 server. But still now, i can't connect. Ping from my computer to windows 2008 is good. Also I can connect 80 port(but can't 1433 port.) How can i solve this problem?
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
can you connect with the sql sever client tools i.e. sql server management studio? if not what error message does it give?
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
1. MS-sql 2008 Server(windows2008, firewall off) 2. Windows7 64bit(ms-sql2008) 3. Windows xp 32bit My Windows version is windows7 64bit. I can connect other ms-sql server which windows2003. But i can't connect ms-sql server which windows 2008. But other pc(windows xp) can connect ms-sql server which windows2008, 2003. So, I turn off firewall off windows 2008 server. But still now, i can't connect. Ping from my computer to windows 2008 is good. Also I can connect 80 port(but can't 1433 port.) How can i solve this problem?
hi My english is a little. anyway, nice to meet you~~ and give me your advice anytime~
Here's one quite good check-list you should go through: http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx[^] Few things to check also are: - is the server actually using port 1433 or something else - is the SQL Server a named instance. If it is, do you specify the name of the instance - and of course are you using the right credentials.
The need to optimize rises from a bad design.My articles[^]