I have recently set the security mode to Mixed mode for SQL2005 running on
Win XP Pro SP-2. I want to be able to access the database from other
machines using the sa password. This I can do but I am no longer able to
use the WinNT authen. for local access. What gives?
ThanksLarry - I have only seen this when the user's windows password has
expiredbut they are still logged on in windows and try to access sql
server - any chance this is the case?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||I don't think that is it. But you may be on the right track. I often use a
cached profile, I.e. I am not connected to my domain but still use a Domain
login. If that is the case, SQL server would not be able to validate my
authentication while I am not connected to the server. Of course, I can
test this when I am in the office or possible while I have a VPN open to the
Domain server.
Thanks,
Larry
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ODg6C67OHHA.4172@.TK2MSFTNGP03.phx.gbl...
> Larry - I have only seen this when the user's windows password has
> expiredbut they are still logged on in windows and try to access sql
> server - any chance this is the case?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
Showing posts with label win. Show all posts
Showing posts with label win. Show all posts
Wednesday, March 21, 2012
Monday, March 12, 2012
Missing Transactions
SQL 2k & Win 2k
I have a server(S1) that has a trans. publication of 4 tables. I have
another server (S2) that has a subscription to the publication on S1. This
works fine.
Now, S2 has a merge publication of the same 4 tables to several remote
locations. I have a filter in the publication on each of the the four tables
that filters on a numeric field (ex. loc = 19). If I reinitialize the
subscription, only the data that meets the filter clause is populated on the
subscriber.
SO here is the problem....When data is inserted into S1, it makes it to S2,
but not to the remote locations.
If I do a validation, on S2, I get the error... Article 'TableName' failed
data validation (rowcount only) this message appears for each table.
If I insert a row manually into one of the tables on S1 & run the
distribution & merge agents manually, the row makes it to the final
destination, well on the one test I did.
TIA,
Larry...
Is there anything logged in your conflict tables? Use the conflict viewer to
tell.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:6EB8F35D-7D55-468D-AEBB-5209D1A406F5@.microsoft.com...
> SQL 2k & Win 2k
> I have a server(S1) that has a trans. publication of 4 tables. I have
> another server (S2) that has a subscription to the publication on S1.
> This
> works fine.
> Now, S2 has a merge publication of the same 4 tables to several remote
> locations. I have a filter in the publication on each of the the four
> tables
> that filters on a numeric field (ex. loc = 19). If I reinitialize the
> subscription, only the data that meets the filter clause is populated on
> the
> subscriber.
> SO here is the problem....When data is inserted into S1, it makes it to
> S2,
> but not to the remote locations.
> If I do a validation, on S2, I get the error... Article 'TableName' failed
> data validation (rowcount only) this message appears for each table.
> If I insert a row manually into one of the tables on S1 & run the
> distribution & merge agents manually, the row makes it to the final
> destination, well on the one test I did.
> TIA,
> Larry...
|||When I 'View Confilcts', there are <no confilict tables>.
Larry...
PS - got my book yesterday...thanks!
"Hilary Cotter" wrote:
> Is there anything logged in your conflict tables? Use the conflict viewer to
> tell.
|||Also, when I look at the 'Merge Agent History', there have been no
transactions replicated today, but I know there has been some data that has
been moved from S1 to S2.
|||I'm drawing a blank on this one. I'd contact PSS on this. Hope you enjoy the
book.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:7231045F-D1B7-4EF3-9FC1-8A6EF303065D@.microsoft.com...
> Also, when I look at the 'Merge Agent History', there have been no
> transactions replicated today, but I know there has been some data that
> has
> been moved from S1 to S2.
>
I have a server(S1) that has a trans. publication of 4 tables. I have
another server (S2) that has a subscription to the publication on S1. This
works fine.
Now, S2 has a merge publication of the same 4 tables to several remote
locations. I have a filter in the publication on each of the the four tables
that filters on a numeric field (ex. loc = 19). If I reinitialize the
subscription, only the data that meets the filter clause is populated on the
subscriber.
SO here is the problem....When data is inserted into S1, it makes it to S2,
but not to the remote locations.
If I do a validation, on S2, I get the error... Article 'TableName' failed
data validation (rowcount only) this message appears for each table.
If I insert a row manually into one of the tables on S1 & run the
distribution & merge agents manually, the row makes it to the final
destination, well on the one test I did.
TIA,
Larry...
Is there anything logged in your conflict tables? Use the conflict viewer to
tell.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:6EB8F35D-7D55-468D-AEBB-5209D1A406F5@.microsoft.com...
> SQL 2k & Win 2k
> I have a server(S1) that has a trans. publication of 4 tables. I have
> another server (S2) that has a subscription to the publication on S1.
> This
> works fine.
> Now, S2 has a merge publication of the same 4 tables to several remote
> locations. I have a filter in the publication on each of the the four
> tables
> that filters on a numeric field (ex. loc = 19). If I reinitialize the
> subscription, only the data that meets the filter clause is populated on
> the
> subscriber.
> SO here is the problem....When data is inserted into S1, it makes it to
> S2,
> but not to the remote locations.
> If I do a validation, on S2, I get the error... Article 'TableName' failed
> data validation (rowcount only) this message appears for each table.
> If I insert a row manually into one of the tables on S1 & run the
> distribution & merge agents manually, the row makes it to the final
> destination, well on the one test I did.
> TIA,
> Larry...
|||When I 'View Confilcts', there are <no confilict tables>.
Larry...
PS - got my book yesterday...thanks!
"Hilary Cotter" wrote:
> Is there anything logged in your conflict tables? Use the conflict viewer to
> tell.
|||Also, when I look at the 'Merge Agent History', there have been no
transactions replicated today, but I know there has been some data that has
been moved from S1 to S2.
|||I'm drawing a blank on this one. I'd contact PSS on this. Hope you enjoy the
book.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:7231045F-D1B7-4EF3-9FC1-8A6EF303065D@.microsoft.com...
> Also, when I look at the 'Merge Agent History', there have been no
> transactions replicated today, but I know there has been some data that
> has
> been moved from S1 to S2.
>
Subscribe to:
Posts (Atom)