MSSQL Database setup fails
-
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 -
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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login