firma:autodesk:vault
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende Überarbeitung | ||
firma:autodesk:vault [2025/10/17 09:46] – gelöscht - Externe Bearbeitung (Unbekanntes Datum) 127.0.0.1 | firma:autodesk:vault [2025/10/17 09:56] (aktuell) – ↷ Links angepasst, weil Seiten im Wiki verschoben wurden 47.128.125.92 | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
+ | ====== Alles Rund um den Vault ====== | ||
+ | |||
+ | ===== Infos zu Service Packs ===== | ||
+ | |||
+ | Vault 2025 : [[https:// | ||
+ | Vault 2024 : [[https:// | ||
+ | Vault 2023 : [[https:// | ||
+ | Vault 2022 : [[https:// | ||
+ | Vault 2021 : [[https:// | ||
+ | Vault 2020 : [[https:// | ||
+ | Vault 2019 : [[https:// | ||
+ | |||
+ | ---- | ||
+ | |||
+ | ===== 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:// | ||
+ | |||
+ | ---- | ||
+ | |||
+ | ==== SQL Server Umfeld ==== | ||
+ | |||
+ | === Port Scanner === | ||
+ | |||
+ | https:// | ||
+ | |||
+ | === Versionen === | ||
+ | |||
+ | === Versionstand abfragen === | ||
+ | |||
+ | < | ||
+ | SELECT @@version | ||
+ | SELECT SERVERPROPERTY (' | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | Microsoft SQL Server 2014 (SP3) (KB4022619) - 12.0.6024.0 (X64) | ||
+ | Sep 7 2018 01: | ||
+ | Copyright (c) Microsoft Corporation | ||
+ | Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor) | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | Standard Edition (64-bit) | ||
+ | </ | ||
+ | |||
+ | ====Wo Liegen die Dateien der Datenbanken | ||
+ | |||
+ | < | ||
+ | USE master; | ||
+ | SELECT name " | ||
+ | </ | ||
+ | |||
+ | ==== Übersicht ==== | ||
+ | |||
+ | Liste der Versions Stände - Größe der Datenbank | ||
+ | |||
+ | Siehe auch [[https:// | ||
+ | |||
+ | | Version | ||
+ | | | | | | | ||
+ | | SQL Server 2019 | 15.0.1000.169 | ||
+ | | | | | | | ||
+ | | [[https:// | ||
+ | | | | | | | ||
+ | | 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 | ||
+ | | | | | | | ||
+ | | 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 | ||
+ | | | | | | | ||
+ | | 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 | ||
+ | | | | | | | ||
+ | | SQL Server 2005 Service Pack 4 | ||
+ | | SQL Server 2005 Service Pack 3 | ||
+ | | SQL Server 2005 Service Pack 2 | ||
+ | | SQL Server 2005 Service Pack 1 | ||
+ | | SQL Server 2005 RTM | 9.00.1399 | ||
+ | | | | | | | ||
+ | |||
+ | ---- | ||
+ | |||
+ | ==== Wiederherstellung steht aus ==== | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | < | ||
+ | EXEC sp_resetstatus CADViewerDb | ||
+ | ALTER DATABASE KnowledgeVaultMaster SET EMERGENCY | ||
+ | DBCC checkdb (KnowledgeVaultMaster) | ||
+ | ALTER DATABASE KnowledgeVaultMaster SET SINGLE_USER with ROLLBACK IMMEDIATE | ||
+ | DBCC checkdb (KnowledgeVaultMaster, | ||
+ | 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, | ||
+ | ALTER DATABASE KnowledgeVaultMaster SET MULTI_USER | ||
+ | </ | ||
+ | |||
+ | ---- | ||
+ | |||
+ | |||
+ | ==== Open Fire Wall ==== | ||
+ | |||
+ | Als CMD Speichern un mit Admin Rechten ausführen | ||
+ | |||
+ | < | ||
+ | @echo ========= | ||
+ | netsh advfirewall firewall add rule name=" | ||
+ | @echo ========= | ||
+ | @echo Enabling SQLServer default instance port 1433 | ||
+ | netsh advfirewall firewall add rule name=" | ||
+ | @echo Enabling Dedicated Admin Connection port 1434 | ||
+ | netsh advfirewall firewall add rule name=" | ||
+ | @echo Enabling Conventional SQL Server Service Broker port 4022 | ||
+ | netsh advfirewall firewall add rule name=" | ||
+ | @echo Enabling Transact SQL/RPC port 135 | ||
+ | netsh advfirewall firewall add rule name=" | ||
+ | @echo ========= | ||
+ | @echo Enabling SSAS Default Instance port 2383 | ||
+ | netsh advfirewall firewall add rule name=" | ||
+ | @echo Enabling SQL Server Browser Service port 2382 | ||
+ | netsh advfirewall firewall add rule name=" | ||
+ | @echo ========= | ||
+ | @echo Enabling HTTP port 80 | ||
+ | netsh advfirewall firewall add rule name=" | ||
+ | @echo Enabling SSL port 443 | ||
+ | netsh advfirewall firewall add rule name=" | ||
+ | @echo Enabling port for SQL Server Browser Service' | ||
+ | netsh advfirewall firewall add rule name=" | ||
+ | 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 | ||
+ | |||
+ | " | ||
+ | |||
+ | Dann die Windows Maschine | ||
+ | |||
+ | z.B. | ||
+ | |||
+ | Alter Tresor LEGO | ||
+ | Neuer Treso LEGO-USA | ||
+ | |||
+ | " | ||
+ | |||
+ | |||
+ | 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:// | ||
+ | |||
+ | | | ||
+ | |[[https:// | ||
+ | |[[https:// | ||
+ | |[[https:// | ||
+ | | | | ||
+ | |[[https:// | ||
+ | | | | ||
+ | |[[https:// | ||
+ | | | | ||
+ | |[[https:// | ||
+ | | | | ||
+ | |[[https:// | ||
+ | |::: | | | ||
+ | |::: | | | ||
+ | |::: | |RTM | | ||
+ | | | | ||
+ | |[[https:// | ||
+ | |::: | |RTM | | ||
+ | | | | ||
+ | |[[https:// | ||
+ | |::: | |RTM |Hotfix 1 | ||
+ | |::: | |RTM | | ||
+ | | | | ||
+ | |[[https:// | ||
+ | |::: | |SP1 | | ||
+ | |::: |::: | ||
+ | | | ||
+ | |[[https:// | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | |::: | |SP3 | | ||
+ | |::: | |SP2 |Hotfix 3 | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | |::: | |SP1 | | ||
+ | |::: | |RTM | | ||
+ | | || | ||
+ | |[[https:// | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | | || | ||
+ | |[[https:// | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | | || | ||
+ | |Vault 2011 | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | | || | ||
+ | |Vault 2010 | ||
+ | |::: |::: | ||
+ | |::: |::: | ||
+ | | || | ||
+ | |Vault 2009 | ||
+ | | || | ||
+ | |Vault 2008 | ||
+ | |::: | |RTM | | ||
+ | |||
+ | --- | ||
+ | |||
+ | =====Timeout bei DEX einlesen ===== | ||
+ | |||
+ | {{ firma: | ||
+ | |||
+ | ----- | ||
+ | |||
+ | =====Dateiendungen auf Kleinschrift===== | ||
+ | |||
+ | | ||
+ | |||
+ | [[https:// | ||
+ | |||
+ | ===== SQL Datenbank ===== | ||