Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Login Failed Expand / Collapse
Author
Message
Posted Monday, July 13, 2009 9:12 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 08, 2013 4:59 AM
Points: 196, Visits: 79
Comments posted to this topic are about the item Login Failed
Post #752448
Posted Tuesday, July 14, 2009 7:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 7:28 AM
Points: 1,281, Visits: 4,731
The fact that there were any votes for the "delete Resource database" option was a bit scary.

- Jeff
Post #752656
Posted Wednesday, July 15, 2009 12:54 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 6:34 AM
Points: 654, Visits: 265
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!
Post #753190
Posted Wednesday, July 15, 2009 1:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 08, 2013 4:59 AM
Points: 196, Visits: 79
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
Post #753218
Posted Tuesday, July 21, 2009 2:47 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:58 AM
Points: 3,924, Visits: 1,588
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.
Post #756971
Posted Tuesday, July 21, 2009 2:49 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:58 AM
Points: 3,924, Visits: 1,588
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.
Post #756973
Posted Sunday, March 21, 2010 3:34 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 8:37 AM
Points: 8,287, Visits: 8,738
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
Post #887054
Posted Monday, April 05, 2010 1:28 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 4:56 AM
Points: 1,002, Visits: 884
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!

Post #896977
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse