Alrighty... This has been a bugger of a pain all day.
We have Enterprise RS on our test server - only the web part. The databases are located on the test sql server, and both servers are more than happy to talk to each other just fine. On the webserver where report manager is, we have tossed the default website and relocated the virtual directories to a different website, which is accesible over the network via an ip address. I can get into the report manager just fine.
Here's the problem: when I click on a report in the report manager, I cannot view the report. Initially the problem was that it would give a 403 access forbidden message, which doesn't make sense since the user was a content manager and full rights were available across the board. Now after several hours of playing it gives an action cancelled, cannot link to the requested webpage error. It gives it on any report, but I can access the report properties just fine. I can get into data sources just fine as well.
Upon reading something in here, I've tried editing the RSWebApplication.config file to change the
<ReportServerUrl>http://TestWWW/ReportServer</ReportServerUrl>
value to
<ReportServerUrl>http://10.1.1.74/ReportServer</ReportServerUrl>
which is the address of the site it should be located at. When I do that and save it, it get's kinda interesting - when I try to view any report, I get a directory listing (with it enabled for the directory) of 10.1.1.74 - /ReportServer/. Then when I click any of the directories, it takes me to 10.1.1.74/ReportServer/ - (note the change in hyphens) which displays all the uploaded files on the report server. If I click on a report, it displays the report!
What the heck is going on? Anyone seen this and fixed it?
- TCorrection: when I said it displayed the report, I spoke too soon. It brings up the window with the standard report bars, but hangs with the green spinning generation graphic.
Showing posts with label located. Show all posts
Showing posts with label located. Show all posts
Monday, March 19, 2012
Friday, February 10, 2012
Cannot restore database from a remote server
I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.
Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
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/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>
|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.
Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
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/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>
|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
Cannot restore database from a remote server
I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
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/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
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/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
Cannot restore database from a remote server
I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
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/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
--
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
>> I am unable to restore a new database from a backup located in a
>> different
>> server. The MSSQLSERVER service starts with the same network
> administrator,
>> who has sysadmin rights, for both servers. The problem is that when
> trying
>> to restore from the Enterprise Manager I cannot see the mapped drive nor
> can
>> I setup a backup device to the computer containing the backup. Are there
>> any pointers that any of you can give me on how to resolve this problem?
>> Thanks in advance for your help.
>>
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
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/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
--
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
>> I am unable to restore a new database from a backup located in a
>> different
>> server. The MSSQLSERVER service starts with the same network
> administrator,
>> who has sysadmin rights, for both servers. The problem is that when
> trying
>> to restore from the Enterprise Manager I cannot see the mapped drive nor
> can
>> I setup a backup device to the computer containing the backup. Are there
>> any pointers that any of you can give me on how to resolve this problem?
>> Thanks in advance for your help.
>>
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
Cannot restore database from a remote server
I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.
Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
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/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>
|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.
Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
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/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>
|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
Subscribe to:
Posts (Atom)