Post reply

Prompting user for credentials rather than using Windows Authentication

  • July 16, 2015 at 8:49 am

    #318986

    Hi guys,

    We now have a user setup in the database that we need to access. For the credentials if I select to use windows authentication then use input parameters for the server address and database name then it all logs in fine. However if in the credentials area I select 'prompt user' and enter my windows credentials, then enter the server address and database name it does not allow me access. So is windows authentication doing something i'm not aware of?

    Thanks

    Dean

  • July 16, 2015 at 9:15 am

    #1813017

    If you are using Windows authentication, you don't need to manually enter credentials... It will automatically take the login token from Windows layer and present it to SQL Server through Kerberos.

    Only for SQL login (created inside SQL Server), you need to manually enter login and password.

  • July 16, 2015 at 9:21 am

    #1813024

    I was logging in using my windows credentials when prompted to ensure the connection worked and the report returned data. Users will not be using windows authentication.

  • July 16, 2015 at 2:16 pm

    #1813125

    that sounds like a [data source] or [shared data source] was added, but does not have saved credentials in it.

    check the data source of the report you were prompted with.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 16, 2015 at 2:51 pm

    #1813132

    It is a data source yes. I don't want to save credentials, I want the user to be prompted each time the report is run.

  • July 16, 2015 at 5:13 pm

    #1813148

    So is everyone goi g to put in th3 same credentials, like Reportreader /SOMEPASSWORD? or will each user have a set 9f sql credentials

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 17, 2015 at 2:43 am

    #1813188

    At present each person will use the same credentials to access the remote server and one Sql user. This may change over time hence the need for the user to enter the details themselves.

Viewing 7 posts - 1 through 6 (of 6 total)

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