Project

General

Profile

Sidebar »

Vault

Alles zum Thema Vault

Service Packs

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

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

Quelle

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

h1.

Timeout bei DEX einlesen

Link

Dateiendungen auf Kleinschrift

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

Referenz

SQL Datenbank