Hello
I have a report server running on a win2003 sp1 domain controller. The
reportServer database is sql2005 sp2 also running on the domain controller.
Now I´m trying to configure a report. The reports datasource is a SqlServer
2000 database also running on the domain controller
The connection string is "Data Source=localhost;Initial Catalog=MyDataDB"
If I try to run the report I´ve got a login error (rsLogonFailed)
Logon failure: the user has not been granted the requested logon type at
this computer. (Exception from HRESULT: 0x80070569)
I think it isn´t the connection to the sql2000 database because I have tried
to prompt the user to type credentials. The same error
Any ideas?
regards
BjörnFound it.
Had to allow the user to login local
Björn
"Berger" <prodevteam@.gmx.net> schrieb im Newsbeitrag
news:OzxacToCIHA.4472@.TK2MSFTNGP05.phx.gbl...
> Hello
> I have a report server running on a win2003 sp1 domain controller. The
> reportServer database is sql2005 sp2 also running on the domain
> controller.
> Now I´m trying to configure a report. The reports datasource is a
> SqlServer 2000 database also running on the domain controller
> The connection string is "Data Source=localhost;Initial Catalog=MyDataDB"
> If I try to run the report I´ve got a login error (rsLogonFailed)
> Logon failure: the user has not been granted the requested logon type at
> this computer. (Exception from HRESULT: 0x80070569)
> I think it isn´t the connection to the sql2000 database because I have
> tried to prompt the user to type credentials. The same error
> Any ideas?
> regards
> Björn
>
|
No comments:
Post a Comment