MS SQL Server Notification Services - Seperating Notification Application and Notification Database

Author

Seperating Notification Application and Notification Database

lotek

2005-12-09, 8:25 pm

I am using the notification classes using c# to manage subscriibers,
subscriptions, etc. However, this application is on a different server than
the notifications database. How can i tell the c# program where to save the
subscribers to? The app works fine on the same machine, but obviously on
different ones it doesnt work. Ideas?

Thanks
Matt

kate

2005-12-12, 8:25 pm

for NS(sp1)sql2000 you need to install the NS client tools from the
install disk. this gives you the dll's and the registry settings to
point those dll's to your target backend.

kate p

lotek via SQLMonster.com

2005-12-12, 8:25 pm

Ok i got that far, now im getting an error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

I set the user/pass on the Instance:
nSApplication = new NSApplication (nSInstance, "App");
nSInstance.SqlUser = "user";
nSInstance.SqlPassword = "pass";

I also included the sqluser/pass using nscontrol -register and -create on the
database machine..
and registered the app on the webhost machine.

Im not sure what the problem is, the app works fine on the same machine as
notification services. It seems like its still trying to use windows
authentication though...Ideas?

Thanks!
Matt

kate wrote:
>for NS(sp1)sql2000 you need to install the NS client tools from the
>install disk. this gives you the dll's and the registry settings to
>point those dll's to your target backend.
>
>kate p

--
Message posted via http://www.webservertalk.com

lotek via SQLMonster.com

2005-12-12, 8:25 pm

Whoops, got it! I accidently created the nSApplication before setting the
instance user/pass. Seems to be working! Thanks!

lotek wrote:[color=darkred
]
>Ok i got that far, now im getting an error:
>
>Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>Server connection.
>
>I set the user/pass on the Instance:
> nSApplication = new NSApplication (nSInstance, "App");
> nSInstance.SqlUser = "user";
> nSInstance.SqlPassword = "pass";
>
>I also included the sqluser/pass using nscontrol -register and -create on the
>database machine..
>and registered the app on the webhost machine.
>
>Im not sure what the problem is, the app works fine on the same machine as
>notification services. It seems like its still trying to use windows
>authentication though...Ideas?
>
>Thanks!
>Matt
>

--
Message posted via http://www.webservertalk.com

Joe Webb

2005-12-13, 3:23 am

Same for 2005.

--
Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)On 12 Dec 2005 13:27:07 -0800, "kate"
<k@alert-tech.co.uk> wrote:

>for NS(sp1)sql2000 you need to install the NS client tools from the
>install disk. this gives you the dll's and the registry settings to
>point those dll's to your target backend.
>
>kate p

Sponsored Links