microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Seperating Notification Application and Notification Database

Subject: Re: Seperating Notification Application and Notification Database
From: "lotek via SQLMonster.com"
Date: Mon, 12 Dec 2005 22:13:04 GMT
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Whoops, got it! I accidently created the nSApplication before setting the
instance user/pass. Seems to be working! Thanks!

lotek wrote:
>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
>
>>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.sqlmonster.com

<Prev in Thread] Current Thread [Next in Thread>