Moving SQL Reporting Services Native Mode
I am trying to move a SQL Reporting Services database from a 2016 server to 2022. No problem, done this many times before. But on this one the source server in Reporting Services Configuration manager shows as Native, but once restored on the new server. When I run Reporting Services Configuration manager it pops up as Sharepoint. Anyway to set it back to native mode? Please advise. Thanks! JG
SQL Server Agent is not starting after in place upgrade of SQL server from 2012 to 2019
SQL Server Agent is not starting after in place upgrade of SQL server from 2012 to 2019 I have done in place upgrade of SQL server from SQL 2012 Standard Edition (64-bit) SP4 to Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X 64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X 64> (Build 17763: ) (Hypervisor). But after upgradation, sql server agent is in stopped state. I have tried with Local system account also but still no luck. Error in windows event logs is SQLServerAgent could not be started (reason: SQLServerAgent cannot start because the msdb database is read-only). I have checked and confirm that msdb database is not in read only state. Can someone help me to resolve this issue.
Large-scale VDI deployment management with Active Directory and domains
Hello I am working for a start up and deployed RDS persitent VDI for just one enterprise which works perfectly. Now office wants to offer Persitent VDI to multiple company. I don't have much experience and would appreciate a guidance and solution for large-scale deployment. Do i have to create one Forest or multiple Forest? Do i have to create a Parent Domain then multiple child domain? Do i have to create multiple Domains? I don't want the Enterprise to be able to see each other or access other Enterprise files or software. like Teams and others. I intend to create multiple vlans per enteprise, my concern is Active Directory, RD broker, RD gateway and RD web. I will appreciate feedback, insight on how to create the domains and trust relationship. Best regards