No announcements
Found 9189 threads
-
0 VotesHow to clear the existing names in USER NAME drop down list in Sql Server Management Studion in Sql Server 2008 R2`.
Hi, We have Sql Server 2008R2 clustered instance running in 2 nodes with Windows 2008R2 SP1 operating system. I would like to know how I could clear the existing names ...Answered | 3 Replies | 2749 Views | Created by Binny Mathew Earalil - Wednesday, April 22, 2015 6:38 AM | Last reply by Nivek Zehcnas - Wednesday, August 19, 2020 10:01 PM
-
0 Votes
cant seem to open 2019 server firewall ports
Hello, can't seem to open port 1433 on the 2019 firewall although we added the required rule for incoming traffic on all profiles for port ...Proposed | 11 Replies | 1605 Views | Created by nicocleemput - Friday, August 14, 2020 5:30 AM | Last reply by MIAOYUXI - Tuesday, August 18, 2020 1:23 AM -
0 Votes
Support for FIPS 186-3/4 in SQL Server 2016 and newer
Hello, We are trying to use Transparent Database Encryption on MSSQL 2016 with integration of Gemalto's Luna HSM running in FIPS mode (FIPS 186-3/4), unfortunately, we have ...Unanswered | 3 Replies | 1740 Views | Created by david_umifan - Wednesday, August 12, 2020 5:17 AM | Last reply by MIAOYUXI - Monday, August 17, 2020 1:11 AM -
0 Votes
TDE regenerate key
ALTER DATABASE ENCRYPTION KEY REGENERATE WITH ALGORITHM = { AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY } | ENCRYPTION BY SERVER { ...Answered | 5 Replies | 2028 Views | Created by sakurai_db - Friday, August 7, 2020 6:00 AM | Last reply by Liweiyin - Wednesday, August 12, 2020 11:38 PM -
0 Votes
SQL TDE Key Question
I went through the docs document to set up SQL Server TDE Extensible Key Management by using Azure Key Vault. I have a question: how to rotate the key ...Proposed | 4 Replies | 1985 Views | Created by Andury - Monday, August 10, 2020 12:12 AM | Last reply by Liweiyin - Wednesday, August 12, 2020 11:30 PM -
1 Votes
How to obtain SIDs of Sql Server installed NT Service Accounts
Groups, and look at the properties of a group, say "SQLServerSqlAgentUser$myservername$SQLEXPRESS", it has one member "NT SERVICE\SQLAgent$SQLEXPRESS (S-1-5-80-592940576-165...". ...Answered | 7 Replies | 12658 Views | Created by Nivesh Patnaik - Thursday, February 23, 2012 9:46 PM | Last reply by SIRDAGON - Wednesday, August 12, 2020 1:57 PM -
0 Votes
Remote Access Security
HOA=Home Owners Assoc.POS=Point of Sale System I maintain a website for a HOA in Mexico. The website is hosted by a hosting service located in the USA The ...Proposed | 16 Replies | 2955 Views | Created by wgcampbell - Wednesday, August 5, 2020 4:07 PM | Last reply by wgcampbell - Tuesday, August 11, 2020 10:19 PM -
1 Votes
Clone sql database user
Securables. Now I need to add a new user to this database with the same access as the existing users. I was wondering whether there is an easier way to copy access from another ...Answered | 3 Replies | 1666 Views | Created by dper77 - Monday, August 10, 2020 2:12 PM | Last reply by dper77 - Tuesday, August 11, 2020 7:17 PM -
0 Votes
sa account frequently getting expired
This sql server is managed instance in VM hosted in Ms Azure. the password of sa account getting frequently expired and once modified working again.Proposed | 3 Replies | 1932 Views | Created by Idrees Mohammed - Wednesday, August 5, 2020 3:10 PM | Last reply by Cathy Ji - Monday, August 10, 2020 6:54 AM -
0 Votes
Inherited SQL Server Security
So I am mainly a BI guy...SSRS...SSIS...Our DBA recently resigned and guess who got tasked with SQL Server Security. Can anyone provide me a good means to understand users and roles ...Proposed | 4 Replies | 1799 Views | Created by ITBobbyP - Wednesday, August 5, 2020 4:38 PM | Last reply by MIAOYUXI - Monday, August 10, 2020 2:01 AM -
1 Votes
Permission in SQL Server
Hi team, We have very small team and don't have dedicated DBA i need your help to create account with minimum privileges to do following. Requirement: ...Proposed | 5 Replies | 1942 Views | Created by DavidsSql - Wednesday, August 5, 2020 1:44 AM | Last reply by MIAOYUXI - Friday, August 7, 2020 1:25 AM -
0 Votes
How to Disable TLS 1.0 and 1.1
Hi, we made a security test scan and we need to disable TLS 1.0. Where we migth disable TLS 1.0? We made that by TLS 1.0 and 1.1 ...Unanswered | 2 Replies | 2275 Views | Created by josenadim - Wednesday, August 5, 2020 9:06 PM | Last reply by josenadim - Thursday, August 6, 2020 4:29 PM -
0 Votes
How to configure security for PolyBase
I'm installing SQL Server 2019 on a new production machine and would like to know the security considerations for having this feature. This will be a "stand alone" server instance. ...Answered | 4 Replies | 2227 Views | Created by moondaddy - Saturday, August 1, 2020 6:41 PM | Last reply by MIAOYUXI - Thursday, August 6, 2020 1:19 AM -
0 Votes
access via ssms from local machine to remote server (sql instance)
hi guys, i am abit confuse as in according to cis security ...Answered | 1 Replies | 1836 Views | Created by judithMacky - Tuesday, August 4, 2020 9:57 AM | Last reply by Olaf Helper - Tuesday, August 4, 2020 10:09 AM -
0 Votes
Ensure 'xp_cmdshell' Server Configuration Option is set to '0'
Hi, Our Security team got following security vulnerability in our production database. Database version is SQL Server 2017. Ensure 'xp_cmdshell' Server ...Unanswered | 3 Replies | 1810 Views | Created by arifulhaq - Tuesday, August 4, 2020 7:28 AM | Last reply by Cathy Ji - Tuesday, August 4, 2020 9:17 AM -
0 Votes
[Announcement] SQL server related Forums will be migrated to a new home on Microsoft Q&A!
This SQL Server related Forum will be migrated to a new home on Microsoft Q&A! We’ve listened to your ... -
0 Votes
How to generate audit reports that includes all user permissions to particular database and also some info from Active Directory
Here is the format I am looking for fullname,adloginname,email to be fetched from Active Directory, rest comes from a database FullName ...Unanswered | 1 Replies | 1821 Views | Created by shan2008 - Sunday, August 2, 2020 11:14 PM | Last reply by Cathy Ji - Monday, August 3, 2020 8:04 AM -
0 Votes
access storage account from azure sql db without enabling allow trusted microsoft services
I cant access storage account from azure sql db without enabling allow trusted microsoft services on storage account. Further storage account has firewall to enable access from selected network ...Proposed | 4 Replies | 2448 Views | Created by AZHAR SH - Wednesday, July 29, 2020 3:54 AM | Last reply by Cathy Ji - Monday, August 3, 2020 6:38 AM -
0 Votes
How to import TDE certificate stored in Azure Key Vault?
Hello, I have exported my on-prem SQL Server TDE certificate both the .cert and .pvk files. I have also converted them into .pfx format and uploaded to Azure Key Vault. ...Unanswered | 3 Replies | 2384 Views | Created by Sidney L - Thursday, July 30, 2020 12:33 PM | Last reply by Cathy Ji - Monday, August 3, 2020 3:32 AM -
0 Votes
How to pull all users along with their permissions on a specific database
I want to produce worksheet below , some info like username , email etc should come from AD . anyone have script to share or any ideas to start would be helpful. it is for auditing who has what rights ...Proposed | 6 Replies | 2981 Views | Created by shan2008 - Wednesday, July 22, 2020 5:17 AM | Last reply by Cris Zhan - Monday, August 3, 2020 1:16 AM - Items 1 to 20 of 9189 Next ›
No announcements
