I want help with error message I get when I access remote DB

[sailor152]

I am having the following error when I try to access a remote DB on remote server from my MS SQL 2005 Studio Express

Anyone can explain why I have the following error
------------------------------------------------------------------------------------------------------

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlS erver.Express.S moEnum)

For help, click: http://go.microsoft.co m/fwlink?ProdName =Microsoft+SQL+ Server&LinkId=2 0476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlS erver.Express.C onnectionInfo)

------------------------------

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)

[deepuv04]

I am having the following error when I try to access a remote DB on remote server from my MS SQL 2005 Studio Express

Anyone can explain why I have the following error
------------------------------------------------------------------------------------------------------

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlS erver.Express.S moEnum)

For help, click: http://go.microsoft.co m/fwlink?ProdName =Microsoft+SQL+ Server&LinkId=2 0476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlS erver.Express.C onnectionInfo)

------------------------------

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)

Hi,
I think this is firewall issue

put your firewall off it will work other wise

Make sure you add a firewall exception for sqlwb.exe (the management studio executable). You might need to open up port 1433 TCP as well.

Thanks

[FredSovenix]

Is the server you're trying to access a regular SQL Server, or a SQL Server Express instance?

If the latter, you have to explicitly enable TCP/IP by going to the "binn" folder under the SQL Server Express installation and launching the "svrnetcn.e xe" utility. Such installation have TCP/IP turned off by default.

If the former, and it's SQL Server 2005, then TCP/IP is also turned off by default and you have to enable it by opening the Management Studio on the SQL server, right-clicking the server node itself, hit properties, go to "Connection s" in the menu to the left, and put a check-box next to "Allow Remote Connections to this Server".

Otherwise, you probably are dealing with a firewall issue.