how to setup the permission of share fold in log shipping ?

when I set up log shipping in SQL SERVER 2000
I got the following error:
'Unable to copy the initialization file to the secondary server '%s' '
I know this is permission question about the share fold to log file.
I want to know the following thing:
one is how to setup permisson about about the share fold to log file?
two is whether log shpping primary and the secondary db must be run
in domin mode or not?
thanks in advance!
1. if your logshipping jobs are owned by 'sa', the acct for sqlserver
service needs to have access to the shared.
2. no, they do not have to be running in a same domain. the key here is to
ensure each server can access the shared.
-oj
<lovexueer@.gmail.com> wrote in message
news:1143611950.475014.180370@.i39g2000cwa.googlegr oups.com...
> when I set up log shipping in SQL SERVER 2000
> I got the following error:
> 'Unable to copy the initialization file to the secondary server '%s' '
> I know this is permission question about the share fold to log file.
> I want to know the following thing:
> one is how to setup permisson about about the share fold to log file?
> two is whether log shpping primary and the secondary db must be run
> in domin mode or not?
>
> thanks in advance!
>

how to setup the permission of share fold in log shipping ?

when I set up log shipping in SQL SERVER 2000
I got the following error:
'Unable to copy the initialization file to the secondary server '%s' '
I know this is permission question about the share fold to log file.
I want to know the following thing:
one is how to setup permisson about about the share fold to log file?
two is whether log shpping primary and the secondary db must be run
in domin mode or not?
thanks in advance!1. if your logshipping jobs are owned by 'sa', the acct for sqlserver
service needs to have access to the shared.
2. no, they do not have to be running in a same domain. the key here is to
ensure each server can access the shared.
-oj
<lovexueer@.gmail.com> wrote in message
news:1143611950.475014.180370@.i39g2000cwa.googlegroups.com...
> when I set up log shipping in SQL SERVER 2000
> I got the following error:
> 'Unable to copy the initialization file to the secondary server '%s' '
> I know this is permission question about the share fold to log file.
> I want to know the following thing:
> one is how to setup permisson about about the share fold to log file?
> two is whether log shpping primary and the secondary db must be run
> in domin mode or not?
>
> thanks in advance!
>

how to setup the permission of share fold in log shipping ?

when I set up log shipping in SQL SERVER 2000
I got the following error:
'Unable to copy the initialization file to the secondary server '%s' '
I know this is permission question about the share fold to log file.
I want to know the following thing:
one is how to setup permisson about about the share fold to log file?
two is whether log shpping primary and the secondary db must be run
in domin mode or not?
thanks in advance!1. if your logshipping jobs are owned by 'sa', the acct for sqlserver
service needs to have access to the shared.
2. no, they do not have to be running in a same domain. the key here is to
ensure each server can access the shared.
--
-oj
<lovexueer@.gmail.com> wrote in message
news:1143611950.475014.180370@.i39g2000cwa.googlegroups.com...
> when I set up log shipping in SQL SERVER 2000
> I got the following error:
> 'Unable to copy the initialization file to the secondary server '%s' '
> I know this is permission question about the share fold to log file.
> I want to know the following thing:
> one is how to setup permisson about about the share fold to log file?
> two is whether log shpping primary and the secondary db must be run
> in domin mode or not?
>
> thanks in advance!
>|||sorry,I don't understand what you said to the first quesiton?
can you tell furthur detailed information about how to setup the
permisson of shared fold ?sql

How to set Access Workgroup

My package is to copy data from an Access 97 db into a SQL2k5 table.

Problem is that the 'mdb' is subscribed to a 'mdw' workgroup and I have been unable to workout / read how to get the SSIS manager to join the workgroup. Connection fails because "...you don't have necessary permission..."

I was able to do this previously for SQL 2k by messing with the registry, but I'm now on unfamiliar teritory.

Any answers? Cheers.

Open the connection manager UI, and select the All button. Within there you get the Jet OLEDB:System Database propery, which you point at your MDW. You could also just change the connection string directly from the properties grid, or use an expression or configuration if the location can be derived or just change.

|||

Connection works. Although I found that I had to specify the password in both the 1st dialogue and security:password item in the 'All' page.

I'm now getting a unicode conversion failure - I've seen other pastings about this so I'll follow those.

Many Thanks.