Hello,
My reports access the class File, a builtin class in the .NET Framework,
to check whether a file exists on a network drive somewhere. I use the File.Exists
method if that's ny help.
What I saw initally was that File.Exists returned false in every instance,
even if the file I was checked existed. I raised the trust level in the ReportServer
by editing the rssrvpolicy.config and setting the FirstMatchCodeGroup to
FullTrust. This made the code work when I access the report server locally
using Remote Desktop, however if I access the ReportServer remotely using
the machine name in the browser the call the File.Exists fails even with
the modifications to rssrvpolicy.config in place.
Does anyone have any idea as to what makes it work locally but not remotely?
--
Med venlig hilsen,
Søren Lund
www.publicvoid.dkI should mention that this is Reporting Services for SQL Server 2000 SP2
running on a Windows Server 2003 machine.
Showing posts with label exists. Show all posts
Showing posts with label exists. Show all posts
Tuesday, March 6, 2012
Thursday, February 9, 2012
Access Denied Error when attaching a Database file
I have a server that crashed, so a new OS was installed. I now have access
to the drive where the database file exists. I am now trying to either copy
that file onto a new server or reattach it to a new insance of SQL Server.
In both cases I get a Access denied error.
Any suggestions on how to get around this ?
Thanks in advance,
WayneMHi
Right click on the File > Properties, Security Tab.
Change the permissions that you can access it.
You may want to login as administrator and take ownership of the directory
too.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"WayneM" <WayneM@.discussions.microsoft.com> wrote in message
news:66CD847E-6B85-41C7-AC03-491E4B6D32A2@.microsoft.com...
>I have a server that crashed, so a new OS was installed. I now have access
> to the drive where the database file exists. I am now trying to either
> copy
> that file onto a new server or reattach it to a new insance of SQL Server.
> In both cases I get a Access denied error.
> Any suggestions on how to get around this ?
> Thanks in advance,
> WayneM|||Hi,
See if the SQL Server service starup accoung have read/write access to the
folder.
Thanks
Hari
SQL Server MVP
"WayneM" <WayneM@.discussions.microsoft.com> wrote in message
news:66CD847E-6B85-41C7-AC03-491E4B6D32A2@.microsoft.com...
>I have a server that crashed, so a new OS was installed. I now have access
> to the drive where the database file exists. I am now trying to either
> copy
> that file onto a new server or reattach it to a new insance of SQL Server.
> In both cases I get a Access denied error.
> Any suggestions on how to get around this ?
> Thanks in advance,
> WayneM|||Is it possible that the database file is corrupted? I am able to copy the
Master database file, but not my application database. Is there a simple wa
y
to determine if the file is or is not corrupted?
Thanks,
WayneM
"Hari Prasad" wrote:
> Hi,
> See if the SQL Server service starup accoung have read/write access to the
> folder.
> Thanks
> Hari
> SQL Server MVP
> "WayneM" <WayneM@.discussions.microsoft.com> wrote in message
> news:66CD847E-6B85-41C7-AC03-491E4B6D32A2@.microsoft.com...
>
>|||Is there a backup of these database(s), and is the backup file on a
different hard drive or server?
Regards,
Keith
This posting is provided "as is" without inferring rights or warranties.
"WayneM" <WayneM@.discussions.microsoft.com> wrote in message
news:360AE82B-6E0D-4B75-847C-9C79247CDCFD@.microsoft.com...[vbcol=seagreen]
> Is it possible that the database file is corrupted? I am able to copy the
> Master database file, but not my application database. Is there a simple
> way
> to determine if the file is or is not corrupted?
> Thanks,
> WayneM
> "Hari Prasad" wrote:
>
to the drive where the database file exists. I am now trying to either copy
that file onto a new server or reattach it to a new insance of SQL Server.
In both cases I get a Access denied error.
Any suggestions on how to get around this ?
Thanks in advance,
WayneMHi
Right click on the File > Properties, Security Tab.
Change the permissions that you can access it.
You may want to login as administrator and take ownership of the directory
too.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"WayneM" <WayneM@.discussions.microsoft.com> wrote in message
news:66CD847E-6B85-41C7-AC03-491E4B6D32A2@.microsoft.com...
>I have a server that crashed, so a new OS was installed. I now have access
> to the drive where the database file exists. I am now trying to either
> copy
> that file onto a new server or reattach it to a new insance of SQL Server.
> In both cases I get a Access denied error.
> Any suggestions on how to get around this ?
> Thanks in advance,
> WayneM|||Hi,
See if the SQL Server service starup accoung have read/write access to the
folder.
Thanks
Hari
SQL Server MVP
"WayneM" <WayneM@.discussions.microsoft.com> wrote in message
news:66CD847E-6B85-41C7-AC03-491E4B6D32A2@.microsoft.com...
>I have a server that crashed, so a new OS was installed. I now have access
> to the drive where the database file exists. I am now trying to either
> copy
> that file onto a new server or reattach it to a new insance of SQL Server.
> In both cases I get a Access denied error.
> Any suggestions on how to get around this ?
> Thanks in advance,
> WayneM|||Is it possible that the database file is corrupted? I am able to copy the
Master database file, but not my application database. Is there a simple wa
y
to determine if the file is or is not corrupted?
Thanks,
WayneM
"Hari Prasad" wrote:
> Hi,
> See if the SQL Server service starup accoung have read/write access to the
> folder.
> Thanks
> Hari
> SQL Server MVP
> "WayneM" <WayneM@.discussions.microsoft.com> wrote in message
> news:66CD847E-6B85-41C7-AC03-491E4B6D32A2@.microsoft.com...
>
>|||Is there a backup of these database(s), and is the backup file on a
different hard drive or server?
Regards,
Keith
This posting is provided "as is" without inferring rights or warranties.
"WayneM" <WayneM@.discussions.microsoft.com> wrote in message
news:360AE82B-6E0D-4B75-847C-9C79247CDCFD@.microsoft.com...[vbcol=seagreen]
> Is it possible that the database file is corrupted? I am able to copy the
> Master database file, but not my application database. Is there a simple
> way
> to determine if the file is or is not corrupted?
> Thanks,
> WayneM
> "Hari Prasad" wrote:
>
Subscribe to:
Posts (Atom)