Solved

"Error 55555, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addm

Posted on 2014-09-22
6
3,362 Views
Last Modified: 2014-09-27
Hi Expert,

Suddenly, We had received the below error message.  The server can't established because of this.  How do i fix it.  Thanks in advanced

"Error 55555, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage."
0
Comment
Question by:terminator_vn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 34

Assisted Solution

by:ste5an
ste5an earned 250 total points
ID: 40336763
It's a user-defined message. Look for RAISERROR in triggers or stored procedures of your database. E.g.

SELECT  *
FROM    sys.sql_modules SM
WHERE   [definition] LIKE '%RAISERROR%'

Open in new window

0
 

Author Comment

by:terminator_vn
ID: 40336811
I ran your script.  There is no RAIERROR occurred
0
 
LVL 34

Expert Comment

by:ste5an
ID: 40336978
What SQL Server version and database application do you run?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:terminator_vn
ID: 40337096
Server 2012 standard and SQL 2012.  I am running TigerPaw applicaiton
0
 

Accepted Solution

by:
terminator_vn earned 0 total points
ID: 40337624
I think I solved a problem.  It required SQL 2005 BW Compatibility.
0
 

Author Closing Comment

by:terminator_vn
ID: 40347430
System required SQL 2005 BW Compatibility.
0

Featured Post

 Watch the Recording: Learning MySQL 5.7

MySQL 5.7 has a lot of new features. If you've dabbled with an older version of MySQL, it is definitely worth learning.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

634 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