Database (MSSQL Express 2005) setup failed

jojo1234

Joined: 2008-06-10
Posts: 1
Posted: Tue, 2008-06-10 12:41

Hi @all,

by the installation i get the following error:

Server: Windows Server 2003 with MSSQL Express 2005 installed on the server.

First i create a sql file and extract the file on the cmd

mssql.sql
#################################################################
>sqlcmd -S ********\SQLEXPRESS -e -i mssql.sql
create database gallery
use gallery
Der Datenbankkontext wurde auf 'gallery' geändert.
create schema g2user
create login g2user with password = "*******"
create user g2user for login g2user with default_schema = g2user
grant ALTER, INSERT, UPDATE, SELECT, DELETE to g2user
#################################################################

there is no error

After them i´ll get an error on the webinstalltion in step 5 like this:

#################################################################
Database Setup
Please select your database type and enter your database authentication information. The installer will not create the database for you, so you must create one yourself and enter the database name here. If you are installing Gallery into a database that already has tables in it, the table and column prefixes will keep Gallery data from conflicting with what you already have.

Database type: MySQL (v3.23.34a and newer) MySQL (versions before v3.23.34a) PostgreSQL v7.x and newer Oracle (9i and newer) IBM DB2 (v9.x and newer) Microsoft SQL Server 2005 and newer
DB Hostname: *******\SQLEXPRESS
DB Username: g2user
DB Password: *******
DB Name: gallery
Table Prefix: g2_
Column Prefix: g_

We received the following database related errors:
Host=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=********\SQLEXPRESS;DATABASE=gallery;UID=g2user;PWD=*******
version=2.8
PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=********\SQLEXPRESS;DATABASE=gallery: No connection established
#################################################################

What is wrong ? What can i do? Where ist the error?

Please help me and post the Messages here or to my mailadress!

Thanks
jojo1234

 
cw823

Joined: 2009-09-01
Posts: 1
Posted: Sun, 2009-10-18 18:13

I had this same problem, I noticed when I tried to create an ODBC connection to the gallery2 database SQL was only setup for windows authentication. I had to change to SQL AND Windows authentication and then was able to create the ODBC, and was able to get past step 5