Step 5 Database Setup
|
dc02476
Joined: 2008-08-03
Posts: 1 |
Posted: Sun, 2008-08-03 09:35
|
|
I have installed SQL Express and created the database gallery2. I keep getting this message. Host=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=HP2007\SQLEXPRESS;DATABASE=gallery2;UID=g2user;PWD=password I am using the following: DB Hostname: HP2007\SQLEXPRESS Any Ideas |
|
Posts: 1
Hi,
I have exactly the same problem but with SQL 2008 (not express) on a Win2008 64bit (IIS7) box. Up to step 5 of a new install of version 2.3 everything runs fine.
Suggestions to solution more than welcome. Missing driver?
Host=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=.;DATABASE=nnn;UID=nnn;PWD=nnn
version=6.0
PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=.;DATABASE=nnn: No connection established
Cheers,
Johan
Posts: 16503
Sorry no clue for that setup other than sending you to these:
http://codex.gallery2.org/Gallery2:Installation_on_Windows_Server_2003_and_IIS6 (mysql is written about on that page)
http://codex.gallery2.org/Gallery2:MSSQL
And this (not linked to from anything because it was never finished)
http://codex.gallery2.org/Gallery2:Installation_on_IIS7_and_Microsoft_SQL_Server
Make sure that php is setup to connect to MSSQL. Good luck. Just an FYI, G3 (edit: that's the next version of gallery) does not support running on Windows environments.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 1
Make sure the SQL server has both Windows and SQL authentication enabled. I only had it on windows authentication, once i changed it and restarted it worked.