I'm a complete noob at windows servers and IIS so please be patient with me.
I originally set up a website using php/mysql. I have the website running PHP with FastCGI through IIS already, but the SQL Server part is tripping me up. I'm shocked that there are no instructions about this that I can find anywhere.
I installed a bunch of SQL Server options through the Web Platform Installer (WPI). I can't connect using
sqlcmd or the Microsoft SQL Server Management Studio. I get the same error for both ("A network related or instance-specific error has occurred...") I know I'm missing a vital step to start up the server and connect to it, but I can't find what I need to do anywhere. SQL Server (SQLEXPRESS) is displaying as running in my services list. In the SQL Server Configuration manager, SQL Server (SQLEXPRESS) is shown as running in the SQL Server Services list. SQL Server Browser and SQL Server Agent are listed, but stopped, and the option to start them is grayed out.
I need to be able to create my DB on this machine through something and connect to the server through php with the sqlsrv driver. The sqlsrv_* functions work, but I can't connect to
sqlsrv_connect() either. I'm sure I'm just missing some important step to get the server actually running.
I'd love to use LAMP, but a lot of the other application software relies on SQL Server and windows.