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

Notification

Icon
Error

Trouble Connecting to SQL Server
debywilliams
#1 Posted : Monday, October 10, 2016 3:19:26 AM(UTC)
Groups: Member
Joined: 5/26/2015(UTC)
Posts: 3
Location: united states

Hi

I\'ve been through the set up guide for SQL Server connections but my SQL Server is reporting the following errors continuously and Logic Monitor is retrieving no data.

01/10/2012 15:52:24,Logon,Unknown,Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 194.83.78.12]

01/10/2012 15:52:24,Logon,Unknown,Error: 18452, Severity: 14, State: 1.

01/10/2012 15:52:24,Logon,Unknown,SSPI handshake failed with error code 0x80090308, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. [CLIENT: 194.83.78.12].

01/10/2012 15:52:24,Logon,Unknown,Error: 17806, Severity: 20, State: 14.


The user accounts are all able to connect directly to the SQL Server instances. I use account in ASPHostPortal.com

Can you point me in the right direction please?

Thanks
Ultidev Team
#2 Posted : Monday, October 10, 2016 9:49:02 AM(UTC)
Ultidev Team

Groups: Administration
Joined: 11/3/2005(UTC)
Posts: 2,253

Thanks: 28 times
Was thanked: 60 time(s) in 59 post(s)
Hi,

ASP.NET security is truly confusing. If your application is running with impersonation under UWS, and trying to connect to SQL Server using integrated authentication, then it hits SQL Server with machine's (instead of domain) user identity, likely either "NETWORK SERVICE" or "LOCAL SYSTEM" user. To make ASP.NET security and authetication somewhat simpler, we've put together a page accessible at http://localhost:7756/ on systems where UWS is installed.

Best regards,
UltiDev Team.
Please donate at http://www.ultidev.com/products/Donate.aspx to help us improve our products.
Guest
#3 Posted : Thursday, December 8, 2016 10:59:16 PM(UTC)
Groups:

Message was deleted by a Moderator.
Rss Feed  Atom Feed
Users browsing this topic
Guest
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 can vote in polls in this forum.