| Author |
Topic |
|
mtcoder
Starting Member
19 Posts |
 Posted - 2010-10-05 : 14:30:50
|
| I installed sql express 2008 on a windows XP box (we are using it for testing as a pretend server). Install went as normal, but I cannot seem to use the sql management studio on my desktop to connect to the SQL instance on the xp box. Says....TITLE: Connect to Server------------------------------Cannot connect to xx.xxx.xxx.xxx------------------------------ADDITIONAL INFORMATION:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)Is there anything special that has to be setup when it is installed on XP instead of a normal server? I have tried to think of everything it could be. Usually its really easy, install SQL on server connect done, but not this time. Thanks for the help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-05 : 15:00:31
|
| No SAC in sql 2008.can you connect locally? if not, make sure sql server service is running.if yes, make sure remote connections are enabled |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-05 : 16:00:10
|
I was going to say "I'd be shocked if they found SAC in 2k8..." lolol  |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mtcoder
Starting Member
19 Posts |
Posted - 2010-10-06 : 11:16:33
|
| Locally on the box I have no problem connecting with sql manager, but when I try running manager studio from my desktop. I get the error message, which is frustrating, and I am worried there could be deeper rooted problems. Just for punishment I fully reinstalled SQL 2008 express on the box and still get same error message. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-06 : 11:39:46
|
| checked that remote connections are enabled? |
|
|
|
mtcoder
Starting Member
19 Posts |
Posted - 2010-10-06 : 13:57:35
|
| Yeap remote connections are enabled. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mtcoder
Starting Member
19 Posts |
Posted - 2010-10-06 : 16:04:47
|
| So much fun when the System's person doesn't talk with Database person. Apparently one of our network guys installed GhostWall its a software driven Firewall, and even though they set it up to allow all traffic on all ports, luck would have it GhostWall sits on one of the SQL ports thus blocking my connections. Nothing like 2 days of brain scratching, to find out its some hidden service running in the background. Once Ghostwall was removed I was fine. Now to Ghostwalls credit they don't support SQL 2008 on a server currently, and I believe MS change the ports SQL uses by default with 2008. I do appreciate the assistance though and I actually picked up a ton of helpful information for troubleshooting the sql ports and connections. Thank you all for the help. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
SQL Express 2008 on XP can't remotely administate
Tara Kizer