By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,727 Members | 1,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,727 IT Pros & Developers. It's quick & easy.

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

P: 4
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.SqlServer.Express.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

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

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

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

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)
Mar 11 '08 #1
Share this Question
Share on Google+
2 Replies


deepuv04
Expert 100+
P: 227
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.SqlServer.Express.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

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

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

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

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
Mar 12 '08 #2

P: 10
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.exe" 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 "Connections" 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.
Mar 13 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.