Andrew Gunn's Blog: error: 28 - Server doesn't support requested protocol

Monday, 25 February 2008

error: 28 - Server doesn't support requested protocol

After trying to setup SQL Server 2005 Express, I kept getting the following error when I tried to connect from a web application:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol)"

Network protocols are disabled in SQL Server 2005 Express by default so we need to enable TCP/IP:

Launch the SQL Server Configuration Manager

Expand the "SQL Server 2005 Network Configuration" node

Left click the "Protocols for SQLEXPRESS" node to view the supported protocols

Right click the "TCP/IP" protocol and select "Enable"

42 comments:

Anonymous said...: Hai,
Tks for the post to solve my problem.

Kasi; 31 March 2008 at 05:18
Anonymous said...: This helped me as well. RTFM... who needs that hassle!

Thanks,
-DS; 4 April 2008 at 02:59
Anonymous said...: Thanks. That was exactly what I needed to know.; 26 June 2008 at 15:08
Anonymous said...: You helped me, too! Thanks, guy.; 9 July 2008 at 02:55
Anonymous said...: This short and exact post solved my problem. Thanks!; 13 July 2008 at 08:49
Anonymous said...: Thank you for posting this, I had the same issue.; 9 September 2008 at 19:49
Hallowtheme said...: Thanks for a quick fix to my issue.; 21 October 2008 at 14:42
Hallowtheme said...: Thanks for fixing my problem.; 21 October 2008 at 14:43
Anonymous said...: Thank you, that was the problem!; 17 November 2008 at 15:33
Unknown said...: Fixed my problem. Thanks!; 21 November 2008 at 09:36
Anonymous said...: Thanks! :); 28 November 2008 at 11:20
The Waffles and Pancakes blog said...: Solved my problem with SQL Server 2008 as well. TCP/IP isn't enabled by default on new instances.

Thanks!; 26 January 2009 at 15:21
Unknown said...: BIG hanks for you Andrew :-D
that is it.; 17 February 2009 at 18:29
Linglom said...: If you want to see more detail steps, visit Enable remote connection to SQL Server 2005 Express; 11 April 2009 at 11:26
Anonymous said...: Thank you, it help to solve my problem too!; 27 May 2009 at 01:09
Anonymous said...: Thanks Andrew. Useful information.
- Karthik; 20 July 2009 at 17:23
Anonymous said...: Thanks for the post! It solved my problem.; 1 August 2009 at 22:24
Mark said...: Thanx.. This really helped me a lot..; 3 November 2009 at 07:10
Anonymous said...: Thanks a lot!; 19 November 2009 at 20:39
Unknown said...: U Freakin awesome man :D ... u helped me after sitting searching for this Error agessss .... COOOLLLL ;); 16 December 2009 at 02:04
Anonymous said...: Thanks!; 21 January 2010 at 11:57
granadaCoder said...: Sometimes you need to RESTART THE MSSQL Service for it to "kick in".

"Sql Server"
or
"Sql Server (MyInstance)"
under Control Panel -- Services.

..

Restart "Sql Server Browser" while you're there........if you have remote machines talking to your server and getting the issue.; 2 February 2010 at 19:47
Anonymous said...: Thanks mate. Very helpful. Nice screen shots.; 28 April 2010 at 19:03
Kris Hen said...: Thank you very much for your post, would have driven me crazy if I didn't know that setting!; 4 June 2010 at 00:37
Anonymous said...: Thanks! from Peru :P; 8 July 2010 at 18:20
Anonymous said...: Thanks for the post. It fixed my problem!; 26 July 2010 at 15:18
Anonymous said...: THANKS!!!! really helped me; 22 September 2010 at 19:04
Anonymous said...: Hey Andrew thank you soooo much for this. It worked like a charm. You really saved me hours of frustration!!! Thanks again!!; 3 February 2011 at 15:07
Anonymous said...: Thanks a lot :); 30 March 2011 at 05:08
Anonymous said...: thank u very much 4 ur help.; 12 April 2011 at 18:57
Anonymous said...: Hi,

Thanks a lot! Works for me

Shaheen; 22 April 2011 at 12:57
Frank said...: just what i was looking for thanks; 5 May 2011 at 16:30
Frank said...: Just what I was looking for thanks for the help; 5 May 2011 at 16:31
Tamzin Nicholas said...: omw...thanks for this dude...was irritating me now for a long time; 19 May 2011 at 09:06
Martin and Fran said...: Totally brilliant. I have spent all weekend trying to work out a solution. Discovered a different Event Log which google sent me straight to this site. THANK YOU!; 14 June 2011 at 13:29
Anonymous said...: Three years later your thoughtful comment is helping other people, this time for SQL 2008. Thanks!

Tim; 22 July 2011 at 19:43
Anonymous said...: Quickly solved my issue.
Thanks!; 5 August 2011 at 08:01
Nosfi said...: In my case too. Problem solved. Thanks.; 26 August 2011 at 08:46
sunil said...: Thank you very much you have saved my day...; 17 September 2011 at 07:33
Anonymous said...: good tip..
saved my time :); 19 September 2011 at 13:03
Anonymous said...: always gets me - thanks.; 8 January 2012 at 08:37
Sharanya said...: Really helpfull... thanks..; 24 January 2012 at 03:37