Hi I'm trying to connect my reports to my sql database using OLE DB. So i select the Microsoft OLE DB Provider for SQL Server. I then enter the following details: Server: s03.Winhost.com UserID: DB_xxxxx_dbname_user Password: dbpassword Database: DB_xxxxx_dbname however it says i have the incorrect password even though i definitely have the correct password. Am i entering the correct info? Any other reason why it won't work? Thanks
The error message you have an incorrect password is fairly straight forward. I do not know what else to tell you other then double check your db login and db password. Also make sure you are pointing to the correct SQL server. Since you blocked out your database information I really can't go into our records and double check for you. But the error that says "You have an incorrect password" only means you are not typing the correct db login or db password.