I need to restore master Db on my SQL 2005. But I get an error. From prompt I stop the sql instance, then restart it in single user mode with /m command. Then launching sqlcmd -s nameistance I've this error
Msg 18461, Level 14, State 1, Server ServerName, Line 1. Login Failed for user 'ServerName/Administrator'. Reason: server is in single user mode. Only one administrator can connect at this time.
Then I go to stop all other sql service and sqlcmd work.
Then I restore the master DB and going restarting sql, the service don't want to start.
Maybe a user problem? Restoring old master I don't restore the new user created in the new sql installation and it don't start it? Or what?
I give to you some more details of the situation. The server hard disk where an ERP was installed, crash at startup. I've all backup for master, msdb, model and society dB and ERP core. Then I've all MDF and log file for all SQL DB in the data folder. Now I've restored all backup, so not MDF, and the only one I can't restore is the master. The ERP is very old and need SQL 2005.
As I read you mean that is not enough to have DB but I need also Windows registry key? Because the support has been discontented and my reseller don't have setup for server. They don't remember if it's enough to restore only DB so I want to restore also master to understand if it can work the same. I've also the server folder with all ERP files. There's no installation folder in the server. Only this folder copied manually in C:
Original Master has one table dedicated to user login, that in the standard SQL master is not present. And the error I receive from clients is for a user login problem. But when I restore master, SQL service don't start. So I was thinking that, if in the new installation of SQL I've set an user different from to original one, because I don't know it, so when I restore the old one, user is different and SQL don't start.