MS SQL 2005 Database connection error

[mcheung0]

I'm getting what looks like a connection error when trying to access a SQL database - it's started doing this after virtualising the server it's installed on from a microsoft virtual server to a XenServer

This is the eventvwr error on the server :

[17113 :
initconfig: Error 2(error not found) opening 'C:\MSDEMSSQL\Data\master.mdf' for configuration information.]



and there's an error that occurs when trying to connect to the database instance from another server (screenshot)

It looks like it says it can't connect probably due to the server switching

Any ideas?

Thanks
Michael

[sister_annex]

Check your SQL config to make sure TCP/IP connections are allowed and also named pipes are enabled.

was it a p2v conversion or was it a fresh build - the usual service packs etc i presume have been installed?

Mark

[mcheung0]

Thanks for the responses - The server didn't change name

I'm having difficulty changing settings for the SQL installation on the server as Server Configuration won't open - Have attached another screenshot for this

Sorry should have included this earlier

Any other ways of editing the config?

The process was Virtualised server (MS) to Virtualised server (Citrix XenServer) - V2V?

Thanks
Michael

[mcheung0]

Update:

read this SQL Server 2005 WMI Provider Error - Technical Weblog of Eric Charran - Site Home - MSDN Blogs and ran the command C:\Program Files\Microsoft SQL Server\90\Shared>mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof" as suggested

this fixed the problem of being denied access to SQL Configuration Manager (NOTE: I had cd to the 'Shared' Directory then run the command minus the directory path) Hoorah!

What settings should I be looking for in regards to getting my database connections correct again?

Mark, you mentioned TCP/IP - could you elaborate?

Thanks
Michael

[mcheung0]

further update:

when trying to start the SQL service It fails and I have this error in eventvwr :

'Error 2(error not found) occurred while opening file 'Error 2(error not found) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL$NET2\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.' event ID 17113

Thanks
Michael

[mcheung0]

SOLVED:

my startup path for the SQL database was incorrect - the database file had been transferred to
'C:\Program Files\Microsoft SQL Server\MSSQL$NET2\Template' -

Copying this back to the correct
'C:\Program Files\Microsoft SQL Server\MSSQL$NET2\Data' directory
lets the service boot correctly... ah basic mistakes

Michael