all groups > sql server notification services > june 2007 >
You're in the

sql server notification services

group:

Accessing NS Instance on a Database Server from a Web Server


Accessing NS Instance on a Database Server from a Web Server LegacySARK
6/22/2007 9:43:35 PM
sql server notification services:
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#>
Re: Accessing NS Instance on a Database Server from a Web Server LegacySARK via SQLMonster.com
6/27/2007 12:00:00 AM
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

[quoted text, click to view]

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-notification/200706/1
Re: Accessing NS Instance on a Database Server from a Web Server LegacySARK via SQLMonster.com
6/27/2007 12:00:00 AM
Ignore the question below. It's been resolved. Thanks.

[quoted text, click to view]

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-notification/200706/1
Re: Accessing NS Instance on a Database Server from a Web Server Joe Webb
6/27/2007 4:48:31 AM
[quoted text, click to view]

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...

--
Joe Webb
SQL Server MVP
AddThis Social Bookmark Button