Connecting to separate instance of DB on different port

(0) Share

Report

Posted on by BarbaraF

147

Hello,

I am wondering how to connect to a separate instance of a database running on the same server but on a different port. While I can go to the solomon.ini file and change the database, using a comma (for the port) will be read as a separate server. Similarly, using the \ isn't handled correctly. Essentially, I've setup two instances of SQL Server on a server (a test and a dev). For a variety of reasons, I cannot setup another server for one of them but have to use the same server with separate instances (and preferably on a non-standard port). I can connect to the base one from dynamics, but not the other. Thanks.

All responses (1)

Answers (0)

Suggested answer

Erich Strelow F 16 on at

Like (1)

Report

RE: Connecting to separate instance of DB on different port

I don't think there is a way to set the port on SL level.

But, you could setup different SQL server alias for test and dev. Check https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/create-or-delete-a-server-alias-for-use-by-a-client?view=sql-server-ver15

Dynamics SL is pretty much hard wired to SQL Server, so there's no "Connection String" concept whatsoever. The SQL Server Alias gizmo sort of fills the gap to allow certain flexibility. Since it works at client level, you must define the alias in all the users endpoints. Use with care, since this is the kind of settings that mess up future network diagnostics.