====== Alles Rund um den Vault ======
===== Infos zu Service Packs =====
Vault 2025 : [[https://help.autodesk.com/view/VAULT/2024/DEU/?guid=Vault_ReleaseNotes_CLC_updates_updates_install_information_html|Link]]\\
Vault 2024 : [[https://help.autodesk.com/view/VAULT/2024/DEU/?guid=Vault_ReleaseNotes_CLC_updates_updates_install_information_html|Link]]\\
Vault 2023 : [[https://help.autodesk.com/view/VAULT/2023/DEU/?guid=Vault_ReleaseNotes_CLC_updates_updates_install_information_html|Link]]\\
Vault 2022 : [[https://help.autodesk.com/view/VAULT/2022/DEU/?guid=Vault_ReleaseNotes_CLC_updates_updates_install_information_html|Link]]\\
Vault 2021 : [[https://help.autodesk.com/view/VAULT/2021/DEU/?guid=Vault_ReleaseNotes_CLC_updates_updates_install_information_html|Link]]\\
Vault 2020 : [[https://help.autodesk.com/view/VAULT/2020/DEU/?guid=Vault_ReleaseNotes_CLC_updates_updates_install_information_html|Link]]\\
Vault 2019 : [[https://help.autodesk.com/view/VAULT/2019/DEU/?guid=Vault_ReleaseNotes_CLC_updates_updates_install_information_html|Link]]\\
----
===== Passwörter =====
==== SQL Server ====
SA User :
User : sa
Password : AutodeskVault@26200
User : VaultSys
Password : SuperMan769400006!
vorgabemäßiges Windows-Benutzerkonto :
User : AutodeskVault
Password : Au1oDSK@26200
Passwort vergessen : [[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/I-have-lost-forgotten-or-mislaid-the-Administrators-password-for-Autodesk-Vault-and-need-to-reset-it.html|Link]]
----
==== SQL Server Umfeld ====
=== Port Scanner ===
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/using-portqrytool-sqlserver
=== Versionen ===
=== Versionstand abfragen ===
SELECT @@version
SELECT SERVERPROPERTY ('edition')
Microsoft SQL Server 2014 (SP3) (KB4022619) - 12.0.6024.0 (X64)
Sep 7 2018 01:37:51
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: ) (Hypervisor)
Standard Edition (64-bit)
====Wo Liegen die Dateien der Datenbanken
USE master;
SELECT name "Logical Name", physical_name "File Location" FROM sys.master_files;
==== Übersicht ====
Liste der Versions Stände - Größe der Datenbank
Siehe auch [[https://buildnumbers.wordpress.com/sqlserver/|LINK]]
| Version | | Stand | Build |
| | | | |
| SQL Server 2019 | 15.0.1000.169 | | |
| | | | |
| [[https://support.microsoft.com/de-de/topic/sql-server-2017-buildversionen-346e8fcd-c07c-5eeb-e10b-e3411ba8d8dd|SQL Server 2017 RTM]] | 14.0.1000.169 | | |
| | | | |
| SQL Server 2016 RTM | 13.0.1742.0 | | |
| | | | |
| SQL Server 2014 RTM | 12.0.2000.80 | | |
| | | | |
| SQL Server 2012 Service Pack 1 | 11.00.3000.00 | | |
| SQL Server 2012 RTM | 11.00.2100.60 | | |
| | | | |
| SQL Server 2008 R2 Express | | 1 CPU | 10 GB Data |
| | | | |
| SQL Server 2008 R2 Service Pack 2 | 10.50.4000.0 | | |
| SQL Server 2008 R2 Service Pack 1 | 10.50.2500.0 | | |
| SQL Server 2008 R2 RTM | 10.50.1600.1 | | |
| | | | |
| SQL Server 2008 Express | | 1 CPU | 4 GB Data |
| | | | |
| SQL Server 2008 Service Pack 3 | 10.00.5500.00 | | |
| SQL Server 2008 Service Pack 2 | 10.00.4000.00 | | |
| SQL Server 2008 Service Pack 1 | 10.00.2531.00 | | |
| SQL Server 2008 RTM | 10.00.1600.22 | | |
| | | | |
| SQL Server 2008 Express | | 1 CPU | 4 GB Data |
| | | | |
| SQL Server 2005 Service Pack 4 | 9.00.5000.00 | | |
| SQL Server 2005 Service Pack 3 | 9.00.4035 | | |
| SQL Server 2005 Service Pack 2 | 9.00.3042 | | |
| SQL Server 2005 Service Pack 1 | 9.00.2047 | | |
| SQL Server 2005 RTM | 9.00.1399 | | |
| | | | |
----
==== Wiederherstellung steht aus ====
[[https://www.qli.de/t3/geocaching/news/artikel/?tx_news_pi1%5Bnews%5D=19&tx_news_pi1%5Bcontroller%5D=News&tx_news_pi1%5Baction%5D=detail&cHash=5d6281909df1b74247658708883945bd|Link]]
EXEC sp_resetstatus CADViewerDb
ALTER DATABASE KnowledgeVaultMaster SET EMERGENCY
DBCC checkdb (KnowledgeVaultMaster)
ALTER DATABASE KnowledgeVaultMaster SET SINGLE_USER with ROLLBACK IMMEDIATE
DBCC checkdb (KnowledgeVaultMaster, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE KnowledgeVaultMaster SET MULTI_USER
EXEC sp_resetstatus KnowledgeVaultMaster
ALTER DATABASE KnowledgeVaultMaster SET EMERGENCY
DBCC checkdb (KnowledgeVaultMaster)
ALTER DATABASE KnowledgeVaultMaster SET SINGLE_USER with ROLLBACK IMMEDIATE
DBCC checkdb (KnowledgeVaultMaster, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE KnowledgeVaultMaster SET MULTI_USER
----
==== Open Fire Wall ====
Als CMD Speichern un mit Admin Rechten ausführen
@echo ========= SQL Server Ports ===================
netsh advfirewall firewall add rule name="Open Port 80 (OSSP)" dir=in action=allow protocol=TCP localport=80
@echo ========= SQL Server Ports ===================
@echo Enabling SQLServer default instance port 1433
netsh advfirewall firewall add rule name="SQL Server (OSSP)" dir=in action=allow protocol=TCP localport=1433
@echo Enabling Dedicated Admin Connection port 1434
netsh advfirewall firewall add rule name="SQL Admin Connection (OSSP)" dir=in action=allow protocol=TCP localport=1434
@echo Enabling Conventional SQL Server Service Broker port 4022
netsh advfirewall firewall add rule name="SQL Service Broker (OSSP)" dir=in action=allow protocol=TCP localport=4022
@echo Enabling Transact SQL/RPC port 135
netsh advfirewall firewall add rule name="SQL Debugger/RPC (OSSP)" dir=in action=allow protocol=TCP localport=135
@echo ========= Analysis Services Ports ==============
@echo Enabling SSAS Default Instance port 2383
netsh advfirewall firewall add rule name="Analysis Services (OSSP)" dir=in action=allow protocol=TCP localport=2383
@echo Enabling SQL Server Browser Service port 2382
netsh advfirewall firewall add rule name="SQL Browser (OSSP)" dir=in action=allow protocol=TCP localport=2382
@echo ========= Misc Applications ==============
@echo Enabling HTTP port 80
netsh advfirewall firewall add rule name="HTTP (OSSP)" dir=in action=allow protocol=TCP localport=80
@echo Enabling SSL port 443
netsh advfirewall firewall add rule name="SSL (OSSP)" dir=in action=allow protocol=TCP localport=443
@echo Enabling port for SQL Server Browser Service's 'Browse' Button
netsh advfirewall firewall add rule name="SQL Browser (OSSP)" dir=in action=allow protocol=UDP localport=1434
REM @echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
REM netsh advfirewall set multicastbroadcastresponse ENABLE
pause
----
===== Vault umbenennen=====
Wird der Rechner Name geändert, muss auch die ADMS Instance umbenannt werden!
Zunächst der Vault
"C:\...\Connectivity.ADMSConsole.exe" -OsiteRename -SNO{AlterName} -SNN{NeuerName} -DBUsa -DBPAutodeskVault@26200
Dann die Windows Maschine
z.B.
Alter Tresor LEGO
Neuer Treso LEGO-USA
"C:\Program Files\Autodesk\ADMS Professional 2019\ADMS Console\Connectivity.ADMSConsole.exe" -OsiteRename -SNOLego -SNNlego-usa -DBUsa -DBPAutodeskVault@26200
Wichtig :
Dem ADMS_LEGO User im SQL Server auch umbenennen
----
==== Vault Versionsstände ====
Alles rund um die Vault Versionsstände - mit Link zu den Autodesk Empfehlungen
[[http://crackingthevault.typepad.com/crackingthevault/2015/09/vault-build-numbers.html|LINK]]
| Version | | |Stand | Build | .NET | API | SQL Server |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2024-products.html|Vault 2024]] | | | | 29.0.68. 0| 4.7| 28/12 | 2016 / 2019 |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2023-products.html|Vault 2023]] | | | | 28.0.66. 0| 4.7| 28/12 | 2016 / 2019 |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2022-products.html|Vault 2022]] | | | | 27.0.66. 0| 4.7| 27/12 | 2016 / 2019 |
| |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2021-products.html|Vault 2021]] | | | | 26.0.66. 0| 4.7| 26/12 | 2014 / 2017 |
| |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2020-products.html|Vault 2020]] | | | | 25.0.66. 0| 4.7| 25/12 | 2014 / 2016 |
| |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2019-products.html|Vault 2019]] | | | | 25.0.66. 0| 4.7| 24/12 | 2014 / 2016 |
| |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2018-products.html|Vault 2018]] | | |Update 2 | 23.2. 3. 0| 4.6| 23/11 | 2012 / 2014 |
|::: | | |Update 1 | 23.1. 1. 0|::: |::: |::: |
|::: | | |Update 0.1 | 23.0.76. 0|::: |::: |::: |
|::: | |RTM | | 23.0.76. 0|::: |::: |::: |
| |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2017-products.html|Vault 2017]] | |RTM |Hotfix 1 | 22.1. 2. 0| 4.6| 22/10 | 2012 / 2014 |
|::: | |RTM | | 22.0.56. 0|::: |::: |::: |
| |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2016-products.html|Vault 2016]] | | | | 21.1. 4. 0| 4.5| 21/ 9 | 2012 / 2014 |
|::: | |RTM |Hotfix 1 | 21.0.59.10|::: |::: |::: |
|::: | |RTM | | 21.0.59.0|::: |::: |::: |
| |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2015-products.html|Vault 2015]] |R2 |RTM | | 20.0.42.0| 4.5| 20/ 8 | 2008 / 2008 R2 |
|::: | |SP1 | | 19.1.13.0|::: |::: | 2012 |
|::: |::: |RTM | | 19.0.49.0|::: |::: | |
| | |
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-Requirements-for-Autodesk-Vault-2014-Products.html|Vault 2014]] |Subscription Release 1 |SP1 |Hotfix 3 | 18.101.3.30| 4.0| 19/ 7 ||
|::: |::: |::: |Hotfix 2 | 18.101.3.20|::: |::: ||
|::: |::: |::: |Hotfix 1 | 18.101.3.10|::: |::: ||
|::: |::: |::: | | 18.101.3.0|::: |::: ||
|::: |::: | | | 18.100.12.0|::: |::: ||
|::: | |SP3 | | 18.3.2.00| 4.0| ||
|::: | |SP2 |Hotfix 3 | 18.2.2.30| 4.0| ||
|::: |::: |::: |Hotfix 2 | 18.2.2.20|::: |::: ||
|::: |::: |::: |Hotfix 1 | 18.2.2.10|::: |::: ||
|::: |::: |::: | | 18.2.2.0|::: |::: ||
|::: | |SP1 | | 18.1.8.0|::: |::: ||
|::: | |RTM | | 18.0.110.x|::: |::: ||
| ||
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-2013-products.html|Vault 2013]] | |SP1 |Update 2 | 17.3.2.0| ?.?| 18/ 6 ||
|::: |::: |::: |Update 1 | 17.2.9.0| | ||
|::: |::: |::: | | 17.1.16.0| |::: ||
|::: |::: |RTM | | 17.0.62.0| |::: ||
| ||
|[[https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-Requirements-for-Autodesk-Vault-2012-products.html|Vault 2012]] | | |Update 3 | 16.3.10.0| ?.?|::: ||
|::: |::: |::: |Update 2 | 16.2.17.0| |::: ||
|::: |::: |::: |Update 1 | 16.1.58| |::: ||
|::: |::: |RTM | | 16.0.56.X| |::: ||
| ||
|Vault 2011 | | |Update 2 | 15.2.66.X| ?.?|::: ||
|::: |::: |::: |Update 1 | 15.1.58.X| |::: ||
|::: |::: |RTM | | 15.0.58.X| |::: ||
| ||
|Vault 2010 | | |Update 2 | 14.2.x.x| ?.?|::: ||
|::: |::: |::: |Update 1 | 14.1.x.x| |::: ||
|::: |::: |RTM | | 14.0.63.x| |::: ||
| ||
|Vault 2009 | |RTM | | 13.0.47.x| ?.?|::: ||
| ||
|Vault 2008 | |SP1 | | 12.1.145.x| |::: ||
|::: | |RTM | | 12.0.123.x| |::: ||
---
=====Timeout bei DEX einlesen =====
{{ :autodesk:timeout-when-importing-files-with-autodesk-data-transfer-utility-to-vault-wi.pdf |Link}}
-----
=====Dateiendungen auf Kleinschrift=====
forfiles /S /M *.pdf /C "cmd /C RENAME @FILE @FNAME.pdf"
[[https://technet.microsoft.com/de-de/library/cc753551(v=ws.10).aspx]]
===== SQL Datenbank =====