Skip to main content
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
Results tagged with
Search options not deleted user 35768

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. …
AKDiscer's user avatar
  • 1,385
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 …
AKDiscer's user avatar
  • 1,385
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. …
AKDiscer's user avatar
  • 1,385
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
AKDiscer's user avatar
  • 1,385
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). …
AKDiscer's user avatar
  • 1,385
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. …
AKDiscer's user avatar
  • 1,385
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. …
AKDiscer's user avatar
  • 1,385
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 …
AKDiscer's user avatar
  • 1,385