This post is part of our weekly series about installing and running the latest version of Microsoft SQL Database Server.
If you have an older version of SQL Server and need to update, we’ve listed the steps below.
Note that this article covers the latest update for SQL Server, version 17.0.
In general, the most important thing you can do is to make sure that your database has been updated to the latest one, and that the operating system you’re using supports it.
Here’s how.
First, ensure that the database has already been updated.
In Windows Server 2016, the latest database update is available here.
On your server, right-click on the database, select Properties, and then select the Security tab.
Select the Security category, and click Update Database.
Select Microsoft SQL 2017 Update (KB3176873) to run the update.
This will install the update on your server.
If your database is not already updated, go to Start > All Programs, click on the All Programs icon, and choose the SQL Server Maintenance Center icon to open a dialog box.
Choose OK, and the update will install.
In some cases, you may need to manually update your database.
If this is the case, the next step is to manually install the latest SQL Server update on the server.
On the server, open a command prompt window, and type the following command: msconfig /flushdns If this command does not work, you can also try using the command: getcwd /flushdb /unregisterdns In this example, we’ll use the /unregistersdns option to remove the domain registrar and domain controller from the registry.
To remove the registry entries, use the following syntax: getpwuid /delete /deletedomain This command will delete the registry entry, and delete the server’s DNS records.
To re-register the domain controller, use this command: setpw_domain_registry_name /register_registrar This command deletes the registry value, and registers the domain registry.
If the server has previously registered its DNS server, you must remove it before starting the installation.
In this case, you’ll need to re-registrate the server with the registry key.
For more information, see Get more information about Microsoft SQL and the Windows PowerShell cmdlets that manage database services.
After you’ve installed the SQL server update, you should be able to log in with your old credentials.
To check that the SQL installation was successful, use a list of servers that you are currently running as a query in the System Events section of the Start menu.
If there are any problems with the SQL deployment, you might want to reevaluate the SQL servers and re-run the SQL install.
For a more detailed description of the installation process, see the Microsoft documentation on SQL Server.