How to get SQL Server 2008 running
If you get the login failed error message for your SQL Server database, then it's a good idea to make sure that everything runs as it should. Here's a post on how you get SQL Server 2008 up and running.
- The SQL Server Browser service is running.
You can find it under Services (Control Panel->Administrative Tools->Services)
- TCP/IP is activated.
You can activate TCP/IP through SQL Server Configuration Manager, under SQL Server Network Configuration->Protocols for (SQLEXPRESS). Right click TCP/IP in the list to activate.
- SQL Server and Windows Authentication mode is activated.
In SQL Server Management Studio, right click your instance->Properties->Security and tick SQL Server and Windows authentication mode.
- Remote Connections are allowed for your SQL Server instance.
In SQL Server Management Studio, right click your instance->Properties->Connections and tick Allow remote connections to this server.
Last, but not least - make sure your SQL Server database credentials are correct! Mind the server, database name, user and password.