Cannot open database requested by the login. The login failed.Login failed for user domain\username

By [)ia6l0 iii

You will get this SQL Connection error, if your SQL Server is not configured to use SQL Server authentication. You need to enable mixed mode authentication to enable both Windows and SQL Server authentication mechanisms.

Follow these steps to set up Mixed Mode security:

1. Expand a server group.
2. Right-click a server, and then choose Properties from the context menu.
3. Click the Security tab.
4. Under Authentication, choose SQL Server and Windows.
5. Click Ok to apply the changes,

Related FAQs

Find if tables has Clustered Index in a database
Find if a table has a Clustered Index using the Information_Shcema tables.
Use the Replicate function in SQL to print specific number of Characters
This is extremely useful function when you want to display number of characters depending on some column value.
Compound operators in SQL Server 2008?
Simpler syntax in SQL Server 2008.
Cannot open database requested by the login. The login failed.Login failed for user domain\username  (1930 Views)