SQL 2019, not sure if this needs to be asked over on dbatools but here goes. I’m a sysadmin at the windows and instance level. I’m including the command and output below. Any ideas?
Install-DbaSqlWatch -SqlInstance $Server -Database SQLWATCH
WARNING: [13:20:30][Publish-DbaDacPackage] Deployment failed | Could not deploy package.
Error SQL72014: .Net SqlClient Data Provider: Msg -2, Level 11, State 0, Line 0 Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Error SQL72045: Script execution error. The executed script:
BEGIN TRANSACTION;
MERGE INTO dbo.sqlwatch_config_sql_instance
AS target
USING (SELECT @@SERVERNAME AS [servername],
0 AS [repo_collector_is_active]) AS source ON target.sql_instance = source.[servername]
WHEN NOT MATCHED THEN INSERT (sql_instance, [repo_collector_is_active]) VALUES (source.[servername], source.[repo_collector_is_active]);
MERGE INTO [dbo].[sqlwatch_meta_server]
AS target
USING (SELECT CONVERT (sysname, SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’)) AS [physical_name],
CONVERT (sysname, @@SERVERNAME) AS [servername],
CONVERT (sysname, @@SERVICENAME) AS [service_name],
CONVERT (VARCHAR (50), local_net_address) AS [local_net_address],
CONVERT (VARCHAR (50), local_tcp_port) AS [local_tcp_port],
DATEDIFF(mi, GETUTCDATE(), GETDATE()) AS [utc_offset_minutes],
@@VERSION AS [sql_version]
FROM sys.dm_exec_connections
WHERE session_id = @@spid) AS source ON target.[se
ComputerName : $Server (NOT THE REAL NAME)
InstanceName : MSSQLSERVER
SqlInstance : $Server (NOT THE REAL NAME)
Database : SQLWATCH
Status : (Failed)