+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1
    mcheung0's Avatar
    Join Date
    Sep 2008
    Location
    York
    Posts
    24
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    13

    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 :

    [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
    Attached Images Attached Images

  2. #2
    sister_annex's Avatar
    Join Date
    Jan 2009
    Location
    Wolverhampton
    Posts
    594
    Thank Post
    100
    Thanked 136 Times in 120 Posts
    Rep Power
    49
    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

  3. #3
    mcheung0's Avatar
    Join Date
    Sep 2008
    Location
    York
    Posts
    24
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    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
    Attached Images Attached Images

  4. #4
    mcheung0's Avatar
    Join Date
    Sep 2008
    Location
    York
    Posts
    24
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    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

  5. #5
    mcheung0's Avatar
    Join Date
    Sep 2008
    Location
    York
    Posts
    24
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    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

  6. #6
    mcheung0's Avatar
    Join Date
    Sep 2008
    Location
    York
    Posts
    24
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    13
    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

SHARE:
+ Post New Thread

Similar Threads

  1. Sql 2005 Connection timout
    By UkDraxion in forum Wireless Networks
    Replies: 0
    Last Post: 7th December 2009, 03:25 PM
  2. Replies: 6
    Last Post: 2nd October 2009, 12:21 PM
  3. Install SQL 2005 Full over 2005 Express (other instances)
    By Heebeejeebee in forum MIS Systems
    Replies: 4
    Last Post: 7th April 2009, 03:19 PM
  4. MS SQL 2005 - Dump SQL
    By tom_newton in forum Windows
    Replies: 7
    Last Post: 23rd January 2008, 05:10 PM
  5. SQL 2005
    By jcollings in forum MIS Systems
    Replies: 12
    Last Post: 22nd October 2007, 03:00 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •