Question : Suppose I have a user table in my site in which there are around 2-3 Million users (records) […]
Tag: authentication
The server principal “loginname” is not able to access the database “SSISDB” under the current security context
Question : We have a stored procedure which calls an SSIS package from the SSISdb database. It works when run […]
Why is MongoDB user with the only privilege as “find” able to insert and update collection?
Question : I want my user to have only find action privilege on a specific collection. However, when I create […]
How to find out all the permissions that belong to a specific server/ database role in SQL Server? [duplicate]
Question : This question already has answers here: List all permissions for a given role? (7 answers) Closed 2 years […]
Secure way to connect: Windows Authentication or SQL Server Authentication and why?
Question : Which is the best way to create a connection string for SQL Server? Should I be using a […]
SQL Server 2012 Can’t log in with machine account
Question : We’re migrating an IIS/SQL Server site from 2008 to 2012, and I’m having a problem with authentication. We […]
SymmetricDS fails to start for PostgreSQL 9.2
Question : I’m trying to get SymmetricDS up and running with PostgreSQL. I’ve followed the tutorial (almost) exactly. (I have […]
Connect to SQL Server with Windows Authentication in a different domain
Question : I am trying to connect to a remote SQL Server on a VPN in a different domain. When […]
sql server authentication login failed
Question : I have SQL Server 2014 on my Windows Server 2012 R2. I can connect locally to SQL Server […]
“Specify SQL Server administrators” – unusual default value
Question : When installing SQL Server, you get to specify SQL Server administrators, i.e., the list of users initially in […]