Re: NS with Remote DB Server?
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:
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:
>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
>[NSException: Notification Services failed to get the metadata for the
>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.
> Line Number: 65536
>in a line
>NS_Instance = New
>When I register the instance I have provided the SQL user name and password
>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.