logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
CPBOURG  
#1 Posted : Thursday, February 20, 2020 3:37:48 PM(UTC)
CPBOURG

Rank: Advanced Member

Groups: Registered
Joined: 9/13/2018(UTC)
Posts: 41
Belgium
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!
epf  
#2 Posted : Wednesday, April 29, 2020 7:31:37 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 902
Switzerland

Thanks: 14 times
Was thanked: 150 time(s) in 144 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.

Users browsing this topic
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.