Mainly to pay attention to the issue of permission, generally release / subscribe, I suggest you prepare as follows:
1. Publish the server, the subscriber is created a Windows user of the same name, and set the same password, as a valid access to the Snapshot folder, the Valid Access User - Control Panel - Manage Tool - Computer Management - User and Group - Right-click User - New User - Create a user who is subjected to WINDOWS in Administrator group
2. On the publishing server, create a shared directory, use the storage directory of the released snapshot file:
My computer - D: / New Directory, named: Pub - Right-click this new directory - Property - Share - Select "Share this Folder" - Press New to set the specific User authority, guarantee that the user created in the first step has all permissions to the folder - determine
3. Set the boot user of the SQL agent (SQLSERVERAGENT "service (publish / subscribe server to do this)
Start - Program - Administrative Tools - Services - Right-Type SQLServerAgent - Properties - Login - Select "This Account" - Enter or select the Windows Login User Name created in the first step - "Password" Enter The user's password
4. Set the SQL Server authentication mode to resolve the permissions when the connection is resolved (the release / subscriber is doing this setting)
Enterprise Manager - Right-click SQL Instance - Property - Security - Authentication - Select "SQL Server and Windows" - OK
5. Registered Enterprise Manager on the Publisher and Subscriber - Right-click SQL Server Group - New SQL Server Registration ... - Next - In the available server, enter the remote server name you want to register - Add - Next - Connection, select Second "SQL Server Authentication" - Next - Enter Username and Password - Next - Select SQL Server Group, you can also create a new group - Step - complete
6. For use only IP, you cannot use the computer name, the server alias (on the connection end configuration, for example, if you configure on the subscriber, the IP of the publish server is start-program-program- -Microsoft SQL Server - Client Network Utility - Alias - Add - Network Library Select "TCP / IP" - Server Alias Enter SQL Server Name - Connection Parameters - Enter SQL Server IP Address in Server Name - - If you modify the port of SQL, deselect "Dynamic Decision Port" and enter the corresponding port number
