I can not connect to database with database account

Bita

Hi everybody
I specify sql account in enterprise manager with system administrator, database creator and security administrator roles permission on one database as db-owner and public, when in navision I try to connect to this database, this error message was going:
"The following sql server error(s) occurred:
18452,"28000",[Microsoft][ODBC Sql server Driver][SQL Server] Login failed for user 'username'. Reason: not associated with a trusted sql server connection. OK "

I connect with windows authentication with no problems,
Any help or Idea,

vmtaylor

Hi
I am getting the same problem.
You managed to sort it out?

DenSter

I think that's the error you get when your SQL Server is installed in Windows mode, and you are trying to open a database with a database login. Change the security of your SQL Server to allow mixed login and try again.

Bita

Thanks, you solved my problems. =D>

DenSter

Nah you solved it yourself by asking the question here, I just made a suggestion as to how to do it glad I could help.

rajpatelbca

Thanks Denster. i was having same problem but now i have solved this problem as per your instruction.

=D> =D> =D> =D> =D>

Regards,

DenSter

wow exactly 2 years after