July 28, 2011 at 9:22 am
I'm connected to SQL 2008 R2 sp1 via SSMS as myDomain\User1
I am receiving error message trying to setup PULL SUBSCRIPTION from remote server
Could not connect to server 'myServer' because 'myServer' is not defined as a remote server. Verify that you have specified the correct server name.
This is a misleading messge. When I change my permissions for myDomain\User1 to sysdamin on the publication server, I am able to setup the PULL subsription.
Reading thru Microsofts documentation on security model for PULL SUBSCRIBERS, I cannot locate any special permissions required. (fyi, all snapshot share folder permissions are set appropriately)
thoughts?
August 2, 2011 at 5:20 am
A second business unit is still receiving this same error.. (trying to create a PULL SUBSCRIPTION):
error: Could not connect to server 'MyServer\MyInstance' because 'MyServer\MyInstance' is not defined as a remote server. Verify that you have specified the correct server name
As the DBA w/ sysadmin and being local admin on the publication\distribution SQL Server 2008 R2 box, I am able to setup the PULL SUBSCRIPTION to the remote box. I've checked the snapshot folder permissions (sharing and security) and the SQL permissions for the user. Cannot seem to locate why these users cannot create PULL SUBSCRIPTIONs ?
Has the security level changed in SQL 2008 R2 \ Windows Server 2008 requiring addt'l permisisons to creat a PULL SUBSCRIPTION?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply