When a subscription send an email with the report attached, Outlook 2002 does
not show that there is an attachment or have the ability to open it.
I have tested this by using Outlook 2003 and a Web Email Client to get the
same email, and the attachment is present in all cases except for Outlook
2002. I have also forwarded the email from Outlook 2003 to 2002 and the
attachment is not present, but if I save the attachment in Outlook 2003 and
attach it to an email and send it to 2002 the attachment is available.
--
HaroldsHi Harolds,
- Does your attachment contains all English language information?
- What's the mail server you are using? Exchange Server 2000 or Exchange
Server 2003?
- Have you upgraded to the latest version of SQL Server 2000 Reporting
Services SP2 or SQL Server 2005 Reporting Services?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||-Yes the attachment contains all English language information.
-We do not use exchange server
-I am not sure but I believe we are using SP2, how would I know which
version of SQL Server 2000 Reporting services we are using.
--
Harolds
"Michael Cheng [MSFT]" wrote:
> Hi Harolds,
> - Does your attachment contains all English language information?
> - What's the mail server you are using? Exchange Server 2000 or Exchange
> Server 2003?
> - Have you upgraded to the latest version of SQL Server 2000 Reporting
> Services SP2 or SQL Server 2005 Reporting Services?
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi,
If you are not using Exchange Server, what mail server you are using? We
have an known issue with IBM Lotus Domino servers as it cannot load the
attachment, and the reports appear as a zero-byte file attachment. Check
the KB below for more detailed information.
FIX: You may receive a zero-byte attachment in e-mail when e-mail
subscriptions are sent to Lotus Domino e-mail servers by SQL Server 2000
Reporting Services
http://support.microsoft.com/?id=872774
To identify whether you have upgraded to SQL Server 2000 Service Pack 2,
you may go to the report server via link <http://<machine>/reportserver> to
see the bottom line
If it appears to be 8.00.1038, you have upgraded to SP2
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||This problem is not in the mail server, because Outlook 2003 has NO problems
with the attachment, also the mail server (CommuniGate Pro) has a web
interface for which it also has NO problems with the attachment. The problem
is that Outlook 2002 doesn't recognize the fact that the email from the
report server has an attachment.
--
Harolds
"Michael Cheng [MSFT]" wrote:
> Hi,
> If you are not using Exchange Server, what mail server you are using? We
> have an known issue with IBM Lotus Domino servers as it cannot load the
> attachment, and the reports appear as a zero-byte file attachment. Check
> the KB below for more detailed information.
> FIX: You may receive a zero-byte attachment in e-mail when e-mail
> subscriptions are sent to Lotus Domino e-mail servers by SQL Server 2000
> Reporting Services
> http://support.microsoft.com/?id=872774
> To identify whether you have upgraded to SQL Server 2000 Service Pack 2,
> you may go to the report server via link <http://<machine>/reportserver> to
> see the bottom line
> If it appears to be 8.00.1038, you have upgraded to SP2
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Harolds,
I understand it is only Outlook 2002 that you will encounter the error
with. However, we must check the whole process internally from Reporting
Services to Mail Server and Outlook 2002. This work had be to done by
opening a Support incident with Microsoft Customer Service and Support so
that a dedicated Support Professional can assist with this case. If you
need any help in this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.sql
Showing posts with label subscription. Show all posts
Showing posts with label subscription. Show all posts
Wednesday, March 28, 2012
Monday, February 20, 2012
OS error 5 in PULL Subscription
I am getting the error:
The process could not read file
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1\20050203112524\Table1.
sch' due to OS error 5. The step failed.
when trying to start a PULL subscription in SQL Server 7.0.
The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1' path has all
rights given to Everyone.
Any ideas?
-WillError 5 is Access denied. So check both, NTFS and Share permissions, ant try
to connect there using Agents account.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Will T" <unknown@.nowhere.net> wrote in message
news:O0cODFiCFHA.3280@.TK2MSFTNGP14.phx.gbl...
> I am getting the error:
> The process could not read file
>
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1\20050203112524\Table1.
> sch' due to OS error 5. The step failed.
> when trying to start a PULL subscription in SQL Server 7.0.
> The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1' path has all
> rights given to Everyone.
> Any ideas?
> -Will
>|||I am connecting using the sa account on the Distributor. What NT account
would that be?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OmSaYNiCFHA.1392@.tk2msftngp13.phx.gbl...
> Error 5 is Access denied. So check both, NTFS and Share permissions, ant
try
> to connect there using Agents account.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Will T" <unknown@.nowhere.net> wrote in message
> news:O0cODFiCFHA.3280@.TK2MSFTNGP14.phx.gbl...
> > I am getting the error:
> >
> > The process could not read file
> >
>
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1\20050203112524\Table1.
> > sch' due to OS error 5. The step failed.
> >
> > when trying to start a PULL subscription in SQL Server 7.0.
> >
> > The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1' path has all
> > rights given to Everyone.
> >
> > Any ideas?
> >
> > -Will
> >
> >
>|||Is that a hidden public share or is it the admin share? It
looks like an admin share and if it's an administrative
share, the account needs to be an admin on the box to access
the share. Or you need to create a public share with the
appropriate rights, permissions.
-Sue
On Thu, 3 Feb 2005 13:50:40 -0500, "Will T"
<unknown@.nowhere.net> wrote:
>I am getting the error:
>The process could not read file
>'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1\20050203112524\Table1.
>sch' due to OS error 5. The step failed.
>when trying to start a PULL subscription in SQL Server 7.0.
>The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1' path has all
>rights given to Everyone.
>Any ideas?
>-Will
>|||Will,
Dejan is referring to the SQL Server Agent on your subscriber. That is a
service running as a domain user which should have the right to read files
from the distribution working folder. Log on to the subscriber using this
same account and try to read files from the DWF to double-check that rights
are set up correctly.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Well spotted Sue,
- Will, typically you'd share \\MYSERVER\ReplData
Rgds,
Paul Ibison|||Thanks for the clarification. I will look in to it.
Thanks,
Will
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uC$9qAjCFHA.3732@.TK2MSFTNGP14.phx.gbl...
> Will,
> Dejan is referring to the SQL Server Agent on your subscriber. That is a
> service running as a domain user which should have the right to read files
> from the distribution working folder. Log on to the subscriber using this
> same account and try to read files from the DWF to double-check that
rights
> are set up correctly.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||The '\\MYSERVER\ReplData' is shared to Everyone. Thanks.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b505011s7n93vo5p6cd8v6hin7e6ho8013@.4ax.com...
> Is that a hidden public share or is it the admin share? It
> looks like an admin share and if it's an administrative
> share, the account needs to be an admin on the box to access
> the share. Or you need to create a public share with the
> appropriate rights, permissions.
> -Sue
> On Thu, 3 Feb 2005 13:50:40 -0500, "Will T"
> <unknown@.nowhere.net> wrote:
> >I am getting the error:
> >
> >The process could not read file
>'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1\20050203112524\Table1
.
> >sch' due to OS error 5. The step failed.
> >
> >when trying to start a PULL subscription in SQL Server 7.0.
> >
> >The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1' path has all
> >rights given to Everyone.
> >
> >Any ideas?
> >
> >-Will
> >
>|||Thank you all for the information. The account on the local MSDE machine was
only a local account. I changed it to an account on the network and it now
works fine.
Q: is it standard practice to make an accoutn just for this type of thing?
-Will
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uC$9qAjCFHA.3732@.TK2MSFTNGP14.phx.gbl...
> Will,
> Dejan is referring to the SQL Server Agent on your subscriber. That is a
> service running as a domain user which should have the right to read files
> from the distribution working folder. Log on to the subscriber using this
> same account and try to read files from the DWF to double-check that
rights
> are set up correctly.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||If you need the SQL Server to access anything outside of its own process eg
mail, reporting services, replication, then a domain user is mandatory. We
tend to have a separate domain user account for each server, although we
have some non-trusted domains so this is mandatory. This account is a local
administrator, but not a domain admin. I have also seen places where the
same account is used for each sql server. In part I guess it depends on how
securely you guard your passwords - in the one-for-all scenario, if the
password is compromised, you lose control of all your servers.
HTH,
Paul Ibison (SQL Server MVP)
The process could not read file
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1\20050203112524\Table1.
sch' due to OS error 5. The step failed.
when trying to start a PULL subscription in SQL Server 7.0.
The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1' path has all
rights given to Everyone.
Any ideas?
-WillError 5 is Access denied. So check both, NTFS and Share permissions, ant try
to connect there using Agents account.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Will T" <unknown@.nowhere.net> wrote in message
news:O0cODFiCFHA.3280@.TK2MSFTNGP14.phx.gbl...
> I am getting the error:
> The process could not read file
>
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1\20050203112524\Table1.
> sch' due to OS error 5. The step failed.
> when trying to start a PULL subscription in SQL Server 7.0.
> The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1' path has all
> rights given to Everyone.
> Any ideas?
> -Will
>|||I am connecting using the sa account on the Distributor. What NT account
would that be?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OmSaYNiCFHA.1392@.tk2msftngp13.phx.gbl...
> Error 5 is Access denied. So check both, NTFS and Share permissions, ant
try
> to connect there using Agents account.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Will T" <unknown@.nowhere.net> wrote in message
> news:O0cODFiCFHA.3280@.TK2MSFTNGP14.phx.gbl...
> > I am getting the error:
> >
> > The process could not read file
> >
>
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1\20050203112524\Table1.
> > sch' due to OS error 5. The step failed.
> >
> > when trying to start a PULL subscription in SQL Server 7.0.
> >
> > The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1' path has all
> > rights given to Everyone.
> >
> > Any ideas?
> >
> > -Will
> >
> >
>|||Is that a hidden public share or is it the admin share? It
looks like an admin share and if it's an administrative
share, the account needs to be an admin on the box to access
the share. Or you need to create a public share with the
appropriate rights, permissions.
-Sue
On Thu, 3 Feb 2005 13:50:40 -0500, "Will T"
<unknown@.nowhere.net> wrote:
>I am getting the error:
>The process could not read file
>'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1\20050203112524\Table1.
>sch' due to OS error 5. The step failed.
>when trying to start a PULL subscription in SQL Server 7.0.
>The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1' path has all
>rights given to Everyone.
>Any ideas?
>-Will
>|||Will,
Dejan is referring to the SQL Server Agent on your subscriber. That is a
service running as a domain user which should have the right to read files
from the distribution working folder. Log on to the subscriber using this
same account and try to read files from the DWF to double-check that rights
are set up correctly.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Well spotted Sue,
- Will, typically you'd share \\MYSERVER\ReplData
Rgds,
Paul Ibison|||Thanks for the clarification. I will look in to it.
Thanks,
Will
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uC$9qAjCFHA.3732@.TK2MSFTNGP14.phx.gbl...
> Will,
> Dejan is referring to the SQL Server Agent on your subscriber. That is a
> service running as a domain user which should have the right to read files
> from the distribution working folder. Log on to the subscriber using this
> same account and try to read files from the DWF to double-check that
rights
> are set up correctly.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||The '\\MYSERVER\ReplData' is shared to Everyone. Thanks.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b505011s7n93vo5p6cd8v6hin7e6ho8013@.4ax.com...
> Is that a hidden public share or is it the admin share? It
> looks like an admin share and if it's an administrative
> share, the account needs to be an admin on the box to access
> the share. Or you need to create a public share with the
> appropriate rights, permissions.
> -Sue
> On Thu, 3 Feb 2005 13:50:40 -0500, "Will T"
> <unknown@.nowhere.net> wrote:
> >I am getting the error:
> >
> >The process could not read file
>'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1\20050203112524\Table1
.
> >sch' due to OS error 5. The step failed.
> >
> >when trying to start a PULL subscription in SQL Server 7.0.
> >
> >The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSERVER_PUB1_PUB1' path has all
> >rights given to Everyone.
> >
> >Any ideas?
> >
> >-Will
> >
>|||Thank you all for the information. The account on the local MSDE machine was
only a local account. I changed it to an account on the network and it now
works fine.
Q: is it standard practice to make an accoutn just for this type of thing?
-Will
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uC$9qAjCFHA.3732@.TK2MSFTNGP14.phx.gbl...
> Will,
> Dejan is referring to the SQL Server Agent on your subscriber. That is a
> service running as a domain user which should have the right to read files
> from the distribution working folder. Log on to the subscriber using this
> same account and try to read files from the DWF to double-check that
rights
> are set up correctly.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||If you need the SQL Server to access anything outside of its own process eg
mail, reporting services, replication, then a domain user is mandatory. We
tend to have a separate domain user account for each server, although we
have some non-trusted domains so this is mandatory. This account is a local
administrator, but not a domain admin. I have also seen places where the
same account is used for each sql server. In part I guess it depends on how
securely you guard your passwords - in the one-for-all scenario, if the
password is compromised, you lose control of all your servers.
HTH,
Paul Ibison (SQL Server MVP)
OS error 5 in PULL Subscription
I am getting the error:
The process could not read file
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1\20050203112524\Table1.
sch' due to OS error 5. The step failed.
when trying to start a PULL subscription in SQL Server 7.0.
The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1' path has all
rights given to Everyone.
Any ideas?
-WillError 5 is Access denied. So check both, NTFS and Share permissions, ant try
to connect there using Agents account.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Will T" <unknown@.nowhere.net> wrote in message
news:O0cODFiCFHA.3280@.TK2MSFTNGP14.phx.gbl...
> I am getting the error:
> The process could not read file
>
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1\20050203112524\Table1.
> sch' due to OS error 5. The step failed.
> when trying to start a PULL subscription in SQL Server 7.0.
> The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1' path has all
> rights given to Everyone.
> Any ideas?
> -Will
>|||I am connecting using the sa account on the Distributor. What NT account
would that be?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OmSaYNiCFHA.1392@.tk2msftngp13.phx.gbl...
> Error 5 is Access denied. So check both, NTFS and Share permissions, ant
try
> to connect there using Agents account.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Will T" <unknown@.nowhere.net> wrote in message
> news:O0cODFiCFHA.3280@.TK2MSFTNGP14.phx.gbl...
>
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1\20050203112524\Table1.
>|||Is that a hidden public share or is it the admin share? It
looks like an admin share and if it's an administrative
share, the account needs to be an admin on the box to access
the share. Or you need to create a public share with the
appropriate rights, permissions.
-Sue
On Thu, 3 Feb 2005 13:50:40 -0500, "Will T"
<unknown@.nowhere.net> wrote:
>I am getting the error:
>The process could not read file
> '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1\20050203112524\Table1
.
>sch' due to OS error 5. The step failed.
>when trying to start a PULL subscription in SQL Server 7.0.
>The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1' path has all
>rights given to Everyone.
>Any ideas?
>-Will
>|||Will,
Dejan is referring to the SQL Server Agent on your subscriber. That is a
service running as a domain user which should have the right to read files
from the distribution working folder. Log on to the subscriber using this
same account and try to read files from the DWF to double-check that rights
are set up correctly.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Well spotted Sue,
- Will, typically you'd share \\MYSERVER\ReplData
Rgds,
Paul Ibison|||Thanks for the clarification. I will look in to it.
Thanks,
Will
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uC$9qAjCFHA.3732@.TK2MSFTNGP14.phx.gbl...
> Will,
> Dejan is referring to the SQL Server Agent on your subscriber. That is a
> service running as a domain user which should have the right to read files
> from the distribution working folder. Log on to the subscriber using this
> same account and try to read files from the DWF to double-check that
rights
> are set up correctly.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||The '\\MYSERVER\ReplData' is shared to Everyone. Thanks.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b505011s7n93vo5p6cd8v6hin7e6ho8013@.
4ax.com...
> Is that a hidden public share or is it the admin share? It
> looks like an admin share and if it's an administrative
> share, the account needs to be an admin on the box to access
> the share. Or you need to create a public share with the
> appropriate rights, permissions.
> -Sue
> On Thu, 3 Feb 2005 13:50:40 -0500, "Will T"
> <unknown@.nowhere.net> wrote:
>
> '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1\20050203112524\Table1
.
>|||Thank you all for the information. The account on the local MSDE machine was
only a local account. I changed it to an account on the network and it now
works fine.
Q: is it standard practice to make an accoutn just for this type of thing?
-Will
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uC$9qAjCFHA.3732@.TK2MSFTNGP14.phx.gbl...
> Will,
> Dejan is referring to the SQL Server Agent on your subscriber. That is a
> service running as a domain user which should have the right to read files
> from the distribution working folder. Log on to the subscriber using this
> same account and try to read files from the DWF to double-check that
rights
> are set up correctly.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||If you need the SQL Server to access anything outside of its own process eg
mail, reporting services, replication, then a domain user is mandatory. We
tend to have a separate domain user account for each server, although we
have some non-trusted domains so this is mandatory. This account is a local
administrator, but not a domain admin. I have also seen places where the
same account is used for each sql server. In part I guess it depends on how
securely you guard your passwords - in the one-for-all scenario, if the
password is compromised, you lose control of all your servers.
HTH,
Paul Ibison (SQL Server MVP)
The process could not read file
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1\20050203112524\Table1.
sch' due to OS error 5. The step failed.
when trying to start a PULL subscription in SQL Server 7.0.
The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1' path has all
rights given to Everyone.
Any ideas?
-WillError 5 is Access denied. So check both, NTFS and Share permissions, ant try
to connect there using Agents account.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Will T" <unknown@.nowhere.net> wrote in message
news:O0cODFiCFHA.3280@.TK2MSFTNGP14.phx.gbl...
> I am getting the error:
> The process could not read file
>
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1\20050203112524\Table1.
> sch' due to OS error 5. The step failed.
> when trying to start a PULL subscription in SQL Server 7.0.
> The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1' path has all
> rights given to Everyone.
> Any ideas?
> -Will
>|||I am connecting using the sa account on the Distributor. What NT account
would that be?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:OmSaYNiCFHA.1392@.tk2msftngp13.phx.gbl...
> Error 5 is Access denied. So check both, NTFS and Share permissions, ant
try
> to connect there using Agents account.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Will T" <unknown@.nowhere.net> wrote in message
> news:O0cODFiCFHA.3280@.TK2MSFTNGP14.phx.gbl...
>
'\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1\20050203112524\Table1.
>|||Is that a hidden public share or is it the admin share? It
looks like an admin share and if it's an administrative
share, the account needs to be an admin on the box to access
the share. Or you need to create a public share with the
appropriate rights, permissions.
-Sue
On Thu, 3 Feb 2005 13:50:40 -0500, "Will T"
<unknown@.nowhere.net> wrote:
>I am getting the error:
>The process could not read file
> '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1\20050203112524\Table1
.
>sch' due to OS error 5. The step failed.
>when trying to start a PULL subscription in SQL Server 7.0.
>The '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1' path has all
>rights given to Everyone.
>Any ideas?
>-Will
>|||Will,
Dejan is referring to the SQL Server Agent on your subscriber. That is a
service running as a domain user which should have the right to read files
from the distribution working folder. Log on to the subscriber using this
same account and try to read files from the DWF to double-check that rights
are set up correctly.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||Well spotted Sue,
- Will, typically you'd share \\MYSERVER\ReplData
Rgds,
Paul Ibison|||Thanks for the clarification. I will look in to it.
Thanks,
Will
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uC$9qAjCFHA.3732@.TK2MSFTNGP14.phx.gbl...
> Will,
> Dejan is referring to the SQL Server Agent on your subscriber. That is a
> service running as a domain user which should have the right to read files
> from the distribution working folder. Log on to the subscriber using this
> same account and try to read files from the DWF to double-check that
rights
> are set up correctly.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||The '\\MYSERVER\ReplData' is shared to Everyone. Thanks.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b505011s7n93vo5p6cd8v6hin7e6ho8013@.
4ax.com...
> Is that a hidden public share or is it the admin share? It
> looks like an admin share and if it's an administrative
> share, the account needs to be an admin on the box to access
> the share. Or you need to create a public share with the
> appropriate rights, permissions.
> -Sue
> On Thu, 3 Feb 2005 13:50:40 -0500, "Will T"
> <unknown@.nowhere.net> wrote:
>
> '\\MYSERVER\D$\MSSQL7\ReplData\unc\MYSER
VER_PUB1_PUB1\20050203112524\Table1
.
>|||Thank you all for the information. The account on the local MSDE machine was
only a local account. I changed it to an account on the network and it now
works fine.
Q: is it standard practice to make an accoutn just for this type of thing?
-Will
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uC$9qAjCFHA.3732@.TK2MSFTNGP14.phx.gbl...
> Will,
> Dejan is referring to the SQL Server Agent on your subscriber. That is a
> service running as a domain user which should have the right to read files
> from the distribution working folder. Log on to the subscriber using this
> same account and try to read files from the DWF to double-check that
rights
> are set up correctly.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||If you need the SQL Server to access anything outside of its own process eg
mail, reporting services, replication, then a domain user is mandatory. We
tend to have a separate domain user account for each server, although we
have some non-trusted domains so this is mandatory. This account is a local
administrator, but not a domain admin. I have also seen places where the
same account is used for each sql server. In part I guess it depends on how
securely you guard your passwords - in the one-for-all scenario, if the
password is compromised, you lose control of all your servers.
HTH,
Paul Ibison (SQL Server MVP)
Subscribe to:
Posts (Atom)