Monday, February 20, 2012

Remote connection failed

I had made an application which is using SQL Expresss.

When I deploy that application on a server where only .Net Framework 2.0 is installed then it gives an error of remote connection.

Does that need some prerequisite for SqlExpress or the reason of error is something else.

Dear Rajkumar,

By default Sql Express does not allow remote connections.

Configuring remote connections is shown overhere.

HTH,

Suprotim Agarwal

|||

The Given points are written on the article you provided.

?Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.?Turn on the SQL Server Browser service.?Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.

But I don''t have any SQLExpress Server or SQLServer2005 installed on my server machine.

I have only .net framework 2005 installed.

|||

Dear rajkumar,

I agree that your application is deployed on the server where only .NET framework is installed. However my question is where is the database installed.

Well if the db is installed in your machine apply the suggestions given in the post to enable remote connections on your database.

HTH,

Suprotim Agarwal

No comments:

Post a Comment