Edit Question - KnowledgeHub

Title Body

Alright, I have a classic asp application and I have a connection string to try to connect to db. MY connection string looks as follows: Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial Catalog=mydb;database=mydb;User Id=me;Password=123 Now when I'm accessing db though front-en I get this error: Microsoft OLE DB Provider for SQL Server error '80040e4d' Login failed for user 'me'. I looked in the sql profiler and I got this: Login failed for user 'me'. Reason: Password did not match that for the login provided. [CLIENT: <named pipe>] Error: 18456, State:8. What I've tried: checked 100 times that my password is actually correct. Tried this: alter login me with check_policy off (Do not even know why I did this) Enable ALL possible permissions for this account in SSMS. Update: 4. I've tried this connection string: Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial Catalog=mydb;database=mydb; Integrated Security = SSPI And I got this error: Microsoft OLE DB Provider for SQL Server error '80004005' Cannot open database mydb requested by the login. The login failed.

Tags (comma-separated) Cancel