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
