News:

We really need your input in this questionnaire

Main Menu

MSSQL Database setup fails

Started by rwtedv, February 06, 2013, 10:39:04 AM

Previous topic - Next topic

rwtedv

Hi,
during installation of 1.2.5x64 on Windows Server 2008 R2 SP1 (german!) with local MS SQLExpress 2008 x64 SP1 (english) the server configuration wizard fails creating a new database.
Error:
Unable to connect to database: [Microsoft][SQL Server Native Client 10.0][SQL Server]
Login failed for user "sa".

I tried also to use windows authentication but I receive the same error "Login failed for user '<mydomain>\Administrator'." I even tried the german version of SQLExpress, but the same error.
Client protocols "Shared Memory", "TCP/IP" and "Named Pipes" are enabled.
Eventlog does not show any Errors or Warnings.

Login to SQL Server Management Studio works fine with both credentials!

Any solutions or ideas?

Thanks for all hints,
Thomas

Victor Kirhenshtein

Hi!

I'll try to reproduce it today. As a workaround, you may try to use odbc.ddr instead of mssql.ddr, but in that case you'll have to create database and db user manually.

Best regards,
Victor