SQL Server updates: VSTA & SSMS

Project

SQL Server updates: VSTA & SSMS

Context: DS · Status Closed · Due 2026-01-29

Back to Projects

Project Details

Name

Context

Status

Due date

Notes Saved

## Activities

**26 Jan 26**

* Call with Jose to coordinate the updates and other related topics.

**27 Jan 26**

* Reviewed the server list provided by Pavia.
* Checked to which application it pertains according to uCMDB.
* Further investigation for some servers.
* Open changes in PROD
* Review procedure for updates.

## Notes

1 pending ticket to track and close.

Actualizar SQL server

\- 20\.2\.1 SSMS
\- VSTA

Como ver que version hay instalada?
apps & features

check for updates

cambio? si, cambio standard, 2 dias
Include name of app, search on ucmdb

tocar algo de failover? no hace falta, no se instalan primarios

reinicios? si, solo secundarios

\- VSTA en todos
\- reiniciar solo secundarios
\- instalar SSMS solo en secundarios
\- identificar primarios y pasarlos a Alberto

\\\dfs-asufs-51.dpko.un.org\\software\\Microsoft\\SQL Server\\SSMS

## CMs details

C75292

Batch Installation - Windows Updates and Clustered SQL Maintenance of Critical Applications

\* Vulnerability: Visual Studio Tools for Applications Elevation of Privilege (CVE-2025-29803)
\* Vulnerability: Security Updates for SQL Server Management Studio (April 2025)

| Server | Application | Primary? | VSTA installed | SSMS Installed | CM | Status |
| ------ | ----------- | -------- | -------------- | -------------- | --- | ------ |
| DFS-UGISSQL-01 | UN Geoportal | Yes | Yes | Yes | C75418 | Completed |
| DFS-UMMCSQL-01 | Umoja Material Master Cockpit |  |  |  | C75421 | Completed |
| DFS-UMMCSQL-51 | Umoja Material Master Cockpit |  |  |  | C75421 | Completed |
| DFS-XLNASQL-01 | LN Read-Only (LNAM) |  |  |  | C75422 | Completed |
| DFS-XLNASQL-51 | LN Read-Only (LNAM) |  |  |  | C75422 | Pending |
| OCHA-BSQL19 | CERF-GMS | N/A | N/A | N/A | N/A | Cancelled |
| SP16-P-SQL-01.global.un.org | Peacekeeping Capability Readiness System (PCRS) |  |  |  | C75423 | Pending |
| SP19-P-SQL-51.global.un.org | Peacekeeping Capability Readiness System (PCRS) |  |  |  | C75423 | Pending |
| SP19-P-SQL-52.global.un.org | Peacekeeping Capability Readiness System (PCRS) |  |  |  | C75423 | Pending |
| SP19-R-SQL-51.global.un.org | Peacekeeping Capability Readiness System (PCRS) |  |  |  | C75423 | Pending |
| SP19-R-SQL-52.global.un.org | Peacekeeping Capability Readiness System (PCRS) |  |  |  | C75423 | Pending |
| DFS-HUB-MON01 | Platform Management |  |  |  | C75424 | Pending |

# TEMPLATE

## Activities

**29 Jan 26**

* Installed VSTA 2017 in PRE and PROD environments. No updates on SSMS and the version is not affected by the vulnerability

**Tasks**
Note RFS references
Send start email
Install in PRE
Install in PROD
Close change in HPSM
Send completed email
Close iNeed ticket

## Notes

Actualizar SQL server

* [ ] Review VSTA
* [ ] Descargar VSTA
* [ ] Instalar VSTA
* [ ] No reinicio

\- 20\.2\.1 SSMS
\- VSTA

\\\dfs-asufs-51.dpko.un.org\\software\\Microsoft\\SQL Server\\SSMS

| Server | Application | Primary? | VSTA | SSMS | CM | Completed |
| ------ | ----------- | -------- | ---- | ---- | --- | --------- |
| DFS-UMMCSQL-01 | Umoja Material Master Cockpit | N/A | v2015. N/A | Not vulnerable | C75421 | Yes |
| DFS-UMMCSQL-51 | Umoja Material Master Cockpit | N/A | v2015. N/A | Not vulnerable | C75421 | Yes |
| UMMC-D-SQL-01 | PRE | N/A | Installed | Installed | C75421 | Yes |

Supports Markdown. Auto-saves.

Items in Project 5 total

Description	Status	Due	RFS
SQL Server updates: VSTA & SSMS - Platform Management	Closed	2026-01-29	RFS-1-12753972809
SQL Server updates: VSTA & SSMS - Peacekeeping Capability Readiness System (PCRS)	Closed	2026-01-29	RFS-1-12753943259
SQL Server updates: VSTA & SSMS - LN Read-Only (LNAM)	Closed	2026-01-29	RFS-1-12753943199
SQL Server updates: VSTA & SSMS - Umoja Material Master Cockpit	Closed	2026-01-29	RFS-1-12753943169
SQL Server updates: VSTA & SSMS - DFS-UGISSQL-01	Closed	2026-01-27	RFS-1-12753519067

Link Existing Item

Item

Only items not already in a project are listed. Recurrent routine tasks are excluded.

Create New Item

Meeting Notes Open Meetings

No meeting notes linked to this project yet.

Project time tracking

Last 30 days

Total: 0:00

No time logs for this project yet.