MIcros 9700 microsdb password 2

[themicrosman]

I have a database that I am trying to recover and import to a lab system that I use. After the import, I try to start EMC and I get the following error.
“Unable to connect to the specified database server”
“Login failed for user ‘microsdb’
Enter the database server name and try again.

Does anyone know how I can change the microsdb password so I can open the EMC? Or any other ideas?

 

[hosehead78]

Here's a thought. When you open EMC, what are you entering as the computer name? Are you using localhost or another name?

Connect to the Micros Database (via SQL Studio Management) and Open up a SQL Query Window.
Type the following: SELECT @@servername
run the query. This will return the correct server name to connect to.

You can rename the server name to your current/restored to name
Type the following in the Query window:

sp_dropserver 'old_name'
GO
sp_addserver 'new_name', local
GO


Where old_name and new_name are, replace them with the old name you got from the first query, and replace the new_name with the new server name.

Close the Connection to the Database.
Stop and Start the SQL Server Service (where the db is located).

See if you can connect now using the new/current Server name.

 

[nstanoszek]

I have a utility that is called getdba...it might help??

 

[hosehead78]

I haven't heard of it. Could you explain what it does?

 

[themicrosman]

Nstanoszek could you post such tool? So we could try it? I would greatly appreciate it

 

[Wildbar]

I have the utility as well. Micros put it on a 3700 system. I have never used it or tested it. No idea if it will work for a 9700 system.
I don't want to post it the app on here as don't think it should be out there for everyone. If somebody wants to take a look at it and use it in a testing environment let me know and I will try and get it to them. My understanding is it will just grab the dba credentials out of an SQL database

 

[hosehead78]

I have a 9700 Lab Environment, if you want to send it to me, I can check it out. Let me know if you want my info.

 

[bufftrek]

I actually have a test setup for 3700 that I would like to test it on.
Give me a heads up if you need my info.

 

[themicrosman]

Make that Three of us who would like it.

 

[Wildbar]

Give me some info and I will get it to you.

 

[hosehead78]

Not sure I know how to get you the info, other than posting it here and we're not supposed to do that. ;-)

 

[Wildbar]

I'll put it up for the day. Let me know if you get it.

https://www.dropbox.com/s/6kq0tl1lbi7nvrz/getdba1.exe?dl=0

 

[hosehead78]

great thanks. any special instructions?

 

[Wildbar]

Just need to have a managers login and password for the database and should be good to go....
Let me know if it works on 9700

 

[themicrosman]

The link is bad

 

[Wildbar]

https://www.dropbox.com/s/6kq0tl1lbi7nvrz/getdba1.exe?dl=0

 

[hosehead78]

Wildbar, can you post it again. I don't remember where I stored it.

 

[Wildbar]

https://www.dropbox.com/s/rulyhbpojkeo9lf/getdba1.exe?dl=0

 

[hosehead78]

Got it, thank you.