Remote connection issues

My experience with SQL Server Express 2005 has been nothing short of a nightmare.

It is installed correctly, and is running, I can connect through management studio express and have created a database, but only to instances running locally. If I try from another machine, it won't connect, saying that the problem may be due to the fact that by default, SQL Server does not allow remote connections.

However, I have enabled remote connections (through TCP/IP and named pipes). I have added sqlserver as a firewall exception, to no avail, and disabled the firewall as well. Nothing seems to work.

Ultimately, I want to connect to a database and execute queries from a VB program.

I am a competent programmer but I am at my wits end.

Hi,

from your remote machine are you able to ping?! have you added a Exception for SQL Port in firewall? Is SQL Browser services and RPC service are running?! Refer below threads also http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1084910&SiteID=1 & http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=817457&SiteID=1

Hemantgiri S. Goswami

|||
Thanks Hemantgiri,

Yes, I can ping, I have added an exception (and turned off the firewall as well). SQL Browser is not running, I didn't think I need it. RCP seems fine.

Maybe there is another problem as well; when connecting locally an exception is raised:
System.Security.SecurityException was unhandled
Message="Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version.... " failed.

I still have no idea what to do, I can't progress until this is fixed.|||

Hi,

SSUser wrote:

Thanks Hemantgiri,

Yes, I can ping, I have added an exception (and turned off the firewall as well). SQL Browser is not running, I didn't think I need it. RCP seems fine.

Maybe there is another problem as well; when connecting locally an exception is raised:
System.Security.SecurityException was unhandled
Message="Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version.... " failed.

I still have no idea what to do, I can't progress until this is fixed.

refer threads for the error http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1027859&SiteID=1 & http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=881572&SiteID=1

SQL Browser service is required refer http://www.teratrax.com/articles/connecting_sql_server_express.html for why!!

HTH

Hemantgiri S. Gsowami