This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
certificateoftrust

SQL SERVER – Fix – Error – The certificate chain was issued by an authority that is not trusted

September 1, 2023
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Error Messages, SQL Server Security

ASP.NET Core applications can sometimes result in the error “The certificate chain was issued by an authority that is not trusted.”

Read More
Dedicated Administrator Connection

SQL SERVER – Adjust Memory with Dedicated Administrator Connection (DAC)

October 15, 2021
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Server Security

the services did not start at all. Let us learn today how to Adjust Memory with a Dedicated Administrator Connection (DAC).

Read More
SQL SERVER - Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value

SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value

September 26, 2019
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Error Messages, SQL Memory, SQL Scripts, SQL Server, Starting SQL

After incorrectly setting max server memory to 14 MB instead of 145000, a client could not start SQL Server. Here is how we got it back online.

Read More
SQL SERVER - FIX: Cannot Connect to SQL in Azure Virtual Machine From Laptop

SQL SERVER – FIX: Cannot Connect to SQL in Azure Virtual Machine From Laptop

January 5, 2019
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Azure, SQL Connection, SQL Error Messages, SQL Server, SQL Server Configuration, SQL Server Security

SSMS on my laptop could not connect to SQL in Azure Virtual Machine, even though it worked fine on the VM itself. Here is how I fixed the connection.

Read More
Manage Connections tool window.

SQL SERVER – Maintenance Plan Error: Failed to Acquire Connection “Local Server Connection”.

May 22, 2018
Pinal Dave
SQL Tips and Tricks
Computer Network, Maintenance Plan, SQL Connection, SQL Error Messages, SQL Server

None of the maintenance plans worked, though the jobs ran fine. The error was failed to acquire connection “Local server connection”. Here is why.

Read More
MySQL - Connection Error - [MySQL][ODBC 5.3(w) Driver]Host 'IP' is Not Allowed to Connect to this MySQL Server

MySQL – Connection Error – [MySQL][ODBC 5.3(w) Driver]Host ‘IP’ is Not Allowed to Connect to this MySQL Server

March 27, 2018
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Connection, SQL Error Messages, SQL Scripts

Setting up a linked server to MySQL, the ODBC test failed: Host ‘IP’ is not allowed to connect to this MySQL server. Here is how I fixed it.

Read More
Report Server Database Configuration Manager.

SQL SERVER – The Report Server Cannot Open a Connection to the Report Server Database. (rsReportServerDatabaseLogonFailed)

March 22, 2018
Pinal Dave
SQL Tips and Tricks
Reporting Services, SQL Connection, SQL Error Messages, SQL Reports, SQL Server

A report viewer failed with rsReportServerDatabaseLogonFailed: the report server cannot open a connection to the report server database. Here is the fix.

Read More
1 2 3 4 … 7 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com