Viewing 15 posts - 391 through 405 (of 2,051 total)
Found one with a youtube movie https://joeschoice.com/sslandmssql/
February 11, 2021 at 9:42 am
Can't see your screenshot.
As an alternative you can import the certificate using the mcc certificate snapin
https://codekabinett.com/rdumps.php?Lang=2&targetDoc=create-install-ssl-tls-certificate-sql-server
It might be need to assign read permissions on the certificate in order to be...
February 10, 2021 at 3:52 pm
No more named SSRS instances since SQL 2017 https://itsalljustelectrons.blogspot.com/2018/01/Installing-SSRS-2017.html
February 10, 2021 at 10:28 am
sqlsni.trace seems to be removed in CU8 probably for fix 13671396 XEvent sqlsni.sni_trace does not fire unless sqlsni.trace is enabled in SQL Server 2019.
Thanks to stummsft for a helper function
February 4, 2021 at 4:36 pm
Solved: On SQL2019 it's called sqlsni.sni_trace instead of sqlsni.trace
February 4, 2021 at 4:09 pm
Test before you try this
Now it is more clear (misread domainy). You want to change the domain of the client and make sure the acces to the original sql servers...
February 2, 2021 at 9:31 am
Can you elaborate a bit?
There is a windows client domainx\userA on client Z on domainx
That has acces to server 1,2,3,4,5,6,7
Question:
If i move the user from client Z to client W,...
February 1, 2021 at 11:06 am
Had to lookup up what you meant with "magic tables". Are those the inserted / deleted tables you can reference from triggers or the output clause?
What is magic table in...
December 29, 2020 at 11:29 am
For TLS 1.2 you'll need version 11.0.6216.27 https://support.microsoft.com/en-us/help/3135244/kb3135244-tls-1-2-support-for-microsoft-sql-server
Might als wel update to SP4 + CU + security fix https://sqlserverbuilds.blogspot.com/#sql2014x.
Can't verify it because our servers are 2017+
December 29, 2020 at 11:17 am
What is the patchversion of SQL Server 2014 ? It could be that TLS 1.2 is now required
December 28, 2020 at 1:24 pm
Can we upgrade straight to CU15 for CU12: yes . CU's contains the patches since SP2
SSMS: check releasenotes https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15
December 28, 2020 at 1:23 pm
Have it as a text parameter instead of datetime? Use a second internal parameter to convert the text to datetime?
December 1, 2020 at 1:32 pm
Thanks for the feedback
November 26, 2020 at 10:37 am
Viewing 15 posts - 391 through 405 (of 2,051 total)