Gossamer Forum
Home : Products : Gossamer Links : Discussions :

MSSQL Express 2005 Install

Quote Reply
MSSQL Express 2005 Install
I'm installing Gossamer Links for a client on a Win2003 dedicated server. I have gotten to the Gossamer Links Setup - SQL Information step.

Up to this point I have install MSSQL Express 2005 under default instance, not SQLEXPRESS instance, enabled sql authentication mode, enable named pipes and TCP/IP access protocols.

I'm rather new to PERL, I have run the following commands from the command prompt, based on the initial error messages:

ppm install DBD::ODBC
ppm install DBI

Now I am getting the following error message:

Error: Could not connect to database: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002)(DBD: db_login/SQLConnect err=-1)

First question, will MSSQL Express 2005 work or do I need to use MSDE 2000?

Is there another command I need to run under PERL to specify a default driver?

I am currently using:

DBD::ODBC 1.13
DBI 1.48

I have tried using localhost,, public IP, and box name in the SQL Hostname field.

Any help would greatly be appreciated.
Quote Reply
Re: [madasczik] MSSQL Express 2005 Install In reply to
I found the issue, I didn't setup a DSN.

Goto Start -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC)
System DSN tab > Add