Tagged Questions
2
votes
1answer
66 views
If the users need INSERT/UPDATE/DELETE permissions, is Windows auth still more secure than SQL Server auth?
Some background first:
The problem described below wouldn't exist at all if the database in question would have been built with a DBA's mindset:
Data access only through views and stored procs --> ...
3
votes
1answer
83 views
Domain group hierarchical group membership and SQL Logins mapped to AD groups [closed]
SQL Version: Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: ...
6
votes
2answers
684 views
securely exposing sql server 2008 for windows authentication
My company wants to have approximately 100 of their sales people (distributed around the country) to be able to run stored procedures from excel and return the data onto the spreadsheet.
We have sql ...
4
votes
1answer
1k views
Windows Authentication for a non-local non-domain Login
I have SQL Server 2008 R2 installed on a Windows Server 2008 R2 box. There is no domain in the network.
Is there any way for me to add a Windows Login on SQL Server for a non-local and non-domain ...