Every time I try to connect to my database, I get the following error: Login failed for user 'sa'. Does anyone know what is wrong? Is the user name wrong? Is the password wrong? I have been having this problem for a while now and I have no idea why this s happening.
I have SQL Server and Windows Authentication mode selected.
I am using SQL Express 2008.
My username and password is for the database, not my windows login.
Has only one come across this problem before?
I am now getting following error:
The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
- I know SQL server is running because I have a program that is already connected to the database