Creating the Report Dataset

  • When im trying to create the query and clicking Query Designer an error is poping up.

    " Login failed for user ....."

    What to do??

    help plz.

  • The user you have specified in the data source doesnt have access to the SQL server or database in the datasource.

    If you have used a SQL login, ensure the users name and password are correct and that the user has access to SQL and the database, if using windows authentication ensure that your account has access to SQL and the database.

  • Just in case you're a newbie like me...

    You need to add a valid username and pwd or use Windows Authentication to the datasource credentials.

    Double click your datasource.

    Click Credentials, enter your SQL username and pwd or click "Use Windows Authentication.."

  • thank you:)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply