Uwe Handzik - CAD Team Handzik

Diese Seite ist nicht editierbar. Sie können den Quelltext sehen, jedoch nicht verändern. Kontaktieren Sie den Administrator, wenn Sie glauben, dass hier ein Fehler vorliegt.
====== 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 : 

<file>
User     : sa 
Password : AutodeskVault@26200
</file>

<file>
User     : VaultSys 
Password : SuperMan769400006! 
</file>


vorgabemäßiges Windows-Benutzerkonto :
<file>
User     : AutodeskVault
Password : Au1oDSK@26200
</file>


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 ===

<file>
SELECT @@version
SELECT SERVERPROPERTY ('edition')
</file>

<file>
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 <X64> (Build 9600: ) (Hypervisor)
</file>

<file>
Standard Edition (64-bit)
</file>

====Wo Liegen die Dateien der Datenbanken 

<file>
USE master;
SELECT name "Logical Name", physical_name "File Location" FROM sys.master_files;
</file>

==== Ü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]]

<file>
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
</file>


<file>
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
</file>

----


==== Open Fire Wall ====

Als CMD Speichern un mit Admin Rechten ausführen 

<file>
@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

</file>
----

===== 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 =====

{{ firma: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 =====