SQL Server 2022 RTM (16.0.1000.6): Are R and Python external language catalog entries created by default?

Prasathkumar Murugan 5 Reputation points
2026-11-22T08:34:26.1333333+00:00
SQL Server Analysis Services
SQL Server Analysis Services

A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.


Answer accepted by question author

AI answer

2026-11-22T08:35:11.3933333+00:00

SQL Server 2022 RTM does not document R and Python as automatically created rows in sys.external_languages; verify the actual database because that view records database-scoped external-language registrations, while R and Python are reserved names handled through Machine Learning Services.

Run this in the database being examined:

SELECT
    DB_NAME() AS database_name,
    external_language_id,
    language,
    create_date,
    principal_id
FROM sys.external_languages
ORDER BY language;

sys.external_languages returns one row for each external language registered in the current database. Microsoft documents R and Python as reserved names for which an external language cannot be created under those exact names; it does not state that SQL Server 2022 seeds corresponding rows automatically.^1^

Therefore:

  • An empty result on a fresh database is not evidence of a failed R/Python installation.
  • Rows created for custom Language Extensions are database-scoped and can differ between databases.
  • Do not attempt CREATE EXTERNAL LANGUAGE [R] or [Python]; both names are reserved.^2^
  • Catalog rows and runtime availability are separate questions. Querying sys.external_languages alone does not establish whether built-in R/Python execution is configured.

SQL Server 2022 runtime behavior

Beginning with SQL Server 2022, SQL Setup no longer installs the R, Python, or Java runtimes. To use R or Python, install Machine Learning Services and Language, install the desired custom runtime and packages, register the runtime with the instance, enable external scripts, and restart the service.^3^

Check whether external-script execution is enabled with:

EXEC sys.sp_configure N'external scripts enabled';

A configured installation should report config_value = 1 and run_value = 1. Runtime functionality must then be tested directly—for example:

EXEC sys.sp_execute_external_script
    @language = N'Python',
    @script = N'import sys; print(sys.version)';

A successful call verifies Python execution; it does not depend on a user-created Python row in sys.external_languages.

In short, reserved names do not imply default catalog entries, and the available documentation does not establish that SQL Server 2022 RTM build 16.0.1000.6 creates such rows. The authoritative result for a particular installation is the per-database query above, while runtime support must be verified separately through Machine Learning Services.


References

  1. sys.external_languages (Transact-SQL)
  2. CREATE EXTERNAL LANGUAGE (Transact-SQL)
  3. Install SQL Server 2022 Machine Learning Services (Python and R) on Windows
AI-generated content may be incorrect. Read our transparency notes for more information.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Newest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.