2018-06-18
902 reads
Raghavender Chavva
Solving the Target Principal Name is Incorrect
One small point to note when we receive the below error while connecting SQL server: The target principal name is incorrect. Cannot generate sspi context
2018-05-31
32,080 reads
Finding table name based on a specific value
This script is used to Find out the table name and column name where a specific string has been used
2018-04-17 (first published: 2018-04-13)
2,352 reads
2018-04-16
920 reads
2016-08-16
1,397 reads
2016-04-19
5,243 reads
SQL Jobs on Always On
This script will check the status of the node in Always On and enable or disable the jobs according to our requirement.
2015-12-02 (first published: 2015-11-18)
1,652 reads
Blogs
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers