Avatar of deanlee17
deanlee17
 asked on

Passing login credentials in data string

Hi guys,

As the title suggests, is this possible? If I switch credentials on I cannot view my parameters. I want to have the following text boxes:

Server:
Database:
Username:
Password:

Initially I had Integrated Security = SSPI in the connection string but I want to use that and use the credentials the user enters in the parameters textbox?

Thanks,
Dean.
Microsoft SQL Server 2008SSRS

Avatar of undefined
Last Comment
ste5an

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
ste5an

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
deanlee17

ASKER
Ok 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?
ste5an

This "credential area" is for SQL Authentication only. Windows Authentication is based on your user account and its login information. You don't need to provide your credentials again.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck