If I have a global PDM network with multiple databases and multiple archive servers with multiple vaults how can I look at an archive server a see which database server (SQL) is referenced?
If I have a global PDM network with multiple databases and multiple archive servers with multiple vaults how can I look at an archive server a see which database server (SQL) is referenced?
That sounds like an awful situation. Somebody needs Admin access to the server.
In the user Admin panel, I can't access those properties. When I right click on the Vault in the Admin panel, after I login I get this:
But, if I login under the Admin account, I can see the archive server in the property box.
And, I'm no PDM expert. So, maybe you could reach out to your VAR. They may be able to web session in and access that information.
Hi Bobby,
1) Expand an archive server node from your administration tool (no need to log into the archive server itself). in my example image, it is "FCOGWS"
2) Right mouse click on an arbitrary vault under said server node. "DEV" in my example and select properties. Log in when prompted.
3) The screen that appears shows the name of the database and corresponding database server (FCOGWS). in my case, the SQL server and the archive server are on the same machine. hence the name of the archive server is the same as the SQL server.
Note: that one archive server can connect to multiple SQL servers. I recommend approaching your network discovery as "per vault" as opposed to as "per archive server". in other words, make an excel spreadsheet and lists all your vaults in the first column, then fill in the information of their corresponding servers.
4) Know that the left-hand side of the administration tool can list multiple archive servers to streamline your discovery. adding and removing servers from the administration tool "tree" is totally safe. It's just a list. you can add an additional archive server by clicking File > Add server.
I hope I helped
Thanks for the assistance. when I following Francisco's instructions I can set the db server. I am in the eastern US, the db is in the UK and our VAR is in Germany. There are various archive servers in the US, Europe and Asia.
I would like to have access to admin tools as displayed in Matt's screenshot. I have been an administrator of a local vault since 2012 and now I have to be prepared to provide assistance on a global platform.
Hi Bobby,
1) Expand an archive server node from your administration tool (no need to log into the archive server itself). in my example image, it is "FCOGWS"
2) Right mouse click on an arbitrary vault under said server node. "DEV" in my example and select properties. Log in when prompted.
3) The screen that appears shows the name of the database and corresponding database server (FCOGWS). in my case, the SQL server and the archive server are on the same machine. hence the name of the archive server is the same as the SQL server.
Note: that one archive server can connect to multiple SQL servers. I recommend approaching your network discovery as "per vault" as opposed to as "per archive server". in other words, make an excel spreadsheet and lists all your vaults in the first column, then fill in the information of their corresponding servers.
4) Know that the left-hand side of the administration tool can list multiple archive servers to streamline your discovery. adding and removing servers from the administration tool "tree" is totally safe. It's just a list. you can add an additional archive server by clicking File > Add server.
I hope I helped