cant comm with RS

After installing SP1 Report Manager can't communicate with Report Server.
Error says...
Unable to communicate with report server. Please verify that the report
server is operational.
The report server service is running. I rebooted after installing sp1.
Any ideas?
Thanks,
GaryVerify that you can access http://<machinename>/ReportServer. If you can,
make sure this URL is specified in the config file of Report Manager
(RSWebApplication.config).
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Gary D." <Dean@.nospam.com> wrote in message
news:#IQgxtIhEHA.140@.TK2MSFTNGP12.phx.gbl...
> After installing SP1 Report Manager can't communicate with Report Server.
> Error says...
> Unable to communicate with report server. Please verify that the report
> server is operational.
> The report server service is running. I rebooted after installing sp1.
> Any ideas?
> Thanks,
> Gary
>

can't backup DB after detach/attach

I moved a database to a new cluster using detach/attach. Now I am unable to
back it up.
When I do it manually it flashes very quickly saying that it has finished,
but the backup file is only 0 KB. When I run it as part of a maintenance plan
I am getting the following error in the logs:
[2] Database myDB: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'F:\sqlBackups\myDB\myDB_db_200512131435.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
I am able to backup other databases on this instance so I am not sure why
this one is being so persnickity. Please let me know if you have any ideas.
Thanks.
well , have you read error log file ?
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:9D5E94FC-5BAC-424E-8FAE-72B4908248BF@.microsoft.com...
>I moved a database to a new cluster using detach/attach. Now I am unable to
> back it up.
> When I do it manually it flashes very quickly saying that it has finished,
> but the backup file is only 0 KB. When I run it as part of a maintenance
> plan
> I am getting the following error in the logs:
> [2] Database myDB: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC
> SQL
> Server Driver][SQL Server]Cannot open backup device
> 'F:\sqlBackups\myDB\myDB_db_200512131435.BAK'. Device error or device
> off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> terminating abnormally.
>
> I am able to backup other databases on this instance so I am not sure why
> this one is being so persnickity. Please let me know if you have any
> ideas.
> Thanks.
sql

can't backup DB after detach/attach

I moved a database to a new cluster using detach/attach. Now I am unable to
back it up.
When I do it manually it flashes very quickly saying that it has finished,
but the backup file is only 0 KB. When I run it as part of a maintenance pla
n
I am getting the following error in the logs:
[2] Database myDB: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'F:\sqlBackups\myDB\myDB_db_200512131435
.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE i
s
terminating abnormally.
I am able to backup other databases on this instance so I am not sure why
this one is being so persnickity. Please let me know if you have any ideas.
Thanks.well , have you read error log file ?
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:9D5E94FC-5BAC-424E-8FAE-72B4908248BF@.microsoft.com...
>I moved a database to a new cluster using detach/attach. Now I am unable to
> back it up.
> When I do it manually it flashes very quickly saying that it has finished,
> but the backup file is only 0 KB. When I run it as part of a maintenance
> plan
> I am getting the following error in the logs:
> [2] Database myDB: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]
[ODBC
> SQL
> Server Driver][SQL Server]Cannot open backup device
> 'F:\sqlBackups\myDB\myDB_db_200512131435
.BAK'. Device error or device
> off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE
is
> terminating abnormally.
>
> I am able to backup other databases on this instance so I am not sure why
> this one is being so persnickity. Please let me know if you have any
> ideas.
> Thanks.

can't backup DB after detach/attach

I moved a database to a new cluster using detach/attach. Now I am unable to
back it up.
When I do it manually it flashes very quickly saying that it has finished,
but the backup file is only 0 KB. When I run it as part of a maintenance plan
I am getting the following error in the logs:
[2] Database myDB: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'F:\sqlBackups\myDB\myDB_db_200512131435.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
I am able to backup other databases on this instance so I am not sure why
this one is being so persnickity. Please let me know if you have any ideas.
Thanks.well , have you read error log file ?
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:9D5E94FC-5BAC-424E-8FAE-72B4908248BF@.microsoft.com...
>I moved a database to a new cluster using detach/attach. Now I am unable to
> back it up.
> When I do it manually it flashes very quickly saying that it has finished,
> but the backup file is only 0 KB. When I run it as part of a maintenance
> plan
> I am getting the following error in the logs:
> [2] Database myDB: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC
> SQL
> Server Driver][SQL Server]Cannot open backup device
> 'F:\sqlBackups\myDB\myDB_db_200512131435.BAK'. Device error or device
> off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> terminating abnormally.
>
> I am able to backup other databases on this instance so I am not sure why
> this one is being so persnickity. Please let me know if you have any
> ideas.
> Thanks.

can't access server from another PC

I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
that I have been unable to access the SQL Server on my laptop from another
PC. When I go to register it from another PC I get:
"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())"
The database is indeed running so I assume it must be some type of
permission problem. Both PCs are in the same domain. I have tried to connect
using Windows account information and SQL Server login information - both
get the same error. I also tried to connect from another PC to the laptop
with the same error. The laptop can see and access databases on each of
these other PC's so it is just reading from the laptop that is not possible.
I did disable my Norton Internet Security to make sure that the firewall
wasn't interferring but still get the same error.
I'm pulling my hair out and could really use your help. Thanks for taking
the time to read this.
InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connect
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via that?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
Message posted via http://www.droptable.com
|||InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connect
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via that?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200704/1
|||> Are you trying to login via Windows Authentication ? as the error message
> seems that this login does not exist in the Security Logins. Do you have
> an
> SQL Server ID you can just prove its Windows Auth with by logging in via
> that?
I tried to login with the sa account when I used SQL Server login
information and a login that I know is valid on my laptop for the Windows
account information login.
Probably another important piece of information that I didn't mention is
that when trying to register this database from another PC, it never is
displayed as one of the available databases. There is a NAME-LAPTOP database
that shows as available (I assume the default from installing Visual Studio)
but no NAME-LAPTOP\NAME_LAPTOP database as this one is called. I was
wondering if it might help to uninstall and reinstall SQL Server. Do you
know if there are ever any conflict between the Visual Studio db and the
main SQL Server db depending on install order? At this point, I don't
remember which I installed first. At one point, I had installed the Visual
InterDev on the laptop by accident but deleted that and installed Visual
Studio. I don't know if that could have messed anything up or not too.
Using Visual Studio on the laptop I can connect to the
NAME-LAPTOP\NAME_LAPTOP database but if I go to another PC I can't connect
using Visual Studio.

> Alternatively I have had the problem with OS's where it uses Netpipes by
> default which are blocked by the network, to prove this create an ODBC
> with
> IP /Port to the SQL Server and prove this works.
Do you mean create a script to see if I can login that way?.

> --
> Message posted via http://www.droptable.com
>
|||Just to let you all know - the uninstall and reinstall of the database on my
laptop fixed all my problems. I'm sorry I didn't try that from the
beginning.

can't access server from another PC

I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
that I have been unable to access the SQL Server on my laptop from another
PC. When I go to register it from another PC I get:
"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())"
The database is indeed running so I assume it must be some type of
permission problem. Both PCs are in the same domain. I have tried to connect
using Windows account information and SQL Server login information - both
get the same error. I also tried to connect from another PC to the laptop
with the same error. The laptop can see and access databases on each of
these other PC's so it is just reading from the laptop that is not possible.
I did disable my Norton Internet Security to make sure that the firewall
wasn't interferring but still get the same error.
I'm pulling my hair out and could really use your help. Thanks for taking
the time to read this.InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connect
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via that?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
--
Message posted via http://www.sqlmonster.com|||InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connect
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via that?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200704/1|||> Are you trying to login via Windows Authentication ? as the error message
> seems that this login does not exist in the Security Logins. Do you have
> an
> SQL Server ID you can just prove its Windows Auth with by logging in via
> that?
I tried to login with the sa account when I used SQL Server login
information and a login that I know is valid on my laptop for the Windows
account information login.
Probably another important piece of information that I didn't mention is
that when trying to register this database from another PC, it never is
displayed as one of the available databases. There is a NAME-LAPTOP database
that shows as available (I assume the default from installing Visual Studio)
but no NAME-LAPTOP\NAME_LAPTOP database as this one is called. I was
wondering if it might help to uninstall and reinstall SQL Server. Do you
know if there are ever any conflict between the Visual Studio db and the
main SQL Server db depending on install order? At this point, I don't
remember which I installed first. At one point, I had installed the Visual
InterDev on the laptop by accident but deleted that and installed Visual
Studio. I don't know if that could have messed anything up or not too.
Using Visual Studio on the laptop I can connect to the
NAME-LAPTOP\NAME_LAPTOP database but if I go to another PC I can't connect
using Visual Studio.
> Alternatively I have had the problem with OS's where it uses Netpipes by
> default which are blocked by the network, to prove this create an ODBC
> with
> IP /Port to the SQL Server and prove this works.
Do you mean create a script to see if I can login that way?.
> --
> Message posted via http://www.sqlmonster.com
>|||Just to let you all know - the uninstall and reinstall of the database on my
laptop fixed all my problems. I'm sorry I didn't try that from the
beginning.

can't access server from another PC

I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
that I have been unable to access the SQL Server on my laptop from another
PC. When I go to register it from another PC I get:
"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())"
The database is indeed running so I assume it must be some type of
permission problem. Both PCs are in the same domain. I have tried to connect
using Windows account information and SQL Server login information - both
get the same error. I also tried to connect from another PC to the laptop
with the same error. The laptop can see and access databases on each of
these other PC's so it is just reading from the laptop that is not possible.
I did disable my Norton Internet Security to make sure that the firewall
wasn't interferring but still get the same error.
I'm pulling my hair out and could really use your help. Thanks for taking
the time to read this.InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connec
t
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible
.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via tha
t?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
Message posted via http://www.droptable.com|||InNeedOfAssistance wrote:
>I recently reformatted my XP laptop and reinstalled SQL Server. Since I did
>that I have been unable to access the SQL Server on my laptop from another
>PC. When I go to register it from another PC I get:
>"A connection could not be established to NAME-LAPTOP\NAME_LAPTOP.
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect())"
>The database is indeed running so I assume it must be some type of
>permission problem. Both PCs are in the same domain. I have tried to connec
t
>using Windows account information and SQL Server login information - both
>get the same error. I also tried to connect from another PC to the laptop
>with the same error. The laptop can see and access databases on each of
>these other PC's so it is just reading from the laptop that is not possible
.
>I did disable my Norton Internet Security to make sure that the firewall
>wasn't interferring but still get the same error.
>I'm pulling my hair out and could really use your help. Thanks for taking
>the time to read this.
Are you trying to login via Windows Authentication ? as the error message
seems that this login does not exist in the Security Logins. Do you have an
SQL Server ID you can just prove its Windows Auth with by logging in via tha
t?
Alternatively I have had the problem with OS's where it uses Netpipes by
default which are blocked by the network, to prove this create an ODBC with
IP /Port to the SQL Server and prove this works.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200704/1|||> Are you trying to login via Windows Authentication ? as the error message
> seems that this login does not exist in the Security Logins. Do you have
> an
> SQL Server ID you can just prove its Windows Auth with by logging in via
> that?
I tried to login with the sa account when I used SQL Server login
information and a login that I know is valid on my laptop for the Windows
account information login.
Probably another important piece of information that I didn't mention is
that when trying to register this database from another PC, it never is
displayed as one of the available databases. There is a NAME-LAPTOP database
that shows as available (I assume the default from installing Visual Studio)
but no NAME-LAPTOP\NAME_LAPTOP database as this one is called. I was
wondering if it might help to uninstall and reinstall SQL Server. Do you
know if there are ever any conflict between the Visual Studio db and the
main SQL Server db depending on install order? At this point, I don't
remember which I installed first. At one point, I had installed the Visual
InterDev on the laptop by accident but deleted that and installed Visual
Studio. I don't know if that could have messed anything up or not too.
Using Visual Studio on the laptop I can connect to the
NAME-LAPTOP\NAME_LAPTOP database but if I go to another PC I can't connect
using Visual Studio.

> Alternatively I have had the problem with OS's where it uses Netpipes by
> default which are blocked by the network, to prove this create an ODBC
> with
> IP /Port to the SQL Server and prove this works.
Do you mean create a script to see if I can login that way?.

> --
> Message posted via http://www.droptable.com
>|||Just to let you all know - the uninstall and reinstall of the database on my
laptop fixed all my problems. I'm sorry I didn't try that from the
beginning.

cannot save storedproc after SP3

hi
we found a bug in EM. we are unable to save/export/transfer a DTS package to
another remote box. is there any workaround or hotfix available?
AlexAlex
See if this helps
http://www.sqldts.com/default.aspx?6,105,204,0,1
Regards
John|||How are you trying ?
File | Save As | SQL Server ?
File | Save As | Structured Storage File ?
Transferring DTS Packages
http://www.sqldts.com/default.aspx?6,105,204,0,1
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"alex" <ntnewsNO@.SPAM.hrz3.hrz.tu-darmstadt.de> wrote in message
news:OgI#tPoUDHA.1280@.tk2msftngp13.phx.gbl...
> hi
> we found a bug in EM. we are unable to save/export/transfer a DTS package
to
> another remote box. is there any workaround or hotfix available?
>
> Alex
>|||hi
> How are you trying ?
> File | Save As | SQL Server ?
> File | Save As | Structured Storage File ?
this are 3 "save as" options in SP3 and 4 "save as" options in SP2 and
prior.
the third in SP3 is "Visual Basic File". in SP2 there is another Option
"Save as DTS package file" (sorry - the options is gone - i don't know the
exact name). we need this DTS package option for transfer...
Alex

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.
>

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.
>

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.
>

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.
>