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"


  • 43 comments:

    Anonymous said...

    Hai,
    Tks for the post to solve my problem.

    Kasi

    Anonymous said...

    This helped me as well. RTFM... who needs that hassle!

    Thanks,
    -DS

    Anonymous said...

    Thanks. That was exactly what I needed to know.

    Anonymous said...

    You helped me, too! Thanks, guy.

    Anonymous said...

    This short and exact post solved my problem. Thanks!

    Anonymous said...

    Thank you for posting this, I had the same issue.

    Hallowtheme said...

    Thanks for a quick fix to my issue.

    Hallowtheme said...

    Thanks for fixing my problem.

    Anonymous said...

    Thank you, that was the problem!

    Rasmus said...

    Fixed my problem. Thanks!

    Patrick said...

    Thanks! :)

    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!

    pzar said...

    BIG hanks for you Andrew :-D
    that is it.

    Linglom said...

    If you want to see more detail steps, visit Enable remote connection to SQL Server 2005 Express

    Anonymous said...

    Thank you, it help to solve my problem too!

    Anonymous said...

    Thanks Andrew. Useful information.
    - Karthik

    Anonymous said...

    Thanks for the post! It solved my problem.

    Mark said...

    Thanx.. This really helped me a lot..

    Anonymous said...

    Thanks a lot!

    Amr said...

    U Freakin awesome man :D ... u helped me after sitting searching for this Error agessss .... COOOLLLL ;)

    Anonymous said...

    Thanks!

    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.

    Anonymous said...

    Thanks mate. Very helpful. Nice screen shots.

    Kristopher said...

    Thank you very much for your post, would have driven me crazy if I didn't know that setting!

    Anonymous said...

    Thanks! from Peru :P

    Anonymous said...

    Thanks for the post. It fixed my problem!

    Anonymous said...

    THANKS!!!! really helped me

    Anonymous said...

    Hey Andrew thank you soooo much for this. It worked like a charm. You really saved me hours of frustration!!! Thanks again!!

    Anonymous said...

    Thanks a lot :)

    Anonymous said...

    thank u very much 4 ur help.

    Anonymous said...

    Hi,

    Thanks a lot! Works for me

    Shaheen

    Frank said...

    just what i was looking for thanks

    Frank said...

    Just what I was looking for thanks for the help

    Tamzin Nicholas said...

    omw...thanks for this dude...was irritating me now for a long time

    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!

    Anonymous said...

    Three years later your thoughtful comment is helping other people, this time for SQL 2008. Thanks!

    Tim

    Anonymous said...

    Quickly solved my issue.
    Thanks!

    Nosfi said...

    In my case too. Problem solved. Thanks.

    Anonymous said...

    Nice one!

    sunil said...

    Thank you very much you have saved my day...

    Anonymous said...

    good tip..
    saved my time :)

    Anonymous said...

    always gets me - thanks.

    Sharanya said...

    Really helpfull... thanks..