Am instalat pe o imagine virtuala de windows server 2008, sql server 2008 express edition.
Am instalat sql -ul, named instance. Apoi am schimbat numele calculatorului.
Dupa acest pas nu a mai pornit sql-ul. Am incercat sa restartez serviciul, degeaba.

Am cautat pe net si am aflat ceva legat de "master".

Mesajul din fisierul de log
"  Error 5(Access is denied.) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\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. "

Ce pot face sa pornesc totusi sql-ul?

marcel soare:

Am instalat pe o imagine virtuala de windows server 2008, sql server 2008 express edition.
Am instalat sql -ul, named instance. Apoi am schimbat numele calculatorului.
Dupa acest pas nu a mai pornit sql-ul. Am incercat sa restartez serviciul, degeaba.

Am cautat pe net si am aflat ceva legat de "master".

Mesajul din fisierul de log
"  Error 5(Access is denied.) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\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. "

Ce pot face sa pornesc totusi sql-ul?

Detaliaza eroarea: ce nu a mai pornit ? SQL Server Management Studio sau serviciul ?

http://www.sqlservercentral.com/Forums/Topic334467-149-1.aspx

Books Online > How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/bbaf1445-b8a2-4ebf-babe-17d8cf20b037.htm

Din pacate cred ca o solutie mai rapida ar fi reinstalarea SQL Server 2008 Express edition.

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro