SQL Server 2025 Now Available on Every ASP.NET Hosting Plan

SQL Server 2025 is now available on every Adaptive Web Hosting plan — right alongside SQL Server 2022. You choose the version each time you create a database in Plesk, so you can start new projects on SQL Server 2025 while your existing SQL Server 2022 databases keep running exactly as they are. Same plans, same price, same database allowance.

Every planDeveloper · Business · Pro

Per databaseYou pick the version in Plesk

Level 170Compatibility level for new databases

In Plesk, go to Databases → Add Database and choose MSSQLSERVER2025 as the database server. Connect to it at sql2025-001.adaptivewebhosting.com. Your plan's SQL Server database count (2, 5 or 10) covers both versions, and SQL Server 2022 stays fully supported.

What's new in SQL Server 2025 that you can use today

We tested each of these on our SQL Server 2025 servers before writing this post:

Native json data type — store JSON in a real JSON column instead of nvarchar(max), plus the new JSON_OBJECTAGG and JSON_ARRAYAGG aggregates.

vector data type and VECTOR_DISTANCE — keep AI embeddings next to your relational data and run similarity search in plain T-SQL. EF Core 10 maps to the new json and vector types.

Regular expressions — REGEXP_LIKE, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_COUNT, REGEXP_INSTR and REGEXP_SPLIT_TO_TABLE.

Quality-of-life T-SQL — the || string concatenation operator, CURRENT_DATE, UNISTR, BASE64_ENCODE / BASE64_DECODE, and the PRODUCT() aggregate.

-- Native json column

CREATE TABLE dbo.Orders (Id int PRIMARY KEY, Details json NOT NULL);

SELECT Id, JSON_VALUE(Details, '$.customer.email') AS Email FROM dbo.Orders;

-- Similarity search over embeddings

DECLARE @q vector(3) = '[0.12, 0.80, 0.33]';

SELECT TOP (5) Id, VECTOR_DISTANCE('cosine', Embedding, @q) AS Distance

FROM dbo.Documents

ORDER BY Distance;

-- Regular expressions

SELECT Email FROM dbo.Customers

WHERE REGEXP_LIKE(Email, '^[^@]+@[^@]+\.[a-z]{2,} );

-- String concatenation and CURRENT_DATE

SELECT 'Order ' || CAST(Id AS varchar(10)) || ' shipped on ' || CAST(CURRENT_DATE AS varchar(10))

FROM dbo.Orders;

Some of the new functions — for example REGEXP_LIKE and REGEXP_SPLIT_TO_TABLE — need database compatibility level 170. New SQL Server 2025 databases are created at level 170. A database you move over from an older version keeps its previous level; open a support ticket if you'd like it raised.

Getting started

In Plesk, open Websites & Domains → Databases → Add Database.

Choose MSSQLSERVER2025 in the Database server list, name the database and create a database user.

Connect from your app, SSMS (version 21 or later) or Visual Studio with SQL Server Authentication:

{

"ConnectionStrings": {

"DefaultConnection": "Server=sql2025-001.adaptivewebhosting.com;Database=YOUR_DATABASE;User Id=YOUR_DB_USER;Password=YOUR_PASSWORD;Encrypt=True;TrustServerCertificate=True;"

}

}

Plesk shows the server as .\MSSQLSERVER2025, which only works on the server itself — always use sql2025-001.adaptivewebhosting.com from your application and tools. Database users belong to the server they were created on, so a user created on SQL Server 2025 won't sign in to SQL Server 2022 (and the other way round).

SQL Server 2025 or SQL Server 2022?

Choose SQL Server 2025 for new projects, and whenever you want the new JSON, vector or regular expression features.

Stay on SQL Server 2022 if your app is happy where it is — it remains fully supported, and there's no need to move. Keep databases that use full-text search (CONTAINS / FREETEXT) on SQL Server 2022.

Moving an existing database to SQL Server 2025

Create a new database on MSSQLSERVER2025, then import your .bak file with Import Dump in Plesk and point your connection string at sql2025-001.adaptivewebhosting.com. One thing to know before you switch: SQL Server backups only restore to the same or a newer version, so a database backed up from SQL Server 2025 can't go back to SQL Server 2022. Keep your original database until you've tested your app on SQL Server 2025.

The full step-by-step guide — server details, SSMS settings, connection strings and troubleshooting — is in our knowledge base: SQL Server 2025 Databases: Creating, Connecting and New Features.

Not hosting with us yet? Every ASP.NET hosting plan includes SQL Server 2025 and SQL Server 2022 databases, dedicated IIS application pools, FREE SSL and a 30-day money-back guarantee.

Back to Blog