Microsoft SQL & application software.

3DNow! · 11 Nov 2014 at 15:00

Hi,

I have a software that is setup through Microsoft Sql server.

I have set it up, now when I start up the program (client) it takes me into a log in screen asks for a log in I'd and password.

Unfortunately I don't remember them anymore and I don't have the manual anymore as it is not been used in 4+ years.

Is their a way to create an administration account through my database so I could access the program
Or access the default administration log in details for the program?

All help would be appreciated.

davetherave2 · 11 Nov 2014 at 20:40

Well if you have database access via ssms then you could try to look at the data but if the passwords are encrypted then you may be out of luck unless you know how the passwords have been encrypted and can either decrypt them or create a new encrypted password. Is this a custom application or an off the shelf product?

3DNow! · 11 Nov 2014 at 20:44

davetherave2 said:
Well if you have database access via ssms then you could try to look at the data but if the passwords are encrypted then you may be out of luck unless you know how the passwords have been encrypted and can either decrypt them or create a new encrypted password. Is this a custom application or an off the shelf product?

It's custom program. And I do have access to the database, I was hoping if somehow I could create a log in account with admin rights and delete the old one.

davetherave2 · 11 Nov 2014 at 21:03

Well have you had a look at the underlying database at all?

Without knowing how the database is constructed and how the user authorization/ authentication system is working it is difficult to give a decent answer.

If you can provide a backup file of the database I could try loading it on one of my test machines and see if it is easy to get access to the system.

Obviously if there is sensitive data in there I understand if you don't want to share.

3DNow! · 12 Nov 2014 at 07:55

davetherave2 said:
Well have you had a look at the underlying database at all?

Without knowing how the database is constructed and how the user authorization/ authentication system is working it is difficult to give a decent answer.

If you can provide a backup file of the database I could try loading it on one of my test machines and see if it is easy to get access to the system.

Obviously if there is sensitive data in there I understand if you don't want to share.

You have an email I can send it through.it's about 100mb

davetherave2 · 12 Nov 2014 at 09:35

send email via trust, but for a file of that size I would suggest putting it on dropbox or other online storage platform and emailing me the link via trust.