Re: Remote Database Server
You're describing the Remote Database Server Configuration. BOL has a
pretty good section on how to do it.
In a nutshell (this vary a bit depending on if you're using Window
Authentication or SQL Server Authentication), you'll want to:
1) Install SQLNS on the NS machine.
2) Install SQLNS database components on the database server.
3) Configure & Build the NS instance as normal.
In the above description, NS is the machine in which you'll run the NS
instance; the database server is the machine that will host the SQL
In the ICF you'll want to identify the database machine in the
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On Wed, 9 Nov 2005 04:41:04 -0800, "Mostafa Salama"
<[email protected]> wrote:
>I installed notification service and it is working great , but now we need
>to seperate the the server that contain the notification service and the
>server that contains the database. i found a tutorial called remote Database
>server deployment (SQL Server Authentication) but unfourtunatly, this
>tutorial is not so much helpful.
>I need to know what i am going to from the beging, even before the creation
>of the instances.
>and do the service will be on one machine and the database of this service
>is on another machine
>could any one help me to know what are the steps to do in order to create
>instance on my machine that access a database on different machine, note that
>my machine contains no databases.