All Questions
Tagged with sql-server-2017 upgrade
19 questions
0
votes
0
answers
52
views
SSRS 2016 compatibility with SQL 2017 after SQL2016 upgrade
We have an SQL Server database engine on the 2016 version. We also have SSRS in the 2016 version. I plan to upgrade the SQL database engine from the 2016 version to the 2017 for it to participate in ...
- 5
2
votes
1
answer
957
views
SQL server wont start automatically after OS upgrade
I did an in place upgrade for host OS from Windows server 2012 R2 to windows server 2022. After this move, I noticed the SQL server 2017 enterprise edition instance therein does not start ...
1
vote
2
answers
4k
views
In-Place upgrade from SQL Sever 2014 to 2017 finds nothing to upgrade
I'm attempting an in place upgrade from SQL 2014 to SQL 2017, Standard Edition on Windows 2012 R2 (Yes, I know...) The issue is that the installer never presents me with a screen to select the ...
- 166
0
votes
1
answer
331
views
SQL Agent Job fails after upgrade to SQL 2017
I have upgraded a database to SQL 2017. A SQL Agent Job that previously ran now fails with this error:
Unable to start execution of step 1
(reason: JobOwner DOMAIN\USERNAME doesn't have permissions ...
- 111
4
votes
0
answers
129
views
Planning for application upgrade which connects to SQL server database
I am looking for some advise/guidance on how to achieve this with minimum downtime and possibly avoid any errors or failure during production change-
Background-
We have SQL database servers ...
- 794
-1
votes
1
answer
121
views
Should my company upgrade from Enterprise 2017 to sql server 2019? [closed]
Our production server is currently running SQL Enterprise 2017.
We're paying for software assurance which means we can upgrade at any time.
Should we be looking at SQL 2019?
- 707
0
votes
2
answers
363
views
Remove Query Tuning Assistant (msqta) schema and tables
When running the Query Tuning Assistant (using the New Database Upgrade Session) on SQL Server 2017 I have a new schema msqta created in the corresponding database as supposed, along with six tables ...
0
votes
1
answer
206
views
Upgrading Operating System only. OS 2016 - 2019
Currently we have a number of Servers that are using Windows 2016 with SQL Server 2017. The support team want to do an in-place upgrade of the OS to 2019 due to 2016 Mainstream support ending in Jan ...
- 63
0
votes
1
answer
289
views
Transactional replication upgrade from SQL Server 2017
We would like to inplace upgrade of transactional replication topology from SQL Server 2017 to SQL2019 with minimal downtime. The following is the setup. All the all current instances are on SQL ...
- 113
1
vote
0
answers
27
views
Is it bad practice to leave the master database at a lower compatibility level after an in-place upgrade? [duplicate]
Based on this documentation, Microsoft intentionally leaves the master database at the previous compatibility level after an in-place upgrade.
I recently performed an in-place upgrade from 2012 to ...
- 751
3
votes
0
answers
749
views
RDS MSSQL in-place upgrade how to update master db compatibility level when rdsa account is db owner
Background
My workplace infrastructure team ran a typical in-place upgrade of an RDS MSSQL instance to update the version from 2012 to 2017.
After the upgrade, while logged in as the "master ...
- 751
0
votes
1
answer
3k
views
Need to upgrade SQL Server from 2012 to 2017 on a Server 2008 box
I have been asked to upgrade SQL Server from 2012 to 2017, it is currently installed on a server with Windows 2008 OS.
My thinking from what I've researched is this:
Take a snapshot of the server
...
LamNam
0
votes
1
answer
77
views
User info retrieval takes too long - ASP.NET Membership
I have an application that has been taken from a sharepoint user control and converted to plain web pages. Everything is working fine - I can sign up and retrieve my password, etc. However, when I try ...
- 1
2
votes
1
answer
1k
views
How to upgrade SQL Server 2016 and 2017 Standard to 2017 Enterprise edition
We have one SQL Server 2016 Standard instance, and two SQL Server 2017 Standard instances installed on the same server. Now my management wants to install SQL Server 2017 Enterprise edition and ...
- 31
2
votes
0
answers
39
views
SQL Server update from GDR to CU-17 [duplicate]
I'm using SQL SERVER 2017 GDR version 14.0.2002.14. I want to upgrade to the latest possible version of SQL Server 2017.
My question is can I download CU-17 and directly run the latest cumulative ...
- 21
0
votes
1
answer
325
views
Behavior Differences Running SQL 2017 in 130 Compat Mode vs. Running SQL 2016 in 130 Compat Mode?
We have a new application which includes ETL scripts, R, and .NET code all actively being developed on SQL 2016 architecture.
I just recently received approval to start setting up new environments ...
- 87
2
votes
2
answers
150
views
Upgrade SQL Server, not user databases
I have one machine we've been fighting to do an in place upgrade of SQL Server from 2016 SP2 CU3 to 2017. It keeps failing, but that's another topic. My question is, is there a way I can run the ...
- 153
0
votes
1
answer
489
views
Methods for right-sizing SQL Server virtualization?
I am starting to plan a migration of SQL Server 2008 R2 Enterprise Ed. to 2017 (edition TBD). One of the more important tasks assigned to me is to determine the specs for the new VMWare hardware my ...
- 841
22
votes
3
answers
10k
views
SQL Server Distributed Availability Group databases not syncing after a server reboot
We're getting ready to perform a large upgrade on our SQL Servers and are noticing some unusual behavior with Distributed Availability Groups that I'm trying to resolve before moving forward.
Last ...
- 9,716