I can't create a connection to my SQL Server express 2008 database. I get a:

"Error using this database connection"

extension version: 1.1.1

name: csTest
server technology: asp
database type: SQL Server Express
version: SQL Server 2008 Express
Use database file: C:\Program Files\<path>\Data\
Database: test

In DW a standard connectionstring does work for my website through a:
ODBC 32bit - Microsoft SQL Server Native Client Version 10.50.4000

or

Provider=SQLNCLI10;Server=[name]\SQLExpress;Database=test;Trusted_Connection=Yes;

Still cannot make a database connection with SQL Server Express 2008 and this extension. I get this error.



Log file SQL server express:

Error: 17204, Severity: 16, State: 1.
FCB: Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA for file number 0. OS error: 5(Toegang geweigerd.).
Logon Error: 1832, Severity: 20, State: 1.
Logon Cannot attach the file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA' as database 'tst-dBase.mdf'. [CLIENT: 192.168.0.196]

well seems the database path is invalid, could you make sure it exist on your server?

-George

Hi George,

Folder DATA contains the tst-dBase.mdf file
Absolute path: C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\

When using Database Connection
database type: Custom
connectionstring: Provider=SQLNCLI10;Server=LAPTOP\SQLExpress;Database=tst-dBase.mdf;Trusted_Connection=Yes;

This works fine

Hello,
Still problem with database connection to SQL Server Express 2008

After update to version 1.3.0 also the custom connectionstring to a mssql server does not work anymore.

I tried everything to connect to an mssql server but none of them works. I have this extension for serveral months now and it doesn't work.