No announcements
-
53 VotesToken-based server access validation failed with an infrastructure error
Hi We have a new Win 2008 Enterprise x64 server running SQL 2008 When we try to connect to the server using Windows Authentication, from a user account ...Answered | 35 Replies | 284789 Views | Created by Bruce Baker - Sunday, February 15, 2009 10:07 PM | Last reply by Mikhail_sa - 6 hours 7 minutes ago
-
0 Votes
SQL Always Encrypted - New-SqlColumnEncryptionKeyEncryptedValue ERROR
Import-Module "SqlServer" $CMKSettings = New-SqlCngColumnMasterKeySettings -CngProviderName "SafeNet Key Storage ...Answered | 2 Replies | 266 Views | Created by Eric_C_Canada - Wednesday, September 25, 2019 8:28 PM | Last reply by Eric_C_Canada - Monday, October 7, 2019 1:21 PM -
4 Votes
SQL Server security question
Hi All, This is more of a security related question. Usually, we connect to Prod SQL Servers via Jump Servers. while connecting to jump ...Answered | 7 Replies | 528 Views | Created by Samantha v - Tuesday, September 17, 2019 6:10 AM | Last reply by Samantha v - Friday, October 4, 2019 7:04 AM -
0 Votes
Possibility of Modifying Entries in the *.LDF Files
Hello Team, I am Serge KOUNGA, Head of IT Audit at an insurance company in Cameroon (Africa). Throughout some of the analyses I performed in our Database, I ...Proposed | 4 Replies | 159 Views | Created by SergeKounga - Wednesday, October 2, 2019 7:13 AM | Last reply by Erland Sommarskog - Wednesday, October 2, 2019 9:32 PM -
0 Votes
Do I need Integration Service installed to run any SSIS package job?
Hi, One of our developer wants to transfer data from Oracle to SQL Server through SSIS package job. SQL Server Integration Service is not installed in database instance. Only ...Answered | 2 Replies | 202 Views | Created by arifulhaq - Monday, September 30, 2019 8:20 PM | Last reply by arifulhaq - Tuesday, October 1, 2019 6:41 AM -
0 Votes
SQL Server TDE (Transparent Data Encryption)
Hi, My company wants to encrypt some of the tables of database. Our requirement is to do storage level encryption. I searched the net and found TDE (Transparent Data ...Answered | 6 Replies | 335 Views | Created by arifulhaq - Saturday, September 28, 2019 9:00 AM | Last reply by Erland Sommarskog - Monday, September 30, 2019 9:32 PM -
0 Votes
Running Vulnerable TDS service
How do you fix a Running Vulnerable TDS service security scan?Answered | 5 Replies | 6606 Views | Created by KArmes - Monday, July 22, 2013 4:26 PM | Last reply by mwapemble - Monday, September 30, 2019 7:03 AM -
4 Votes
Force encryption on SQL Server not working?
Hello Everyone, I'm running SQL Server 2008 64-bit. I've installed a self-signed cert on the box and set "Force ...Answered | 13 Replies | 28639 Views | Created by Ameer Deen - Sunday, December 26, 2010 9:59 PM | Last reply by PanirDasan - Friday, September 27, 2019 5:21 PM -
3 Votes
Port 1433 external Access over Internet for Management Programm
Hello, is there a Way to access a SQL-Server Database (2017 Express) from a Client without VPN (comfortability Reasons when Access from external) not produce a Security-Risk ...Unanswered | 4 Replies | 272 Views | Created by cc500 - Thursday, September 26, 2019 6:27 PM | Last reply by cc500 - Friday, September 27, 2019 4:03 PM -
0 Votes
Auditing contained database authentication
Hello! One more question on auditing, please: This page says: FAILED_DATABASE_AUTHENTICATION_GROUP Indicates that a principal tried ...Unanswered | 3 Replies | 258 Views | Created by MF47 - Thursday, September 26, 2019 3:30 PM | Last reply by MF47 - Friday, September 27, 2019 11:47 AM -
0 Votes
Sending remote attachments using sp_send_dbmail - SQL 2008 R2
Hi, I am using Windows Authentication to send email using sp_send_dbmail. Sending ...Answered | 3 Replies | 12136 Views | Created by dba_0419 - Monday, August 20, 2012 2:08 PM | Last reply by Nizamettin Özpolat - Thursday, September 26, 2019 5:31 AM -
0 Votes
MSSQL Studio passwords
I am setting a password for my login using MSSQL Studio. When I go back to check it, the password is not what I set it to. I know this for two reasons: 1) The password ...Proposed | 2 Replies | 254 Views | Created by StreetScooby - Tuesday, September 24, 2019 5:55 PM | Last reply by Cathy Ji - Wednesday, September 25, 2019 7:43 AM -
0 Votes
SQL 2 node cluster - need to whitelist multiple IPs or just single VIP ?
Hello we have a 2 node (Active / Inactive) SQL Server cluster. We are in Dept A and would like to create a Linked Server into a different SQL Server that's located in a separate Dept B being in ...Answered | 1 Replies | 241 Views | Created by techresearch7777777 - Monday, September 23, 2019 8:05 PM | Last reply by Dedmon Dai - Tuesday, September 24, 2019 9:52 AM -
0 Votes
BATCH_STARTED_GROUP/BATCH_COMPLETED_GROUP
Hello! Can't find the description for the BATCH_STARTED_GROUP/BATCH_COMPLETED_GROUP on this page - is there any documentation on these audit action ...Answered | 12 Replies | 399 Views | Created by MF47 - Wednesday, September 18, 2019 2:58 PM | Last reply by MF47 - Monday, September 23, 2019 1:06 PM -
17 Votes
how to change sql server login password?
hello. iam using SqlServer 2008r2 and my pc is in the network (in an office) how can change my login password which is ...Answered | 8 Replies | 354055 Views | Created by great ehsan - Saturday, June 16, 2012 6:02 AM | Last reply by vitasery - Monday, September 23, 2019 6:37 AM -
5 Votes
query to see all databases to which a user has access
I need a simple script that will list all of the databases to which a particular user has access. We have over 100 databases on our server, and around 300 users. Yes, I know I can get this info by ...Answered | 9 Replies | 28669 Views | Created by Dubious One - Saturday, August 20, 2011 1:09 AM | Last reply by Erland Sommarskog - Sunday, September 22, 2019 5:37 PM -
3 Votes
Grating execute permission on a stored procedure without grating permission on base table not working
Our production DB server supports a complex web application and the problem we currently face is a kind of a basic security issue and I was asked to resolve it in a week time. The ...Proposed | 4 Replies | 355 Views | Created by sqlca - Thursday, September 19, 2019 9:47 PM | Last reply by Erland Sommarskog - Friday, September 20, 2019 9:45 PM -
0 Votes
A self-generated certificate was successfully loaded for encryption.
SQL Server logs message "A self-generated certificate was successfully loaded for encryption". Can we know for each SQL Version i.e. 2005/2008/2012/2014/2016/2017 what is the protocol used. ...Answered | 4 Replies | 298 Views | Created by nitin.doshi - Friday, September 20, 2019 9:40 AM | Last reply by Dan Guzman - Friday, September 20, 2019 10:33 AM -
0 Votes
Change BUILTIN\Administrators from sysadmin to public
Hi, I have a task to delete or degrees permissions to BUILTIN\Administrators in SQL server 2016 (As said best practices). In this group there are local users, local machine ...Unanswered | 4 Replies | 376 Views | Created by ALdo1982 - Thursday, September 19, 2019 10:14 AM | Last reply by Amelia Gu - Friday, September 20, 2019 6:45 AM -
12 Votes
Database Users showing disabled
In SSMS, a database user is showing up as disabled (a down reddish arrow). When I look at the server login - it shows that it is a valid login to the instance. I go to Login Properties and ...Answered | 10 Replies | 32575 Views | Created by DbsBasu - Tuesday, April 5, 2011 3:29 PM | Last reply by Canew Wils - Thursday, September 19, 2019 4:44 PM - Items 1 to 20 of 8987 Next ›
No announcements
