There are many things that could cause this:
1. No or wrong user id/password provided in the connection string
2. You use integrated security in the connectionstring but the server is set up to use sql-server security only
Post the string you use to connect to the database here.