Alles Rund um den Vault

Vault 2025 : Link
Vault 2024 : Link
Vault 2023 : Link
Vault 2022 : Link
Vault 2021 : Link
Vault 2020 : Link
Vault 2019 : Link

SA User :

User     : sa 
Password : AutodeskVault@26200

User     : VaultSys 
Password : SuperMan769400006! 

vorgabemäßiges Windows-Benutzerkonto :

User     : AutodeskVault
Password : Au1oDSK@26200

Passwort vergessen : Link

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/using-portqrytool-sqlserver

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;

Liste der Versions Stände - Größe der Datenbank

Siehe auch LINK

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

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

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

Alles rund um die Vault Versionsstände - mit Link zu den Autodesk Empfehlungen

LINK

—

Link

 forfiles /S /M *.pdf /C "cmd /C RENAME @FILE @FNAME.pdf"

https://technet.microsoft.com/de-de/library/cc753551(v=ws.10).aspx