Hi all:
How to active a push subscription after created push subscription?
Cheers
nick
Drop the push subscription. At the publisher or distributor if you have a
remote distributor go to Tools, Replication, Configure Publishing,
Distributor, Subscribers. Enable your subscriber. The connect to the
subscriber, enable replication. After this go to tools, replication, create
pull subscription. Follow the prompts.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:OnRBILjCFHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi all:
> How to active a push subscription after created push subscription?
>
> Cheers
> nick
>
|||Thanks Hilary
can i ask one more question about push subscription?
i got two DB in my SQL server, call A, B for exampl. A is a publication DB,
B is push subscription DB, so whenever data been changed in B database that
will be updated in A database,
is that good way to manage in this situation?
Cheers
Nick
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:#Mme7OjCFHA.4036@.TK2MSFTNGP15.phx.gbl...
> Drop the push subscription. At the publisher or distributor if you have a
> remote distributor go to Tools, Replication, Configure Publishing,
> Distributor, Subscribers. Enable your subscriber. The connect to the
> subscriber, enable replication. After this go to tools, replication,
create
> pull subscription. Follow the prompts.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Nick" <fsheng@.ebreathe.co.nz> wrote in message
> news:OnRBILjCFHA.2876@.TK2MSFTNGP12.phx.gbl...
>
|||No, its not. Push and pull do not refer to the direction of data movement.
Rather they refer to whether the changes are pushed from the publisher to
the subscriber, or whether the changes are pulled from the publisher to the
subscriber.
This is only valid for transactional or snapshot replication.
If you have snapshot or transactional replication with updatable
subscribers, changes which occur on the subscriber can be pushed from the
subscriber to the publisher. With merge, if you have a push subscription,
the changes are merged at the publisher and pushed to the subscriber. If you
have a pull merge subscription, the changes are merged at the publisher and
pulled to the subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:u4qlYujCFHA.1396@.TK2MSFTNGP14.phx.gbl...
> Thanks Hilary
> can i ask one more question about push subscription?
> i got two DB in my SQL server, call A, B for exampl. A is a publication
DB,
> B is push subscription DB, so whenever data been changed in B database
that[vbcol=seagreen]
> will be updated in A database,
> is that good way to manage in this situation?
> Cheers
> Nick
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:#Mme7OjCFHA.4036@.TK2MSFTNGP15.phx.gbl...
a
> create
>
|||Hi Hilary:
Do you mean only transactional or snapshot replication can handle this case,
but not merge replication?
Cheers
nick
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eTUf#0mCFHA.3376@.TK2MSFTNGP12.phx.gbl...
> No, its not. Push and pull do not refer to the direction of data movement.
> Rather they refer to whether the changes are pushed from the publisher to
> the subscriber, or whether the changes are pulled from the publisher to
the
> subscriber.
> This is only valid for transactional or snapshot replication.
> If you have snapshot or transactional replication with updatable
> subscribers, changes which occur on the subscriber can be pushed from the
> subscriber to the publisher. With merge, if you have a push subscription,
> the changes are merged at the publisher and pushed to the subscriber. If
you
> have a pull merge subscription, the changes are merged at the publisher
and[vbcol=seagreen]
> pulled to the subscriber.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Nick" <fsheng@.ebreathe.co.nz> wrote in message
> news:u4qlYujCFHA.1396@.TK2MSFTNGP14.phx.gbl...
> DB,
> that
have
> a
>
Showing posts with label active. Show all posts
Showing posts with label active. Show all posts
Friday, February 24, 2012
how to active a push subscriptin?
How to activate Mixed Mode (SECURITYMODE=SQL) after installation
Hi,
is there a way to active Mixed Mode Authentication without reinstalling
MSDE?
Thanks,
mm
As in Microsoft Knowledge Base Article - 285097
To set this key to mixed-mode, follow these steps:
1.. Stop SQL Server and all related services, such as SQLAgent, from the
Services control panel.
2.. Click Start, click Run, type regedt32, and then click OK.
3.. Find the HKEY_LOCAL_MACHINE window on the local computer.
4.. Navigate to the following registry key for the default instance:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\ MSSqlServer
5.. Navigate to the following registry key for a named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
6.. On the right-hand pane, find the value LoginMode and double-click it.
7.. In the DWORD Editor window, set the value to 0 or 2. Also, make sure
that the Hex radio button is selected.
8.. Click OK.
Regards,
Jeyakumar
"Michael Mller" <alligator081067@.yahoo.de> wrote in message
news:c4ggt0$2fca9f$1@.ID-93095.news.uni-berlin.de...
> Hi,
> is there a way to active Mixed Mode Authentication without reinstalling
> MSDE?
> Thanks,
> mm
>
|||hi Michael,
"Michael Mller" <alligator081067@.yahoo.de> ha scritto nel messaggio
news:c4ggt0$2fca9f$1@.ID-93095.news.uni-berlin.de...
> Hi,
> is there a way to active Mixed Mode Authentication without reinstalling
> MSDE?
>
please have a look at
http://support.microsoft.com/default...b;en-us;285097 , which
provides info on how to hack the window registry to change authentication
mode..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea & Jeyakumar,
> please have a look at
> http://support.microsoft.com/default...b;en-us;285097 , which
> provides info on how to hack the window registry to change authentication
> mode..
Thanks for your help. I've found that this solution helped other people, but
it sounds mad, it doesnt work for my MSDE SP3 installation.
I have changed the registry key as described, stopped and restarted the
MSSQLSERVER service, but i still can't connect with SQL Server
authentication.
I even have reinstalled MSDE with the SECURITYMODE=SQL option, but no
success. :-(
If I use MS Products like ASP.NET WebMatrix or Access with
windows-intregrated authorization, no problem.
But when I explicitly try to connect with SQL server authentication, the
following message appears:
Error -2147467259
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server existiert nicht oder
Zugriff verweigert.(SQL connection does not exist or access refused.)
Provider=sqloledb;Data Source=edvserver;Network Library=dbmssocn;User
Id=sa;Password=;
Another tool with the same access problem is myLittleAdmin
(http://intranetserver/mla_sql_lite/default.asp).
I'm sure that the sa password is right.
This error appears in WebMatrix too, if i try to use SQL Authentication.
Any further idea?
Bye,
mm
is there a way to active Mixed Mode Authentication without reinstalling
MSDE?
Thanks,
mm
As in Microsoft Knowledge Base Article - 285097
To set this key to mixed-mode, follow these steps:
1.. Stop SQL Server and all related services, such as SQLAgent, from the
Services control panel.
2.. Click Start, click Run, type regedt32, and then click OK.
3.. Find the HKEY_LOCAL_MACHINE window on the local computer.
4.. Navigate to the following registry key for the default instance:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\ MSSqlServer
5.. Navigate to the following registry key for a named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
6.. On the right-hand pane, find the value LoginMode and double-click it.
7.. In the DWORD Editor window, set the value to 0 or 2. Also, make sure
that the Hex radio button is selected.
8.. Click OK.
Regards,
Jeyakumar
"Michael Mller" <alligator081067@.yahoo.de> wrote in message
news:c4ggt0$2fca9f$1@.ID-93095.news.uni-berlin.de...
> Hi,
> is there a way to active Mixed Mode Authentication without reinstalling
> MSDE?
> Thanks,
> mm
>
|||hi Michael,
"Michael Mller" <alligator081067@.yahoo.de> ha scritto nel messaggio
news:c4ggt0$2fca9f$1@.ID-93095.news.uni-berlin.de...
> Hi,
> is there a way to active Mixed Mode Authentication without reinstalling
> MSDE?
>
please have a look at
http://support.microsoft.com/default...b;en-us;285097 , which
provides info on how to hack the window registry to change authentication
mode..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea & Jeyakumar,
> please have a look at
> http://support.microsoft.com/default...b;en-us;285097 , which
> provides info on how to hack the window registry to change authentication
> mode..
Thanks for your help. I've found that this solution helped other people, but
it sounds mad, it doesnt work for my MSDE SP3 installation.
I have changed the registry key as described, stopped and restarted the
MSSQLSERVER service, but i still can't connect with SQL Server
authentication.
I even have reinstalled MSDE with the SECURITYMODE=SQL option, but no
success. :-(
If I use MS Products like ASP.NET WebMatrix or Access with
windows-intregrated authorization, no problem.
But when I explicitly try to connect with SQL server authentication, the
following message appears:
Error -2147467259
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server existiert nicht oder
Zugriff verweigert.(SQL connection does not exist or access refused.)
Provider=sqloledb;Data Source=edvserver;Network Library=dbmssocn;User
Id=sa;Password=;
Another tool with the same access problem is myLittleAdmin
(http://intranetserver/mla_sql_lite/default.asp).
I'm sure that the sa password is right.
This error appears in WebMatrix too, if i try to use SQL Authentication.
Any further idea?
Bye,
mm
Labels:
activate,
active,
authentication,
database,
installation,
microsoft,
mixed,
mode,
mysql,
oracle,
securitymodesql,
server,
sql
Subscribe to:
Posts (Atom)