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.
deanlee17Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
deanlee17Author 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 DeveloperCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.