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
2,534 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 32

Assisted Solution

by:Stefan Hoffmann
Stefan Hoffmann earned 250 total points
Comment Utility
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
Comment Utility
I ran your script.  There is no RAIERROR occurred
0
 
LVL 32

Expert Comment

by:Stefan Hoffmann
Comment Utility
What SQL Server version and database application do you run?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:terminator_vn
Comment Utility
Server 2012 standard and SQL 2012.  I am running TigerPaw applicaiton
0
 

Accepted Solution

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

Author Closing Comment

by:terminator_vn
Comment Utility
System required SQL 2005 BW Compatibility.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now