Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [logon]

9 questions
9
votes
5 answers

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 remote SQL Login security context. That one always…
J.D.
  • 40,776
  • 12
  • 62
  • 141
3
votes
1 answer

SQL Server Error Log and Failed Logins

We recently disabled a SQL account on one of our production servers at the request of the application owner, account no longer used apparently. Since disabling we have seen login failures in the SQL error log. See image below. The app team cannot…
Stockburn
  • 501
  • 4
  • 22
1
vote
1 answer

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() system function and convert the result into…
igelr
  • 2,162
  • 3
  • 26
  • 56
0
votes
2 answers

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 were not too concerned about security and decided…
Garry
  • 53
  • 1
  • 6
0
votes
3 answers

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 access) via SQLCMD, SSMS. Access using SSMS shall…
Elena2020
  • 71
  • 8
0
votes
0 answers

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 able to connect to this account / server from…
Landon Statis
  • 151
  • 2
  • 4
0
votes
1 answer

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 with the login who wants to access and then…
SakZepelin
  • 21
  • 3
  • 8
0
votes
2 answers

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 application intent, see SQL Server Books Online." in…
Tomasz
  • 186
  • 2
  • 13
0
votes
1 answer

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 errors caused by the modification). This works as…
Nick S
  • 631
  • 3
  • 8