«
»

SQL Server troubles

This post is part of a series about my experiences building a PHP app for Windows Server 2008 and IIS 7 for the European WinPHP Challenge 2009 which is sponsored by iBuildings, Microsoft and Leaseweb.

I'm now at the stage where I'm writing code and came across an error:

Message: 2 [Microsoft][SQL Native Client]
    Named Pipes Provider: Could not open a connection to SQL Server [2].

That seemed a little odd, so I fired up the Microsoft SQL Server Management Studio and logged in with the credentials that I'm using in the web app. It let me log in, so I went to click on the Databases item in the Object Explorer and got this message:

sqlmgnt_error.jpg

Any ideas? All I've found when googling is suggestions to reinstall...

This entry was posted on Saturday, 16th May 2009 at 21:01 and is filed under WinPHP Challenge. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

2 Responses to “SQL Server troubles”

  1. 1 Gargoyle
    May 16th, 2009 at 23:01 #

    Have you tried using a TCP connection instead of named pipe?

  2. 2 Rob...
    May 17th, 2009 at 08:42 #

    Gargoyle,

    Yeah - I finally worked that out late last night and fixed the web app issue. Still got the SQL Server Management Studio problem though.

    Rob...

The views expressed in these comments are not the views of the publisher. However, we believe in the rights of others to express their legitimate views and concerns. Any legitimate complaint emailed to rob@akrabat.com will be seriously considered and the post reviewed as desirable and necessary.

Leave a Reply

Buy now!