GV FAE Knowledge

Question:
What is the difference between SQL Server Developer Edition and Express Edition to configure the VMS SQL database?

Answer:
You will run into issues with SQL Server Express Edition while attempting to switch the default database in the VMS to a SQL database. In the SQL Server Configuration Manager option, default SQL Server Port TCP port (1433) is not preset for SQL Server Express Edition, but it is to provide SQL Server Developer Edition.

As a result, there was a connection problem with the SQL Server Express Edition during the configuration of the SQL database in the VMS. A connection was established without any problems if the default SQL TCP port (1433) was specifically selected in the SQL Server Configuration Manager option.

In the Server Configuration Manager option, have a look at the differences between SQL Server Express Edition and SQL Server Developer Edition in the list below.

• SQL Server Express Edition

By default, the TCP Port field is empty, so you need to type default SQL Server TCP port (1433) manually.

• SQL Server Developer Edition

By default SQL Server TCP port preset (1433)