Can't connect to MS SQL Server

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
Fish in a Barrel
Posts: 1
Joined: 10 Jan 2008, 21:16

Can't connect to MS SQL Server

Post by Fish in a Barrel »

I'm attempting to install Mantis 1.1.0 for the first time on a machine with MS SQL Server. I can't get it to connect to SQL Server.

I've been entering the following into the install.php page:
Type of database= Microsoft SQL Server (Experimental)
Hostname= localhost:1433 (I've also tried 127.0.0.1, the actual IP and the machine name, then all of the above without the port number)
Username (for Database)= [my user name]
Password (for Database)= [my password]
Database name (for Database)= mantis
Admin Username (to create Database)= [my user name]
Admin Password (to create Database)= [my password]

When I submit the form I get this for "Attempting to connect to database as admin":
"BAD Does administrative user have access to the database? ( )"

I can connect to this database using SQL authentication from the local machine and a remote machine. What gives?
Kirill
Posts: 638
Joined: 25 Nov 2007, 08:05
Location: Kaliningrad, RF
Contact:

Re: Can't connect to MS SQL Server

Post by Kirill »

may be must set db owner for this user for this db?
vboctor
Site Admin
Posts: 1293
Joined: 13 Feb 2005, 22:11
Location: Redmond, Washington
Contact:

Re: Can't connect to MS SQL Server

Post by vboctor »

You are probably missing the MS SQL instance name. I can't remember the exact format for specifying it. You may want to get in touch with paulr / grangeway on the IRC channel (#mantishelp at irc.freenode.net)
Migrate your MantisBT to the MantisHub Cloud
Post Reply