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 .
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:
Any ideas? All I’ve found when googling is suggestions to reinstall…