Try adding the "sql browser" and the "sql server database engine" to the allow programs on windows firewall. This may help you:
http://msdn.microsoft.com/en-us/library/cc646023.aspx specialy the Dynamic Ports part...
Did you figure this out Jess5K? I have the exact same setup and have no problem remotley connecting to my application database. But the connection won't work to the membership aspnetdb database. How did you fix this?
What it comes down to is that you must go under the SQL Server 2008 Management tools in the Start Menu. Go under the Protocols for the instance you are trying to reach. Make sure that you have all protocols enabled for connection the database. Thanks.
Go to All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager.
Now Sql Server Configuration manager window will appear. Expand SQL Server Netwoek Configuration, select Protocol for MSSQLSERVER & right click on TCP/IP in detail pane go to property and Select IP Address tab. Select in
what instruction written above by chandan is right, this should solve the problem, but i have one good fine visual article which has screen shots too, which will help to configure. please find the link below so others can use it.
Do you have an up to date or additional link to the one you provided above? I am having issues with my firewall and protocols and was hoping to use it as reference.
I realize this post is getting to be almost a year old, but your fix saved me as the server IP address had changed and updating the settings you indicated fixed the problem.
oswazteca
Member
18 Points
9 Posts
Re: how to enable remote Connection sql server 2008
Apr 01, 2010 04:14 PM|LINK
Try adding the "sql browser" and the "sql server database engine" to the allow programs on windows firewall. This may help you: http://msdn.microsoft.com/en-us/library/cc646023.aspx specialy the Dynamic Ports part...
Let me know anything.
sql server firewall remote connections
bwrede2
Member
2 Points
1 Post
Re: how to enable remote Connection sql server 2008
Jun 10, 2010 03:40 PM|LINK
Did you figure this out Jess5K? I have the exact same setup and have no problem remotley connecting to my application database. But the connection won't work to the membership aspnetdb database. How did you fix this?
Jess5K
Member
4 Points
3 Posts
Re: how to enable remote Connection sql server 2008
Jun 15, 2010 04:58 PM|LINK
What it comes down to is that you must go under the SQL Server 2008 Management tools in the Start Menu. Go under the Protocols for the instance you are trying to reach. Make sure that you have all protocols enabled for connection the database. Thanks.
deychandan
Member
5 Points
2 Posts
Re: how to enable remote Connection sql server 2008
Oct 04, 2010 11:18 AM|LINK
hi,
I am installing SQL Server 2008 in Windows XP with SP3.
I have enabled TCP/IP enabled, Named Pipe. Server Property -> Property -> Connection -> Allow remote connections to this server (Checked).
Open TCP/Port of 1433 in Firewall.
Now i amtrying to access this database from ASP.Net page. It will given an error 26.
Please help me.
Thanks in Advance.
Chandan
"MSSQL error"
deychandan
Member
5 Points
2 Posts
Re: how to enable remote Connection sql server 2008
Oct 05, 2010 07:33 AM|LINK
HI,
I solved the problem.
Go to All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager.
Now Sql Server Configuration manager window will appear. Expand SQL Server Netwoek Configuration, select Protocol for MSSQLSERVER & right click on TCP/IP in detail pane go to property and Select IP Address tab. Select in
IP1=> Active=Yes, Enabled=Yes,IP Address =<machine ip address>, TCP Dynamic Port=Empty, TCP Port=1433
IP2=> Active=Yes, Enabled=Yes,IP Address =127.0.0.1, TCP Dynamic Port=Empty, TCP Port=1433
IP3=> TCP Dynamic Port=Empty, TCP Port=1433
And click ok & Restart your SQL Server Service. Run your ASP.Net application its working.
Thanks
Chandan
"MSSQL error"
hemalkotak
Member
6 Points
3 Posts
Re: how to enable remote Connection sql server 2008
Dec 16, 2010 02:49 PM|LINK
Hi,
what instruction written above by chandan is right, this should solve the problem, but i have one good fine visual article which has screen shots too, which will help to configure. please find the link below so others can use it.
http://dotnetpedia.net/site/index.php?q=node/20
pavelcc
Member
2 Points
1 Post
Re: how to enable remote Connection sql server 2008
Mar 04, 2011 05:03 PM|LINK
Enable SQL browser service allow you to Remote Desktop connection
stilichio
Member
2 Points
1 Post
Re: how to enable remote Connection sql server 2008
May 18, 2011 09:17 PM|LINK
Do you have an up to date or additional link to the one you provided above? I am having issues with my firewall and protocols and was hoping to use it as reference.
Thanks,
march11
Contributor
2981 Points
1350 Posts
Re: how to enable remote Connection sql server 2008
Aug 22, 2011 04:21 PM|LINK
deychandan
I realize this post is getting to be almost a year old, but your fix saved me as the server IP address had changed and updating the settings you indicated fixed the problem.
thank you,
SudhaRubini
Member
391 Points
383 Posts
Re: how to enable remote Connection sql server 2008
Feb 08, 2012 07:56 AM|LINK
Hi chandan ,
i tryed your steps. but i get folloeing error
The request failed or the service did not respond in a timely fashion. consult the event log or other application error logs for details.
"MSSQL error"