Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 17, 2012 01:01 PM by rickyaliasgar
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.
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?
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.
Oct 04, 2010 11:18 AM|LINK
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.
Oct 05, 2010 07:33 AM|LINK
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.
Dec 16, 2010 02:49 PM|LINK
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.
Mar 04, 2011 05:03 PM|LINK
Enable SQL browser service allow you to Remote Desktop connection
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.
Aug 22, 2011 04:21 PM|LINK
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.
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.