The Remote Database Deployment scenario *requires* that the SQLNS
database components be installed on the database server. This places
XPs on the instance of SQL Server that are required for NS to run.
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On Sun, 13 Nov 2005 06:55:03 -0800, "Mostafa Salama"
<[email protected]> wrote:
>Thanks a lot for your reply
>i did what you told me
>1)Install SQLNS on the NS machine.
>2)but i didn't install the database components of NS on the SQL server on
>the database server machine
>3)i configure and build the NS instance as normal . [on the NS machine]
>The result is as follows
>1)The 2 databases corresponding to the instance is created on the SQL Server
>2)The service corresponding to the instance is created on the NS Machine.
>But i have a problem now, that it doesn't start, i don't know why
>may be it is because the Window Authentication or SQL Server Authentication?
>i don't know?!
>"Joe Webb" wrote:
>> Hi -
>> 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
>> Server databases.
>> In the ICF you'll want to identify the database machine in the
>> <SqlServerSystem> element.
>> Joe Webb
>> 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
>> >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
>> >my machine contains no databases.