Windows Server 2000/2003 Thread, MS SQL 2005 Database connection error in Technical; I'm getting what looks like a connection error when trying to access a SQL database - it's started doing this ...
21st June 2010, 12:33 PM #1
MS SQL 2005 Database connection error
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 :
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
IDG Tech News
21st June 2010, 12:47 PM #2
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?
21st June 2010, 03:08 PM #3
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?
21st June 2010, 04:39 PM #4
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?
21st June 2010, 04:47 PM #5
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
22nd June 2010, 10:22 AM #6
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
By UkDraxion in forum Wireless Networks
Last Post: 7th December 2009, 03:25 PM
By Ric_ in forum MIS Systems
Last Post: 2nd October 2009, 12:21 PM
By Heebeejeebee in forum MIS Systems
Last Post: 7th April 2009, 03:19 PM
By tom_newton in forum Windows
Last Post: 23rd January 2008, 05:10 PM
By jcollings in forum MIS Systems
Last Post: 22nd October 2007, 03:00 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)