Sql server logs

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

State 16 means that the user does not have permission to log into their target database.

Usually happens when the user does not have permission to their default database.

Check the default database for this user and make sure they have access or change the default database

SkyBVI SSCoach Points: 15128 More actions · Answer 2

@ steve

The application on server tries to login every 30 sec or so and get faield..

Is there a possible way to block the connection attempt thru the sql server ?

Thanks,

Sushant

Regards
Sushant Kumar
MCTS,MCP

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 3

You should look at Logon triggers. This was introduced in SQL 2005 SP2 if I am not mistaken.

-Roy

Rick.Cornell.SME SSCrazy Eights Points: 8597 More actions · Answer 4

Do you have any linked servers created? To me sounds like credentials are wrong!

SkyBVI SSCoach Points: 15128 More actions · Answer 5

Where could I find Logon triggers?

@Twinsoft

There are few linked servers but that server from which the attempts to logon are there , is not added as linked server.

Regards
Sushant Kumar
MCTS,MCP

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 6

You can rollback a connection attempt using logon triggers.

-Roy

SkyBVI SSCoach Points: 15128 More actions · Answer 7

SSCoach

Points: 15128

August 24, 2010 at 11:43 am

any more views?

Regards
Sushant Kumar
MCTS,MCP