CODEWITHSUNDEEP
sqlsql-serversql-server-2008authentication
gopal
gopal

Reputation: 3741

SQL Server authentication in SQL Server 2008

I created a login with SQL authentication credential in SQL Server 2008. But, I am not able to login using that credential.

We followed the same steps in SQL Server 2005 and working without any problem.

What could be the problem?

Thanks, P.Gopalakrishnan.

Upvotes: 2

Views: 625

Answers (2)

Richard
Richard

Reputation: 30618

Have you checked that SQL Server Authentication is enabled? It is disabled by default. From SQL Server Management Studio, right-click your server, Properties, Security, SQL Server and Windows Authentication mode.

Upvotes: 3

Alex H
Alex H

Reputation: 733

have you confirmed that you are logging into the correct instance of sql server on the machine that you created the login for?

Upvotes: 0

Related Questions