Seal Report Forum
»
Troubleshooting
»
Bug Reports
»
Error when executing report : login failed for user xxx
Rank: Advanced Member
Groups: Registered
Joined: 9/13/2018(UTC) Posts: 41  Location: Ottignies Was thanked: 2 time(s) in 2 post(s)
|
Hello,
I have created a new report, based on a new connection to a SQL Server DB.
As I had already another connection woring of that kind, I just duplicated the ODBC connection, the Seal Manager connection...
When executing the report in the designer, it works fine, I got my result.
But when running from the web, I get the error : Login failed for user : xxx. and the user mentioned there is not the one specified in the Seal Connection, not even in the ODBC...
Any clue?
Thanks!
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
From the Web, the execution context is different, the default Web Publication uses an Application Pool with the user 'System',
thus this local user will be used to connect to the databases.
if you are using Integrated Security, consider to create and a dedicated database user, and then use it in the connection definition.
|
|
|
|
|
|
Seal Report Forum
»
Troubleshooting
»
Bug Reports
»
Error when executing report : login failed for user xxx
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
