SQL Server Setup & Upgrade announcement
-
Link
- Customer-ready SQL Server 2012 Upgrade Technical Guide(How to upgrade).
- What's new.(Why upgrade)
-
27 Votes
Marking your questions as Answered
Hi All, I want to make a pitch to have folks mark their questions as Answered once you've received an Answer that solves your problem. Everyone who posts a question has the ...Sticky | 6 Replies | 62998 Views | Created by Samuel Lester - MSFT - Tuesday, February 13, 2007 5:21 AM | Last reply by AbsolutelyFreeWeb - Monday, December 7, 2015 4:32 PM
-
0 Votes
For a 2 node sql availability group: primary and secondary is it essential to have load balancing for high availability?
Hi, For a 2 node sql availability group: primary and secondary is it essential to have load balancing for high ...Unanswered | 13 Replies | 885 Views | Created by xyz2012 - Monday, November 11, 2019 10:14 AM | Last reply by xyz2012 - 7 hours 8 minutes ago -
1 Votes
SQL Server 2016 backup fills the log when databases are offline (Login failed for user 'XXX\YYYY'. Reason: Failed to open the explicitly specified database 'ABC'. [CLIENT: <local machine>])
Hi, After migration from SQL Server 2012 to SQL Server 2016, the maintenance plan backups started to take more time than it was before, but I did not bother so much at this ...Unanswered | 9 Replies | 939 Views | Created by Francis Harvey - Monday, May 7, 2018 9:38 PM | Last reply by Uri Dimant - 10 hours 50 minutes ago -
0 Votes
Error enabling FILESTREAM on SQL 2019
I'm trying to enable FILESTREAM functionality on SQL Server 2019 Configuration Manager, but it's always giving this ...Unanswered | 2 Replies | 435 Views | Created by David Yanagaki Bonafé - Friday, December 6, 2019 11:04 PM | Last reply by Cathy Ji - 14 hours 28 minutes ago -
1 Votes
Error in install SSMS
Hello, I want to install SSMS but I have an error and log file here [2754:2288][2019-12-03T21:57:41]i001: Burn ...Answered | 4 Replies | 663 Views | Created by Arash_89 - Tuesday, December 3, 2019 6:52 PM | Last reply by Amelia Gu - 22 hours 9 minutes ago -
1 Votes
Unable to install SQL Server (-2061893607) "Could not find the Database Engine startup handle"
Hi, I'm trying to install SQL Server 2017 Express Edition, just the basic configuration, and I'm getting the following error when I do ...Unanswered | 24 Replies | 1473 Views | Created by scorcho - Monday, July 15, 2019 9:04 AM | Last reply by idoan - Sunday, December 8, 2019 3:01 AM -
0 Votes
Connection Time Out Error
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the ...Unanswered | 3 Replies | 443 Views | Created by Prajakta Sonawale - Thursday, December 5, 2019 8:16 AM | Last reply by Erland Sommarskog - Friday, December 6, 2019 10:41 PM -
0 Votes
How do you access data in a SQL Availability Group enabled database without putting a password in connection string?
Hi, How do you access data in a SQL Availability Group enabled database without putting a password in connection string? ? Thanks.Answered | 3 Replies | 496 Views | Created by xyz2012 - Wednesday, December 4, 2019 5:01 PM | Last reply by xyz2012 - Friday, December 6, 2019 5:42 PM -
0 Votes
Sql Server 2017 on Ubuntu datetime problem
I have SqlServer 2017 express on Ubuntu 16, When I issue an "GetDate", it returns time 6 hours later than datetime on Ubuntu. We already reset ...Unanswered | 3 Replies | 393 Views | Created by CLAUDIO CHILOMER - Thursday, December 5, 2019 12:02 AM | Last reply by Dedmon Dai - Friday, December 6, 2019 8:42 AM -
0 Votes
Failure to install SQL Server 2012 SP1 CU8/9 with a “Failed to retrieve data for this request.” error
Hi all, Has anyone come across SQL Server 2012 SP1 CU8/9 failing to install with a “Failed to retrieve data for this request.” error. The error is too ...Answered | 9 Replies | 10652 Views | Created by SQL Ranger - Friday, April 25, 2014 4:40 AM | Last reply by SQL Warrior - Thursday, December 5, 2019 5:45 PM -
0 Votes
2nd node in FCI fails to install SQL Server 2016
System.ComponentModel.Win32Exception: Not all privileges or groups referenced are assigned to the caller. at ...Proposed | 10 Replies | 1229 Views | Created by robert.biehl - Monday, October 22, 2018 2:57 PM | Last reply by SQL Warrior - Thursday, December 5, 2019 2:01 PM -
0 Votes
ALWAYS ON set up and creating new Sql server on Windows Failover Clustering for DR
We have currently SQL Server 2016 (SP2-CU6) (X64) Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Hypervisor) and we are planning to ...Unanswered | 4 Replies | 1103 Views | Created by pdsqsql - Thursday, November 28, 2019 2:42 AM | Last reply by Shanky_621 - Thursday, December 5, 2019 4:23 AM -
0 Votes
Installing SQL 2017 clustered instance - Updating permission setting for folder issue
I am installing SQL 2017 enterprise as fail over cluster and running into this issue below. PRODSQL is a clustered shared volume. I created sub folder "SQLData" ...Unanswered | 5 Replies | 608 Views | Created by Stan210 - Monday, December 2, 2019 6:36 PM | Last reply by Stan210 - Wednesday, December 4, 2019 5:05 PM -
0 Votes
Error in SSMS Setup
Hello, I want to install SSMS but I have an error and log file here Log ...Unanswered | 4 Replies | 563 Views | Created by Arash_89 - Tuesday, December 3, 2019 6:53 PM | Last reply by Cris Zhan - Wednesday, December 4, 2019 9:36 AM -
0 Votes
Unable to uninstall Microsoft SQL Server 2008 R2 (64-bit)
Hi I want to unistall the above program that was not previously installed correctly. However the window "Removal Progress" stacked to the message ...Unanswered | 4 Replies | 428 Views | Created by evdokimos - Tuesday, December 3, 2019 11:11 AM | Last reply by Dedmon Dai - Wednesday, December 4, 2019 8:40 AM -
0 Votes
SQL Server ent ed installation on Windows Server core Failover cluster
Hi, I am chasing any information to assist in doing a SQL Server 2019 enterprise edition install on a 2 node Windows Server core. The process to install clustered sql server on ...Unanswered | 3 Replies | 584 Views | Created by Derek Harper - Monday, December 2, 2019 3:07 AM | Last reply by purushottam151 - Wednesday, December 4, 2019 12:25 AM -
0 Votes
Can I use MSSQL Developer Edition for free to configure and demonstrate in any ETL tool?
Can I use MSSQL Developer Edition for free to configure as db source for ETL product demonstration to confirm that the ETL tool can pull data from MSSQL DB for further ...Answered | 4 Replies | 465 Views | Created by RanjanNew - Tuesday, December 3, 2019 9:04 AM | Last reply by RanjanNew - Tuesday, December 3, 2019 10:52 AM -
0 Votes
rob henderson
I have a software application which in order to operate correctly, requires SQL 2005 Standard Edition to be installed on the same laptop. A later edition of SQL is not acceptable as this will ...Proposed | 5 Replies | 816 Views | Created by rob henderson - Monday, December 2, 2019 3:46 PM | Last reply by Olaf Helper - Tuesday, December 3, 2019 9:27 AM -
0 Votes
The patch installer has failed on SQL Server 2016 ENT
Hi Team, While i try to install Update 10 for SQL Server 2016 SP2. found error from logs: Overall summary: Final ...Proposed | 1 Replies | 495 Views | Created by VijayKSQL - Monday, December 2, 2019 7:08 PM | Last reply by Cathy Ji - Tuesday, December 3, 2019 6:35 AM -
1 Votes
Why do I need DAC if I am able to connect to the server via sqlcmd?
DAC attracted my attention at the moment when I was unable to connect to the SQL Server using a traditional way (the reason was deleting logon trigger). I made some searches on the web and ...Answered | 2 Replies | 395 Views | Created by RaufDBA - Monday, December 2, 2019 1:29 PM | Last reply by Olaf Helper - Monday, December 2, 2019 1:45 PM -
0 Votes
The User Data directory in the registry is not valid ... Error code: 0x851A0043
I've installed SQL Server 2014 on a new Windows 7 computer. I am trying to apply the SQLServer2014-KB3158271-x64.exe update which is the "3158271 Cumulative update package 14 (CU14) for SQL ...Proposed | 7 Replies | 882 Views | Created by jmarkfoley - Sunday, December 1, 2019 4:47 AM | Last reply by Cathy Ji - Monday, December 2, 2019 7:20 AM - Items 1 to 20 of 20499 Next ›
SQL Server Setup & Upgrade announcement
-
Link
- Customer-ready SQL Server 2012 Upgrade Technical Guide(How to upgrade).
- What's new.(Why upgrade)