Showing posts with label successfully. Show all posts
Showing posts with label successfully. Show all posts

Wednesday, March 21, 2012

Location of ReportServer\Styles

Hi,

I have successfully modified HTMLViewer.css to a different version, and using rc:stylesheet = <stylesheet> can view the modified report control bar by running the report via a URL.

However, is it possible to relocate the styles directory from its default location of

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\Styles

so it can reside with our report configurations?

Regards

Kevin.

You can not change the location where RS picks up the styles.

Friday, March 9, 2012

LOCAL USER vs GLOBAL USER set in agent service

My replication is not working. I was able to create a transactional replication successfully. However, when i tried starting the agent on the snapshot, it wouldn't work. I figure that it was because my agent service login is different from that of the subscriber. my publisher and distributor is on local user whereas my subsciber sql services use our global login.

Thank you in advance. Good day!

Can you post the error message you're seeing while trying to start snapshot agent job? From that we can confirm whether the issue you're seeing is due to agent account setup. Sometimes the issue may be caused by local user doesn't have permission on network resources.

Thanks,

Zhiqiang Feng

|||

mongol wrote:

My replication is not working. I was able to create a transactional replication successfully. However, when i tried starting the agent on the snapshot, it wouldn't work. I figure that it was because my agent service login is different from that of the subscriber. my publisher and distributor is on local user whereas my subsciber sql services use our global login.

Thank you in advance. Good day!

hi mongol

be sure the the login used by the service has an NTFS permission in the

replication shared folder

and the services has also write permission to the replication target database