MSSQL Named Instance

[afeatherstone]

apologies...i could not find anything on this topic. Is it possible to connect to a named instance on MSSQL 2005? I have a working Mantis installation on the SQL server root, so I know that I can connect and create database objects on by SQL server...but I need to connect to a specific instance and cannot figure out the correct syntax or process. can anyone help?

[vboctor]

Did you try using "server\instance"?

[davide73y]

Use TCP/IP address to link Mantis to a MSSQL Database... Try to assign a new TCP port to your named instance and configure your host in this way

IPAddress:IPport

Example

192.168.1.1:1434 (instead of the usual 1433 for MSSQL)

Bye,
Davide