Error: Error when trying to create a database backup. Fix: Look for the service SQL Server (MSSQLServer) and see the username under ‘Log On As’. Add this user to have full control of permissions on the directory of back up by navigating to the folder / properties/ under secirity tab / Edit and give the... » read more
Make sure to install “Windows Failover Cluster” feature on all nodes in the cluster. Open up “Failover Cluster Manager”. Right click on Failover Cluster Manager and select “Create Cluster”. Select list of servers to be in the cluster. Run Cluster Validation. Provide a “Cluster Name”. Provide a “Networks/IP Address”. Setup a listener is optional but... » read more
Install the Failover Clustering feature Start Server Manager. On the Manage menu, select Add Roles and Features. On the Before you begin page, select Next. On the Select installation type page, select Role-based or feature-based installation, and then select Next. On the Select destination server page, select the server where you want to install the feature, and then select Next. On the Select server roles page, select Next. On the Select features page,... » read more
To switch version (from Evaluation edition to Developer edition) go to Add/Remove program. Select “Microsoft SQL Server Reporting Services” and Uninstall. Go to “Upgrade Edition” and select the version you want to switch to.
Installing SSRS Starting with version 2016, SSRS is a separate install file. Once installed, you will see the “Reporting Services Configuration Manager” app. There may be different version of SSRS Configuration Manager on the same server. Restart of the server may be required after install. To change edition (from Evaluation edition to Developer edition, go... » read more
Open up Setup.exe for SQL Server 2019. In the popup, go to “Installation” and select “New SQL Server stand-alone installation or add features to an existing installation. Tips Use system default to install. Once SQL Server is installed, then go back to change the service accounts. If the setup service accounts don’t have proper permissions,... » read more
The uninstaller for SQL Server is hidden under the control panel’s Add or Remove Programs. Goto “Add or Remove Programs“. Select “Microsoft SQL Server 2019” and “Uninstall”. Select “Remove” from the popup menu. Select instance to remove. Select features to remove. Select “Remove” button. Note: When uninstalling SQL Server, make sure you also uninstall the... » read more
Issue: SSMS IntelliSense autofill feature not working after Red Gate uninstall. Resolution: Enable IntelliSense: For all query windows, please go to Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense, and select Enable IntelliSense. For each opening query window, please go to Query >> Intellisense Enabled. Enable statement completion: please go to Tools >>... » read more
All you need is to create the same login on the second server preserving it’s sid, and you can do this first by copying the login’s sid from sys.server_principals and then by creating the same login using with sid like this: Example: On Primary Database: On Read Only Replica Database: Sources: https://dba.stackexchange.com/questions/174946/creating-a-sql-login-and-user-on-an-alwayson-replica
Issue: D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe Ssms.exe is corrupted or missing. Fix: To repair Management Studio open Control Panel, go to Programs and Features, locate SQL Server Management Studio using the scroll bar and double click on it. You can also just upgrade to a newer version of SQL Server Management Studio.... » read more