Error 40/53 when connecting to DASP with Studio Express

When trying to connect to SQL Server 2005 from a hotel internet (so I have no control over the infrastructure) I am getting an error:

SQL Server does not allow remote connections. (Provider: Named Pipes Provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

Any ideas on how to overcome this? I have a problem with a view that I urgently need to fix and can't connect to do that.

Thanks

marc

 

Hi,
In your SQL Server 2005 Start menu folder...
Look in the Config section for the Surface Area tools.
Run the Surface Area tool and you will see the wizards for features.

Other than that SQL Server should allow you to go outside.
Salute,
Mark

 

I can connect to DASP from home, so I'm not sure what running the Surface Area wizards would do different ....

marc

 

Hi,
Maybe they require a specific port? Can you ask someone at the Hotel?
Salute,
Mark

 

That would be my guess as well, Bruce.

Are there any other tools, web based perhaps, that anyone could recommend that can be used for situations like this where the ports are blocked and access is needed?

TIA

marc

 

Hi,
If 1433/1434 are blocked I think you can use Named Pipes instead.
Salute,
Mark

 

Named pipes don't work either.

Port 14330 appears to be blocked.

I agree that most web based interfaces suck, but it beats having to code an asp page to do what needed to be done. I'm not looking for something to use all the time, just for the occasions when I have an emergency and I'm at work or stuck in some hotel somewhere.

TIA

marc