SQL Guru request

[Deek]

Any SQL Guru's in here?

I am trying to migrate a database to a new server for a client that doesn't want to pay the $12K to Deltek to update his support contract. It seems there is a hard coded password in the app to login to SQL...so....

Is there anyway (like using sql profiler) to see what password it is trying so I can set the account correctly??? Or to see the saved password in SQL on the old server?

Thanks in Advance!


SQL 2008R2
Server 2012

 

[Deek]

[Solved] Re: SQL Guru request

So believe it or not, I ended up guessing the password I was looking for....I've been doing this too long ;-(

 

[Laxer]

That's great to hear because I am not sure anyone here would have known how to help you. :huh:

Or at least, no one who frequents. Fred Garvin may have been able to help you.

Aside from that, I would be your best bet but, all my hands on experience is with mySQL which is a whole different animal to MS SQL.

It's funny, for both my SQL certifications I never had to really touch any specific DB. Sure some of the examples would use it but, for the most part it was all design and query writing. The only exceptions were the final projects which I both wrote the DB in mySQL and the front end in whatever web language best fit. (HTML,JS,PHP,ASP,etc).

Anyway, off to my computational structures class now :wave:

 

[Fred Garvin]

That's great to hear because I am not sure anyone here would have known how to help you. :huh:

Or at least, no one who frequents. Fred Garvin may have been able to help you.

What I find hilarious about that statement is YOU are the one I had to call when i had a SQL issue! :lol:

I had a similar issue with some software from Germany and no available support. Password ended up being part of the program name.

 

[Laxer]

That's great to hear because I am not sure anyone here would have known how to help you. :huh:

Or at least, no one who frequents. Fred Garvin may have been able to help you.

What I find hilarious about that statement is YOU are the one I had to call when i had a SQL issue! :lol:

I had a similar issue with some software from Germany and no available support. Password ended up being part of the program name.

SQL commands or MySQL connectivity sure....

Actual SQL software... Is all you...

The only thing I helped you do was find the correct connectivity kit to go from FoxPro to something usable...