After installing two named instances of SQL Server 2008 R2 DataCenter edition (R2D2 and C3P0) I found the first instance would no longer start. The errorlog showed the reason to be an invalid path.
2010-09-14 18:15:39.12 Server Error: 17113, Severity: 16, State: 1.
2010-09-14 18:15:39.12 Server Error 3(The system cannot find the path specified.) occurred while opening file 'C:\MSSQL\SQLDAT\MSSQL10_50.R2D2\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup
option might have caused the error. Verify your startup options, and correct or remove them if necessary.
Finding the files in the proper location I check the ACLs and found the Local Group created for the second instance on the ACL for the first instance. That is to say for instance R2D2 I found MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$C3P0 instead
of the MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$R2D2 that was originally there.
master.mdf NT AUTHORITY\SYSTEM:(F)
It seems that creating the second instance causes this problem. I have been u
View Complete Post