SQL Guru request

Deek · Oct 16, 2013

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 · Oct 17, 2013

[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 · Oct 17, 2013

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 · Oct 21, 2013

Laxer said:
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 · Oct 21, 2013

Fred Garvin said:
Laxer said:

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.

Click to expand...

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...

Search

Search

SQL Guru request

Deek

Well-known member

Deek

Well-known member

Laxer

Co-Founder
Senior Administrator

Fred Garvin

Sysnative Staff

Laxer

Co-Founder
Senior Administrator

SQL Guru request

Deek

Well-known member

Deek

Well-known member

Laxer

Co-FounderSenior Administrator

Fred Garvin

Sysnative Staff

Laxer

Co-FounderSenior Administrator

Co-Founder
Senior Administrator

Co-Founder
Senior Administrator