Error Connecting to Remote Server Using Microsoft SQL Server Management Studio Express

Dear All,

I am trying to connect to a remote sql server 2005. So I have install the Microsoft SQL Server Management Studio Express. When I try to connect I get the error below.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings 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). Can some one please help. I have even port no 1533 on my pc. Thanks.

This support article might give you some more info..

http://support.microsoft.com/kb/914277

By default, SQL 2005 servers are configured to not allow remote connections through TCP/IP. This is a security measure. You will want to ensure that the remote SQL Server you are trying to connect to is configured to allow remote connections.

Hopefully this helps, if not, please post back with more info.

-Steve

|||

Also, here is a similar thread that you might want to skim through to see if there are any other ideas there

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=847152&SiteID=1

|||

Dear Steve,

I have manage to connect the problem is on my side because of the port I never opened. I realy wish you thanks for all the references you gave and help. Thanks.

|||

I am facing same problem.

I want to connect to Remote Server (windows 2003 server). Iam using Deveoper ed. connecting to express ed.

I have allowed TCP-IP and enabled browser service. and restarted server also. windows firewall disabled.

I want to know where port involes in sql server and where to configure port for both sql server server.

Does SP1 creates probelm if it is not installed.

Error Connecting to Remote Server Using Microsoft SQL Server Management Studio Developer

Dear All,

I am trying to connect to a remote sql server 2005. So I have install the Microsoft SQL Server Management Studio Express. When I try to connect I get the error below.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings 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). Can some one please help. I have even port no 1533 on my pc. Thanks.

This support article might give you some more info..

http://support.microsoft.com/kb/914277

By default, SQL 2005 servers are configured to not allow remote connections through TCP/IP. This is a security measure. You will want to ensure that the remote SQL Server you are trying to connect to is configured to allow remote connections.

Hopefully this helps, if not, please post back with more info.

-Steve

|||

Also, here is a similar thread that you might want to skim through to see if there are any other ideas there

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=847152&SiteID=1

|||

Dear Steve,

I have manage to connect the problem is on my side because of the port I never opened. I realy wish you thanks for all the references you gave and help. Thanks.

|||

I am facing same problem.

I want to connect to Remote Server (windows 2003 server). Iam using Deveoper ed. connecting to express ed.

I have allowed TCP-IP and enabled browser service. and restarted server also. windows firewall disabled.

I want to know where port involes in sql server and where to configure port for both sql server server.

Does SP1 creates probelm if it is not installed.

Error connecting to .sdf database

Dear All,

I am trying to connect to a .sdf database. I am building a console application. First I got an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Then I manage to solve "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". So wat is the possible error on my side ?

Is it not amazing. I have been searching the forums for a solution to this specific problem for weeks now and everyone that answers has no idea what it is we are requesting. you get redirected to a thousand other sites that still can not answer this question. I dont think anyone knows how to solve this!

|||

Which version of the product are you using?

Checking the basics first: Is the product installed on your machine ( check in Add and remove programs).Also check that the System.Data.SqlServerCe.dll is in GAC (C:\windows\assembly).

If your installation was correct, then sqlceme30.dll (and other dlls) should be loaded automatically using some registry settings.

Btw, did you try reinstalling the runtime package on your machine?

Error connecting to .sdf database

Dear All,

I am trying to connect to a .sdf database. I am building a console application. First I got an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Then I manage to solve "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". So wat is the possible error on my side ?

Is it not amazing. I have been searching the forums for a solution to this specific problem for weeks now and everyone that answers has no idea what it is we are requesting. you get redirected to a thousand other sites that still can not answer this question. I dont think anyone knows how to solve this!

|||

Which version of the product are you using?

Checking the basics first: Is the product installed on your machine ( check in Add and remove programs).Also check that the System.Data.SqlServerCe.dll is in GAC (C:\windows\assembly).

If your installation was correct, then sqlceme30.dll (and other dlls) should be loaded automatically using some registry settings.

Btw, did you try reinstalling the runtime package on your machine?