Unable to Install on MS SQL 2005 Express - no Connection established
|
Jason_Fell
Joined: 2009-08-25
Posts: 17 |
Posted: Tue, 2009-08-25 14:32
|
|
Hi All, I am having great difficulties installing this on MS SQL 2005 Express, I am receiving this error: Host=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=localhost;DATABASE=gallery2;UID=root;PWD=P4ssword I ahve ran through all the alternative configurations for SQL Express to allow remote connections, no joy have tried to re-install the entire app aagin, no joy. what do i do next?? I wanted to install this on express as I am currently running Sharepoint locally. Can any body help me with this? please be gentle i am new to this product, and would dearly like to get this running as soon as poss!! cheers Jason |
|
Posts: 17
here is some more information:
URL - http://<website>/
Gallery version - Latest downloaded via preinstall.php (25 Auguist 2009)
version of PHP - v5.2.10
version of IIS - v6.0
your operating system and hardware - Windows Server 2003 Standard, Blade BL460c, 2 x Xeon Quad, 4Gb
SQL type and version - MS SQL Express 2005
the error above appears when trying to setup the DB in Step 5
Posts: 16503
Don't know MSSQL, can only point you to these docs:
http://codex.gallery2.org/Gallery2:MSSQL
I'd also hit google and check to make sure you have PHP configured to load the MSSQL stuff:
http://www.google.com/search?q=php+mssql
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 17
thansk for that, although i have done exactly that earlier, I was hoping someone had actually installed and have it running!
since writing this request for help, I have found that MS SQL does seem to be tricky when configuring.
so i went off and downloaded MySQL, well got it installed, and allseemed to go well, until i wanted to click on any of the links on the page, well the error that appears is the following;
"An error has occurred while interacting with the database."
now after restarting the entire server, I now cannot access anything on the website..
what is happening!!!
why is it so difficult to install!!
Posts: 16503
Sounds like you may have something conflicting. I'm pretty sure that MSSQL and MySQL don't run on the same port so that shouldn't be a problem.
I would suggest, http://www.apachefriends.org/en/xampp.html but that's not going to run SharePoint
First thing I would do is make sure that MySQL is not running and that MSSQL is running, are you able to access your site. Take a look at your Event Viewer (compmgmt.msc) on the server to see what is or isn't starting, error messages, etc. I'd also take a look at your services (services.msc) and make sure that the appropriate services for your servers are running.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 17
thanks for your help on this, but it seem that i cannot get it working with MS SQL, this is a shame as I will have to have another platform to administer along with all the rest.
I will try and build this on a new server, so i am hopeful that these problems disappear!