replication

[victor regs]

replication in 6.5
in creating a publication/article, i received an error that
says "could not create file on the replication working directory.verify
your account has write access..." . I gave all the "full control" permission
on the directory(from the root directory until
epldata) but it doesn't
do any good. what exactly permission i need to make this work?

other thing is, on the tasks for the distribution it gave an error
"37000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated with a trusted SQL Server connection."
what does this mean? I am using the standard security mode.
The other processess (logreader and sync) failed with the error trying
to connect.

I am just relying on the books and BOL ,if there are technical books
that explain in details what are the things that need to be done
to make this works please share this.

your favorable response is highly appreciated

thanks.

[Dave Pooler]

Replication uses trusted connections independently of what users are using. You need to go on a SQL Admin course or get one of the books available from WROX or whoever.

You need to have both SQL Server and Executive running under the same real user account (not SYSTEM). This will be a member of the administrator group (and therefore able to use a trusted connection by default), able to "log on as a service" and the password should be fixed.

The client protocol needs to support trusted connections. I quote:

"You can implement replication on servers that have been configured to use any of SQL Server's login security modes. By default, regardless of the security mode the servers are set for, a distribution server connects to a subscription server using a trusted connection (forced integrated security). This means that you must set the SQL Client Configuration Utility on the distribution server (a combined publisher/distributer or a remote distributor) to use Named Pipes or Multi-Protocol as the default network."

Cheers


------------
victor regs at 3/17/99 2:13:31 PM

replication in 6.5
in creating a publication/article, i received an error that
says "could not create file on the replication working directory.verify
your account has write access..." . I gave all the "full control" permission
on the directory(from the root directory until
epldata) but it doesn't
do any good. what exactly permission i need to make this work?

other thing is, on the tasks for the distribution it gave an error
"37000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated with a trusted SQL Server connection."
what does this mean? I am using the standard security mode.
The other processess (logreader and sync) failed with the error trying
to connect.

I am just relying on the books and BOL ,if there are technical books
that explain in details what are the things that need to be done
to make this works please share this.

your favorable response is highly appreciated

thanks.

[victor regs]

The problem with this is that all the task can not connect to
the publisher/distributor server. And applications using ODBC
can not connect. It says "... general network error...".


------------
Dave Pooler at 3/18/99 4:39:57 AM

Replication uses trusted connections independently of what users are using. You need to go on a SQL Admin course or get one of the books available from WROX or whoever.

You need to have both SQL Server and Executive running under the same real user account (not SYSTEM). This will be a member of the administrator group (and therefore able to use a trusted connection by default), able to "log on as a service" and the password should be fixed.

The client protocol needs to support trusted connections. I quote:

"You can implement replication on servers that have been configured to use any of SQL Server's login security modes. By default, regardless of the security mode the servers are set for, a distribution server connects to a subscription server using a trusted connection (forced integrated security). This means that you must set the SQL Client Configuration Utility on the distribution server (a combined publisher/distributer or a remote distributor) to use Named Pipes or Multi-Protocol as the default network."

Cheers


------------
victor regs at 3/17/99 2:13:31 PM

replication in 6.5
in creating a publication/article, i received an error that
says "could not create file on the replication working directory.verify
your account has write access..." . I gave all the "full control" permission
on the directory(from the root directory until
epldata) but it doesn't
do any good. what exactly permission i need to make this work?

other thing is, on the tasks for the distribution it gave an error
"37000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated with a trusted SQL Server connection."
what does this mean? I am using the standard security mode.
The other processess (logreader and sync) failed with the error trying
to connect.

I am just relying on the books and BOL ,if there are technical books
that explain in details what are the things that need to be done
to make this works please share this.

your favorable response is highly appreciated

thanks.