Passing login credentials in data string

deanlee17
deanlee17 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Developer
Commented:
Well, this makes management more complex. First of all you need to switch your server to mixed authentication. Then you need to create a login for each SQL user. Then you need to create a user for the login in each database the user should access.

Author

Commented:
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?
ste5anSenior Developer

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial