[Webinar] Streamline your web hosting managementRegister Today

x
?
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
Medium Priority
?
4,148 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 37

Assisted Solution

by:ste5an
ste5an earned 1000 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 37

Expert Comment

by:ste5an
ID: 40336978
What SQL Server version and database application do you run?
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 

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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

591 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