Micros RES 4.6 DB will not start

[Bigyellowdog]

clicking on "front of house" in control panel to start system it changes to yellow then in couple minutes then back to red x.

sql database server status FAULT.

Help please.

Run command to force the start?

Thanks in advance.

 

[DrZogg]

Have you changed the computer name? run services.msc and check the name of sqlYOURSERVERNAME and compare the server name with the actual PC name.

If the SQL service has not started, start it.

 

[Bigyellowdog]

computer name is micros. services are running.

how do I check sqlYOURSERVERNAME? Thanks for the help

 

[DrZogg]

check your services and look for sqlMICROS running as a service. YOURSERVERNAMEHERE means put the name of your server here.
Windows>start>run>services.msc will open the srevices window.

 

[Bigyellowdog]

yes computer name is Micros and in services sqlMicros

In control panel db loads BUT..click on Config or anything else I get this..
IMG=http://img688.imageshack.us/img688/2366/configs.png][/IMG][/URL]

Try to Start Res it just hangs..
IMG=http://img703.imageshack.us/img703/7813/startres.png][/IMG][/URL]

 

[DrZogg]

In windows>run> DBENG9

Browse to the DB.

See if it starts.

 

[DrZogg]

Also run:

"C:\Program Files\MICROS\Res\Pos\Bin\LogViewer.exe"

Watch the DB log and find the exact error you are getting on starting DB.

Is it on all levels or only when moving to FOH? The log will tell you exactly what you need to know

 

[ljcampagna]

Posibly a transport key error?