Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

sql server and asp.net give me error

Posted on 2011-02-10
2
Medium Priority
?
581 Views
Last Modified: 2012-05-11
Logon failed for login 'shivadmin' due to trigger execution.
Changed database context to 'shivdiamond'.
Changed language setting to us_english.

lots of time i get this error i try every thing but not work.
0
Comment
Question by:ajaymaster143
2 Comments
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 2000 total points
ID: 34868322
0
 
LVL 13

Expert Comment

by:geek_vj
ID: 34868807
This happens when you drop the database before the trigger is fired. As the database is dropped, you cannot login through the SQL management studio. So, you need to use DAC connection as below from cmd prompt:

sqlcmd -S LocalHost -d master -A

Drop Trigger <Triggername> On All Server

Please replace Localhost in the first query with your servername\Instancename if it is not the default instance.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Loops Section Overview
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question