Login Failed

Question

Post reply

Login Failed

Marcin Zawadzki

Mr or Mrs. 500

Points: 510
More actions
July 13, 2009 at 9:12 pm

#208123

Comments posted to this topic are about the item Login Failed

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

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

jjtetzlo SSCrazy Points: 2511 More actions · Answer 1

The fact that there were any votes for the "delete Resource database" option was a bit scary.

- Jeff

VM-723206 SSCrazy Points: 2964 More actions · Answer 2

pdanke (7/14/2009)
The fact that there were any votes for the "delete Resource database" option was a bit scary.

88 people opted this answer till now! :w00t:

Marcin Zawadzki Mr or Mrs. 500 Points: 510 More actions · Answer 3

Resource database is not wide known.

We belive in 4 system databases: master, model, tempdb, msdb.

For those who would delete resource database - remember, you have to restore your tempdb database from backup after that 😉

SanjayAttray SSChampion Points: 13157 More actions · Answer 4

Marcin Zawadzki (7/15/2009)
Resource database is not wide known.
We belive in 4 system databases: master, model, tempdb, msdb.
For those who would delete resource database - remember, you have to restore your tempdb database from backup after that 😉

I thought SQL server would not work properly and have to re-install SQL Server.

SQL DBA.

SanjayAttray SSChampion Points: 13157 More actions · Answer 5

SanjayAttray (7/21/2009)
Marcin Zawadzki (7/15/2009)
Resource database is not wide known.
We belive in 4 system databases: master, model, tempdb, msdb.
For those who would delete resource database - remember, you have to restore your tempdb database from backup after that 😉
I thought SQL server would not work properly and have to re-install SQL Server.

Ha HA........I got your sarcasm here. Good one. You cannot take backup or restore operation on tempdb.

SQL DBA.

TomThomson SSC Guru Points: 104773 More actions · Answer 6

It's a pity that the correct answer (login using DAC and set the default database and language for that login back to what they were before) isn't available.

I assumed the trigger concerned had a purpose - probably relating to corporate policy - and disabling as a quick fix would be unacceptable, also that I had followed good practise and backed up master before changing properties of a login, and since I wasn't allowed to pick the correct answer opted for what I still think is the least wrong of the options provided.

Tom

GregoryF SSCertifiable Points: 6296 More actions · Answer 7

You can also login using SQLCMD, then drop the trigger.

Logging in using SQLCMD bypasses the trigger, I have had to do it dozens of times when things go wrong.

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!