Benutzer-Werkzeuge

Webseiten-Werkzeuge


autodesk:vault

Alles Rund um den Vault

Infos zu Service Packs

Vault 2025 : Link
Vault 2024 : Link
Vault 2023 : Link
Vault 2022 : Link
Vault 2021 : Link
Vault 2020 : Link
Vault 2019 : 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 : Link


SQL Server Umfeld

Port Scanner

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 <X64> (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 LINK

Version Stand Build
SQL Server 2019 15.0.1000.169
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

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

LINK

Version Stand Build .NET API SQL Server
Vault 2024 29.0.68. 0 4.7 28/12 2016 / 2019
Vault 2023 28.0.66. 0 4.7 28/12 2016 / 2019
Vault 2022 27.0.66. 0 4.7 27/12 2016 / 2019
Vault 2021 26.0.66. 0 4.7 26/12 2014 / 2017
Vault 2020 25.0.66. 0 4.7 25/12 2014 / 2016
Vault 2019 25.0.66. 0 4.7 24/12 2014 / 2016
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
Vault 2017 RTM Hotfix 1 22.1. 2. 0 4.6 22/10 2012 / 2014
RTM 22.0.56. 0
Vault 2016 21.1. 4. 0 4.5 21/ 9 2012 / 2014
RTM Hotfix 1 21.0.59.10
RTM 21.0.59.0
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
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
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
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

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

autodesk/vault.txt · Zuletzt geändert: 2024/06/13 07:18 von uwe-handzik

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki