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



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

Rank: Advanced Member

Groups: Registered
Joined: 9/13/2018(UTC)
Posts: 41
Location: Ottignies

Was thanked: 2 time(s) in 2 post(s)

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?
#2 Posted : Wednesday, April 29, 2020 7:31:37 AM(UTC)

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,208

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