AutoCAD Civil 3D & AutoCAD Civil Services & Support

Upgrading Autodesk Data Management Server for Civil 3D® 2007 to Microsoft SQL Server 2005 Express Edition

Published date: 2007-May-08
ID: TS1057066

Applies to:
Autodesk® Civil 3D® 2007
Autodesk® Vault 5

Issue

You would like to know how to upgrade the Microsoft SQL Server 2000 Desktop Engine to Microsoft SQL Server 2005 Express Edition.

Solution

To upgrade the Microsoft SQL Server 2000 Desktop Engine to Microsoft SQL Server 2005 Express Edition

  1. Download Microsoft SQL 2005 Express Edition from the Microsoft web site. 
  2. Before you start the upgrade, you should create a backup using the Vault Manager application.  During the backup, the web service will be stopped and no one will be able to connect to the server.
  3. Close the Vault Manager once the backup is complete, but do not restart the web service.
  4. On the server, start the installation of Microsoft SQL 2005 Express Edition. 
  5. During the installation, you will be asked if you would like to upgrade a current SQL Instance. Select the Instance option, and then select Autodesk Vault from the drop-down list.
  6. Select the default options for the remaining questions to complete the upgrade.
  7. Once the upgrade is complete, open Windows Explorer and navigate to the <installdir>\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install directory. 
  8. Double-click the instmsdb.sql file, which should then open in SQL Management Studio.
  9. Log in to the Autodesk Vault instance and execute the script in the database. 
  10. Once the script is complete, close the Management Studio.

To restart the web service

  1. Open Vault Manager and log in.
  2. Perform another backup from Vault Manager.
  3. Once the backup is complete, start the web service from the File menu.

Give us your feedback on this document:
 Resolved my issue.
 Helpful but incomplete.
 Difficult to find.
 Difficult to understand.
 Did not resolve my issue.
 Document contains broken links and references.
 No comment.
 
AUTODESK DOES NOT GUARANTEE THAT YOU WILL BE ABLE TO SUCCESSFULLY DOWNLOAD OR IMPLEMENT ANY SERVICE PACK OR WORKAROUND, OR ANY OF THE TIPS, TRICKS, EXAMPLES OR SUGGESTIONS OUTLINED IN ANY AUTODESK PRODUCT SUPPORT TECHNICAL DOCUMENTS. TECHNICAL DOCUMENTS, SERVICE PACKS AND WORKAROUNDS ARE SUBJECT TO CHANGE WITHOUT NOTICE TO YOU. AUTODESK PROVIDES TECHNICAL DOCUMENTS, SERVICE PACKS AND WORKAROUNDS "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED, INCLUDING WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL AUTODESK OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF DATA, OR LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, THAT MAY OCCUR AS A RESULT OF IMPLEMENTING ANY SERVICE PACK OR WORKAROUND, OR ANY SUGGESTION OUTLINED IN ANY AUTODESK PRODUCT SUPPORT TECHNICAL DOCUMENT, EVEN IF AUTODESK OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.