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?
Can't connect to MS SQL Server
Moderators: Developer, Contributor
Re: Can't connect to MS SQL Server
may be must set db owner for this user for this db?
Re: Can't connect to MS SQL Server
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