How to get the user/password of a database

[Cooperdam]

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?

 

[Cooperdam]

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;" />

 

[gmmastros]

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

 

[Cooperdam]

Yes, it wasn't me who set this up.

 

[gmmastros]

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