Home Sitemap Feedback About... Print
Custom Search

SQL Server troubleshooting


Known problems - Express Edition

  • SQL Express SP2 and Windows Vista UAC - on SQL Server Express WebLog
  • 918693 - Error message when you install SQL Server Express Edition Service Pack 1 or SQL Server 2005 Express Edition with Advanced Services: "SQL Server Setup did not have the administrator permissions required to rename a file"
  • 919390 - Error message when you try to upgrade SQL Server 2005 Express Edition to SQL Server 2005 Express Edition with Advanced Services: "Login failed for user 'sa'. Refer to server error logs and setup logs for more information"
  • 921498 - Error message when you try to create a database connection to SQL Server Express in a Windows Server 2003-based terminal server session: "Failed to spawn a user instance of SQL Server"
  • 929907 - You may be unable to perform most database operations after you log on to an instance of SQL Server 2005 Express Edition Service Pack 1 on a Windows Vista-based computer

Known problems - Mobile Edition

  • 912428 - Error message when you try to replicate a table from SQL Server 2005 to SQL Server 2005 Mobile Edition: "HRESULT 0x80004005 (0)"
  • 912430 - You cannot replicate data from SQL Server 2005 to SQL Server Mobile by using the 64-bit version of IIS
  • 912432 - You receive a compiler error message when you call the Dispose(BooleanParameter) method of the SqlCeDataReader object in a SQL Server 2005 Mobile Edition project
  • 912434 - You cannot open the SQL Server Mobile Setup Help file in the SQL Server Mobile Server Tools installation wizard
  • 912435 - BUG: Error message when you try to obtain schema information from a SQL Server 2005 Mobile Edition database by using the SqlCeConnection.GetSchema method: "NotSupportedException"
  • 914827 - An .sdf database file in SQL Server Mobile is larger than the same .sdf database file in SQL Server CE 2.0 when you use the ntext data type or the image data type
  • 920272 - Error message when you call the Pull method of an RDA object: "duplicate value cannot be inserted into a unique index. [Table name = __sysRDASubscriptions, Constraint name = c_LocalTableName]"

Known problems - Compact Edition

  • 912907 - How to specify the location of a temporary database in SQL Server 2005 Compact Edition
  • 296076 - A Windows CE device power failure that occurs during a transaction commit may cause a SQL Server CE database or a SQL Server 2005 Compact Edition database to be marked suspect
  • 945372 - The column of the rowversion data type is replicated to the subscriber after you synchronize the data between a SQL Server 2005 publisher and a SQL Server Compact 3.5 subscriber
  • 945374 - You cannot compile a SQL Server Compact-based OLE DB application for Windows Mobile 5.0, and the Transact.h file cannot be found
  • 945375 - Error message when you try to drag a table from a SQL Server Compact 3.5 database file to a Windows form in Visual Studio 2008: "An error occurred while performing the drop: Exception has been thrown by the target of an invocation"
  • 952218 - Error message when you try to connect to SQL Server Compact 3.5 Service Pack 1 from SQL Server Management Studio in SQL Server 2008: "Unable to load Microsoft SQL Server Compact"