Vault General

Reply
Contributor
Posts: 25
Registered: ‎10-17-2005
Message 1 of 9 (396 Views)

Vault SQL Server install

396 Views, 8 Replies
04-09-2012 06:58 AM

I just installed Vault 2010, on win 2008 (64bit) server.  I am wanting to get to sql server 2008 (64bit) full on the server, but it doesn't look like it installed 2005 (64 bit) when I installed the vault (default).  How can I tell I got the 2005 64 bit version?  Can I upgrade to 2008 64bit after the default installation?

Board Manager
Posts: 526
Registered: ‎02-01-2006
Message 2 of 9 (387 Views)

Re: Vault SQL Server install

04-09-2012 09:54 AM in reply to: s_hiebert

The Vault Server only comes with SQL Express 32-bit versions.  To move to 64 bit, you will need to install it manually.  See the Advanced Configuration Guide for manual SQL installaiton procedures.



Irvin Hayes Jr
Product Manager
Autodesk, Inc.

*Expert Elite*
DarrenP
Posts: 6,823
Registered: ‎09-13-2007
Message 3 of 9 (380 Views)

Re: Vault SQL Server install

04-09-2012 11:12 AM in reply to: ihayesjr

advanced config guide: http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=16853779&linkID=9261341

you pretty much have to uninstall the 32 bit of sql express and install the 64 bit version of sql

then read the above pdf on how to setup sql correctly for vault

Contributor
Posts: 25
Registered: ‎10-17-2005
Message 4 of 9 (373 Views)

Re: Vault SQL Server install

04-09-2012 11:24 AM in reply to: DarrenP

OK..I can't seem to get the Vault installed after I pre-install SQL Server 2008 Standard.

My current server is a Win 2008 R2 with SQL Server 2008 Standard.  When I tried to install SQL Standard, it said that I had to install SQL Server SP1 after the install, so I did.

 

This is a fresh install of the vault and sql server.

 

Now, when I install the vault, I get an error "There is an old unused database and/or FileStore.  Please remove or delete these files"

 

I got this error when I originally tried to pre-install SQL Server 2008 R2.  Then I thought I saw that r2 was not supported. That's when I tred to install just 2008 Standard SQL with sp1.

 

Any ideas?

Board Manager
Posts: 526
Registered: ‎02-01-2006
Message 5 of 9 (368 Views)

Re: Vault SQL Server install

04-09-2012 11:32 AM in reply to: s_hiebert

Did you uninstall SQL Express prior to installing SQL Standard?

Did you name the SQL Standard instance "AutodeskVault" as it is outlined in the Advanced Configuration Guide?

Did you goto the SQL Express Data directory and delete the KnowledgeVaultMaster and Vault databases?

Did you goto the File Store path and delete the file store?

 

The error message is a link to its help which will instruct you how to get rid of the error.



Irvin Hayes Jr
Product Manager
Autodesk, Inc.

New Member
Posts: 2
Registered: ‎04-24-2012
Message 6 of 9 (321 Views)

Re: Vault SQL Server install

04-24-2012 09:12 AM in reply to: ihayesjr

When you uninstall SQL Express will your database remain on the server so it can be imported into SQL Standard?

Board Manager
Posts: 526
Registered: ‎02-01-2006
Message 7 of 9 (316 Views)

Re: Vault SQL Server install

04-24-2012 10:08 AM in reply to: s_hiebert

If you perform an automatic upgrade, SQL Standard will attach the databases.  If you have to uninstall and install SQL Standard, the databases will remain in the SQL Express Data folder.  You should move them to the SQL Standard Data folder and attach them using the ADMS Console.



Irvin Hayes Jr
Product Manager
Autodesk, Inc.

New Member
Posts: 2
Registered: ‎04-24-2012
Message 8 of 9 (313 Views)

Re: Vault SQL Server install

04-24-2012 10:16 AM in reply to: ihayesjr

I was under the impression that I needed to uninstall SQL Express before loading the full version of SQL. Is there an document that describes the procedures for upgrading SQL then moving the database?

Board Manager
Posts: 526
Registered: ‎02-01-2006
Message 9 of 9 (310 Views)

Re: Vault SQL Server install

04-24-2012 10:26 AM in reply to: s_hiebert

Please see Upgrade Autodesk Vault.

The easiest way is to perform a backup prior to uninstal and restore it after the upgrade.



Irvin Hayes Jr
Product Manager
Autodesk, Inc.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
New button for Platinum & Gold Subscription customers
Gold & Platinum Subscription customers can alert Autodesk if they require assistance with their forum post

Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community