Hi -
It's kind of hard to tell from you post what's been done, so here is a
couple of general comments/questions that may help lead you in the
right direction.
1) have you installed the SQLNS components on the database server?
2) do you have the appropriate permissions on the remote database
server - either through SQL Server Authentication or through Windows
Authentication?
HTH...
--
Joe Webb
SQL Server MVP
http://www.sqlns.com ~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 I support PASS, the Professional Association for SQL Server.
(
www.sqlpass.org)
On Wed, 9 Nov 2005 04:51:08 -0800, "Mostafa Salama"
[quoted text, click to view] <MostafaSalama@discussions.microsoft.com> wrote:
>when i run create methode to create an instance called SADBNS
>where the SQL database server is on different machine
>note that i previously installed it where SQL database server is on the same
>machine
>
>this error appeared
>-----------------------------------------------------------------------------------------
>-----------------------------------------------------------------------------------------
>An error occurred when creating the instance stored procedures.
>FailedStoredProcedure:
>microsoft.SqlServer.NotificationServices.Common.Generator2
>ApplicationName: SADBNSVApp
>The rule could not be added (or updated) to the table of rules in the
>application database.
>InstanceName: SADBNSV
>ApplicationName: SADBNSVApp
>RuleId: 7
>RuleName: KPIEventsChronRule
>RuleType: EventChronicleRule
>RuleAction:
>-----------------------------------------------------------------------------------------
>-----------------------------------------------------------------------------------------
>could any one help to solve this problem
