SQL Server proxy account and local policy
Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the...
2014-10-11
1,315 reads
Originally posted on Peter's blog:
If a user is a member of Sysadmin server role of SQL Server 2005, the...
2014-10-11
1,315 reads
I’m a great fan of running the latest version of Windows Server whenever I deploy SQLServer. I always try to...
2014-10-10 (first published: 2014-10-04)
6,172 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-10-10
476 reads
For the fifth year Steve Jones and I are organizing the Monday Night Networking Dinner at the PASS Summit. It...
2014-10-10 (first published: 2014-10-02)
6,076 reads
The first week of November, we’ll be at the PASS Summit inSeattle, WA. This is the highlight of most SQL Server speakers’...
2014-10-10
661 reads
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-10-10
973 reads
Introduction
After finishing up six months of managing the marketing for SQLSaturday Orlando I’ve been going back through all my blog...
2014-10-10
775 reads
C-R-U-D The Basics
What is CRUD? Well, there are a lot of things I can think of when I use the...
2014-10-09 (first published: 2014-10-01)
8,146 reads
Quick note in case I need again some day. The team recently moved all the user databases for a monitoring...
2014-10-09 (first published: 2014-10-02)
6,031 reads
I saw a whole bunch of great sessions last month. I was all over the place from Las Vegas to...
2014-10-09
554 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
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