Dear guys please could you help me regarding this issue I'm trying to solve it with weeks. An app that we use for printing management (Ysoft SafeQ) is unable to communicate please see logs below:
SQL Server Log:
03/16/2017 09:26:47,Logon,Unknown,Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10.0.101.202]
03/16/2017 09:26:47,Logon,Unknown,Error: 18452 Severity: 14 State: 1.
03/16/2017 09:26:47,Logon,Unknown,SSPI handshake failed with error code 0x8009030c 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. The logon attempt failed [CLIENT: 10.0.101.202]
03/16/2017 09:26:47,Logon,Unknown,Error: 17806 Severity: 20 State: 14.
This is a printer managment app that we are using on client side to manage printed pages. Yes we are in Windows environment that app is installed on (Windows Server 2012 R2)
is there a management console wherein you can specify username and password, or does it use currently logged in user to communicate with sql server? I assume this client app somehow communicates with SQL server?
Alright sir I will send all this to the client. Regarding to point 5 I'm unable to login remotely to that SQL server for reason that this is a Bank and they will not allow us for security reason you know how Banks are they always send us screen shot and SQL logs?
Hi yosiasz
Please see below answers from client side:
Is there a centralized management system portal to manage this print service – nuk pe kuptoj pytjen! (Client didn't understand the question) please could you be more clear!!!
Do each users have access to this client tool on their machine or select users only – each user
Is this "client tool" accessible via a browser or an actual client installed on each user's machine – web browser
Is this service installed on premise or is it a cloud service? – installed in premises
Dear Kdedoviq,
The error is self explanatory: you cannot use " Integrated Security=True " with that connection, you should use a valid SQL database username and password combination that has appropriate permissions for the specific database you are trying to access.
so try putting this:
Data Source=palm.MyHostingServicecom;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUserName;Password=MyUserPassword