Search Results
Search type | Search syntax |
---|---|
Tags | [tag] |
Exact | "words here" |
Author |
user:1234 user:me (yours) |
Score |
score:3 (3+) score:0 (none) |
Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
Views | views:250 |
Code | code:"if (foo != bar)" |
Sections |
title:apples body:"apples oranges" |
URL | url:"*.example.com" |
Saves | in:saves |
Status |
closed:yes duplicate:no migrated:no wiki:no |
Types |
is:question is:answer |
Exclude |
-[tag] -apples |
For more details on advanced search visit our help page |
Allowing users to access only the data they are authorized to access. It also encompasses protection of data during movement on the network and storage on disks and backups.
0
votes
1
answer
958
views
How Do I Gain SysAdmin Access Without Having a SysAdmin Account? [duplicate]
There are two security principles set, SA (disabled), and a AD group that is only associated with the Public server role. …
4
votes
3
answers
26k
views
Connection Manager in SSIS 2017 Package NOT Saving the Password
We're using Visual Studio 15.7.2 and using SSIS on SQL 2017 (14.0.3029.16).
We built a connection manager to a 3rd-party, vendor managed SQL Server 2008 R2 (10.50.6529.0). Our only allowed connectio …
0
votes
2
answers
68
views
SharePoint Database Creation Failure
I wonder if this question will need to be moved to the SharePoint SE site, but I believe this could be a simple a SQL Server security fix. … I don't believe the security settings and logins were extracted from the old server and placed in the new. …
1
vote
SharePoint Database Creation Failure
I believe I found the real issue.
SharePoint 2010 is NOT compatible with SQL 2014.
SQL Server 2014 and SharePoint supportability
3
votes
Accepted
SQL Login keeps losing access to databases
Long answer:
The master database houses the security database for each instance of SQL Server (think Active Directory for a database server). …
2
votes
2
answers
3k
views
Numerous failed authentication attempts in error log
I've gone through every security folder and searched AD high and low, nothing, no remnants of this account. …
3
votes
2
answers
6k
views
SQL Login keeps losing access to databases
Here are two of the error messages we receive:
Upon investigation of the account, it shows up under the Security object folder in SSMS. … Security is a weakness of mine and I'm employing steps to change this, so any insight you can provide would be greatly appreciated. Please let me know if you need more information. …
2
votes
1
answer
67
views
System Database Migration and Security - Log Shipping or DB Mirroring
I've setup log shipping between two servers (they used to be mirrored).
What is the simplest or most efficient way to mirror the system databases between the primary and secondary?
Is it just a mat …