Login failed for user "Sachin"
There is a very simple solution for this...
just check the connection string you have used, wrong values in the connection string cause this error.
Check if the username and password you are using for connection are correct for the specified database.
If u dont know the Username n Password try "sa" as username and a blank password.
And if this dosent work try this ...
1. Click Start - Programs - Microsoft SQL Server - Enterprise Manager to open the Enterprise Manager.
2. Connect to the appropriate Server if the SQL is a client installation.
3. Right click on the Server Node and click on Properties.
4. This opens the Properties Dialog.
5. Switch to the Security Tab.
6. Under the Security section, make sure the Option SQL Server and Windows is selected.
7. This ensures that your SQL Server is running under Mixed Mode Authentication.
I , Me , Myself
- Sachin
- Hi .. This is Sachin Uchil. I have been in the field of .NET development for about 2 years now. Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.