Forum Discussion
REPLICACIONES EN SQL SERVER
Hola mi gente soy nuevo por aqui, necesito de su ayuda trato de replicar una base de datos local hacia Azure (en la nube) pero me da un error y no replica y no se que podra ser.
- bake13Microsoft
Hola Jonathan1998 -- Azure SQL Database as a replication subscriber only supports SQL Authentication and from the error you included, it appears you were trying to use Windows Authentication. Note the third bullet point on link below. Take care.
- Jonathan1998Copper Contributor
- bake13Microsoft
Hola Jonathan1998 -- The screen capture is difficult to read, but I believe the error is that is access is denied to the Snapshot Agent directory. For this, ensure that the account running the snapshot agent process has write access to the specified directory.
So if I am understanding your environment correctly, only the connection to the Subscriber (Azure SQL Database) will use SQL authentication. The Distribution and Snapshot agents will use Integrated Authentication. Take care.