Windows 10: Inplace upgrade of Server OS on a SQL 2012 Database server

Discus and support Inplace upgrade of Server OS on a SQL 2012 Database server in Windows 10 Gaming to solve the problem; We have an SQL database server version 2012 which is running on server OS 2012 R2. We want to upgrade the Server OS to 2019 and later upgrade SQL to... Discussion in 'Windows 10 Gaming' started by AjayrajNair, Jan 5, 2022.

  1. Inplace upgrade of Server OS on a SQL 2012 Database server


    We have an SQL database server version 2012 which is running on server OS 2012 R2. We want to upgrade the Server OS to 2019 and later upgrade SQL to version 2016.Wanted to know whether it was safe to do an inplace upgrade of the server OS 2012R2 to Server OS 2019. Is this safe considering that the SQL application is running on it? or is the best option be to install a separate new server with Server OS 2019 and then backup and restore the SQL catalogues to the new server.

    :)
     
    AjayrajNair, Jan 5, 2022
    #1

  2. Downgrade of SQL Server 2017 to SQL Server 2012

    Hi,

    Please suggest me how can i get the licence for SQL Server 2012.

    Currently we have SQL Server 2017 Volume licencing.

    Regards,

    Praveen.
     
    PraveenkumarOPP, Jan 5, 2022
    #2
  3. JohnDahl1 Win User
    KB4284815 for Windows Server 2012 causes SQL Server problem and Remote Desktop access problem

    After installing KB4284815 the June cumulative rollup update on my Microsoft Server 2012 R2, SQL Server 2012 Express hosted on this server, has no communication to applications which use database tables. The database was not accessible from any domain connected
    workstations and their applications.

    The error message was [DBNETLIB] ConnectionOpen [Connect()] SQL Server does not exist or access denied. This error can be demonstrated using a UDL

    file (just create a text file, rename it to a UDL extension). Open it. On the Provider tab choose your usual SQL provider (I am using Microsoft OLE DB Provider for SQL Server) and on the Connection tab, try to navigate to your server and database instance.
    (I am using Windows NT integrated security). You will get the error when you click the Test Connection

    It was accessible using SQL Server Management Studio, if logged in on the Server 2012 desktop. Also broken was Remote Desktop access to the Server 2012 from a VPN client.

    Uninstalling the KB and rebooting the server restored users ability to use our applications that connect to the SQL databases.
     
    JohnDahl1, Jan 5, 2022
    #3
  4. Inplace upgrade of Server OS on a SQL 2012 Database server

    Upgraded to Windows 10 and now SQL Server 2012 cannot connect to the server

    Hi,

    I upgraded to windows 10 but now have issues with SQL Server Mangement Studio 2012.

    When it opens it has the Server type as database engine then the server name xxxx\SQLEXPRESS and the authenication as windows authentication, where xxxx is the name of my laptop.

    I click connect then get the message below,

    Cannot connect to xxxx\SQLEXPRESS

    Additional information:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.

    I have looked on the net for answers but nothing has helped. I have checked the Sql Service Browser is running. So don't know what to do next??
     
    MarkSawyerYI, Jan 5, 2022
    #4
Thema:

Inplace upgrade of Server OS on a SQL 2012 Database server

Loading...
  1. Inplace upgrade of Server OS on a SQL 2012 Database server - Similar Threads - Inplace upgrade Server

  2. Transferring of Windows Server 2012, SQL Server 2012 and Sharepoint Servers 2013 license...

    in Windows 10 Gaming
    Transferring of Windows Server 2012, SQL Server 2012 and Sharepoint Servers 2013 license...: Are the license key of Windows Server 2012, SQL Server 2012 and Sharepoint Servers 2013 transferable/reusable on a new device? https://answers.microsoft.com/en-us/windows/forum/all/transferring-of-windows-server-2012-sql-server/db4c414d-199c-4b7a-a676-6657bc226fca
  3. Transferring of Windows Server 2012, SQL Server 2012 and Sharepoint Servers 2013 license...

    in Windows 10 Software and Apps
    Transferring of Windows Server 2012, SQL Server 2012 and Sharepoint Servers 2013 license...: Are the license key of Windows Server 2012, SQL Server 2012 and Sharepoint Servers 2013 transferable/reusable on a new device? https://answers.microsoft.com/en-us/windows/forum/all/transferring-of-windows-server-2012-sql-server/db4c414d-199c-4b7a-a676-6657bc226fca
  4. Transferring of Windows Server 2012, SQL Server 2012 and Sharepoint Servers 2013 license...

    in Windows 10 Updates and Activation
    Transferring of Windows Server 2012, SQL Server 2012 and Sharepoint Servers 2013 license...: Are the license key of Windows Server 2012, SQL Server 2012 and Sharepoint Servers 2013 transferable/reusable on a new device? https://answers.microsoft.com/en-us/windows/forum/all/transferring-of-windows-server-2012-sql-server/db4c414d-199c-4b7a-a676-6657bc226fca
  5. SQL Server 2012 Collation Error

    in Windows 10 Software and Apps
    SQL Server 2012 Collation Error: The query:USE vPICList_lite;SELECT *FROM ABS runs correctly in SQL Server 2012The query:[dbo].[spVinDecode] @v = N'3VWRF81H2WM128705'returns:Msg 468, Level 16, State 9, Procedure spVinDecode, Line 282Cannot resolve the collation conflict between "Latin1_General_CI_AS" and...
  6. SQL Server Database Connectivity Issues

    in Windows 10 Gaming
    SQL Server Database Connectivity Issues: Not sure if this is the appropriate place to ask, but I currently use MS SQL Server Management Studio v18.10 for work. Whenever I'm on WiFi, I have no issues connecting to SQL Server databases, but as soon as I plug in my ethernet cable, I can't connect and I get timeout...
  7. SQL Server Database Connectivity Issues

    in Windows 10 Software and Apps
    SQL Server Database Connectivity Issues: Not sure if this is the appropriate place to ask, but I currently use MS SQL Server Management Studio v18.10 for work. Whenever I'm on WiFi, I have no issues connecting to SQL Server databases, but as soon as I plug in my ethernet cable, I can't connect and I get timeout...
  8. SQL Server Database Connectivity Issues

    in Windows 10 Customization
    SQL Server Database Connectivity Issues: Not sure if this is the appropriate place to ask, but I currently use MS SQL Server Management Studio v18.10 for work. Whenever I'm on WiFi, I have no issues connecting to SQL Server databases, but as soon as I plug in my ethernet cable, I can't connect and I get timeout...
  9. Inplace upgrade of Server OS on a SQL 2012 Database server

    in Windows 10 Software and Apps
    Inplace upgrade of Server OS on a SQL 2012 Database server: We have an SQL database server version 2012 which is running on server OS 2012 R2. We want to upgrade the Server OS to 2019 and later upgrade SQL to version 2016.Wanted to know whether it was safe to do an inplace upgrade of the server OS 2012R2 to Server OS 2019. Is this...
  10. Inplace upgrade windows 2012 Server r2 to windows 2016 server Probelm

    in Windows 10 Installation and Upgrade
    Inplace upgrade windows 2012 Server r2 to windows 2016 server Probelm: Hi anyone,I have this problem encounter doing inplace upgrade, i cannot proceed https://answers.microsoft.com/en-us/windows/forum/all/inplace-upgrade-windows-2012-server-r2-to-windows/cf0ee70a-3420-4cf1-a2b2-353a06e334eb