Community
Vault Forum
Welcome to Autodesk’s Vault Forums. Share your knowledge, ask questions, and explore popular Vault topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Vault Installation on Full SQL

7 REPLIES 7
Reply
Message 1 of 8
Anonymous
310 Views, 7 Replies

Vault Installation on Full SQL

I saw a post about installing Vault on a full SQL server, apparently
without the need to install MSDE first and then do an upgrade.

Can someone provide a link to a procedure for doing this?

I'm new to Autodesk and my VAR is not giving me much help in this area.

MikeMc
7 REPLIES 7
Message 2 of 8
Anonymous
in reply to: Anonymous

This should be pretty straightforward. Here are the general
steps/guidelines:

1) Install a separate instance for Autodesk Data Management Server
(ADMS) -- it should be named "AUTODESKVAULT" (case is not important)

2) Make sure you specify mixed mode authentication (the default choice
is Windows only; this is NOT sufficient)

3) For convenience, use "AutodeskVault" as the 'sa' password. This isn't
absolutely necessary, but will streamline some operations in Vault Manager.

4) Apply SQL Server SP3a BEFORE installing ADMS.

Once you've done this, the ADMS installer should recognize and use this
SQL instance instead of installing its own instance of MSDE.

Cheers,
Jeff

MikeMc wrote:
> I saw a post about installing Vault on a full SQL server, apparently
> without the need to install MSDE first and then do an upgrade.
>
> Can someone provide a link to a procedure for doing this?
>
> I'm new to Autodesk and my VAR is not giving me much help in this area.
>
> MikeMc
Message 3 of 8
Anonymous
in reply to: Anonymous

Installation of the Vault went OK. I installed SQL Data files to the 😧
drive.

The Content Manager, however, put it's data files under C:\Program
Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data. I was hoping to install
ALL data files to the 😧 drive. The C: partition was 'imaged' before I
installed the Vault and Content Manager. I can start over or perhaps you
another suggestion.

Thanks for your help.

MikeMc


"Jeff Pek (Autodesk)" wrote in message
news:4950909@discussion.autodesk.com...
This should be pretty straightforward. Here are the general
steps/guidelines:

1) Install a separate instance for Autodesk Data Management Server
(ADMS) -- it should be named "AUTODESKVAULT" (case is not important)

2) Make sure you specify mixed mode authentication (the default choice
is Windows only; this is NOT sufficient)

3) For convenience, use "AutodeskVault" as the 'sa' password. This isn't
absolutely necessary, but will streamline some operations in Vault Manager.

4) Apply SQL Server SP3a BEFORE installing ADMS.

Once you've done this, the ADMS installer should recognize and use this
SQL instance instead of installing its own instance of MSDE.

Cheers,
Jeff

MikeMc wrote:
> I saw a post about installing Vault on a full SQL server, apparently
> without the need to install MSDE first and then do an upgrade.
>
> Can someone provide a link to a procedure for doing this?
>
> I'm new to Autodesk and my VAR is not giving me much help in this area.
>
> MikeMc
Message 4 of 8
Anonymous
in reply to: Anonymous

It's possible to control the installation of SQL server to have it keep
its data files in a place other than C: -- however, I don't recall that
the usual installation UI provides an opportunity to do this.

You can use the DetachLibrary utility (content folder) to detach the
content library databases, move them to where you want, and then use the
AttachLibrary tool to reconnect them.

We recommend that all data files be kept together for reliability of
maintenance tasks.

Jeff

MikeMc wrote:
> Installation of the Vault went OK. I installed SQL Data files to the 😧
> drive.
>
> The Content Manager, however, put it's data files under C:\Program
> Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data. I was hoping to install
> ALL data files to the 😧 drive. The C: partition was 'imaged' before I
> installed the Vault and Content Manager. I can start over or perhaps you
> another suggestion.
>
> Thanks for your help.
>
> MikeMc
>
>
> "Jeff Pek (Autodesk)" wrote in message
> news:4950909@discussion.autodesk.com...
> This should be pretty straightforward. Here are the general
> steps/guidelines:
>
> 1) Install a separate instance for Autodesk Data Management Server
> (ADMS) -- it should be named "AUTODESKVAULT" (case is not important)
>
> 2) Make sure you specify mixed mode authentication (the default choice
> is Windows only; this is NOT sufficient)
>
> 3) For convenience, use "AutodeskVault" as the 'sa' password. This isn't
> absolutely necessary, but will streamline some operations in Vault Manager.
>
> 4) Apply SQL Server SP3a BEFORE installing ADMS.
>
> Once you've done this, the ADMS installer should recognize and use this
> SQL instance instead of installing its own instance of MSDE.
>
> Cheers,
> Jeff
>
> MikeMc wrote:
>
>>I saw a post about installing Vault on a full SQL server, apparently
>>without the need to install MSDE first and then do an upgrade.
>>
>>Can someone provide a link to a procedure for doing this?
>>
>>I'm new to Autodesk and my VAR is not giving me much help in this area.
>>
>>MikeMc
Message 5 of 8
Anonymous
in reply to: Anonymous

Thanks for the help.

I did set the default data file location to 😧 drive during the SQL
installation. However, the Content Manager installer must be hard coded to
the C:\Program Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data location.

MikeMc


"Jeff Pek (Autodesk)" wrote in message
news:4951251@discussion.autodesk.com...
It's possible to control the installation of SQL server to have it keep
its data files in a place other than C: -- however, I don't recall that
the usual installation UI provides an opportunity to do this.

You can use the DetachLibrary utility (content folder) to detach the
content library databases, move them to where you want, and then use the
AttachLibrary tool to reconnect them.

We recommend that all data files be kept together for reliability of
maintenance tasks.

Jeff

MikeMc wrote:
> Installation of the Vault went OK. I installed SQL Data files to the 😧
> drive.
>
> The Content Manager, however, put it's data files under C:\Program
> Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data. I was hoping to
> install
> ALL data files to the 😧 drive. The C: partition was 'imaged' before I
> installed the Vault and Content Manager. I can start over or perhaps you
> another suggestion.
>
> Thanks for your help.
>
> MikeMc
>
>
> "Jeff Pek (Autodesk)" wrote in message
> news:4950909@discussion.autodesk.com...
> This should be pretty straightforward. Here are the general
> steps/guidelines:
>
> 1) Install a separate instance for Autodesk Data Management Server
> (ADMS) -- it should be named "AUTODESKVAULT" (case is not important)
>
> 2) Make sure you specify mixed mode authentication (the default choice
> is Windows only; this is NOT sufficient)
>
> 3) For convenience, use "AutodeskVault" as the 'sa' password. This isn't
> absolutely necessary, but will streamline some operations in Vault
> Manager.
>
> 4) Apply SQL Server SP3a BEFORE installing ADMS.
>
> Once you've done this, the ADMS installer should recognize and use this
> SQL instance instead of installing its own instance of MSDE.
>
> Cheers,
> Jeff
>
> MikeMc wrote:
>
>>I saw a post about installing Vault on a full SQL server, apparently
>>without the need to install MSDE first and then do an upgrade.
>>
>>Can someone provide a link to a procedure for doing this?
>>
>>I'm new to Autodesk and my VAR is not giving me much help in this area.
>>
>>MikeMc
Message 6 of 8
Anonymous
in reply to: Anonymous

When you say the content manager, are you referring to the Inventor
standard content data? What file(s) do you see in that directory?

Thanks,
Jeff

MikeMc wrote:
> Thanks for the help.
>
> I did set the default data file location to 😧 drive during the SQL
> installation. However, the Content Manager installer must be hard coded to
> the C:\Program Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data location.
>
> MikeMc
>
>
> "Jeff Pek (Autodesk)" wrote in message
> news:4951251@discussion.autodesk.com...
> It's possible to control the installation of SQL server to have it keep
> its data files in a place other than C: -- however, I don't recall that
> the usual installation UI provides an opportunity to do this.
>
> You can use the DetachLibrary utility (content folder) to detach the
> content library databases, move them to where you want, and then use the
> AttachLibrary tool to reconnect them.
>
> We recommend that all data files be kept together for reliability of
> maintenance tasks.
>
> Jeff
>
> MikeMc wrote:
>
>>Installation of the Vault went OK. I installed SQL Data files to the 😧
>>drive.
>>
>>The Content Manager, however, put it's data files under C:\Program
>>Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data. I was hoping to
>>install
>>ALL data files to the 😧 drive. The C: partition was 'imaged' before I
>>installed the Vault and Content Manager. I can start over or perhaps you
>>another suggestion.
>>
>>Thanks for your help.
>>
>>MikeMc
>>
>>
>>"Jeff Pek (Autodesk)" wrote in message
>>news:4950909@discussion.autodesk.com...
>>This should be pretty straightforward. Here are the general
>>steps/guidelines:
>>
>>1) Install a separate instance for Autodesk Data Management Server
>>(ADMS) -- it should be named "AUTODESKVAULT" (case is not important)
>>
>>2) Make sure you specify mixed mode authentication (the default choice
>>is Windows only; this is NOT sufficient)
>>
>>3) For convenience, use "AutodeskVault" as the 'sa' password. This isn't
>>absolutely necessary, but will streamline some operations in Vault
>>Manager.
>>
>>4) Apply SQL Server SP3a BEFORE installing ADMS.
>>
>>Once you've done this, the ADMS installer should recognize and use this
>>SQL instance instead of installing its own instance of MSDE.
>>
>>Cheers,
>> Jeff
>>
>>MikeMc wrote:
>>
>>
>>>I saw a post about installing Vault on a full SQL server, apparently
>>>without the need to install MSDE first and then do an upgrade.
>>>
>>>Can someone provide a link to a procedure for doing this?
>>>
>>>I'm new to Autodesk and my VAR is not giving me much help in this area.
>>>
>>>MikeMc
Message 7 of 8
Anonymous
in reply to: Anonymous

Jeff,

I believe the attached pictures will help show my current installation.

Thanks, Mike

"Jeff Pek (Autodesk)" wrote in message
news:4951394@discussion.autodesk.com...
When you say the content manager, are you referring to the Inventor
standard content data? What file(s) do you see in that directory?

Thanks,
Jeff

MikeMc wrote:
> Thanks for the help.
>
> I did set the default data file location to 😧 drive during the SQL
> installation. However, the Content Manager installer must be hard coded to
> the C:\Program Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data
> location.
>
> MikeMc
>
>
> "Jeff Pek (Autodesk)" wrote in message
> news:4951251@discussion.autodesk.com...
> It's possible to control the installation of SQL server to have it keep
> its data files in a place other than C: -- however, I don't recall that
> the usual installation UI provides an opportunity to do this.
>
> You can use the DetachLibrary utility (content folder) to detach the
> content library databases, move them to where you want, and then use the
> AttachLibrary tool to reconnect them.
>
> We recommend that all data files be kept together for reliability of
> maintenance tasks.
>
> Jeff
>
> MikeMc wrote:
>
>>Installation of the Vault went OK. I installed SQL Data files to the 😧
>>drive.
>>
>>The Content Manager, however, put it's data files under C:\Program
>>Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data. I was hoping to
>>install
>>ALL data files to the 😧 drive. The C: partition was 'imaged' before I
>>installed the Vault and Content Manager. I can start over or perhaps you
>>another suggestion.
>>
>>Thanks for your help.
>>
>>MikeMc
>>
>>
>>"Jeff Pek (Autodesk)" wrote in message
>>news:4950909@discussion.autodesk.com...
>>This should be pretty straightforward. Here are the general
>>steps/guidelines:
>>
>>1) Install a separate instance for Autodesk Data Management Server
>>(ADMS) -- it should be named "AUTODESKVAULT" (case is not important)
>>
>>2) Make sure you specify mixed mode authentication (the default choice
>>is Windows only; this is NOT sufficient)
>>
>>3) For convenience, use "AutodeskVault" as the 'sa' password. This isn't
>>absolutely necessary, but will streamline some operations in Vault
>>Manager.
>>
>>4) Apply SQL Server SP3a BEFORE installing ADMS.
>>
>>Once you've done this, the ADMS installer should recognize and use this
>>SQL instance instead of installing its own instance of MSDE.
>>
>>Cheers,
>> Jeff
>>
>>MikeMc wrote:
>>
>>
>>>I saw a post about installing Vault on a full SQL server, apparently
>>>without the need to install MSDE first and then do an upgrade.
>>>
>>>Can someone provide a link to a procedure for doing this?
>>>
>>>I'm new to Autodesk and my VAR is not giving me much help in this area.
>>>
>>>MikeMc
Message 8 of 8
Anonymous
in reply to: Anonymous

I've confirmed that the content library installer does, in fact, always
use the standard "Program Files" location when installing the library
data files.

If you want to move these into the normal data area, you should first
detach the libraries using the Content Center Library Manager, then move
the data files into the other place, then re-attach them.

Jeff

MikeMc wrote:
> Jeff,
>
> I believe the attached pictures will help show my current installation.
>
> Thanks, Mike
>
> "Jeff Pek (Autodesk)" wrote in message
> news:4951394@discussion.autodesk.com...
> When you say the content manager, are you referring to the Inventor
> standard content data? What file(s) do you see in that directory?
>
> Thanks,
> Jeff
>
> MikeMc wrote:
>
>>Thanks for the help.
>>
>>I did set the default data file location to 😧 drive during the SQL
>>installation. However, the Co
>
> ntent Manager installer must be hard coded to
>
>>the C:\Program Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data
>>location.
>>
>>MikeMc
>>
>>
>>"Jeff Pek (Autodesk)" wrote in message
>>news:4951251@discussion.autodesk.com...
>>It's possible to control the installation of SQL server to have it keep
>>its data files in a place other than C: -- however, I don't recall that
>>the usual installation UI provides an opportunity to do this.
>>
>>You can use the DetachLibr
>
> ary utility (content folder) to detach the
>
>>content library databases, move them to where you want, and then use the
>>AttachLibrary tool to reconnect them.
>>
>>We recommend that all data files be kept together for reliability of
>>maintenance tasks.
>>
>>Jeff
>>
>>MikeMc wrote:
>>
>>
>>>Installation of the Vault went OK. I installed SQL Data files to the 😧
>>>drive.
>>>
>>>The Content Manager, however, put it's data files under C:\Program
>>>Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data. I wa
>
> s hoping to
>
>>>install
>>>ALL data files to the 😧 drive. The C: partition was 'imaged' before I
>>>installed the Vault and Content Manager. I can start over or perhaps you
>>>another suggestion.
>>>
>>>Thanks for your help.
>>>
>>>MikeMc
>>>
>>>
>>>"Jeff Pek (Autodesk)" wrote in message
>>>news:4950909@discussion.autodesk.com...
>>>This should be pretty straightforward. Here are the general
>>>steps/guidelines:
>>>
>>>1) Install a separate instance for Autodesk Data Management Ser
>
> ver
>
>>>(ADMS) -- it should be named "AUTODESKVAULT" (case is not important)
>>>
>>>2) Make sure you specify mixed mode authentication (the default choice
>>>is Windows only; this is NOT sufficient)
>>>
>>>3) For convenience, use "AutodeskVault" as the 'sa' password. This isn't
>>>absolutely necessary, but will streamline some operations in Vault
>>>Manager.
>>>
>>>4) Apply SQL Server SP3a BEFORE installing ADMS.
>>>
>>>Once you've done this, the ADMS installer should recognize and use this
>>>SQL instance
>
> instead of installing its own instance of MSDE.
>
>>>Cheers,
>>> Jeff
>>>
>>>MikeMc wrote:
>>>
>>>
>>>
>>>>I saw a post about installing Vault on a full SQL server, apparently
>>>>without the need to install MSDE first and then do an upgrade.
>>>>
>>>>Can someone provide a link to a procedure for doing this?
>>>>
>>>>I'm new to Autodesk and my VAR is not giving me much help in this area.
>>>>
>>>>MikeMc
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>>

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report