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
A cat with a new collar remains the same cat, beside its old collar

Can Admin Rename SA Account in SQL Server? – Interview Question of the Week #256

December 22, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Question: Can Admin Rename SA Account in SQL Server?

Answer: Yes, of course. The syntax for to rename SA account is very simple:

Read More
An allotment plot with its gate open, older lettuce rows and a new row of seedlings inside one fence

Granting Read Access to One Schema With GRANT SELECT ON SCHEMA

November 19, 2019
Pinal Dave
SQL Tips and Tricks
Schema, SQL Login, SQL Server, SQL Server Security

Use GRANT SELECT ON SCHEMA for focused read access, test a loginless user, and check ownership chains and table-level DENY behavior.

Read More
Gouache painting of two wooden cogwheels with different tooth sizes side by side on a workbench so they cannot mesh, one wheel vermilion

Error 17182: Unable to Initialize SSL Support in SQL Server

November 11, 2019
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages, SQL Log, SQL Server Installation, SQL Server Security

Error 17182 says the client and server do not possess a common algorithm. A client could not install SQL Server 2014 because the build did not support TLS 1.2. Switching protocols, patching and switching back fixed it.

Read More
Gouache painting of a brass rubber stamp beside a neat stack of blank paper sheets and a vermilion ink pad, with the top sheet unstamped

Error 21089: Log Shipping Jobs Need Sysadmin on the Monitor Server

October 21, 2019
Pinal Dave
SQL Tips and Tricks
Log Shipping, SQL Error Messages, SQL Server Agent, SQL Server Security

Error 21089 failed the Copy and Restore jobs of a log shipping setup. A Profiler trace showed the jobs raising the error on the monitor server. The SQL Server Agent startup account was not a sysadmin there.

Read More
Gouache painting of a stone canal lock with its sluice closed and a small paper boat waiting in the water, a vermilion flag on the boat

Setup Error 25641: Event File Target Parameter Invalid in SQL Server

October 9, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Extended Events, SQL Server, SQL Server Installation, SQL Server Security

Setup error 25641 stopped a SQL Server 2012 installation in a client environment. The ERRORLOG said the filename parameter for the event_file target was invalid. Process Monitor showed Access Denied for the service account on the drive that holds the LOG folder.

Read More
A leather satchel on a station bench, its strap buckled tight but its brass clasp hanging open

Listing Driver, Encryption and Auth Scheme for Every Connection

September 3, 2019
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL DMV, SQL Server, SQL Server Encryption, SQL Server Security

Inspect the auth scheme, encryption, driver interface, and protocol for current SQL Server connections, then group the results clearly.

Read More
Gouache illustration of Public role permissions, with a shared entrance key rack separate from individual locked cabinets.

SQL SERVER – Public Role Permissions and Effective Security Risk

August 28, 2019
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Every database user belongs to Public and cannot be removed from that role. A reader asked whether the role should be eliminated.

Read More
Previous 1 … 6 7 8 9 10 11 12 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

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