I have a created a local user called 'MynetDB' with SQL Server Authentication (password) in SQL server 2008. Server roles is public
and user mapping to 2 databases as db_owner
and public
. Status has Permission to connect database engine:
= Grant and Login:
= Enabled.
When I try to connect to server database engine with SQL Server authentication it is giving error Login failed for user 'MynetDB'. (Microsoft SQL Server, Error: 18456)
I also tried from C# code giving same error. Please advise me how access the databases?
Edit:
I am getting error on Management studio also
C#
<remove name="MyNetDB" />
<add name="MyNetDB" connectionString="Data Source={ServerName};Initial Catalog=MynetDB;User Id=MynetDB;Password=taD6eg4c;" providerName="System.Data.SqlClient" />
Best Answer
To figure out exactly what is happening, you should check the State that is reported in the message, either in the event log or SQL Server log. For example:
The state will usually help narrow down the exact cause. Here is a list of the states and their meanings: