I've created local users on Server Console - Admin rights - but can't log in with them. How to fix/debug?
Hello,
What type of users have you created? Are they Domain Users or Custom Users?
Do you receive an error message on the webpage? If yes, could you post a screenshot.
Best regards,
Jeff Dagenais
custom - says invalid user or password.
I created in Server Console.
in win event vwr - seeing Login failed for user 'NT AUTHORITY\LOCAL SERVICE'. Reason: Failed to open the explicitly specified database 'DVLS'. [CLIENT: <local machine>]
Log Name: Application
Source: MSSQL$SQLEXPRESS
Date: 5/25/2018 9:51:10 AM
Event ID: 18456
Task Category: Logon
Level: Information
Keywords: Classic,Audit Failure
User: LOCAL SERVICE
Computer: BUD-SEC.budman.beer
Description:
Login failed for user 'NT AUTHORITY\LOCAL SERVICE'. Reason: Failed to open the explicitly specified database 'DVLS'. [CLIENT: <local machine>]
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$SQLEXPRESS" />
<EventID Qualifiers="49152">18456</EventID>
<Level>0</Level>
<Task>4</Task>
<Keywords>0x90000000000000</Keywords>
<TimeCreated SystemTime="2018-05-25T14:51:10.000000000Z" />
<EventRecordID>2361</EventRecordID>
<Channel>Application</Channel>
<Computer>BUD-SEC.budman.beer</Computer>
<Security UserID="S-1-5-19" />
</System>
<EventData>
<Data>NT AUTHORITY\LOCAL SERVICE</Data>
<Data> Reason: Failed to open the explicitly specified database 'DVLS'.</Data>
<Data> [CLIENT: <local machine>]</Data>
<Binary>184800000E000000130000004200550044002D005300450043005C00530051004C0045005800500052004500530053000000070000006D00610073007400650072000000</Binary>
</EventData>
</Event>
Do I have to give this server computer access to DB?
I enabled win authentication too - same error message
Hello,
I have already ask you about the DVLS Diagnostic report on the other forum thread. I will wait for it.
(https://forum.devolutions.net/topic29817-new-install--how-to-enable-domain-authentication-after-install.aspx)
Which authentication method did you use to connect on the database in the Database tab of the DVLS settings?
Is it using a SQL account (green) or by enabling the Integrated Security option (blue)?
Best regards,
Érica Poirier
integrated
Using RDMOwner which is domain acct
@everyone,
This issue has been resolved. Please consult the following post for further information.
https://forum.devolutions.net/topic29817-new-install--how-to-enable-domain-authentication-after-install.aspx?lastpage=1#post116776
Best regards,
Érica Poirier