Connect to SQL using OLE DB

Discussion in 'Databases' started by taingstar, Dec 7, 2010.

  1. 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
     
    Last edited by a moderator: Oct 14, 2015
  2. Ray

    Ray

    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.
     

Share This Page