Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
EA
Starting Member
19 Posts |
 Posted - 2006-07-07 : 02:54:31
|
| I've created several alerts, it seems to be working correctly.But .... why is alert 014 (SQL Server event alert, severity 14 insufficient permission) raised when a succesful connection is made?I get the message "Login succeeded for user "domain\user". Connection: Trusted.This is not an insufficient permission? Why is the alert raised?Any help or suggestions are welcome! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-07-08 : 01:34:13
|
| Perhaps you have a login on the database server and are allowed to login, but maybe the account you are using lack permission on your default database?Have you recently made a restore? Add the login account to your default database.Peter LarssonHelsingborg, Sweden |
 |
|
|
EA
Starting Member
19 Posts |
Posted - 2006-07-10 : 03:01:35
|
| I'm using the sysadmin account. The event is fired either I'm using a sql server account (Login succeeded for user 'user'. Connection: Non-Trusted) or a NT account (Login succeeded for user 'domain\user'. Connection: Trusted).Btw, the security audit level is 'Failure'. So why fire the alert with an informational message? |
|
|
|
|
|
|
Alert - Insufficient Permission