I have created a login with SQL Authentication credentials in SQL Server 2008. But I cannot log in using those credentials.
We followed the same steps in SQL Server 2005 and are working without any problems.
What could be the problem?
Thank P.Gopalakrishnan.
Have you checked if SQL Server Authentication is enabled? It is disabled by default. In SQL Server Management Studio, right click on Server, Properties, Security, SQL Server and Windows Authentication Mode.
have you confirmed that you are logging into the correct instance of SQL Server on the machine where you created the login?