|
|
You're in the
sql server notification services
group:Remote Database Server
sql server notification services:
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
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 Machine 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?! thanks [quoted text, click to view] "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. > > HTH... > > -- > Joe Webb > SQL Server MVP > http://www.sqlns.com > > > ~~~ > Get up to speed quickly with SQLNS > http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 > > I support PASS, the Professional Association for SQL Server. > (www.sqlpass.org) > > > On Wed, 9 Nov 2005 04:41:04 -0800, "Mostafa Salama" > <MostafaSalama@discussions.microsoft.com> wrote: > > >Hello > >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.
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. HTH... -- Joe Webb SQL Server MVP http://www.sqlns.com ~~~ Get up to speed quickly with SQLNS http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 I support PASS, the Professional Association for SQL Server. (www.sqlpass.org) On Wed, 9 Nov 2005 04:41:04 -0800, "Mostafa Salama" [quoted text, click to view] <MostafaSalama@discussions.microsoft.com> wrote:
>Hello >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
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. -- Joe Webb SQL Server MVP http://www.sqlns.com ~~~ Get up to speed quickly with SQLNS http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 I support PASS, the Professional Association for SQL Server. (www.sqlpass.org) On Sun, 13 Nov 2005 06:55:03 -0800, "Mostafa Salama" [quoted text, click to view] <MostafaSalama@discussions.microsoft.com> 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 >Machine >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?! > >thanks > >"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. >> >> HTH... >> >> -- >> Joe Webb >> SQL Server MVP >> http://www.sqlns.com >> >> >> ~~~ >> Get up to speed quickly with SQLNS >> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 >> >> I support PASS, the Professional Association for SQL Server. >> (www.sqlpass.org) >> >> >> On Wed, 9 Nov 2005 04:41:04 -0800, "Mostafa Salama" >> <MostafaSalama@discussions.microsoft.com> wrote: >> >> >Hello >> >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.
ok, i installed it now, and i redeoploy the instance
but it still the service that is installed on my machine doesn't start, i don't know why? [quoted text, click to view] "Joe Webb" wrote:
> 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. > > -- > Joe Webb > SQL Server MVP > http://www.sqlns.com > > > ~~~ > Get up to speed quickly with SQLNS > http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 > > I support PASS, the Professional Association for SQL Server. > (www.sqlpass.org) > > > On Sun, 13 Nov 2005 06:55:03 -0800, "Mostafa Salama" > <MostafaSalama@discussions.microsoft.com> 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 > >Machine > >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?! > > > >thanks > > > >"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. > >> > >> HTH... > >> > >> -- > >> Joe Webb > >> SQL Server MVP > >> http://www.sqlns.com > >> > >> > >> ~~~ > >> Get up to speed quickly with SQLNS > >> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 > >> > >> I support PASS, the Professional Association for SQL Server. > >> (www.sqlpass.org) > >> > >> > >> On Wed, 9 Nov 2005 04:41:04 -0800, "Mostafa Salama" > >> <MostafaSalama@discussions.microsoft.com> wrote: > >> > >> >Hello > >> >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. > >>
Not that it's going to help, but I have the same problem.
I've installed every part of NS on my SQL Server, but when trying to run the samples, there is an event login error, where it's trying to log the database name as the user. No errors pop up, you can only see it in the event log. The stock sample for instance moves data in to the events folder but never sends a notification. I tried setting up my desktop as the NS server as well, and get a similiar error, the service just won't start. Anyone fixed this issue? Ches
Ches -
If I undersood you right, events are being created in the events table, but the generator is failing when firing the matching rules? That usually indicates a problem with the match rule itself. It could also be that there is no subscription matching the event being submitted and the error log is something else. Can you post the error log? HTH... -- Joe Webb SQL Server MVP http://www.sqlns.com ~~~ Get up to speed quickly with SQLNS http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 I support PASS, the Professional Association for SQL Server. (www.sqlpass.org) [quoted text, click to view] On 14 Nov 2005 08:15:53 -0800, ches.weldishofer@gmail.com wrote:
>Not that it's going to help, but I have the same problem. > >I've installed every part of NS on my SQL Server, but when trying to >run the samples, there is an event login error, where it's trying to >log the database name as the user. No errors pop up, you can only see >it in the event log. The stock sample for instance moves data in to >the events folder but never sends a notification. > >I tried setting up my desktop as the NS server as well, and get a >similiar error, the service just won't start. > >Anyone fixed this issue? >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |