SQL Server RS.exe Utility
rs.exe SQL Server 2012 D:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn SQL Server 2019 D:\Program Files\Microsoft SQL Server Reporting Services\Shared Tools\ Error: ‘rs’ is not recognized as an internal or external command Solution: Per MS’s site it’s anticipating this utility to be in “…\Microsoft SQL Server\###\Tools\Binn” so copy the rs files over to: D:\Program Files (x86)\Microsoft SQL... » read more
Deploy SSIS Package via .SSISDeploymentManifest file
Copy SSIS package file (.dtsx) to server. Run xxxxxx.SSISDeploymentManifest file to start the Package Installation Wizard. Make sure the configuration file xxxxxxConfig.xml also exist in the same folder. The Package Installation Wizard will look for this file for configuration setup. Deployment with this method will set the database connection string. SSIS Package deployment using SSIS... » read more
Unable to Connect to Integration Services
Issue: Unable to view SSIS packages via Integration Services in SSMS. Get “Access is denied” when trying to connect to Integration Services service on the computer xxxxxx. Fix: Run SSMS in “Administrator” mode. Then access the SSIS package by connecting to Integration Services instead of the Database Engine.
SQL Profiler: Filter By Database Name
Filter result by database name. Under Trace properties > Events Selection tab > select show all columns. Now under column filters, you should see the database name. Enter the database name for the Like section and you should see traces only for that database. Note: Make sure you show all columns and select database name.... » read more
Enable SSRS Email Subscription
Go to Report Server Configuration Manager and set the E-mail Settings. Restart SSRS services. On SSRS, you will now see an “Email” subscription option when you create new SSRS subscription.
Unable to add secondary server to AlwaysOn
Error: Failed to obtain cluster information. Either the specificed instance of SQL Server is not running on a Windows Server Failover Cluster (WSFC) node, or the user lacks sysadmin permissions on the SQL Server instance to obtain the cluster information. Resolution: Make sure you restart SQL Server services after setting the AlwaysOn setting. Error: SQL... » read more
SQL Server Permission to Backup Database
db_backupoperator – This role will allow the user to take backups of the database. Server Level – PUBLIC ROLEDatabase Level – DB_BACKUPOPERATOR This is the least privilege to take backups for a database.
Log was not truncated because records at the beginning of the log are pending replication or Change Data Capture
Issue: Log has grown to be very large and unable to trunk log file even after database and transaction log backup. Get the following error message when trying to truncate log. The log was not truncated because records at the beginning of the log are pending replication or Change Data Capture. Ensure the Log Reader... » read more
Server is not configured for remote access
Linked Server Error: Could not execute procedure on remote server ‘XXXX’ because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access. Fix: Make sure remote access is enabled on the database server and that the server has been restarted if the configuration changed. Also... » read more