Connecting to SSIS 2008 Without Local Admin
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
65 reads
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
65 reads
After setting up a new SQL Server instance for development I found the following permissions were needed extra permissions were...
2013-03-21
63 reads
When developing and debugging transport security WCF services it’s a real pain if each developer on the team needs to...
2013-03-15
221 reads
In my previous post I walked through configuring ADFS and writing a small C# console app to authenticate with it...
2013-02-06
546 reads
I’m writing this post more as documentation for myself as I know I will be repeating this process quite a...
2013-01-31
436 reads
Page navigation can be a pain to achieve in a true MVVM way, I recently ran in to this problem...
2013-01-14
97 reads
In this post I am going to walk you through creating a virtual environment from the ground up to play...
2012-11-19
60 reads
PowerShell Style
I recently needed to automate disk alerts for each of our servers, to keep it simple I wrote a...
2012-09-22
128 reads
In C# it is possible to write classes that implement an interface but only show the methods of the interface...
2012-06-07
54 reads
What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.
What are message queues?
Message queues are a...
2012-06-03
232 reads
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
By James Serra
(This is the second post in a three-part series on how AI is changing...
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Comments posted to this topic are about the item Pay for Performance, which is...
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
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