VS2010RC setup installs unusable MSSQL2008 Express? RSS

• • Reply
  

  guenavan

  Contributor

  4306 Points

  1695 Posts

  VS2010RC setup installs unusable MSSQL2008 Express?

  Jun 22, 2010 03:41 AM|LINK

  I am lost between VS2010, MSSQLServer2008 and VS2008 setups and where to look for/report to the bugs on VS2010.

  I installed MS SQL Server 2008 Express [1a] as part of VS2010 RC setup [1] from a mounted on E:\ image [1].
  (Well, after that I installed VSTS2008SP1 and MSSQLServer2008R2 Developer on Windows XP SP3, all in en-us)
   

  Now, I cannot start SQL Server(SQLExpress) service [1a].
  
  Eventvwr.msc shows [4] that this service is trying to read and write to mounted drive E:\ from which VS2010RC [1] was installed.

  Is it something by design?
  known problem?
  bug? 
  my fault?
  virus?

  What are possible walk-arounds?

  If it is a bug then where to report it - to MSSQLServer2008 connect or to VS2010?
  I even could not launch or understand anything from [1a], like a version, etc. in order to report it to SQL Server connect.

  [1]
  VS2010UltimTrial.iso
  Microsoft Visual Studio 2010
  Version 10.0.30319.1 RTMRel
  from
  http://www.microsoft.com/downloads/details.aspx?FamilyID=06a32b1c-80e9-41df-ba0c-79d56cb823f7&displaylang=en

  [1a]
  MS SQL Server 2008 Express
  Probably from
  E:\WCU\SSE\SQLExpr32_x86_enu.exe (where E:\ - is mounted drive for [1]) 
  Product Name: SQL Server 2008 Express SP1
  Product Version: 10.0.2731.0
  
  [2]

  ---------------------------
  SQL Server Configuration Manager
  ---------------------------
  The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.
  ---------------------------
  OK  
  ---------------------------

  or the same from services.msc

  ---------------------------
  Services
  ---------------------------
  Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 1814.
  ---------------------------
  OK  
  ---------------------------
  

  [4]
  EVENTS in eventvwr.msc

  [4.1]

  Source: MSSQL$SQLEXPRESS
  EventID: 17204
  Description:
  FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf for file number 1.  OS error: 2(failed to retrieve text for this error. Reason: 1815).

  For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

  [4.2] 

  Source: MSSQL$SQLEXPRESS
  EventID: 17204
  Description:
  FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBData.mdf for file number 1.  OS error: 2(failed to retrieve text for this error. Reason: 1815).

  For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

  [4.3]

  Source: MSSQL$SQLEXPRESS
  EventID: 17207
  Description:
  FileMgr::StartLogFiles: Operating system error 2(failed to retrieve text for this error. Reason: 1815) occurred while creating or opening file 'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBLog.ldf'. Diagnose and correct the operating system error, and retry the operation.

  For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp[4.4]
  Source: MSSQL$SQLEXPRESS
  EventID: 17207
  Description:
  FileMgr::StartLogFiles: Operating system error 2(failed to retrieve text for this error. Reason: 1815) occurred while creating or opening file 'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.

  For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

   

  Gennady Vanin (Novosibirsk) -- Геннадий Ванин (Новосибирск) -- Guennadi Vanine
  • Edited by guenavan on Jun 22, 2010 04:23 AM
  • Edited by guenavan on Oct 12, 2010 05:22 AM