Issue: SQL Server 2016 would not send mail on a new server migration to Windows Server 2016 Solution: By default, Windows Server 2016 installs .net framework 4.7 The database mail feature needs .Net 3.5 Install this windows feature and this issue gets resolved.
Below is an error that showed up while trying to execute a stored procedure on instance X from SQL server instance y. MYSERVER here represents the name of SQL Server instance X Msg 7411, Level 16, State 1, Line 1 Server ‘MYSQLSERVER′ is not configured for RPC. Solution to this was to set RPC in/out […]
On a server running SQL 2014 SSIS with SSISDB configured, one of the SQL Agent jobs configured to run using a proxy account kept failing with the error below. Message Unable to start execution of step 1 (reason: JobOwner domain\domainuser doesn‘t have permissions to use proxy 1 for subsystem SSIS). The step failed. Solution that […]
Issue: A restored database from one instance to the other keeps showing below when attempting to say, alter a stored procedure. The database owner SID recorded in the master database differs from the database owner SID recorded in database Solution applied: Assuming XYZ is the name of the database and contosoadmin is the name of […]
Error “Maximum request length exceeded” in Reporting Services This error came up while trying to upload a 3.9Mb SSRS report to a new SQL 2008 R2 reporting server. Solution: open the web.config file found in: C:Program FilesMicrosoft SQL ServerMSRS10_50.#####Reporting ServicesReportServer #### stands for your instance name Modify line 40 or the line with below: to: […]