Does the ADMS Server have to be installed on the SQL Server?

[Anonymous]

Does the Autodesk Data Management Server (Vault Server) have to be installed
on the same computer as Microsoft's SQL Server?

The reason I ask is our company has Microsoft's SQL Server Enterprise
Edition installed at cthe ompany's data center which our division accesses
through a WAN link. We considered putting the ADMS at the data center, but
decided against it due to the performance hit imposed by checking files
in/out through the bandwidth bottleneck created by the WAN link. So with the
ADMS, the Vault database, and File Store on our LAN, IT is wondering if SQL
requests (calls?) can be made to an SQL Server on another computer through
the WAN link?

As always, thank you for your help!

Sincerely,

Michael

[Anonymous]

ADMS installed on the same machine as Microsoft's SQL Server is the Autodesk
supported configuration.

But you can work with a remote SQL server instance. This is achieved by
changing certain server configurations.

Suppose you have a SQL server instance [named REMOTE_INST] on a machine
[named REMOTE_MC]

Install your ADMS on a separate machine [named LOCAL_MC].
Then update the web.config and Vault Manager Config file to change the
database instance name to REMOTE_MC\REMOTE_INST
If the above instance has sa password different then default sa password for
AutodeskVault instance, VaultManager will prompt to provide that.
Then launch Vault Manager and create KnowledgeVaultMaster and Vaults. They
will be created at the remote instance.

I'll suggest to create AutodeskVault instance on the REMOTE_MC with default
sa password.

There are certain limitations and workaround associated with attach/detach
and backup/restore. Also full content search will not be available.

So if you really need it contact Autodesk technical support.
I do not know if there are any published documentation for this or not.

--

Ajay Choudhary
Software Engineer
Autodesk Inc.



"Michael Trull" wrote in message
news:5131908@discussion.autodesk.com...
Does the Autodesk Data Management Server (Vault Server) have to be installed
on the same computer as Microsoft's SQL Server?

The reason I ask is our company has Microsoft's SQL Server Enterprise
Edition installed at cthe ompany's data center which our division accesses
through a WAN link. We considered putting the ADMS at the data center, but
decided against it due to the performance hit imposed by checking files
in/out through the bandwidth bottleneck created by the WAN link. So with the
ADMS, the Vault database, and File Store on our LAN, IT is wondering if SQL
requests (calls?) can be made to an SQL Server on another computer through
the WAN link?

As always, thank you for your help!

Sincerely,

Michael

[Anonymous]

Aside from this, it's certainly a bit "scary" to think about database calls
to be made across a WAN. I think I'd rather see the remote file store on a
WAN before I'd want to see SQL calls made over a WAN, given the frequency of
the respective accesses.

It may be worth a test to see what you're in for, but I'm not overly
optimistic...

Also, to follow up on something you (Michael) said:
"with the ADMS, the Vault database, and File Store on our LAN...."

Do you really mean this? Where would the database physically reside?

Jeff

"Ajay Choudhary" wrote in message
news:5131955@discussion.autodesk.com...
ADMS installed on the same machine as Microsoft's SQL Server is the Autodesk
supported configuration.

But you can work with a remote SQL server instance. This is achieved by
changing certain server configurations.

Suppose you have a SQL server instance [named REMOTE_INST] on a machine
[named REMOTE_MC]

Install your ADMS on a separate machine [named LOCAL_MC].
Then update the web.config and Vault Manager Config file to change the
database instance name to REMOTE_MC\REMOTE_INST
If the above instance has sa password different then default sa password for
AutodeskVault instance, VaultManager will prompt to provide that.
Then launch Vault Manager and create KnowledgeVaultMaster and Vaults. They
will be created at the remote instance.

I'll suggest to create AutodeskVault instance on the REMOTE_MC with default
sa password.

There are certain limitations and workaround associated with attach/detach
and backup/restore. Also full content search will not be available.

So if you really need it contact Autodesk technical support.
I do not know if there are any published documentation for this or not.

--

Ajay Choudhary
Software Engineer
Autodesk Inc.



"Michael Trull" wrote in message
news:5131908@discussion.autodesk.com...
Does the Autodesk Data Management Server (Vault Server) have to be installed
on the same computer as Microsoft's SQL Server?

The reason I ask is our company has Microsoft's SQL Server Enterprise
Edition installed at cthe ompany's data center which our division accesses
through a WAN link. We considered putting the ADMS at the data center, but
decided against it due to the performance hit imposed by checking files
in/out through the bandwidth bottleneck created by the WAN link. So with the
ADMS, the Vault database, and File Store on our LAN, IT is wondering if SQL
requests (calls?) can be made to an SQL Server on another computer through
the WAN link?

As always, thank you for your help!

Sincerely,

Michael

[Anonymous]

Jeff and Ajay:

Thank you for your help! And I also must thank you for your patience. Even
though I am making these posts, I assure you that your responses are being
distributed to much more knowledgeable personnel in our IT group.

Unfortunately I am engaging this dialogue at a level well above my
understanding. So I can only apologize for any comments that may foster
confusion.

If the ADMS is making calls to the SQL Server and the Server is the only
thing accessing the database, then the database would reside with the SQL
Server, not on the LAN as I mentioned before. Until this came up earlier
today, I had not given much thought to the ADMS and its interaction with the
SQL Server. I have always viewed the ADMS and the SQL Server as a single
entity and had not considered how they might be broken up.

Thanks again for your help!

Sincerely,

Michael

"Jeff Pek (Autodesk)" wrote in message
news:5131988@discussion.autodesk.com...
Aside from this, it's certainly a bit "scary" to think about database calls
to be made across a WAN. I think I'd rather see the remote file store on a
WAN before I'd want to see SQL calls made over a WAN, given the frequency of
the respective accesses.

It may be worth a test to see what you're in for, but I'm not overly
optimistic...

Also, to follow up on something you (Michael) said:
"with the ADMS, the Vault database, and File Store on our LAN...."

Do you really mean this? Where would the database physically reside?

Jeff

[Anonymous]

Michael,

Please understand that this is NOT a supported configuration (despite the
previous posts). The SQL databases must reside on the same machine/server as
the Autodesk Data Management Server (Vault server) and IIS.

We are considering support for this in the future, but this remains an
unsupported configuration. Please know that you may be able to get this
"working", but there is a high potential for downstream problems when you go
to backup/restore, migrate to the next release, etc. As such, please don't
implement this configuration.

Thanks and best regards,

Bob Henry
Autodesk, Inc.


"Michael Trull" wrote in message
news:5132071@discussion.autodesk.com...
Jeff and Ajay:

Thank you for your help! And I also must thank you for your patience. Even
though I am making these posts, I assure you that your responses are being
distributed to much more knowledgeable personnel in our IT group.

Unfortunately I am engaging this dialogue at a level well above my
understanding. So I can only apologize for any comments that may foster
confusion.

If the ADMS is making calls to the SQL Server and the Server is the only
thing accessing the database, then the database would reside with the SQL
Server, not on the LAN as I mentioned before. Until this came up earlier
today, I had not given much thought to the ADMS and its interaction with the
SQL Server. I have always viewed the ADMS and the SQL Server as a single
entity and had not considered how they might be broken up.

Thanks again for your help!

Sincerely,

Michael

"Jeff Pek (Autodesk)" wrote in message
news:5131988@discussion.autodesk.com...
Aside from this, it's certainly a bit "scary" to think about database calls
to be made across a WAN. I think I'd rather see the remote file store on a
WAN before I'd want to see SQL calls made over a WAN, given the frequency of
the respective accesses.

It may be worth a test to see what you're in for, but I'm not overly
optimistic...

Also, to follow up on something you (Michael) said:
"with the ADMS, the Vault database, and File Store on our LAN...."

Do you really mean this? Where would the database physically reside?

Jeff

[Anonymous]

Bob:

Thank you for your comments!

We met with IT yesterday and everyone agrees that this is not something we
will do. The fact that Autodesk does not support this configuration and we
would be completely on our own was sufficient to cause IT to abandon this
approach. They also do not want to tie up our WAN link with
Vault/Produsctstream traffic so it appears we are going to install SQL
locally.

I realize that this is a retreat back to Autodesk's original recommendation,
but it took everyone's patient answers to the questions raised in my recent
threads for IT to understand and accept that this is truly the best approach
for the forseeable future.

Sincerely,

Michael