Could not run the pull subscription

Indra,
try changing the owner of the job to sa.
HTH,
Paul Ibison
Hi paul, Do i have to run sql agent and sql server in boht computer as a
sa, it runing now but just for information.
Can i ask you some more informatio.
As I am going to install MSDE to our field user to whome i wanted to
give database so that they can work offline and when they want to
synchronize on demand. How i have to create the security premision, what
type to user account, window/sql mix or only window or only sql and what
type of owner ship they need so that they can replicate or synchronize
the data with our center server. Could you please give me some
information or the link where from i can read a bit.
Thanks a lot.
Indra.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Indra,
in BOL have a look at replication, security. The subsections are agent login
security and Publication Access Lists. Your SQL Server Agent is the context
under which the replication jobs function. Typically the replication agent
is set to impersonate its login on the server it connects to, so if you want
a really simple setup, have the same domain user as the service user for sql
server and the agent services on your publisher/distributer and the
subscriber. If you want it to be more granular then the references in BOL
above will help.
The reason I mentioned setting the job's owner to sa is that although the
job runs as the agent, the replication process involves a verification that
the job owner is in active directory and setting the owner to sa avoids this
issue.
SQL Logins in replication are usually used for non-trusted domains.
HTH,
Paul Ibison
|||Thanks a lot Paul,
This is really a good information. I wanted to go for the simplest way
so that there will be no problem from the client site. Write now i am
testing as you mention with giving the dbowner permition, is it
necessary to give that permision or just data reader or data writer also
work in the case of repliction.
I need little bit more information, if you can help me. Acutally we are
using ACCESS database asd i am on the process to migrate (doing all the
testing, before actual migration).
I already migrated (for test) to sql database keeping front end as it is
ADP file. What i want to do is copy all ADP file to client m/c and
install local MSDE AND SYNCHRONIZE THROUGH MERGE REPLICATION ON DEMAND,
SO THAT USER CAN ALSO WORK WHERE THERE IN NO INTERNET ACCESS. TILL NOW
I have just converted to sql and trying to run merge on the one client,
but not yet tested for ADP file with new replicated data. Do you have
any idea or information regarding this type of project.
Thank you very much for help.
Indra.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Indra,
For security, the role requirements are different for each agent. Have a
look in BOL for replication, security, Role Requirements.
For Access-SQL replication, have a look in BOL for these articles:
"Implementing Merge Replication to Access Subscribers"
"Data type mapping to Jet-SQL 4.0 for Merge Replication"
HTH,
Paul Ibison

Could not get the column information from the OLE DB provider IBMDA400

Hello

I'm trying to get data from as400 server to sql server, trough a job.
The job executes a stored procedure that retrieves data from a view in an other database on the same server. That view gets the data from as400.
Now, when i run the mentioned stored procedure in the query analyzer, everything works fine, but when the stored procedure is executed from the scheduled job, it fails each time giving the error

"Could not get the column information from the OLE DB provider 'IBMDA400'. [SQLSTATE 42000] (Error 7350). The step failed."

on random points during that process (by that i mean the lenght of time it runs)

does anyone know what the diffrence is between executing an sp in query analyzer or using a job, keeping in mind retrieving data from as400?

thanksSQLAgent service account should have the same permissions as yours. If you're piping data from AS/400 using linked server, make sure mapping entry exists for SQLAgent account as well.

corruption of database maintenance wizard

when I try to add a job I am unable to use the wizard
the screen that holds the settings is corrupted
I can no longer define how many backups have to stay in the folder
(disk backup)
I can set the number but the listbox after that stays empty so I can
not set "hours" or "days"
the job itself doesn't work neither
the existing jobs keep happening but are no longer visible in the
enterprise manager
can I solve this some way?
maybe with queries?
I did try to use the "new" sql 2005 console for my 2k servers
could this be related?
thnxSQL2000 Maintenance plans are treated as legacy in SQL2005 and limited in
what they can do etc. The 2005 tool is not meant to edit 2000 plans. You
may have to redo them using 2000 EM since there is no telling what might
have changed.
--
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.3b897d6207852634.36062@.yahoo.com...
> when I try to add a job I am unable to use the wizard
> the screen that holds the settings is corrupted
> I can no longer define how many backups have to stay in the folder (disk
> backup)
> I can set the number but the listbox after that stays empty so I can not
> set "hours" or "days"
> the job itself doesn't work neither
> the existing jobs keep happening but are no longer visible in the
> enterprise manager
> can I solve this some way?
> maybe with queries?
> I did try to use the "new" sql 2005 console for my 2k servers
> could this be related?
> thnx
>|||> SQL2000 Maintenance plans are treated as legacy in SQL2005 and limited in
> what they can do etc. The 2005 tool is not meant to edit 2000 plans. You
> may have to redo them using 2000 EM since there is no telling what might have
> changed.
> --
> Andrew J. Kelly SQL MVP
> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
> news:mn.3b897d6207852634.36062@.yahoo.com...
>> when I try to add a job I am unable to use the wizard
>> the screen that holds the settings is corrupted
>> I can no longer define how many backups have to stay in the folder (disk
>> backup)
>> I can set the number but the listbox after that stays empty so I can not
>> set "hours" or "days"
>> the job itself doesn't work neither
>> the existing jobs keep happening but are no longer visible in the
>> enterprise manager
>> can I solve this some way?
>> maybe with queries?
>> I did try to use the "new" sql 2005 console for my 2k servers
>> could this be related?
>> thnx
>>
I didn't try to change anything using the 2k5 VS tool
but I can't change it using the 2k enterprise manager anymore
since the wizard got corrupted somehow
I am not sure if it is related
my question is how to repair it without interrupting the server
functionality (too much)
grtz|||Since I have no way to know what is corrupted all I can say is to delete any
that you suspect are corrupt and rebuild them.
--
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.42317d62800a030b.36062@.yahoo.com...
>> SQL2000 Maintenance plans are treated as legacy in SQL2005 and limited in
>> what they can do etc. The 2005 tool is not meant to edit 2000 plans.
>> You may have to redo them using 2000 EM since there is no telling what
>> might have changed.
>> --
>> Andrew J. Kelly SQL MVP
>> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
>> news:mn.3b897d6207852634.36062@.yahoo.com...
>> when I try to add a job I am unable to use the wizard
>> the screen that holds the settings is corrupted
>> I can no longer define how many backups have to stay in the folder (disk
>> backup)
>> I can set the number but the listbox after that stays empty so I can not
>> set "hours" or "days"
>> the job itself doesn't work neither
>> the existing jobs keep happening but are no longer visible in the
>> enterprise manager
>> can I solve this some way?
>> maybe with queries?
>> I did try to use the "new" sql 2005 console for my 2k servers
>> could this be related?
>> thnx
>>
> I didn't try to change anything using the 2k5 VS tool
> but I can't change it using the 2k enterprise manager anymore
> since the wizard got corrupted somehow
> I am not sure if it is related
> my question is how to repair it without interrupting the server
> functionality (too much)
> grtz
>|||> Since I have no way to know what is corrupted all I can say is to delete any
> that you suspect are corrupt and rebuild them.
> --
> Andrew J. Kelly SQL MVP
> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
> news:mn.42317d62800a030b.36062@.yahoo.com...
>>
>> I didn't try to change anything using the 2k5 VS tool
>> but I can't change it using the 2k enterprise manager anymore
>> since the wizard got corrupted somehow
>> I am not sure if it is related
>> my question is how to repair it without interrupting the server
>> functionality (too much)
>> grtz
>>
I'd like to but I can't
the interface doesn't show me any jobs
but they do still work
I just cannot add any new ones because the wizard is broken somehow
grtz|||You should still be able to create a new maintenance plan and add what ever
you want there. They don't have to all be in the same plan.
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.521c7d6216230948.36062@.yahoo.com...
>> Since I have no way to know what is corrupted all I can say is to delete
>> any that you suspect are corrupt and rebuild them.
>> --
>> Andrew J. Kelly SQL MVP
>> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
>> news:mn.42317d62800a030b.36062@.yahoo.com...
>>
>> I didn't try to change anything using the 2k5 VS tool
>> but I can't change it using the 2k enterprise manager anymore
>> since the wizard got corrupted somehow
>> I am not sure if it is related
>> my question is how to repair it without interrupting the server
>> functionality (too much)
>> grtz
>>
> I'd like to but I can't
> the interface doesn't show me any jobs
> but they do still work
> I just cannot add any new ones because the wizard is broken somehow
> grtz
>|||> You should still be able to create a new maintenance plan and add what ever
> you want there. They don't have to all be in the same plan.
> --
> Andrew J. Kelly SQL MVP
> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
> news:mn.521c7d6216230948.36062@.yahoo.com...
>>
>> I'd like to but I can't
>> the interface doesn't show me any jobs
>> but they do still work
>> I just cannot add any new ones because the wizard is broken somehow
>> grtz
>>
no I cannot,
for some reason the wizard doesn't allow me to set a value for how many
files I'd like to keep in the backup folder
I can set a number but not the type of value after that
I already tried to add a new job anyway but it keeps failing
since I have no idea how to fix the wizard I thought I'd give the
experts a try to tell me why,how and where the wizard might fail
and how to repair it's behaviour
perhaps thru sql?
grtz|||Without seeing what you have I really have no idea how to fix it. I rarely
advocate using the maintenance plan wizard at all for so many reasons, this
being just one. Anything you can do with he wizard can be done fairly
easily with simple tsql commands and a normal scheduled job. But you can use
the same utility that the wizard uses to execute these tasks and you don't
need to use the gui to do it. Create a new scheduled job and call the
sqlmaint utility with the appropriate parameters to do what you want done.
See "sqlmaint utility" in BooksOnLine for the details.
--
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.53927d6233044d14.36062@.yahoo.com...
>> You should still be able to create a new maintenance plan and add what
>> ever you want there. They don't have to all be in the same plan.
>> --
>> Andrew J. Kelly SQL MVP
>> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
>> news:mn.521c7d6216230948.36062@.yahoo.com...
>>
>> I'd like to but I can't
>> the interface doesn't show me any jobs
>> but they do still work
>> I just cannot add any new ones because the wizard is broken somehow
>> grtz
>>
> no I cannot,
> for some reason the wizard doesn't allow me to set a value for how many
> files I'd like to keep in the backup folder
> I can set a number but not the type of value after that
> I already tried to add a new job anyway but it keeps failing
> since I have no idea how to fix the wizard I thought I'd give the experts
> a try to tell me why,how and where the wizard might fail
> and how to repair it's behaviour
> perhaps thru sql?
> grtz
>

corruption of database maintenance wizard

when I try to add a job I am unable to use the wizard
the screen that holds the settings is corrupted
I can no longer define how many backups have to stay in the folder
(disk backup)
I can set the number but the listbox after that stays empty so I can
not set "hours" or "days"
the job itself doesn't work neither
the existing jobs keep happening but are no longer visible in the
enterprise manager
can I solve this some way?
maybe with queries?
I did try to use the "new" sql 2005 console for my 2k servers
could this be related?
thnx
SQL2000 Maintenance plans are treated as legacy in SQL2005 and limited in
what they can do etc. The 2005 tool is not meant to edit 2000 plans. You
may have to redo them using 2000 EM since there is no telling what might
have changed.
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.3b897d6207852634.36062@.yahoo.com...
> when I try to add a job I am unable to use the wizard
> the screen that holds the settings is corrupted
> I can no longer define how many backups have to stay in the folder (disk
> backup)
> I can set the number but the listbox after that stays empty so I can not
> set "hours" or "days"
> the job itself doesn't work neither
> the existing jobs keep happening but are no longer visible in the
> enterprise manager
> can I solve this some way?
> maybe with queries?
> I did try to use the "new" sql 2005 console for my 2k servers
> could this be related?
> thnx
>
|||> SQL2000 Maintenance plans are treated as legacy in SQL2005 and limited in[vbcol=seagreen]
> what they can do etc. The 2005 tool is not meant to edit 2000 plans. You
> may have to redo them using 2000 EM since there is no telling what might have
> changed.
> --
> Andrew J. Kelly SQL MVP
> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
> news:mn.3b897d6207852634.36062@.yahoo.com...
I didn't try to change anything using the 2k5 VS tool
but I can't change it using the 2k enterprise manager anymore
since the wizard got corrupted somehow
I am not sure if it is related
my question is how to repair it without interrupting the server
functionality (too much)
grtz
|||Since I have no way to know what is corrupted all I can say is to delete any
that you suspect are corrupt and rebuild them.
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.42317d62800a030b.36062@.yahoo.com...
> I didn't try to change anything using the 2k5 VS tool
> but I can't change it using the 2k enterprise manager anymore
> since the wizard got corrupted somehow
> I am not sure if it is related
> my question is how to repair it without interrupting the server
> functionality (too much)
> grtz
>
|||> Since I have no way to know what is corrupted all I can say is to delete any[vbcol=seagreen]
> that you suspect are corrupt and rebuild them.
> --
> Andrew J. Kelly SQL MVP
> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
> news:mn.42317d62800a030b.36062@.yahoo.com...
I'd like to but I can't
the interface doesn't show me any jobs
but they do still work
I just cannot add any new ones because the wizard is broken somehow
grtz
|||You should still be able to create a new maintenance plan and add what ever
you want there. They don't have to all be in the same plan.
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.521c7d6216230948.36062@.yahoo.com...
> I'd like to but I can't
> the interface doesn't show me any jobs
> but they do still work
> I just cannot add any new ones because the wizard is broken somehow
> grtz
>
|||> You should still be able to create a new maintenance plan and add what ever[vbcol=seagreen]
> you want there. They don't have to all be in the same plan.
> --
> Andrew J. Kelly SQL MVP
> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
> news:mn.521c7d6216230948.36062@.yahoo.com...
no I cannot,
for some reason the wizard doesn't allow me to set a value for how many
files I'd like to keep in the backup folder
I can set a number but not the type of value after that
I already tried to add a new job anyway but it keeps failing
since I have no idea how to fix the wizard I thought I'd give the
experts a try to tell me why,how and where the wizard might fail
and how to repair it's behaviour
perhaps thru sql?
grtz
|||Without seeing what you have I really have no idea how to fix it. I rarely
advocate using the maintenance plan wizard at all for so many reasons, this
being just one. Anything you can do with he wizard can be done fairly
easily with simple tsql commands and a normal scheduled job. But you can use
the same utility that the wizard uses to execute these tasks and you don't
need to use the gui to do it. Create a new scheduled job and call the
sqlmaint utility with the appropriate parameters to do what you want done.
See "sqlmaint utility" in BooksOnLine for the details.
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.53927d6233044d14.36062@.yahoo.com...
> no I cannot,
> for some reason the wizard doesn't allow me to set a value for how many
> files I'd like to keep in the backup folder
> I can set a number but not the type of value after that
> I already tried to add a new job anyway but it keeps failing
> since I have no idea how to fix the wizard I thought I'd give the experts
> a try to tell me why,how and where the wizard might fail
> and how to repair it's behaviour
> perhaps thru sql?
> grtz
>

corruption of database maintenance wizard

when I try to add a job I am unable to use the wizard
the screen that holds the settings is corrupted
I can no longer define how many backups have to stay in the folder
(disk backup)
I can set the number but the listbox after that stays empty so I can
not set "hours" or "days"
the job itself doesn't work neither
the existing jobs keep happening but are no longer visible in the
enterprise manager
can I solve this some way?
maybe with queries?
I did try to use the "new" sql 2005 console for my 2k servers
could this be related?
thnxSQL2000 Maintenance plans are treated as legacy in SQL2005 and limited in
what they can do etc. The 2005 tool is not meant to edit 2000 plans. You
may have to redo them using 2000 EM since there is no telling what might
have changed.
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.3b897d6207852634.36062@.yahoo.com...
> when I try to add a job I am unable to use the wizard
> the screen that holds the settings is corrupted
> I can no longer define how many backups have to stay in the folder (disk
> backup)
> I can set the number but the listbox after that stays empty so I can not
> set "hours" or "days"
> the job itself doesn't work neither
> the existing jobs keep happening but are no longer visible in the
> enterprise manager
> can I solve this some way?
> maybe with queries?
> I did try to use the "new" sql 2005 console for my 2k servers
> could this be related?
> thnx
>|||> SQL2000 Maintenance plans are treated as legacy in SQL2005 and limited in[vbcol=seagreen]
> what they can do etc. The 2005 tool is not meant to edit 2000 plans. You
> may have to redo them using 2000 EM since there is no telling what might h
ave
> changed.
> --
> Andrew J. Kelly SQL MVP
> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
> news:mn.3b897d6207852634.36062@.yahoo.com...
I didn't try to change anything using the 2k5 VS tool
but I can't change it using the 2k enterprise manager anymore
since the wizard got corrupted somehow
I am not sure if it is related
my question is how to repair it without interrupting the server
functionality (too much)
grtz|||Since I have no way to know what is corrupted all I can say is to delete any
that you suspect are corrupt and rebuild them.
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.42317d62800a030b.36062@.yahoo.com...
> I didn't try to change anything using the 2k5 VS tool
> but I can't change it using the 2k enterprise manager anymore
> since the wizard got corrupted somehow
> I am not sure if it is related
> my question is how to repair it without interrupting the server
> functionality (too much)
> grtz
>|||> Since I have no way to know what is corrupted all I can say is to delete any[vbcol=seagree
n]
> that you suspect are corrupt and rebuild them.
> --
> Andrew J. Kelly SQL MVP
> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
> news:mn.42317d62800a030b.36062@.yahoo.com...
I'd like to but I can't
the interface doesn't show me any jobs
but they do still work
I just cannot add any new ones because the wizard is broken somehow
grtz|||You should still be able to create a new maintenance plan and add what ever
you want there. They don't have to all be in the same plan.
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.521c7d6216230948.36062@.yahoo.com...
> I'd like to but I can't
> the interface doesn't show me any jobs
> but they do still work
> I just cannot add any new ones because the wizard is broken somehow
> grtz
>|||> You should still be able to create a new maintenance plan and add what ever[vbcol=seagreen
]
> you want there. They don't have to all be in the same plan.
> --
> Andrew J. Kelly SQL MVP
> "chriske911" <chriske911nospam@.yahoo.com> wrote in message
> news:mn.521c7d6216230948.36062@.yahoo.com...
no I cannot,
for some reason the wizard doesn't allow me to set a value for how many
files I'd like to keep in the backup folder
I can set a number but not the type of value after that
I already tried to add a new job anyway but it keeps failing
since I have no idea how to fix the wizard I thought I'd give the
experts a try to tell me why,how and where the wizard might fail
and how to repair it's behaviour
perhaps thru sql?
grtz|||Without seeing what you have I really have no idea how to fix it. I rarely
advocate using the maintenance plan wizard at all for so many reasons, this
being just one. Anything you can do with he wizard can be done fairly
easily with simple tsql commands and a normal scheduled job. But you can use
the same utility that the wizard uses to execute these tasks and you don't
need to use the gui to do it. Create a new scheduled job and call the
sqlmaint utility with the appropriate parameters to do what you want done.
See "sqlmaint utility" in BooksOnLine for the details.
Andrew J. Kelly SQL MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.53927d6233044d14.36062@.yahoo.com...
> no I cannot,
> for some reason the wizard doesn't allow me to set a value for how many
> files I'd like to keep in the backup folder
> I can set a number but not the type of value after that
> I already tried to add a new job anyway but it keeps failing
> since I have no idea how to fix the wizard I thought I'd give the experts
> a try to tell me why,how and where the wizard might fail
> and how to repair it's behaviour
> perhaps thru sql?
> grtz
>

Corrupted sysindexes

After running the command dbcc checkdb, which is part of a weekly job the following returned
CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
Any ideas on how to fixed this sysindexes table.
I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
Considering it is sysindexes, my guess you are in for a restore. If that isn't convenient, opening a case with
MS is probably a good idea (but chances are that they don't have better options either). General
recommendations for corrupt or suspect databases: http://www.karaszi.com/sqlserver/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Stephen" <stephen.hoye@.tabq.com.au> wrote in message
news:89575553-91E2-459B-B6CD-0709E5C79463@.microsoft.com...
> After running the command dbcc checkdb, which is part of a weekly job the following returned
> CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
> Any ideas on how to fixed this sysindexes table.
> I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
>
|||I'm going to create a DTS package and move the database over to anthor DB.
Then I'l rename them. We do have back up, but the problem was picked up after I long weekend.
There was no going back because a number of days had pasted.
Doing the above DTS method, there is no loss in data.

Corrupted sysindexes

After running the command dbcc checkdb, which is part of a weekly job the following returne
CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2)
Any ideas on how to fixed this sysindexes table.
I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdConsidering it is sysindexes, my guess you are in for a restore. If that isn't convenient, opening a case with
MS is probably a good idea (but chances are that they don't have better options either). General
recommendations for corrupt or suspect databases: http://www.karaszi.com/sqlserver/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Stephen" <stephen.hoye@.tabq.com.au> wrote in message
news:89575553-91E2-459B-B6CD-0709E5C79463@.microsoft.com...
> After running the command dbcc checkdb, which is part of a weekly job the following returned
> CHECKDB found 1 allocation errors and 957 consistency errors in table 'sysindexes' (object ID 2).
> Any ideas on how to fixed this sysindexes table.
> I've run dbcc updateusage, dbbc reindex on all tables, dbbc checkdb
>|||I'm going to create a DTS package and move the database over to anthor DB
Then I'l rename them. We do have back up, but the problem was picked up after I long weekend
There was no going back because a number of days had pasted
Doing the above DTS method, there is no loss in data.