The process could not create file - Snapshot Agent fails

[s***@gmail.com]

Hi

It is very simple

Step1:
youneed to check this stored procedure
sp_helpserver

Step2:
Run this stored procedure in Subscriber Master Database..
Syntax:
sp_link_publication @publisher = 'publisher', @publisher_db = 'publication database', @publication = 'publication name', @security_mode = 0, @login = 'sa', @password = 'yoursapassword' @distributor = 'distributor'


----For example
In My system I'm faceing this Here
My publisher = 'VINAYAKA\SERVER2008R2'
My subscriber ='VINAYAKA\SERVER2'
mydistributor = 'VINAYAKA\SERVER1'
publisher_db = 'siva'
publication = 'sivaTp'
login = 'sa'--> Login is your creating your subscriber asking one login that login you use
password = '1122'



sp_link_publication @publisher = 'VINAYAKA\SERVER2008R2', @publisher_db = 'siva', @publication = 'sivaTp', @security_mode = 0, @login = 'sa', @password = 'Vinayaka', @distributor = 'VINAYAKA\SERVER1'

[s***@gmail.com]

Hi

It is very simple

Step1:
youneed to check this stored procedure
sp_helpserver

Step2:
Run this stored procedure in Subscriber Master Database..
Syntax:
sp_link_publication @publisher = 'publisher', @publisher_db = 'publication database', @publication = 'publication name', @security_mode = 0, @login = 'sa', @password = 'yoursapassword' @distributor = 'distributor'


----For example
In My system I'm faceing this Here
My publisher = 'VINAYAKA\SERVER2008R2'
My subscriber ='VINAYAKA\SERVER2'
mydistributor = 'VINAYAKA\SERVER1'
publisher_db = 'siva'
publication = 'sivaTp'
login = 'sa'--> Login is your creating your subscriber asking one login that login you use
password = '1122'



sp_link_publication @publisher = 'VINAYAKA\SERVER2008R2', @publisher_db = 'siva', @publication = 'sivaTp', @security_mode = 0, @login = 'sa', @password = '1122', @distributor = 'VINAYAKA\SERVER1'

[s***@gmail.com]

Hi

It is very simple

Step1:
youneed to check this stored procedure
sp_helpserver

Step2:
Run this stored procedure in Subscriber Master Database..
Syntax:
sp_link_publication @publisher = 'publisher', @publisher_db = 'publication database', @publication = 'publication name', @security_mode = 0, @login = 'sa', @password = 'yoursapassword' @distributor = 'distributor'


----For example
In My system I'm faceing this Here
My publisher = 'VINAYAKA\SERVER2008R2'
My subscriber ='VINAYAKA\SERVER2'
mydistributor = 'VINAYAKA\SERVER1'
publisher_db = 'siva'
publication = 'sivaTp'
login = 'sa'--> Login is your creating your subscriber asking one login that login you use
password = '1122'



sp_link_publication @publisher = 'VINAYAKA\SERVER2008R2', @publisher_db = 'siva', @publication = 'sivaTp', @security_mode = 0, @login = 'sa', @password = 'Vinayaka', @distributor = 'VINAYAKA\SERVER1'

[s***@gmail.com]

Hi

It is very simple

Step1:
youneed to check this stored procedure on your subscriber master database
sp_helpserver

Step2:
Run this stored procedure on Subscriber Master Database..
Syntax:
sp_link_publication @publisher = 'publisher', @publisher_db = 'publication database', @publication = 'publication name', @security_mode = 0, @login = 'sa', @password = 'yoursapassword' @distributor = 'distributor'


----For example
In My system I'm faceing this Here
My publisher = 'VINAYAKA\SERVER2008R2'
My subscriber ='VINAYAKA\SERVER2'
mydistributor = 'VINAYAKA\SERVER1'
publisher_db = 'siva'
publication = 'sivaTp'
login = 'sa'--> Login is your creating your subscriber asking one login that login you use
password = '1122'



sp_link_publication @publisher = 'VINAYAKA\SERVER2008R2', @publisher_db = 'siva', @publication = 'sivaTp', @security_mode = 0, @login = 'sa', @password = 'Vinayaka', @distributor = 'VINAYAKA\SERVER1'

[s***@gmail.com]

Hi

It is very simple

Step1:
youneed to check this stored procedure on your subscriber master database
sp_helpserver

Step2:
Run this stored procedure on Subscriber Master Database..
Syntax:
sp_link_publication @publisher = 'publisher', @publisher_db = 'publication database', @publication = 'publication name', @security_mode = 0, @login = 'sa', @password = 'yoursapassword' @distributor = 'distributor'


----For example
In My system I'm faceing this Here
My publisher = 'VINAYAKA\SERVER2008R2'
My subscriber ='VINAYAKA\SERVER2'
mydistributor = 'VINAYAKA\SERVER1'
publisher_db = 'siva'
publication = 'sivaTp'
login = 'sa'--> Login is your creating your subscriber asking one login that login you use
password = '1122'



sp_link_publication @publisher = 'VINAYAKA\SERVER2008R2', @publisher_db = 'siva', @publication = 'sivaTp', @security_mode = 0, @login = 'sa', @password = '1122', @distributor = 'VINAYAKA\SERVER1'