Questions tagged [logon]
The logon tag has no usage guidance.
8
questions
0
votes
2answers
55 views
Lockdown database access on certain tables
I have a dev team who have a number of SQL databases used as a back end for mostly excel front end.
This originally came from an excel spreadsheet until it got made into SQL databases.
At first, they ...
9
votes
5answers
2k views
Linked Server connection started failing with "Cannot generate SSPI context ... SQL Server Network Interfaces: The logon attempt failed" error?
The Issue
I have two SQL Server 2016 Standard Edition servers on the same domain. ServerA has two linked server connections setup to ServerB.
The first linked server connection is using a dedicated ...
0
votes
3answers
192 views
Safe and secure implementation of logon trigger in SQL Server 2014 Express edition?
I've to implement the following requirement:
Access to SQL Server instance shall be allowed only from a C# application.
Users shall not be able to access any database (even those in which they have ...
0
votes
0answers
149 views
Logon Trigger IP Address Issue
I have this logon trigger to restrict IP addresses. It is the same trigger I have seen everywhere. However, it is not working as expected, and I was hoping someone could give some direction.
I am ...
0
votes
1answer
452 views
Logon failed for login due to trigger execution / LOGON TRIGGER
I have this situation.
I created a logon script to block any session for specific logins. These logins are in a table.
So the behaviour of my script is simple.
Get the login from the table, compare it ...
0
votes
1answer
346 views
failed logon trigger blocking access into SQL Server instance
I wanted to create a trigger to record all the names of logins(who logon into system) in ServerLogonRecords table(all the columns are nullable) using LOGON trigger. I get information using eventdata() ...
0
votes
1answer
145 views
Logon error to readonly db
getting error:
"The target database ('MyDB') is in an availability group and is currently accessible for connections when the application intent is set to read only. For more information about ...
0
votes
1answer
887 views
Oracle Logon Trigger ReCompile
Typically when an oracle object goes invalid due to a dependent object being modified, the next execution of the invalid object will compile it and everything will be execute as expected (assuming no ...
