Let’s load PowerUpSQL

. .\\PowerUpSQL.ps1

Untitled

Getting the SQL SPNs

Get-SQLInstanceDomain -Verbose

Untitled

Now checking if we have the Accessibility to connect to the server

Get-SQLInstanceDomain | Get-SQLConnectionTestThreaded -Verbose

Untitled

Please notice that I have a connection success on the dcorp-mssql server!

Let’s see I we can extract some information about the server

Get-SQLInstanceDomain | Get-SQLServerInfo -Verbose

Untitled

Please notice that we have access but not as Sys Admin!

Enumerating Database Links

Get-SQLServerLink -Instance dcorp-mssql -Verbose

Untitled