No announcements
-
0 VotesAudit - fn_get_audit_file crashes
We are migrating our databases to new servers with a fresh SQL 2019 install. We have auditing enabled and are successfully capturing audit data. We have a daily report we run to review the ...Unanswered | 1 Replies | 73 Views | Created by BQuig - Friday, December 27, 2019 2:43 PM | Last reply by Erland Sommarskog - Friday, December 27, 2019 10:16 PM
-
0 Votes
Ingresos fallidos Usuario SA
Good afternoon, Maybe someone can help me, in my work we have windows server 2014, in Windows Server 2019, a month ago I see that the memory ...Unanswered | 3 Replies | 396 Views | Created by Marco Gutierrez G - Thursday, December 19, 2019 9:44 PM | Last reply by Cris Zhan - Wednesday, December 25, 2019 9:46 AM -
0 Votes
pre-login handshake error
Hi Guys, I am getting below error while connecting SQL Server 2008 R2 from remotely ssms (of 2008 version) from one of the Windows XP VDI. However it is ...Proposed | 5 Replies | 464 Views | Created by Arup.mca - Tuesday, December 17, 2019 4:11 PM | Last reply by Cris Zhan - Thursday, December 19, 2019 12:50 AM -
0 Votes
ms sql server error 18456 on sa login
Hello. I have a problem with sa login to ms sql server 2014 and 2008 on Windows 10. I have new computer with Windows 10. I am login ...Unanswered | 18 Replies | 563 Views | Created by Concept User - Tuesday, December 17, 2019 11:29 AM | Last reply by Erland Sommarskog - Wednesday, December 18, 2019 10:22 AM -
0 Votes
Microsoft Login SQL Server Login Message How Do I fix ?
Microsoft SQL Server Login connection failed : SQLState :'08001' SQL Server Error:-1 [Microsoft] [SQL Server Native ...Unanswered | 6 Replies | 877 Views | Created by VeroV12112019 - Wednesday, December 11, 2019 11:01 PM | Last reply by VeroV12112019 - Friday, December 13, 2019 8:27 PM -
0 Votes
Error: Login failed for user 'admin'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]
Hi, I cannot open my stand alone system because when im trying to log in on it, a pop up window shows: Login failed for user 'admin'. the Database attached to SQL ...Proposed | 2 Replies | 453 Views | Created by jemds - Thursday, December 12, 2019 5:53 AM | Last reply by Cris Zhan - Friday, December 13, 2019 3:20 AM -
1 Votes
How Kerberos and SSL handshake works together?
I see lots articles on net talking about handshaking process of Kerberos authentication or SSL, but I don't find article that describe how these two work together during their handshaking ...Proposed | 5 Replies | 942 Views | Created by PhotoHiker - Wednesday, December 11, 2019 10:02 PM | Last reply by cthivierge - Friday, December 13, 2019 2:14 AM -
5 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 | 15 Replies | 30651 Views | Created by Ameer Deen - Sunday, December 26, 2010 9:59 PM | Last reply by DINM - Thursday, December 12, 2019 4:35 PM -
0 Votes
When register a SPN, why the service name has to be associated with an account?
When registering a SPN using SETSPN -A or SETSPN -S, you need specify an account name (eg. domain account, computer account) under which the service is running. Can anybody please tell me ...Answered | 5 Replies | 1239 Views | Created by PhotoHiker - Friday, December 6, 2019 5:41 PM | Last reply by Cris Zhan - Thursday, December 12, 2019 1:46 AM -
0 Votes
db_datareader and explicit permissions
I have noticed a strange circumstance. In many of our databases, certain users have been assigned to the DB_datareader or the db_datawriter roles. However there will be certain tables in ...Answered | 14 Replies | 13824 Views | Created by joeller - Monday, November 7, 2011 5:40 PM | Last reply by Yared Eshetu - Wednesday, December 11, 2019 9:15 PM -
2 Votes
Secure database files
Hello, Is it possible to crate a password on the database file itself so no one can recreate it or take it and attach it to new server the files i mean is ...Answered | 5 Replies | 999 Views | Created by AbanoubZak - Friday, December 6, 2019 1:19 PM | Last reply by Cris Zhan - Wednesday, December 11, 2019 6:50 AM -
2 Votes
In Place Rebuild a TDE Encrypted SQL Server Instance
Hi, I have a TDE Encrypted SQL Server machine (with a masterkey, Certs, etc). I need to rebuild this SQL Server onto new Hardware BUT keep the original SQL Server Name. ...Proposed | 9 Replies | 1026 Views | Created by MaxShapiro - Thursday, December 5, 2019 8:46 PM | Last reply by Cathy Ji - Tuesday, December 10, 2019 1:36 AM -
0 Votes
Always Encrypted certificate, can be exported and shared ?
I understand how to setup and use Always Encrypted. Part of the process is to create a certificate to use in creating the CMK. Then, export the ...Answered | 1 Replies | 845 Views | Created by DataPimpin - Thursday, December 5, 2019 7:45 PM | Last reply by Amelia Gu - Friday, December 6, 2019 7:31 AM -
0 Votes
xp_instance_regread & xp_regread
Hi All, Public user has execute Extended stored procedure (xp_instance_regread & xp_regread) permisison and it has been reported in audit. Is it safe to revoke the ...Answered | 4 Replies | 1091 Views | Created by SQL_Dave - Wednesday, December 4, 2019 10:26 AM | Last reply by Uri Dimant - Thursday, December 5, 2019 12:09 PM -
0 Votes
Row Level Security vs View ?
Hello which has better performance and usually better practice RLS or View? Target table will have a column name like Department_ID so that only each different Departments can see ...Proposed | 5 Replies | 1600 Views | Created by techresearch7777777 - Friday, November 22, 2019 7:28 PM | Last reply by Erland Sommarskog - Wednesday, December 4, 2019 11:08 PM -
4 Votes
make program or process not to access to our sql server
I want to make limit to connecting our SQL Server. Because this SQL instance is only for our application. But some 3rd office is using our database to get our information. Sometime 3rd office acquire ...Proposed | 12 Replies | 1538 Views | Created by juniorkiran - Tuesday, November 26, 2019 2:04 PM | Last reply by Erland Sommarskog - Tuesday, December 3, 2019 10:16 PM -
0 Votes
Linked Server
I am getting the error below when I tried to create a Linked Server. I am using a Win10 OS , that is running SQL Server 2014 Connecting to A Win10 OS work ...Proposed | 3 Replies | 1355 Views | Created by AniLoDia - Thursday, November 28, 2019 7:04 PM | Last reply by Cris Zhan - Monday, December 2, 2019 1:32 AM -
1 Votes
SQL Server 2017 CU1 Update Failed Shared Features
Attempting to update a SQL Server 2017 Express install to latest CU17 however WSUS wants to install CU1. CU1 is failing, bootstrap log below. Cannot see why the shared features was not ...Proposed | 7 Replies | 1168 Views | Created by PoorITGuy - Wednesday, November 27, 2019 2:17 PM | Last reply by Cris Zhan - Monday, December 2, 2019 1:09 AM -
0 Votes
SQL server on premise with Azure AD authentication
Hi, I do have a SQL on-premise joined to a domain which is hybrid with Office 365/Azure. Since we are moving some machines out of the on-premise domain to Azure ...Unanswered | 1 Replies | 1295 Views | Created by Jose_Rojas - Thursday, November 28, 2019 8:21 AM | Last reply by Dedmon Dai - Friday, November 29, 2019 8:17 AM -
0 Votes
Sysadmin read-only SQL Server 2016
Hello Everyone: Actually we need to create an user non sysadmin that could doing following: 1) Check configurations over ...Proposed | 4 Replies | 1243 Views | Created by Aleds - Thursday, November 28, 2019 7:10 PM | Last reply by Cathy Ji - Friday, November 29, 2019 5:27 AM - Items 1 to 20 of 9034 Next ›
No announcements
