Feeds:
Posts
Comments

Posts Tagged ‘Sydney BizTalk’

This is quite a simple one for the DBAs. If you get stumped with a SQL agent error for your machine name, details are listed as follows:

Error: Could not find server in sysservers. Execute sp_addlinkedserver to add the server to sysservers. The statement has been terminated.

Solution:

  1. Open SSMS and verify that SQL Server name is correct
    use master
    Select @@Servername
    
  2. Run the following command
    Use Master
    GO
    Sp_DropServer 'myServer123'
    GO
    Use Master
    GO
    Sp_Addserver 'myServer786', 'local'
    GO
    
  3. Restart SQL Server service
  4. Re-run command on step#1. This should return back the correct machine name

Happy coding 🙂

Advertisements

Read Full Post »

Found the following error to be quite a simple fix. Posting incase, someone is looking for a solution.

Error: Communication with MessageBox  BizTalkMsgBoxDb on SQL Instance XYZ/Instance01 has been re-established

Solution:

Most likely you’d be running BizTalk 2009 (as I found out to be!). Installing the following hot-fix would resolve it:

KB Article Number(s): 980560
Link: http://support.microsoft.com/kb/980560

Happy fixing…

Read Full Post »