Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get the user/password of a database

Status
Not open for further replies.

Cooperdam

MIS
Oct 7, 2009
65
US
HI I created a database a while back but don't recall much about how i did this. It is a small database holding the users names and reports they can get.

Now I have a program that is trying to read this database and get the reports to present in a combo box. But it's not displaying the data. I am using the same id and password as other established databases on the server. so I don't know if this is correct or not.

How do I determine what is the id and password?
 
In case I wasn't clear
i need to access a database in a webconfig file as in this example: Where do i find the User Id and password?

<connectionStrings>
<add name="ConnectionString" connectionString="Server=REPORTSERVER\SQLSERVER2008;Database=Medical;User ID=sa;Password=sa;" />
 
I think you should log in to the database using windows authentication. Then you can change the password to be anything you want.

On a related note... Are you really logging in to databases using the sa login?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
If you are the current person responsible for the database(s), then I encorage you to stop using sa. It's a huge security risk.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top