Accessing NS Instance on a Database Server from a Web Server

Thanks, Joe. The issue was that I had not registered the instance on the web
server. I'm beyond that point, and getting a new erorr when I try to
instantiate the NSInstance object in the web service.

"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: TCP Provider, error: 0 - No such host is known.)"

I get the same error when I run the check status command from the
Notification Services command prompt. Could this be a firewall setting?

Thanks,
Joe

Joe Webb wrote:
>> Hello. I'm new to SQL Server 2005 Notification Services. I'm trying to
>> access an Instance of SQL 2005 NS on a remote Database Server from a Web
>> Service on a different web server, using the following code:
>>
>> <C#>
>> using Microsoft.SqlServer.NotificationServices;
>
>I take it you are receiving an error of some kind? If you can share more
>details, we'll be glad to offer whatever help we can.
>
>BTW - One common mistake is forgetting to register the instance on the web
>server.
>
>HTH...
>

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-notification/200706/1
 >> Stay informed about: Accessing NS Instance on a Database Server from a Web Server 

Ignore the question below. It's been resolved. Thanks.

LegacySARK wrote:
>Thanks, Joe. The issue was that I had not registered the instance on the web
>server. I'm beyond that point, and getting a new erorr when I try to
>instantiate the NSInstance object in the web service.
>
>"An error has occurred while establishing a connection to the server. When
>connecting to SQL Server 2005, this failure may be caused by the fact that
>under the default settings SQL Server does not allow remote connections.
>(provider: TCP Provider, error: 0 - No such host is known.)"
>
>I get the same error when I run the check status command from the
>Notification Services command prompt. Could this be a firewall setting?
>
>Thanks,
>Joe
>
>>> Hello. I'm new to SQL Server 2005 Notification Services. I'm trying to
>>> access an Instance of SQL 2005 NS on a remote Database Server from a Web
>[quoted text clipped - 10 lines]
>>
>>HTH...

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-notification/200706/1
 >> Stay informed about: Accessing NS Instance on a Database Server from a Web Server