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,071 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
  • 4
  • 2
6 Comments
 
LVL 33

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 33

Expert Comment

by:ste5an
ID: 40336978
What SQL Server version and database application do you run?
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

680 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