Click to download this Excel file now. To learn what a specific version number of SQL Server maps to, or to find the KB article information for a specific cumulative update package or a service pack, search for the version number in the SQL Server Complete Version list tables.
Each of the following links provides information for all of the applicable products and technologies. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.
Method 2: Look at the first few lines of the Errorlog file for that instance. The entries may resemble the following:. This entry provides all the necessary information about the product, such as version, product level, bit versus bit, the edition of SQL Server, and the OS version on which SQL Server is running.
The output of this query has been enhanced to show additional information, as documented in the blog post article, What build of SQL Server are you using? The output of this query has been enhanced to show additional information. This tool gives information about all the instances of SQL Server that are installed on the system.
The only thing to be aware of is that this tool can be run locally only on the system where SQL server is installed. It cannot be used to obtain information about remote servers.
To determine which versions of the client tools are installed on your system, start Management Studio, and then click About on the Help menu. See the following screenshot.
The version is also displayed in the Reporting Services Configuration tool. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of Analysis Services.
Method 2: Check the version of the Msmdsrv. The default locations are shown in the following table. For more information about verifying Analysis Services build versions review Verify Analysis Services cumulative update build version. Because replication agents may be installed on several different computers, it is important to check the installed versions on all affected computers. For example, the Distribution Agent in Transactional or Peer-to-Peer replication may exist on computers that differ from the publisher instance of SQL Server and may exist on the various subscriber instances of SQL Server in a pull subscription.
Therefore, you have replication agent files that are installed on the IIS web server. And you may have to check the version of those. For more information, see Upgrade or patch replicated databases. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.
Related Hot Network Questions. Office Office Exchange Server. Not an IT pro? Script Center. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. SQL Server Setup. The system configuration check report contains a short description for each executed rule, and the execution status.
Install SQL Server Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback?
0コメント