>Hi friends, I have two MS SQL Servers, one is away from the other in another building at several Kilomters. The other building's users access the first SQL server through the Internet but the speed is sometimes very slow so, I guess I need to replicate the database to the second sql server so that those users access the data locally, they just need to query or report data on line but do not make changes. Is that a good solution? Or is there a better solution?
>
>On the other hand I'm trying to create a replication with a test database I tell it to use the server as its own Distributor, and when the Replication Wizard asks me to specify a Snapshot Folder I enter "\\MyServer\D$\ReplData" which is what the wizard puts by default, the folder exists on the server, but when I click on the "Next" button. It shows me a message telling the following:
>
>"The snapshot folder '\\MyServer\D$\ReplData', uses a special share name which can usually be accessed only by a login with administratives privileges on computer 'MyServer'. This share may not be accesible by agents running on other computers, such as the agents for pull subscriptions.
>
>Are you sure you want to use this snapshot folder path?"
>
>What can I do at this point? What is the right way to specify a snapshot folder path?

It seems to me that you should create a "real" share on the server and reference it.