I got a bit of a problem with my connection. I wrote a programm in VB.Net wich connects to a sql-server 2005. On my local Computer everything works great, but on another Computer in the Network, I just receving timeouts. I allready check, if the sever allows remote connection.
My connectionstring for the SQL connection looks like this:
"Initial Catalog=Bauvorhaben;Data Source=P4-2400\SQLEXPRESS;Password=?;Persist Security Info=True;User ID=Lars"
I allready tried to get an connection to SQL-Server 2000. But the same here.
Does somebody have a clue, why I can't connect?
Thanks,
Lars
By default SQLExpress do not allow remote conneciton.
You need to
1. Turn on remote connection using SQL Server configuration Manager.
2. Start sqlbrowser service that is collocated with the SQLExpress server. SQL Browser service is needed if the sqlserver is a name instance, such as sqlexpress.
3. Make sure you make exception for sqlservr.exe in the firewall configuration of windows.
http://blogs.msdn.com/sql_protocols/archive/2005/11/14/492616.aspx
No comments:
Post a Comment