Page 1 of 1

MSSQL Named Instance

Posted: 21 Oct 2009, 22:54
by 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?

Re: MSSQL Named Instance

Posted: 24 Oct 2009, 07:49
by vboctor
Did you try using "server\instance"?

Re: MSSQL Named Instance

Posted: 11 Nov 2009, 11:52
by 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