sql2k sp3
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisR
right click on your agent and make the agent owner sa. Restart your job.
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>
|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> 8198:
> same
>
Showing posts with label pull. Show all posts
Showing posts with label pull. Show all posts
Thursday, March 22, 2012
error 8198
sql2k sp3
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisRright click on your agent and make the agent owner sa. Restart your job.
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> 8198:
> same
>sql
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisRright click on your agent and make the agent owner sa. Restart your job.
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> 8198:
> same
>sql
error 8198
sql2k sp3
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisR
right click on your agent and make the agent owner sa. Restart your job.
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>
|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> 8198:
> same
>
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisR
right click on your agent and make the agent owner sa. Restart your job.
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>
|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> 8198:
> same
>
error 8198
sql2k sp3
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisRright click on your agent and make the agent owner sa. Restart your job.
--
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
>> sql2k sp3
>> win2k sp4
>> Im trying to create a Pull Subscription for replication and get "Error
> 8198:
>> Could not obtain information about Windows NT group/ user 'domain/
>> user'".
>> I read this:
>> http://support.microsoft.com/?kbid=834124
>> But both boxes are in the same domain and the same subnet. Both use the
> same
>> domain admin account for SQL Server and the Agent accounts.
>> I also read this:
>> http://support.microsoft.com/?kbid=838460
>> But Im not about to install sp4 Beta on anything.
>> Is there anything else I can do?
>> TIA, ChrisR
>>
>
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisRright click on your agent and make the agent owner sa. Restart your job.
--
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
>> sql2k sp3
>> win2k sp4
>> Im trying to create a Pull Subscription for replication and get "Error
> 8198:
>> Could not obtain information about Windows NT group/ user 'domain/
>> user'".
>> I read this:
>> http://support.microsoft.com/?kbid=834124
>> But both boxes are in the same domain and the same subnet. Both use the
> same
>> domain admin account for SQL Server and the Agent accounts.
>> I also read this:
>> http://support.microsoft.com/?kbid=838460
>> But Im not about to install sp4 Beta on anything.
>> Is there anything else I can do?
>> TIA, ChrisR
>>
>
Error 8114 Date data
I am trying to pull over data in for a specified date from an ODBC connected
AS/400 table, and I get the following error.
Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
Here's an example of what the field looks like in the AS/400 table:
1999-08-24 00:00:00.000
I thought that I could just as "where date = '2005-07-01 00:00:00.00'" but
it doesn't work.
Any thoughts'
Thanks in advance.This could be the limitation of the provider you use. Try a different or
newer provider.
Adrian
"aschossler" <aschossler@.discussions.microsoft.com> wrote in message
news:6C6CD9AF-F37E-459E-9A42-64CE221D2E94@.microsoft.com...
>I am trying to pull over data in for a specified date from an ODBC
>connected
> AS/400 table, and I get the following error.
> Server: Msg 8114, Level 16, State 8, Line 1
> Error converting data type DBTYPE_DBTIMESTAMP to datetime.
> Here's an example of what the field looks like in the AS/400 table:
> 1999-08-24 00:00:00.000
> I thought that I could just as "where date = '2005-07-01 00:00:00.00'"
> but
> it doesn't work.
> Any thoughts'
> Thanks in advance.sql
AS/400 table, and I get the following error.
Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
Here's an example of what the field looks like in the AS/400 table:
1999-08-24 00:00:00.000
I thought that I could just as "where date = '2005-07-01 00:00:00.00'" but
it doesn't work.
Any thoughts'
Thanks in advance.This could be the limitation of the provider you use. Try a different or
newer provider.
Adrian
"aschossler" <aschossler@.discussions.microsoft.com> wrote in message
news:6C6CD9AF-F37E-459E-9A42-64CE221D2E94@.microsoft.com...
>I am trying to pull over data in for a specified date from an ODBC
>connected
> AS/400 table, and I get the following error.
> Server: Msg 8114, Level 16, State 8, Line 1
> Error converting data type DBTYPE_DBTIMESTAMP to datetime.
> Here's an example of what the field looks like in the AS/400 table:
> 1999-08-24 00:00:00.000
> I thought that I could just as "where date = '2005-07-01 00:00:00.00'"
> but
> it doesn't work.
> Any thoughts'
> Thanks in advance.sql
Error 8114 Date data
I am trying to pull over data in for a specified date from an ODBC connected
AS/400 table, and I get the following error.
Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
Here's an example of what the field looks like in the AS/400 table:
1999-08-24 00:00:00.000
I thought that I could just as "where date = '2005-07-01 00:00:00.00'" but
it doesn't work.
Any thoughts?
Thanks in advance.
This could be the limitation of the provider you use. Try a different or
newer provider.
Adrian
"aschossler" <aschossler@.discussions.microsoft.com> wrote in message
news:6C6CD9AF-F37E-459E-9A42-64CE221D2E94@.microsoft.com...
>I am trying to pull over data in for a specified date from an ODBC
>connected
> AS/400 table, and I get the following error.
> Server: Msg 8114, Level 16, State 8, Line 1
> Error converting data type DBTYPE_DBTIMESTAMP to datetime.
> Here's an example of what the field looks like in the AS/400 table:
> 1999-08-24 00:00:00.000
> I thought that I could just as "where date = '2005-07-01 00:00:00.00'"
> but
> it doesn't work.
> Any thoughts?
> Thanks in advance.
AS/400 table, and I get the following error.
Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
Here's an example of what the field looks like in the AS/400 table:
1999-08-24 00:00:00.000
I thought that I could just as "where date = '2005-07-01 00:00:00.00'" but
it doesn't work.
Any thoughts?
Thanks in advance.
This could be the limitation of the provider you use. Try a different or
newer provider.
Adrian
"aschossler" <aschossler@.discussions.microsoft.com> wrote in message
news:6C6CD9AF-F37E-459E-9A42-64CE221D2E94@.microsoft.com...
>I am trying to pull over data in for a specified date from an ODBC
>connected
> AS/400 table, and I get the following error.
> Server: Msg 8114, Level 16, State 8, Line 1
> Error converting data type DBTYPE_DBTIMESTAMP to datetime.
> Here's an example of what the field looks like in the AS/400 table:
> 1999-08-24 00:00:00.000
> I thought that I could just as "where date = '2005-07-01 00:00:00.00'"
> but
> it doesn't work.
> Any thoughts?
> Thanks in advance.
Error 8114 Date data
I am trying to pull over data in for a specified date from an ODBC connected
AS/400 table, and I get the following error.
Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
Here's an example of what the field looks like in the AS/400 table:
1999-08-24 00:00:00.000
I thought that I could just as "where date = '2005-07-01 00:00:00.00'" but
it doesn't work.
Any thoughts'
Thanks in advance.This could be the limitation of the provider you use. Try a different or
newer provider.
Adrian
"aschossler" <aschossler@.discussions.microsoft.com> wrote in message
news:6C6CD9AF-F37E-459E-9A42-64CE221D2E94@.microsoft.com...
>I am trying to pull over data in for a specified date from an ODBC
>connected
> AS/400 table, and I get the following error.
> Server: Msg 8114, Level 16, State 8, Line 1
> Error converting data type DBTYPE_DBTIMESTAMP to datetime.
> Here's an example of what the field looks like in the AS/400 table:
> 1999-08-24 00:00:00.000
> I thought that I could just as "where date = '2005-07-01 00:00:00.00'"
> but
> it doesn't work.
> Any thoughts'
> Thanks in advance.
AS/400 table, and I get the following error.
Server: Msg 8114, Level 16, State 8, Line 1
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
Here's an example of what the field looks like in the AS/400 table:
1999-08-24 00:00:00.000
I thought that I could just as "where date = '2005-07-01 00:00:00.00'" but
it doesn't work.
Any thoughts'
Thanks in advance.This could be the limitation of the provider you use. Try a different or
newer provider.
Adrian
"aschossler" <aschossler@.discussions.microsoft.com> wrote in message
news:6C6CD9AF-F37E-459E-9A42-64CE221D2E94@.microsoft.com...
>I am trying to pull over data in for a specified date from an ODBC
>connected
> AS/400 table, and I get the following error.
> Server: Msg 8114, Level 16, State 8, Line 1
> Error converting data type DBTYPE_DBTIMESTAMP to datetime.
> Here's an example of what the field looks like in the AS/400 table:
> 1999-08-24 00:00:00.000
> I thought that I could just as "where date = '2005-07-01 00:00:00.00'"
> but
> it doesn't work.
> Any thoughts'
> Thanks in advance.
Friday, March 9, 2012
Error 409: The assignment operator operation could not take a text data type as an argumen
How can I make it work when I need to pull out a field which is text type using a stored procedure? Please help!!!Thanks
I am getting the following error
Error 409: The assignment operator operation could not take a text data type as an argument
===========my sp=================================
CREATE PROCEDURE [dbo].[sp_SelectABC]
(@.a varchar(50) output,
@.b text output
)
AS
set nocount on
select @.a=name, @.b= description from ABC
I am getting the following error
Error 409: The assignment operator operation could not take a text data type as an argument
===========my sp=================================
CREATE PROCEDURE [dbo].[sp_SelectABC]
(@.a varchar(50) output,
@.b text output
)
AS
set nocount on
select @.a=name, @.b= description from ABC
GONo, you can't do that.
You're going to have to replace it with
select name, description from ABC
Friday, February 17, 2012
Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
Hi,
Does anyone know how to get over this problem in SQL 2000 without
removing all replication then adding back in?
Could not create a Pull subscription to publication XXX
Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
Thanks
Dave
Is the pull subscriber in the dbo role on the publisher and the distributor?
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
"David Gray" <grayd@.turpin-distribution.com> wrote in message
news:28j6s25v4j97onbjvg6j05pdv1uq56pmob@.4ax.com...
> Hi,
> Does anyone know how to get over this problem in SQL 2000 without
> removing all replication then adding back in?
> Could not create a Pull subscription to publication XXX
> Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
> Thanks
> Dave
|||On Fri, 2 Feb 2007 10:37:32 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:
>Is the pull subscriber in the dbo role on the publisher and the distributor?
Hi,
I'm not sure what you mean. I'm not able to add the subscriber
because of the error mentioned in the subject line.
The other strange thing is that none of the other subscribers on this
SQL 2K box appear in the Replication | Subscriptions tree (EM Console)
even after I refresh.
Dave
Does anyone know how to get over this problem in SQL 2000 without
removing all replication then adding back in?
Could not create a Pull subscription to publication XXX
Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
Thanks
Dave
Is the pull subscriber in the dbo role on the publisher and the distributor?
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
"David Gray" <grayd@.turpin-distribution.com> wrote in message
news:28j6s25v4j97onbjvg6j05pdv1uq56pmob@.4ax.com...
> Hi,
> Does anyone know how to get over this problem in SQL 2000 without
> removing all replication then adding back in?
> Could not create a Pull subscription to publication XXX
> Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
> Thanks
> Dave
|||On Fri, 2 Feb 2007 10:37:32 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:
>Is the pull subscriber in the dbo role on the publisher and the distributor?
Hi,
I'm not sure what you mean. I'm not able to add the subscriber
because of the error mentioned in the subject line.
The other strange thing is that none of the other subscribers on this
SQL 2K box appear in the Replication | Subscriptions tree (EM Console)
even after I refresh.
Dave
Labels:
adding,
back,
create,
database,
error,
incould,
microsoft,
mysql,
oracle,
pull,
replication,
server,
sql,
sql-dmo,
subscription,
table,
transpublication,
withoutremoving,
xxxx
Wednesday, February 15, 2012
Error 208
Running - SQL 2K Win2K
When I attempt to create a pull subscription from Server A to Server B,
I get the error message,
Error 208:Invalid object name 'syspublications'.
Invalid object name 'sysextendedarticlesview'.
I have done some research & have read everything from remove replicaton
to copy these objects from another server and create them on Server A.
All I am looking for is...
1. What caused this.
2. How do I fix it.
AHIA,
Larry...
This error is most frequently caused by restoring a published database.
The best fix is to copy the objects from a database of the same version
where they are present. Right click on them in EM, and select copy. Then
paste them into QA with the focus on the problem db and execute it.
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
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1134404027.880653.314400@.g43g2000cwa.googlegr oups.com...
> Running - SQL 2K Win2K
> When I attempt to create a pull subscription from Server A to Server B,
> I get the error message,
> Error 208:Invalid object name 'syspublications'.
> Invalid object name 'sysextendedarticlesview'.
> I have done some research & have read everything from remove replicaton
> to copy these objects from another server and create them on Server A.
> All I am looking for is...
> 1. What caused this.
> 2. How do I fix it.
> AHIA,
> Larry...
>
When I attempt to create a pull subscription from Server A to Server B,
I get the error message,
Error 208:Invalid object name 'syspublications'.
Invalid object name 'sysextendedarticlesview'.
I have done some research & have read everything from remove replicaton
to copy these objects from another server and create them on Server A.
All I am looking for is...
1. What caused this.
2. How do I fix it.
AHIA,
Larry...
This error is most frequently caused by restoring a published database.
The best fix is to copy the objects from a database of the same version
where they are present. Right click on them in EM, and select copy. Then
paste them into QA with the focus on the problem db and execute it.
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
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1134404027.880653.314400@.g43g2000cwa.googlegr oups.com...
> Running - SQL 2K Win2K
> When I attempt to create a pull subscription from Server A to Server B,
> I get the error message,
> Error 208:Invalid object name 'syspublications'.
> Invalid object name 'sysextendedarticlesview'.
> I have done some research & have read everything from remove replicaton
> to copy these objects from another server and create them on Server A.
> All I am looking for is...
> 1. What caused this.
> 2. How do I fix it.
> AHIA,
> Larry...
>
Error 207
Hi everyone,
I am trying to create a Transactional Pull Subscription=20
but I get an error 207 : Invalid column=20
name "enabled_for_syncmgr"
Invalid columnname "alt_snapshot_folder"
Invalid columnname "dts_package_name".
Both The Publication and Subscriber databases are SQL=20
Server 7 backups restored on a SQL Server 2000 Server. The=20
Publication worked with no problem on the SQL Server 7=20
server environment.
Does anybody have any idea.
Best regards=20
Jakob Br=F8ckner
If possible please also post an answer directly to my=20
email address.
I think your best idea is to recreate the publication - SQL 2000 is sending
some new parameters that were not around in SQL 7
"Jakob Brckner" <jb@.visual.as> wrote in message
news:052301c47fb7$05f48470$7d02280a@.phx.gbl...
Hi everyone,
I am trying to create a Transactional Pull Subscription
but I get an error 207 : Invalid column
name "enabled_for_syncmgr"
Invalid columnname "alt_snapshot_folder"
Invalid columnname "dts_package_name".
Both The Publication and Subscriber databases are SQL
Server 7 backups restored on a SQL Server 2000 Server. The
Publication worked with no problem on the SQL Server 7
server environment.
Does anybody have any idea.
Best regards
Jakob Brckner
If possible please also post an answer directly to my
email address.
|||I have already recreated the publication with same error.
/Jakob Br=F8ckner
>--Original Message--
>I think your best idea is to recreate the publication -=20
SQL 2000 is sending
>some new parameters that were not around in SQL 7
>"Jakob Br=F8ckner" <jb@.visual.as> wrote in message
>news:052301c47fb7$05f48470$7d02280a@.phx.gbl...
>Hi everyone,
>I am trying to create a Transactional Pull Subscription
>but I get an error 207 : Invalid column
>name "enabled_for_syncmgr"
>Invalid columnname "alt_snapshot_folder"
>Invalid columnname "dts_package_name".
>Both The Publication and Subscriber databases are SQL
>Server 7 backups restored on a SQL Server 2000 Server. The
>Publication worked with no problem on the SQL Server 7
>server environment.
>Does anybody have any idea.
>Best regards
>Jakob Br=F8ckner
>If possible please also post an answer directly to my
>email address.
>
>.
>
|||It seems I have solved the problem. The problem was that the tables :
MSsubscription_properties
MSreplication_subscriptions
Have a different design in SQL Server 2K than in SQL Server 7. And these
tables was also restored. And the sp_addpullsubscription_agent tries to
insert into these tables and some fields are missing or have different names.
But the sp_addpullsubscription_agent does not drop and recreate the table
for obvious reasons. But I dropped them through Query Analyser since you are
not allowed to drop System tables through Enterprise manager. But usiing :
DROP TABLE MSsubscription_properties
DROP TABLE MSreplication_subscriptions
and then trying to pull the subscription solved the problem.
/Jakob
"Jakob Br?ckner" wrote:
> I have already recreated the publication with same error.
> /Jakob Br?ckner
> SQL 2000 is sending
>
I am trying to create a Transactional Pull Subscription=20
but I get an error 207 : Invalid column=20
name "enabled_for_syncmgr"
Invalid columnname "alt_snapshot_folder"
Invalid columnname "dts_package_name".
Both The Publication and Subscriber databases are SQL=20
Server 7 backups restored on a SQL Server 2000 Server. The=20
Publication worked with no problem on the SQL Server 7=20
server environment.
Does anybody have any idea.
Best regards=20
Jakob Br=F8ckner
If possible please also post an answer directly to my=20
email address.
I think your best idea is to recreate the publication - SQL 2000 is sending
some new parameters that were not around in SQL 7
"Jakob Brckner" <jb@.visual.as> wrote in message
news:052301c47fb7$05f48470$7d02280a@.phx.gbl...
Hi everyone,
I am trying to create a Transactional Pull Subscription
but I get an error 207 : Invalid column
name "enabled_for_syncmgr"
Invalid columnname "alt_snapshot_folder"
Invalid columnname "dts_package_name".
Both The Publication and Subscriber databases are SQL
Server 7 backups restored on a SQL Server 2000 Server. The
Publication worked with no problem on the SQL Server 7
server environment.
Does anybody have any idea.
Best regards
Jakob Brckner
If possible please also post an answer directly to my
email address.
|||I have already recreated the publication with same error.
/Jakob Br=F8ckner
>--Original Message--
>I think your best idea is to recreate the publication -=20
SQL 2000 is sending
>some new parameters that were not around in SQL 7
>"Jakob Br=F8ckner" <jb@.visual.as> wrote in message
>news:052301c47fb7$05f48470$7d02280a@.phx.gbl...
>Hi everyone,
>I am trying to create a Transactional Pull Subscription
>but I get an error 207 : Invalid column
>name "enabled_for_syncmgr"
>Invalid columnname "alt_snapshot_folder"
>Invalid columnname "dts_package_name".
>Both The Publication and Subscriber databases are SQL
>Server 7 backups restored on a SQL Server 2000 Server. The
>Publication worked with no problem on the SQL Server 7
>server environment.
>Does anybody have any idea.
>Best regards
>Jakob Br=F8ckner
>If possible please also post an answer directly to my
>email address.
>
>.
>
|||It seems I have solved the problem. The problem was that the tables :
MSsubscription_properties
MSreplication_subscriptions
Have a different design in SQL Server 2K than in SQL Server 7. And these
tables was also restored. And the sp_addpullsubscription_agent tries to
insert into these tables and some fields are missing or have different names.
But the sp_addpullsubscription_agent does not drop and recreate the table
for obvious reasons. But I dropped them through Query Analyser since you are
not allowed to drop System tables through Enterprise manager. But usiing :
DROP TABLE MSsubscription_properties
DROP TABLE MSreplication_subscriptions
and then trying to pull the subscription solved the problem.
/Jakob
"Jakob Br?ckner" wrote:
> I have already recreated the publication with same error.
> /Jakob Br?ckner
> SQL 2000 is sending
>
Labels:
column20name,
create,
database,
enabled_for_syncmgr,
error,
invalid,
microsoft,
mysql,
oracle,
pull,
server,
sql,
subscription20but,
transactional
Subscribe to:
Posts (Atom)