I want to configure Reporting Server security model using DBMS access. For this I know that I shoud configure a DBMS adapter configuration using sql password passthru.

But I get login failed error message, alhoug i have login ids in the database as my computer login accounts.

Is anyone experienced about like that configuration,

This message has been edited. Last edited by: Kerry,

In SQL Server you also need to set the security so it does SQL server first then windows.

quote:

you

I have configured my sQL server on Mixed Mode Security. Both SQL server and Windows Authentication.

Next I have created Windows SQL login id in SQL server. these ones are also defined as local Windows user. But still I get Login Failed message.

I have looged in the server as local system account which has also been defined in SQL server Login id. But no change..

Any comments or suggestions about this issue? If you also have any step by step document, it will be useful for me,

Thanks,

Hi aakgun,

Has this issue been resolved? If this is related to configurations, your best channel for assistance would be to open a case with Customer Support Services. The phone number is 1-800-736-6130, or you can access online at InfoResponse.

Cheers,

Kerry