Member Avatar for jineesh

I was connecting my sql 2005 database from windows applications using a specific username and password. when i have created the user manually i can connect easily to my application.
but when i created the user with code ie using sql scripts i was not able to connect to the database.
This is the message i am geting "Login failed for user 'dbAdmin'."
error code is -2146232060
error num is 18456
What can i do? Please any one help me.

Regards,
Jineesh

  • 3 Contributors
  • 2 Replies
  • 116 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by Fruit Alchemist
Member Avatar for thines01

Are the parameters for your connection string correct?
Are you using a SqlConnectionStringBuilder?

Member Avatar for Fruit Alchemist

Check if you username and password is correct on the sqlconnection string. Also make sure your sql instance is configured to allow sql server and windows authentication. Check that also in your sqlconnection string.

Edited by Fruit Alchemist because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.