[Top] [All Lists]

Re: NS with Remote DB Server?

Subject: Re: NS with Remote DB Server?
From: Joe Webb
Date: Thu, 19 Oct 2006 07:09:27 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi Tarpan - 

I'm assuming you've installed the NS client tools and have registered
the instance on the web server, right? 

See if these links help:

Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

On Mon, 16 Oct 2006 07:21:01 -0700, tarpan
<[email protected]> wrote:

>Hi everybody,
>In good old times with a one server everything worked fine. Now I have 2 
>servers: web server + DB server.  I have deployed NS Instance to the Web 
>server with DBs created on the DB server. Installs nice and easy. 
>However, my Subscription management App (ASP.Net based) crashes with message:
> Login failed for user ''. The user is not associated with a trusted SQL 
>Server connection.
>[NSException: Notification Services failed to get the metadata for the 
>specified instance.
>Instance Name: NSInstance
>  Source: .Net SqlClient Data Provider
>  Number: 18452
>  State: 1
>  Class: 14
>  Server: DBSERVER\DB
>  Message: Login failed for user ''. The user is not associated with a 
>trusted SQL Server connection.
>  Procedure: 
>  Line Number: 65536
>in a line
>NS_Instance = New 
>When I register the instance I have provided the SQL user name and password 
>as :
>nscontrol register ... -server SqlServer -sqlusername USERNAME -sqlpassword 
>My guess is: the ASP app runs under ASPNET user. When I create object of 
>NSInstance class, the object trying to access it's database with the 
>credentials of ASPNET user. The DB server does not know who the ASPNET user 
>is, so it rejects the connection. 
>I tried to add user WebServer\ASPNET to the SQL server - unsuccessful. At 
>this point I don't know what to do.
>Whoever has any ideas, please help me. Thank you.
>PS. I have tried to deploy the NS to the DB Server and register it on the 
>web server - got exactly same result. 

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