Greetings,
One of the DBs on my mssql server should ask for a login and password to change content. The content/DB is access via web page. Any suggestions as to why it has suddenly stopped challenging the user for login? I checked the services and all the necessary ones seems to be running.:confused:
Thanks in advance.
spdunneCheck your web browser settings. It is probably cached some how. Make sure you delete all cookies, history, etc. and try again.
Also make sure that the website is not using windows authentication; this will automatically log you into the db.
I suspect that this issue is either with the browser or web page, not the DB.
Good luck,
Hope this helped
Showing posts with label via. Show all posts
Showing posts with label via. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
No disk in drive a:
Good morning
We ask for help please for the following:
From a Windows XP SP2 via Terminal Services (mstsc.exe) we were accessing a
Windows Server 2003 SP1/SQL 2000 SP4.
After remote instruction to be restarted the SQL Server Service, this
service aparentely stops OK, but does not start again
with an error on the master Database.
Note: in Task Manager the SQL Process was still active, not possible to
eliminate
After some attempts to restart the service, we note that other DBs were also
alocated. Allways working via Terminal.
When finally we went to the phisical Server, to restart the machine, we note
the dialog message: There is no disk in drive a:
Note: this dialog does not appear on the terminal side
When this msg was accepted the situation was reestablished.
Is this a known error?
How to solve?
How to be sure that the dialog msg is really mapped to the Terminal
environment?
Thanks
Regards
Rui MendonçaHi RM,
Have a look at this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;281345&sd=tech
Ray
"RM" wrote:
> Good morning
> We ask for help please for the following:
> From a Windows XP SP2 via Terminal Services (mstsc.exe) we were accessing a
> Windows Server 2003 SP1/SQL 2000 SP4.
> After remote instruction to be restarted the SQL Server Service, this
> service aparentely stops OK, but does not start again
> with an error on the master Database.
> Note: in Task Manager the SQL Process was still active, not possible to
> eliminate
> After some attempts to restart the service, we note that other DBs were also
> alocated. Allways working via Terminal.
>
> When finally we went to the phisical Server, to restart the machine, we note
> the dialog message: There is no disk in drive a:
> Note: this dialog does not appear on the terminal side
> When this msg was accepted the situation was reestablished.
>
> Is this a known error?
> How to solve?
> How to be sure that the dialog msg is really mapped to the Terminal
> environment?
> Thanks
> Regards
> Rui Mendonça
>
>|||Hello Rui,
I agree with Ray this issue is related to default error mode handling. Some
settings in terminal session blocks the error dialog which causes the
process of SQL Server to hang. You may want to check if you log on to
Windows with same domain user account and if the issue occurs with other
user account.
Also, please change the registry key ErrorMode Value = 2 to see if there is
any side effect. Usually this error message "There is no disk in drive a:"
does not cause real issue and can be ignored. You may still see the
information logged in event log though the dialog does not prompt.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.|||I Thank you all for the help.
I have posted a very urgent situation in "microsoft.public.sqlserver.server"
with the name "Event ID: 17052 Urgent"
Please Help
Thanks a lot
Rui Mendonça
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:sJNUcJalGHA.5164@.TK2MSFTNGXA01.phx.gbl...
> Hello Rui,
> I agree with Ray this issue is related to default error mode handling.
> Some
> settings in terminal session blocks the error dialog which causes the
> process of SQL Server to hang. You may want to check if you log on to
> Windows with same domain user account and if the issue occurs with other
> user account.
> Also, please change the registry key ErrorMode Value = 2 to see if there
> is
> any side effect. Usually this error message "There is no disk in drive a:"
> does not cause real issue and can be ignored. You may still see the
> information logged in event log though the dialog does not prompt.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> 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.
>|||Hello Rui,
Please note I'v replied in that in that thread. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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
We ask for help please for the following:
From a Windows XP SP2 via Terminal Services (mstsc.exe) we were accessing a
Windows Server 2003 SP1/SQL 2000 SP4.
After remote instruction to be restarted the SQL Server Service, this
service aparentely stops OK, but does not start again
with an error on the master Database.
Note: in Task Manager the SQL Process was still active, not possible to
eliminate
After some attempts to restart the service, we note that other DBs were also
alocated. Allways working via Terminal.
When finally we went to the phisical Server, to restart the machine, we note
the dialog message: There is no disk in drive a:
Note: this dialog does not appear on the terminal side
When this msg was accepted the situation was reestablished.
Is this a known error?
How to solve?
How to be sure that the dialog msg is really mapped to the Terminal
environment?
Thanks
Regards
Rui MendonçaHi RM,
Have a look at this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;281345&sd=tech
Ray
"RM" wrote:
> Good morning
> We ask for help please for the following:
> From a Windows XP SP2 via Terminal Services (mstsc.exe) we were accessing a
> Windows Server 2003 SP1/SQL 2000 SP4.
> After remote instruction to be restarted the SQL Server Service, this
> service aparentely stops OK, but does not start again
> with an error on the master Database.
> Note: in Task Manager the SQL Process was still active, not possible to
> eliminate
> After some attempts to restart the service, we note that other DBs were also
> alocated. Allways working via Terminal.
>
> When finally we went to the phisical Server, to restart the machine, we note
> the dialog message: There is no disk in drive a:
> Note: this dialog does not appear on the terminal side
> When this msg was accepted the situation was reestablished.
>
> Is this a known error?
> How to solve?
> How to be sure that the dialog msg is really mapped to the Terminal
> environment?
> Thanks
> Regards
> Rui Mendonça
>
>|||Hello Rui,
I agree with Ray this issue is related to default error mode handling. Some
settings in terminal session blocks the error dialog which causes the
process of SQL Server to hang. You may want to check if you log on to
Windows with same domain user account and if the issue occurs with other
user account.
Also, please change the registry key ErrorMode Value = 2 to see if there is
any side effect. Usually this error message "There is no disk in drive a:"
does not cause real issue and can be ignored. You may still see the
information logged in event log though the dialog does not prompt.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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.|||I Thank you all for the help.
I have posted a very urgent situation in "microsoft.public.sqlserver.server"
with the name "Event ID: 17052 Urgent"
Please Help
Thanks a lot
Rui Mendonça
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:sJNUcJalGHA.5164@.TK2MSFTNGXA01.phx.gbl...
> Hello Rui,
> I agree with Ray this issue is related to default error mode handling.
> Some
> settings in terminal session blocks the error dialog which causes the
> process of SQL Server to hang. You may want to check if you log on to
> Windows with same domain user account and if the issue occurs with other
> user account.
> Also, please change the registry key ErrorMode Value = 2 to see if there
> is
> any side effect. Usually this error message "There is no disk in drive a:"
> does not cause real issue and can be ignored. You may still see the
> information logged in event log though the dialog does not prompt.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> 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.
>|||Hello Rui,
Please note I'v replied in that in that thread. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
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
Friday, March 23, 2012
No Commit at end of program processing on 2005
Hi All,
I have written some ETL software that allows the user to turn off
autocommit and then set the commit frequency. It is C++ talking via
ODBC.
We are testing on an SQL Server 2005 machine and the behavior we are
seeing is that the rows written after the last commit issued by the
program are not being reflected into the database. These are the
error messages...
It seems like 2005 is not performing a commit when the program
terminates successfully. So rows written between the last commit
issued by the program and program close are not showing up in the
database.
This seems strange as 2000 did issue a commit for these message at the
end of processing...that is...if we used autocommit turned off and
committed every say 10,000 rows...the messages that were written
after the last commmit have always been there...same on oracle and
other databases..
Is there a database level option to make a commit happen at the end of
processing? Or perhaps an option for the MSFT SQL Server ODBC driver
to commit when the connection is closed?
Thanks
Peter
www.peternolan.comHi Peter
"Peter Nolan" wrote:
> Hi All,
> I have written some ETL software that allows the user to turn off
> autocommit and then set the commit frequency. It is C++ talking via
> ODBC.
> We are testing on an SQL Server 2005 machine and the behavior we are
> seeing is that the rows written after the last commit issued by the
> program are not being reflected into the database. These are the
> error messages...
> It seems like 2005 is not performing a commit when the program
> terminates successfully. So rows written between the last commit
> issued by the program and program close are not showing up in the
> database.
> This seems strange as 2000 did issue a commit for these message at the
> end of processing...that is...if we used autocommit turned off and
> committed every say 10,000 rows...the messages that were written
> after the last commmit have always been there...same on oracle and
> other databases..
> Is there a database level option to make a commit happen at the end of
> processing? Or perhaps an option for the MSFT SQL Server ODBC driver
> to commit when the connection is closed?
> Thanks
> Peter
> www.peternolan.com
>
I am not sure why you are setting autocommit off!! If you have not
explicitly started a transaction or you are using implicit transaction any
data changed after the transaction (implicitly or explicitly) started will be
rolled back. If you allowed autocommit to be on and you did not explicitly
start the transaction then the data changed will be committed.
I don't think this behaviour has changed, but you it is not good practice to
assume that a feature of the driver is going be a shortcut to handling the
transactions properly.
Johnsql
I have written some ETL software that allows the user to turn off
autocommit and then set the commit frequency. It is C++ talking via
ODBC.
We are testing on an SQL Server 2005 machine and the behavior we are
seeing is that the rows written after the last commit issued by the
program are not being reflected into the database. These are the
error messages...
It seems like 2005 is not performing a commit when the program
terminates successfully. So rows written between the last commit
issued by the program and program close are not showing up in the
database.
This seems strange as 2000 did issue a commit for these message at the
end of processing...that is...if we used autocommit turned off and
committed every say 10,000 rows...the messages that were written
after the last commmit have always been there...same on oracle and
other databases..
Is there a database level option to make a commit happen at the end of
processing? Or perhaps an option for the MSFT SQL Server ODBC driver
to commit when the connection is closed?
Thanks
Peter
www.peternolan.comHi Peter
"Peter Nolan" wrote:
> Hi All,
> I have written some ETL software that allows the user to turn off
> autocommit and then set the commit frequency. It is C++ talking via
> ODBC.
> We are testing on an SQL Server 2005 machine and the behavior we are
> seeing is that the rows written after the last commit issued by the
> program are not being reflected into the database. These are the
> error messages...
> It seems like 2005 is not performing a commit when the program
> terminates successfully. So rows written between the last commit
> issued by the program and program close are not showing up in the
> database.
> This seems strange as 2000 did issue a commit for these message at the
> end of processing...that is...if we used autocommit turned off and
> committed every say 10,000 rows...the messages that were written
> after the last commmit have always been there...same on oracle and
> other databases..
> Is there a database level option to make a commit happen at the end of
> processing? Or perhaps an option for the MSFT SQL Server ODBC driver
> to commit when the connection is closed?
> Thanks
> Peter
> www.peternolan.com
>
I am not sure why you are setting autocommit off!! If you have not
explicitly started a transaction or you are using implicit transaction any
data changed after the transaction (implicitly or explicitly) started will be
rolled back. If you allowed autocommit to be on and you did not explicitly
start the transaction then the data changed will be committed.
I don't think this behaviour has changed, but you it is not good practice to
assume that a feature of the driver is going be a shortcut to handling the
transactions properly.
Johnsql
Wednesday, March 21, 2012
No Client Protocols Enabled yet I can still get a DSN connection to SQL Server 2005
Perplexed...Why am I able to get a connection to my SQL Server from an
Access 2003 database via DSN linked SQL server db table without a
common protocol between the client and server? Could it be that the
client does have TCP/IP or Named Pipes enabled but they are just not
showing up in the cliconfg.exe utility as such? Help!Clients have always TCP/IP and/or Named Pipes enabled. This setting is for
the server, not for the client tools.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"lacdn76" <dakarpiak@.yahoo.com> wrote in message
news:1175526801.931586.126790@.y66g2000hsf.googlegroups.com...
> Perplexed...Why am I able to get a connection to my SQL Server from an
> Access 2003 database via DSN linked SQL server db table without a
> common protocol between the client and server? Could it be that the
> client does have TCP/IP or Named Pipes enabled but they are just not
> showing up in the cliconfg.exe utility as such? Help!
>
Access 2003 database via DSN linked SQL server db table without a
common protocol between the client and server? Could it be that the
client does have TCP/IP or Named Pipes enabled but they are just not
showing up in the cliconfg.exe utility as such? Help!Clients have always TCP/IP and/or Named Pipes enabled. This setting is for
the server, not for the client tools.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"lacdn76" <dakarpiak@.yahoo.com> wrote in message
news:1175526801.931586.126790@.y66g2000hsf.googlegroups.com...
> Perplexed...Why am I able to get a connection to my SQL Server from an
> Access 2003 database via DSN linked SQL server db table without a
> common protocol between the client and server? Could it be that the
> client does have TCP/IP or Named Pipes enabled but they are just not
> showing up in the cliconfg.exe utility as such? Help!
>
No Client Protocols Enabled yet I can still get a DSN connection to SQL Server 2005
Perplexed...Why am I able to get a connection to my SQL Server from an
Access 2003 database via DSN linked SQL server db table without a
common protocol between the client and server? Could it be that the
client does have TCP/IP or Named Pipes enabled but they are just not
showing up in the cliconfg.exe utility as such? Help!
Clients have always TCP/IP and/or Named Pipes enabled. This setting is for
the server, not for the client tools.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"lacdn76" <dakarpiak@.yahoo.com> wrote in message
news:1175526801.931586.126790@.y66g2000hsf.googlegr oups.com...
> Perplexed...Why am I able to get a connection to my SQL Server from an
> Access 2003 database via DSN linked SQL server db table without a
> common protocol between the client and server? Could it be that the
> client does have TCP/IP or Named Pipes enabled but they are just not
> showing up in the cliconfg.exe utility as such? Help!
>
Access 2003 database via DSN linked SQL server db table without a
common protocol between the client and server? Could it be that the
client does have TCP/IP or Named Pipes enabled but they are just not
showing up in the cliconfg.exe utility as such? Help!
Clients have always TCP/IP and/or Named Pipes enabled. This setting is for
the server, not for the client tools.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"lacdn76" <dakarpiak@.yahoo.com> wrote in message
news:1175526801.931586.126790@.y66g2000hsf.googlegr oups.com...
> Perplexed...Why am I able to get a connection to my SQL Server from an
> Access 2003 database via DSN linked SQL server db table without a
> common protocol between the client and server? Could it be that the
> client does have TCP/IP or Named Pipes enabled but they are just not
> showing up in the cliconfg.exe utility as such? Help!
>
No Access to mapped drives
Hi,
I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me
)
Thanks in advance,
Olaf
Hi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me)
> Thanks in advance,
> Olaf
>
|||Hari,
thanks for the quick reply, but:
the sql server account does have full permissions as it is the domain admin
account. Also, I do not want to use an UNC path, but a mapped drive. The
other sql server I mentioned does show the mapped drives in Enterprise
Manager.
Anyway, thx
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Start the SQL Server service using a Domain user which has got rights in
> remote server share. After that you will be able to access the remot path
> from query analyzer.
> backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
with[vbcol=seagreen]
> init
> Note:-
> Enterprise manager will not show the mapped drives
>
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
do[vbcol=seagreen]
> a
error[vbcol=seagreen]
> medium
> all.
> the
security[vbcol=seagreen]
> server.
sql[vbcol=seagreen]
> sql
identically,
> accessing
>
|||Hi,
Can you try this from query analyzer:-
xp_cmdshell 'net use k: \\remoteserver\share'
(No need of specifying user name and password , becuase u are starting sql
server in domain admin user)
The above command will map the drive k:, now try
Backup database dbname to disk='k:\dbname.bak' with init
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> Hari,
> thanks for the quick reply, but:
> the sql server account does have full permissions as it is the domain
admin[vbcol=seagreen]
> account. Also, I do not want to use an UNC path, but a mapped drive. The
> other sql server I mentioned does show the mapped drives in Enterprise
> Manager.
> Anyway, thx
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
path[vbcol=seagreen]
> with
> do
> error
in[vbcol=seagreen]
> security
the[vbcol=seagreen]
> sql
or[vbcol=seagreen]
> identically,
UNC
>
|||Hi,
yes, this works fine, thanks.
Anyway, I am wondering why the other sql server in our domain can access the
mapped drives without doing anything. Maybe this is a bug ..?
Thanks,
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi,
> Can you try this from query analyzer:-
> xp_cmdshell 'net use k: \\remoteserver\share'
> (No need of specifying user name and password , becuase u are starting sql
> server in domain admin user)
> The above command will map the drive k:, now try
> Backup database dbname to disk='k:\dbname.bak' with init
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> admin
in[vbcol=seagreen]
> path
to[vbcol=seagreen]
or[vbcol=seagreen]
at[vbcol=seagreen]
> in
account[vbcol=seagreen]
> the
the[vbcol=seagreen]
the[vbcol=seagreen]
Security
> or
> UNC
>
|||Hi,
Thats good. I am not sure about the error.
Are you running this command from server or from a client PC using a Query
analyzer. If it is client PC you need to
map the drive from query analyzer. If you are executing from server that
command is suppose to work directly.
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:espbrftUEHA.1036@.TK2MSFTNGP12.phx.gbl...
> Hi,
> yes, this works fine, thanks.
> Anyway, I am wondering why the other sql server in our domain can access
the[vbcol=seagreen]
> mapped drives without doing anything. Maybe this is a bug ..?
> Thanks,
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
sql[vbcol=seagreen]
The[vbcol=seagreen]
rights[vbcol=seagreen]
> in
disk='\\remoteserver\backupshare\dbname.bak'[vbcol=seagreen]
possible[vbcol=seagreen]
> to
an[vbcol=seagreen]
> or
shown[vbcol=seagreen]
> at
drives[vbcol=seagreen]
> account
to[vbcol=seagreen]
sql[vbcol=seagreen]
so[vbcol=seagreen]
> the
> the
> Security
an
>
I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me
)Thanks in advance,
Olaf
Hi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me
)> Thanks in advance,
> Olaf
>
|||Hari,
thanks for the quick reply, but:
the sql server account does have full permissions as it is the domain admin
account. Also, I do not want to use an UNC path, but a mapped drive. The
other sql server I mentioned does show the mapped drives in Enterprise
Manager.
Anyway, thx
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Start the SQL Server service using a Domain user which has got rights in
> remote server share. After that you will be able to access the remot path
> from query analyzer.
> backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
with[vbcol=seagreen]
> init
> Note:-
> Enterprise manager will not show the mapped drives
>
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
do[vbcol=seagreen]
> a
error[vbcol=seagreen]
> medium
> all.
> the
security[vbcol=seagreen]
> server.
sql[vbcol=seagreen]
> sql
identically,
> accessing
>
|||Hi,
Can you try this from query analyzer:-
xp_cmdshell 'net use k: \\remoteserver\share'
(No need of specifying user name and password , becuase u are starting sql
server in domain admin user)
The above command will map the drive k:, now try
Backup database dbname to disk='k:\dbname.bak' with init
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> Hari,
> thanks for the quick reply, but:
> the sql server account does have full permissions as it is the domain
admin[vbcol=seagreen]
> account. Also, I do not want to use an UNC path, but a mapped drive. The
> other sql server I mentioned does show the mapped drives in Enterprise
> Manager.
> Anyway, thx
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
path[vbcol=seagreen]
> with
> do
> error
in[vbcol=seagreen]
> security
the[vbcol=seagreen]
> sql
or[vbcol=seagreen]
> identically,
UNC
>
|||Hi,
yes, this works fine, thanks.
Anyway, I am wondering why the other sql server in our domain can access the
mapped drives without doing anything. Maybe this is a bug ..?
Thanks,
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi,
> Can you try this from query analyzer:-
> xp_cmdshell 'net use k: \\remoteserver\share'
> (No need of specifying user name and password , becuase u are starting sql
> server in domain admin user)
> The above command will map the drive k:, now try
> Backup database dbname to disk='k:\dbname.bak' with init
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> admin
in[vbcol=seagreen]
> path
to[vbcol=seagreen]
or[vbcol=seagreen]
at[vbcol=seagreen]
> in
account[vbcol=seagreen]
> the
the[vbcol=seagreen]
the[vbcol=seagreen]
Security
> or
> UNC
>
|||Hi,
Thats good. I am not sure about the error.
Are you running this command from server or from a client PC using a Query
analyzer. If it is client PC you need to
map the drive from query analyzer. If you are executing from server that
command is suppose to work directly.
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:espbrftUEHA.1036@.TK2MSFTNGP12.phx.gbl...
> Hi,
> yes, this works fine, thanks.
> Anyway, I am wondering why the other sql server in our domain can access
the[vbcol=seagreen]
> mapped drives without doing anything. Maybe this is a bug ..?
> Thanks,
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
sql[vbcol=seagreen]
The[vbcol=seagreen]
rights[vbcol=seagreen]
> in
disk='\\remoteserver\backupshare\dbname.bak'[vbcol=seagreen]
possible[vbcol=seagreen]
> to
an[vbcol=seagreen]
> or
shown[vbcol=seagreen]
> at
drives[vbcol=seagreen]
> account
to[vbcol=seagreen]
sql[vbcol=seagreen]
so[vbcol=seagreen]
> the
> the
> Security
an
>
No Access to mapped drives
Hi,
I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me)
Thanks in advance,
OlafHi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me)
> Thanks in advance,
> Olaf
>
I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me
)Thanks in advance,
OlafHi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me
)> Thanks in advance,
> Olaf
>
No Access to mapped drives
Hi,
I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me)
Thanks in advance,
OlafHi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me)
> Thanks in advance,
> Olaf
>|||Hari,
thanks for the quick reply, but:
the sql server account does have full permissions as it is the domain admin
account. Also, I do not want to use an UNC path, but a mapped drive. The
other sql server I mentioned does show the mapped drives in Enterprise
Manager.
Anyway, thx
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Start the SQL Server service using a Domain user which has got rights in
> remote server share. After that you will be able to access the remot path
> from query analyzer.
> backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
with
> init
> Note:-
> Enterprise manager will not show the mapped drives
>
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
do[vbcol=seagreen]
> a
error[vbcol=seagreen]
> medium
> all.
> the
security[vbcol=seagreen]
> server.
sql[vbcol=seagreen]
> sql
identically,[vbcol=seagreen]
> accessing
>|||Hi,
Can you try this from query analyzer:-
xp_cmdshell 'net use k: \\remoteserver\share'
(No need of specifying user name and password , becuase u are starting sql
server in domain admin user)
The above command will map the drive k:, now try
Backup database dbname to disk='k:\dbname.bak' with init
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> Hari,
> thanks for the quick reply, but:
> the sql server account does have full permissions as it is the domain
admin
> account. Also, I do not want to use an UNC path, but a mapped drive. The
> other sql server I mentioned does show the mapped drives in Enterprise
> Manager.
> Anyway, thx
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
path[vbcol=seagreen]
> with
> do
> error
in[vbcol=seagreen]
> security
the[vbcol=seagreen]
> sql
or[vbcol=seagreen]
> identically,
UNC[vbcol=seagreen]
>|||Hi,
yes, this works fine, thanks.
Anyway, I am wondering why the other sql server in our domain can access the
mapped drives without doing anything. Maybe this is a bug ..?
Thanks,
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Can you try this from query analyzer:-
> xp_cmdshell 'net use k: \\remoteserver\share'
> (No need of specifying user name and password , becuase u are starting sql
> server in domain admin user)
> The above command will map the drive k:, now try
> Backup database dbname to disk='k:\dbname.bak' with init
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> admin
in[vbcol=seagreen]
> path
to[vbcol=seagreen]
or[vbcol=seagreen]
at[vbcol=seagreen]
> in
account[vbcol=seagreen]
> the
the[vbcol=seagreen]
the[vbcol=seagreen]
Security[vbcol=seagreen]
> or
> UNC
>|||Hi,
Thats good. I am not sure about the error.
Are you running this command from server or from a client PC using a Query
analyzer. If it is client PC you need to
map the drive from query analyzer. If you are executing from server that
command is suppose to work directly.
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:espbrftUEHA.1036@.TK2MSFTNGP12.phx.gbl...
> Hi,
> yes, this works fine, thanks.
> Anyway, I am wondering why the other sql server in our domain can access
the
> mapped drives without doing anything. Maybe this is a bug ..?
> Thanks,
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
sql[vbcol=seagreen]
The[vbcol=seagreen]
rights[vbcol=seagreen]
> in
disk='\\remoteserver\backupshare\dbname.bak'[vbcol=seagreen]
possible[vbcol=seagreen]
> to
an[vbcol=seagreen]
> or
shown[vbcol=seagreen]
> at
drives[vbcol=seagreen]
> account
to[vbcol=seagreen]
sql[vbcol=seagreen]
so[vbcol=seagreen]
> the
> the
> Security
an[vbcol=seagreen]
>
I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me
)Thanks in advance,
OlafHi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me
)> Thanks in advance,
> Olaf
>|||Hari,
thanks for the quick reply, but:
the sql server account does have full permissions as it is the domain admin
account. Also, I do not want to use an UNC path, but a mapped drive. The
other sql server I mentioned does show the mapped drives in Enterprise
Manager.
Anyway, thx
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Start the SQL Server service using a Domain user which has got rights in
> remote server share. After that you will be able to access the remot path
> from query analyzer.
> backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
with
> init
> Note:-
> Enterprise manager will not show the mapped drives
>
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
do[vbcol=seagreen]
> a
error[vbcol=seagreen]
> medium
> all.
> the
security[vbcol=seagreen]
> server.
sql[vbcol=seagreen]
> sql
identically,[vbcol=seagreen]
> accessing
>|||Hi,
Can you try this from query analyzer:-
xp_cmdshell 'net use k: \\remoteserver\share'
(No need of specifying user name and password , becuase u are starting sql
server in domain admin user)
The above command will map the drive k:, now try
Backup database dbname to disk='k:\dbname.bak' with init
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> Hari,
> thanks for the quick reply, but:
> the sql server account does have full permissions as it is the domain
admin
> account. Also, I do not want to use an UNC path, but a mapped drive. The
> other sql server I mentioned does show the mapped drives in Enterprise
> Manager.
> Anyway, thx
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
path[vbcol=seagreen]
> with
> do
> error
in[vbcol=seagreen]
> security
the[vbcol=seagreen]
> sql
or[vbcol=seagreen]
> identically,
UNC[vbcol=seagreen]
>|||Hi,
yes, this works fine, thanks.
Anyway, I am wondering why the other sql server in our domain can access the
mapped drives without doing anything. Maybe this is a bug ..?
Thanks,
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Can you try this from query analyzer:-
> xp_cmdshell 'net use k: \\remoteserver\share'
> (No need of specifying user name and password , becuase u are starting sql
> server in domain admin user)
> The above command will map the drive k:, now try
> Backup database dbname to disk='k:\dbname.bak' with init
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> admin
in[vbcol=seagreen]
> path
to[vbcol=seagreen]
or[vbcol=seagreen]
at[vbcol=seagreen]
> in
account[vbcol=seagreen]
> the
the[vbcol=seagreen]
the[vbcol=seagreen]
Security[vbcol=seagreen]
> or
> UNC
>|||Hi,
Thats good. I am not sure about the error.
Are you running this command from server or from a client PC using a Query
analyzer. If it is client PC you need to
map the drive from query analyzer. If you are executing from server that
command is suppose to work directly.
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:espbrftUEHA.1036@.TK2MSFTNGP12.phx.gbl...
> Hi,
> yes, this works fine, thanks.
> Anyway, I am wondering why the other sql server in our domain can access
the
> mapped drives without doing anything. Maybe this is a bug ..?
> Thanks,
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
sql[vbcol=seagreen]
The[vbcol=seagreen]
rights[vbcol=seagreen]
> in
disk='\\remoteserver\backupshare\dbname.bak'[vbcol=seagreen]
possible[vbcol=seagreen]
> to
an[vbcol=seagreen]
> or
shown[vbcol=seagreen]
> at
drives[vbcol=seagreen]
> account
to[vbcol=seagreen]
sql[vbcol=seagreen]
so[vbcol=seagreen]
> the
> the
> Security
an[vbcol=seagreen]
>
No Access to mapped drives
Hi,
I have a Wíndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me :))
Thanks in advance,
OlafHi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wíndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me :))
> Thanks in advance,
> Olaf
>|||Hari,
thanks for the quick reply, but:
the sql server account does have full permissions as it is the domain admin
account. Also, I do not want to use an UNC path, but a mapped drive. The
other sql server I mentioned does show the mapped drives in Enterprise
Manager.
Anyway, thx
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Start the SQL Server service using a Domain user which has got rights in
> remote server share. After that you will be able to access the remot path
> from query analyzer.
> backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
with
> init
> Note:-
> Enterprise manager will not show the mapped drives
>
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > I have a Wíndows 2003 server running SQL Server (SP 3a).
> > My problem: Neither via Enterprise Manager nor T-SQL is it possible to
do
> a
> > backup / restore on a mapped network drive. Using Query Analyzer, an
error
> > shows up saying "Backup medium <xyz> cannot be opened. Media error or
> medium
> > offline", using Enterprise Manager, no network drive is being shown at
> all.
> > Strange enough, it is possible to list and access all network drives in
> the
> > (file-) explorer from this server. I do not consider this to be a
security
> > issue, as the sql server runs under the domain administrator's account
> > having all required permissions. The network drives are assigned to
> > different servers, all of which belong to the same domain as the sql
> server.
> > The domain administrator is permanently logged on the sql server so the
> > network drives are present all the time.
> > It makes no difference if I run the Enterprise Manager directly on the
sql
> > server or from a different machine. It also makes no difference if the
> > connection to the sql server is established using Integrated Security or
> sql
> > server's sa account.
> > There is another sql server in our domain which is configured
identically,
> > apart from running under Win 2000 Server. This one has no problems
> accessing
> > any network drives...
> > For different reasons I do want to use a mapped drive instead of an UNC
> > path, so I hope someone can help me :))
> > Thanks in advance,
> > Olaf
> >
> >
>|||Hi,
Can you try this from query analyzer:-
xp_cmdshell 'net use k: \\remoteserver\share'
(No need of specifying user name and password , becuase u are starting sql
server in domain admin user)
The above command will map the drive k:, now try
Backup database dbname to disk='k:\dbname.bak' with init
--
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> Hari,
> thanks for the quick reply, but:
> the sql server account does have full permissions as it is the domain
admin
> account. Also, I do not want to use an UNC path, but a mapped drive. The
> other sql server I mentioned does show the mapped drives in Enterprise
> Manager.
> Anyway, thx
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > Start the SQL Server service using a Domain user which has got rights in
> > remote server share. After that you will be able to access the remot
path
> > from query analyzer.
> >
> > backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
> with
> > init
> >
> > Note:-
> >
> > Enterprise manager will not show the mapped drives
> >
> >
> > --
> > Thanks
> > Hari
> > MCDBA
> > "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> > news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > > I have a Wíndows 2003 server running SQL Server (SP 3a).
> > > My problem: Neither via Enterprise Manager nor T-SQL is it possible to
> do
> > a
> > > backup / restore on a mapped network drive. Using Query Analyzer, an
> error
> > > shows up saying "Backup medium <xyz> cannot be opened. Media error or
> > medium
> > > offline", using Enterprise Manager, no network drive is being shown at
> > all.
> > > Strange enough, it is possible to list and access all network drives
in
> > the
> > > (file-) explorer from this server. I do not consider this to be a
> security
> > > issue, as the sql server runs under the domain administrator's account
> > > having all required permissions. The network drives are assigned to
> > > different servers, all of which belong to the same domain as the sql
> > server.
> > > The domain administrator is permanently logged on the sql server so
the
> > > network drives are present all the time.
> > > It makes no difference if I run the Enterprise Manager directly on the
> sql
> > > server or from a different machine. It also makes no difference if the
> > > connection to the sql server is established using Integrated Security
or
> > sql
> > > server's sa account.
> > > There is another sql server in our domain which is configured
> identically,
> > > apart from running under Win 2000 Server. This one has no problems
> > accessing
> > > any network drives...
> > > For different reasons I do want to use a mapped drive instead of an
UNC
> > > path, so I hope someone can help me :))
> > > Thanks in advance,
> > > Olaf
> > >
> > >
> >
> >
>|||Hi,
yes, this works fine, thanks.
Anyway, I am wondering why the other sql server in our domain can access the
mapped drives without doing anything. Maybe this is a bug ..?
Thanks,
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Can you try this from query analyzer:-
> xp_cmdshell 'net use k: \\remoteserver\share'
> (No need of specifying user name and password , becuase u are starting sql
> server in domain admin user)
> The above command will map the drive k:, now try
> Backup database dbname to disk='k:\dbname.bak' with init
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> > Hari,
> > thanks for the quick reply, but:
> > the sql server account does have full permissions as it is the domain
> admin
> > account. Also, I do not want to use an UNC path, but a mapped drive. The
> > other sql server I mentioned does show the mapped drives in Enterprise
> > Manager.
> > Anyway, thx
> > Olaf
> >
> > "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> > news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> > > Hi,
> > >
> > > Start the SQL Server service using a Domain user which has got rights
in
> > > remote server share. After that you will be able to access the remot
> path
> > > from query analyzer.
> > >
> > > backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
> > with
> > > init
> > >
> > > Note:-
> > >
> > > Enterprise manager will not show the mapped drives
> > >
> > >
> > > --
> > > Thanks
> > > Hari
> > > MCDBA
> > > "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> > > news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > > > Hi,
> > > > I have a Wíndows 2003 server running SQL Server (SP 3a).
> > > > My problem: Neither via Enterprise Manager nor T-SQL is it possible
to
> > do
> > > a
> > > > backup / restore on a mapped network drive. Using Query Analyzer, an
> > error
> > > > shows up saying "Backup medium <xyz> cannot be opened. Media error
or
> > > medium
> > > > offline", using Enterprise Manager, no network drive is being shown
at
> > > all.
> > > > Strange enough, it is possible to list and access all network drives
> in
> > > the
> > > > (file-) explorer from this server. I do not consider this to be a
> > security
> > > > issue, as the sql server runs under the domain administrator's
account
> > > > having all required permissions. The network drives are assigned to
> > > > different servers, all of which belong to the same domain as the sql
> > > server.
> > > > The domain administrator is permanently logged on the sql server so
> the
> > > > network drives are present all the time.
> > > > It makes no difference if I run the Enterprise Manager directly on
the
> > sql
> > > > server or from a different machine. It also makes no difference if
the
> > > > connection to the sql server is established using Integrated
Security
> or
> > > sql
> > > > server's sa account.
> > > > There is another sql server in our domain which is configured
> > identically,
> > > > apart from running under Win 2000 Server. This one has no problems
> > > accessing
> > > > any network drives...
> > > > For different reasons I do want to use a mapped drive instead of an
> UNC
> > > > path, so I hope someone can help me :))
> > > > Thanks in advance,
> > > > Olaf
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi,
Thats good. I am not sure about the error.
Are you running this command from server or from a client PC using a Query
analyzer. If it is client PC you need to
map the drive from query analyzer. If you are executing from server that
command is suppose to work directly.
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:espbrftUEHA.1036@.TK2MSFTNGP12.phx.gbl...
> Hi,
> yes, this works fine, thanks.
> Anyway, I am wondering why the other sql server in our domain can access
the
> mapped drives without doing anything. Maybe this is a bug ..?
> Thanks,
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Can you try this from query analyzer:-
> >
> > xp_cmdshell 'net use k: \\remoteserver\share'
> >
> > (No need of specifying user name and password , becuase u are starting
sql
> > server in domain admin user)
> >
> > The above command will map the drive k:, now try
> >
> > Backup database dbname to disk='k:\dbname.bak' with init
> >
> > --
> > Thanks
> > Hari
> > MCDBA
> > "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> > news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> > > Hari,
> > > thanks for the quick reply, but:
> > > the sql server account does have full permissions as it is the domain
> > admin
> > > account. Also, I do not want to use an UNC path, but a mapped drive.
The
> > > other sql server I mentioned does show the mapped drives in Enterprise
> > > Manager.
> > > Anyway, thx
> > > Olaf
> > >
> > > "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> > > news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> > > > Hi,
> > > >
> > > > Start the SQL Server service using a Domain user which has got
rights
> in
> > > > remote server share. After that you will be able to access the remot
> > path
> > > > from query analyzer.
> > > >
> > > > backup database dbname to
disk='\\remoteserver\backupshare\dbname.bak'
> > > with
> > > > init
> > > >
> > > > Note:-
> > > >
> > > > Enterprise manager will not show the mapped drives
> > > >
> > > >
> > > > --
> > > > Thanks
> > > > Hari
> > > > MCDBA
> > > > "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> > > > news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > > > > Hi,
> > > > > I have a Wíndows 2003 server running SQL Server (SP 3a).
> > > > > My problem: Neither via Enterprise Manager nor T-SQL is it
possible
> to
> > > do
> > > > a
> > > > > backup / restore on a mapped network drive. Using Query Analyzer,
an
> > > error
> > > > > shows up saying "Backup medium <xyz> cannot be opened. Media error
> or
> > > > medium
> > > > > offline", using Enterprise Manager, no network drive is being
shown
> at
> > > > all.
> > > > > Strange enough, it is possible to list and access all network
drives
> > in
> > > > the
> > > > > (file-) explorer from this server. I do not consider this to be a
> > > security
> > > > > issue, as the sql server runs under the domain administrator's
> account
> > > > > having all required permissions. The network drives are assigned
to
> > > > > different servers, all of which belong to the same domain as the
sql
> > > > server.
> > > > > The domain administrator is permanently logged on the sql server
so
> > the
> > > > > network drives are present all the time.
> > > > > It makes no difference if I run the Enterprise Manager directly on
> the
> > > sql
> > > > > server or from a different machine. It also makes no difference if
> the
> > > > > connection to the sql server is established using Integrated
> Security
> > or
> > > > sql
> > > > > server's sa account.
> > > > > There is another sql server in our domain which is configured
> > > identically,
> > > > > apart from running under Win 2000 Server. This one has no problems
> > > > accessing
> > > > > any network drives...
> > > > > For different reasons I do want to use a mapped drive instead of
an
> > UNC
> > > > > path, so I hope someone can help me :))
> > > > > Thanks in advance,
> > > > > Olaf
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
I have a Wíndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me :))
Thanks in advance,
OlafHi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wíndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me :))
> Thanks in advance,
> Olaf
>|||Hari,
thanks for the quick reply, but:
the sql server account does have full permissions as it is the domain admin
account. Also, I do not want to use an UNC path, but a mapped drive. The
other sql server I mentioned does show the mapped drives in Enterprise
Manager.
Anyway, thx
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Start the SQL Server service using a Domain user which has got rights in
> remote server share. After that you will be able to access the remot path
> from query analyzer.
> backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
with
> init
> Note:-
> Enterprise manager will not show the mapped drives
>
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > I have a Wíndows 2003 server running SQL Server (SP 3a).
> > My problem: Neither via Enterprise Manager nor T-SQL is it possible to
do
> a
> > backup / restore on a mapped network drive. Using Query Analyzer, an
error
> > shows up saying "Backup medium <xyz> cannot be opened. Media error or
> medium
> > offline", using Enterprise Manager, no network drive is being shown at
> all.
> > Strange enough, it is possible to list and access all network drives in
> the
> > (file-) explorer from this server. I do not consider this to be a
security
> > issue, as the sql server runs under the domain administrator's account
> > having all required permissions. The network drives are assigned to
> > different servers, all of which belong to the same domain as the sql
> server.
> > The domain administrator is permanently logged on the sql server so the
> > network drives are present all the time.
> > It makes no difference if I run the Enterprise Manager directly on the
sql
> > server or from a different machine. It also makes no difference if the
> > connection to the sql server is established using Integrated Security or
> sql
> > server's sa account.
> > There is another sql server in our domain which is configured
identically,
> > apart from running under Win 2000 Server. This one has no problems
> accessing
> > any network drives...
> > For different reasons I do want to use a mapped drive instead of an UNC
> > path, so I hope someone can help me :))
> > Thanks in advance,
> > Olaf
> >
> >
>|||Hi,
Can you try this from query analyzer:-
xp_cmdshell 'net use k: \\remoteserver\share'
(No need of specifying user name and password , becuase u are starting sql
server in domain admin user)
The above command will map the drive k:, now try
Backup database dbname to disk='k:\dbname.bak' with init
--
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> Hari,
> thanks for the quick reply, but:
> the sql server account does have full permissions as it is the domain
admin
> account. Also, I do not want to use an UNC path, but a mapped drive. The
> other sql server I mentioned does show the mapped drives in Enterprise
> Manager.
> Anyway, thx
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > Start the SQL Server service using a Domain user which has got rights in
> > remote server share. After that you will be able to access the remot
path
> > from query analyzer.
> >
> > backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
> with
> > init
> >
> > Note:-
> >
> > Enterprise manager will not show the mapped drives
> >
> >
> > --
> > Thanks
> > Hari
> > MCDBA
> > "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> > news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > > I have a Wíndows 2003 server running SQL Server (SP 3a).
> > > My problem: Neither via Enterprise Manager nor T-SQL is it possible to
> do
> > a
> > > backup / restore on a mapped network drive. Using Query Analyzer, an
> error
> > > shows up saying "Backup medium <xyz> cannot be opened. Media error or
> > medium
> > > offline", using Enterprise Manager, no network drive is being shown at
> > all.
> > > Strange enough, it is possible to list and access all network drives
in
> > the
> > > (file-) explorer from this server. I do not consider this to be a
> security
> > > issue, as the sql server runs under the domain administrator's account
> > > having all required permissions. The network drives are assigned to
> > > different servers, all of which belong to the same domain as the sql
> > server.
> > > The domain administrator is permanently logged on the sql server so
the
> > > network drives are present all the time.
> > > It makes no difference if I run the Enterprise Manager directly on the
> sql
> > > server or from a different machine. It also makes no difference if the
> > > connection to the sql server is established using Integrated Security
or
> > sql
> > > server's sa account.
> > > There is another sql server in our domain which is configured
> identically,
> > > apart from running under Win 2000 Server. This one has no problems
> > accessing
> > > any network drives...
> > > For different reasons I do want to use a mapped drive instead of an
UNC
> > > path, so I hope someone can help me :))
> > > Thanks in advance,
> > > Olaf
> > >
> > >
> >
> >
>|||Hi,
yes, this works fine, thanks.
Anyway, I am wondering why the other sql server in our domain can access the
mapped drives without doing anything. Maybe this is a bug ..?
Thanks,
Olaf
"Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> Can you try this from query analyzer:-
> xp_cmdshell 'net use k: \\remoteserver\share'
> (No need of specifying user name and password , becuase u are starting sql
> server in domain admin user)
> The above command will map the drive k:, now try
> Backup database dbname to disk='k:\dbname.bak' with init
> --
> Thanks
> Hari
> MCDBA
> "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> > Hari,
> > thanks for the quick reply, but:
> > the sql server account does have full permissions as it is the domain
> admin
> > account. Also, I do not want to use an UNC path, but a mapped drive. The
> > other sql server I mentioned does show the mapped drives in Enterprise
> > Manager.
> > Anyway, thx
> > Olaf
> >
> > "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> > news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> > > Hi,
> > >
> > > Start the SQL Server service using a Domain user which has got rights
in
> > > remote server share. After that you will be able to access the remot
> path
> > > from query analyzer.
> > >
> > > backup database dbname to disk='\\remoteserver\backupshare\dbname.bak'
> > with
> > > init
> > >
> > > Note:-
> > >
> > > Enterprise manager will not show the mapped drives
> > >
> > >
> > > --
> > > Thanks
> > > Hari
> > > MCDBA
> > > "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> > > news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > > > Hi,
> > > > I have a Wíndows 2003 server running SQL Server (SP 3a).
> > > > My problem: Neither via Enterprise Manager nor T-SQL is it possible
to
> > do
> > > a
> > > > backup / restore on a mapped network drive. Using Query Analyzer, an
> > error
> > > > shows up saying "Backup medium <xyz> cannot be opened. Media error
or
> > > medium
> > > > offline", using Enterprise Manager, no network drive is being shown
at
> > > all.
> > > > Strange enough, it is possible to list and access all network drives
> in
> > > the
> > > > (file-) explorer from this server. I do not consider this to be a
> > security
> > > > issue, as the sql server runs under the domain administrator's
account
> > > > having all required permissions. The network drives are assigned to
> > > > different servers, all of which belong to the same domain as the sql
> > > server.
> > > > The domain administrator is permanently logged on the sql server so
> the
> > > > network drives are present all the time.
> > > > It makes no difference if I run the Enterprise Manager directly on
the
> > sql
> > > > server or from a different machine. It also makes no difference if
the
> > > > connection to the sql server is established using Integrated
Security
> or
> > > sql
> > > > server's sa account.
> > > > There is another sql server in our domain which is configured
> > identically,
> > > > apart from running under Win 2000 Server. This one has no problems
> > > accessing
> > > > any network drives...
> > > > For different reasons I do want to use a mapped drive instead of an
> UNC
> > > > path, so I hope someone can help me :))
> > > > Thanks in advance,
> > > > Olaf
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi,
Thats good. I am not sure about the error.
Are you running this command from server or from a client PC using a Query
analyzer. If it is client PC you need to
map the drive from query analyzer. If you are executing from server that
command is suppose to work directly.
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:espbrftUEHA.1036@.TK2MSFTNGP12.phx.gbl...
> Hi,
> yes, this works fine, thanks.
> Anyway, I am wondering why the other sql server in our domain can access
the
> mapped drives without doing anything. Maybe this is a bug ..?
> Thanks,
> Olaf
> "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:uBh4gbtUEHA.556@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Can you try this from query analyzer:-
> >
> > xp_cmdshell 'net use k: \\remoteserver\share'
> >
> > (No need of specifying user name and password , becuase u are starting
sql
> > server in domain admin user)
> >
> > The above command will map the drive k:, now try
> >
> > Backup database dbname to disk='k:\dbname.bak' with init
> >
> > --
> > Thanks
> > Hari
> > MCDBA
> > "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> > news:e0jYRTtUEHA.2504@.TK2MSFTNGP11.phx.gbl...
> > > Hari,
> > > thanks for the quick reply, but:
> > > the sql server account does have full permissions as it is the domain
> > admin
> > > account. Also, I do not want to use an UNC path, but a mapped drive.
The
> > > other sql server I mentioned does show the mapped drives in Enterprise
> > > Manager.
> > > Anyway, thx
> > > Olaf
> > >
> > > "Hari" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> > > news:%23z%23S4OtUEHA.2388@.TK2MSFTNGP09.phx.gbl...
> > > > Hi,
> > > >
> > > > Start the SQL Server service using a Domain user which has got
rights
> in
> > > > remote server share. After that you will be able to access the remot
> > path
> > > > from query analyzer.
> > > >
> > > > backup database dbname to
disk='\\remoteserver\backupshare\dbname.bak'
> > > with
> > > > init
> > > >
> > > > Note:-
> > > >
> > > > Enterprise manager will not show the mapped drives
> > > >
> > > >
> > > > --
> > > > Thanks
> > > > Hari
> > > > MCDBA
> > > > "Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
> > > > news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> > > > > Hi,
> > > > > I have a Wíndows 2003 server running SQL Server (SP 3a).
> > > > > My problem: Neither via Enterprise Manager nor T-SQL is it
possible
> to
> > > do
> > > > a
> > > > > backup / restore on a mapped network drive. Using Query Analyzer,
an
> > > error
> > > > > shows up saying "Backup medium <xyz> cannot be opened. Media error
> or
> > > > medium
> > > > > offline", using Enterprise Manager, no network drive is being
shown
> at
> > > > all.
> > > > > Strange enough, it is possible to list and access all network
drives
> > in
> > > > the
> > > > > (file-) explorer from this server. I do not consider this to be a
> > > security
> > > > > issue, as the sql server runs under the domain administrator's
> account
> > > > > having all required permissions. The network drives are assigned
to
> > > > > different servers, all of which belong to the same domain as the
sql
> > > > server.
> > > > > The domain administrator is permanently logged on the sql server
so
> > the
> > > > > network drives are present all the time.
> > > > > It makes no difference if I run the Enterprise Manager directly on
> the
> > > sql
> > > > > server or from a different machine. It also makes no difference if
> the
> > > > > connection to the sql server is established using Integrated
> Security
> > or
> > > > sql
> > > > > server's sa account.
> > > > > There is another sql server in our domain which is configured
> > > identically,
> > > > > apart from running under Win 2000 Server. This one has no problems
> > > > accessing
> > > > > any network drives...
> > > > > For different reasons I do want to use a mapped drive instead of
an
> > UNC
> > > > > path, so I hope someone can help me :))
> > > > > Thanks in advance,
> > > > > Olaf
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
Monday, March 19, 2012
nightly rebooting of server
SQL 2000 patched up running under SBS2003
we shutdown and reboot automatically at 2AM into DOS and backup entire
server via Ghost onto a backup and drive and restart server
Question: are there any issues with rebooting SQL daily?
a another consultant claims there are but I can find no mentions in MS db or
literature.
craig@.computermagic.net(donotspam)Hi
If you cleanly shut down SQL server there should be no issue
http://msdn.microsoft.com/library/d...>
rt_6628.asp,
but anything connected to the server would need to handle this loss.
John
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)|||The only issue is that you are blowing away your data cache and query cache,
so this is why queries in the morning run a lot more slowly than they do in
the afternoon.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)
we shutdown and reboot automatically at 2AM into DOS and backup entire
server via Ghost onto a backup and drive and restart server
Question: are there any issues with rebooting SQL daily?
a another consultant claims there are but I can find no mentions in MS db or
literature.
craig@.computermagic.net(donotspam)Hi
If you cleanly shut down SQL server there should be no issue
http://msdn.microsoft.com/library/d...>
rt_6628.asp,
but anything connected to the server would need to handle this loss.
John
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)|||The only issue is that you are blowing away your data cache and query cache,
so this is why queries in the morning run a lot more slowly than they do in
the afternoon.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)
nightly rebooting of server
SQL 2000 patched up running under SBS2003
we shutdown and reboot automatically at 2AM into DOS and backup entire
server via Ghost onto a backup and drive and restart server
Question: are there any issues with rebooting SQL daily?
a another consultant claims there are but I can find no mentions in MS db or
literature.
craig@.computermagic.net(donotspam)Hi
If you cleanly shut down SQL server there should be no issue
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_start_6628.asp,
but anything connected to the server would need to handle this loss.
John
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)|||The only issue is that you are blowing away your data cache and query cache,
so this is why queries in the morning run a lot more slowly than they do in
the afternoon.
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)
we shutdown and reboot automatically at 2AM into DOS and backup entire
server via Ghost onto a backup and drive and restart server
Question: are there any issues with rebooting SQL daily?
a another consultant claims there are but I can find no mentions in MS db or
literature.
craig@.computermagic.net(donotspam)Hi
If you cleanly shut down SQL server there should be no issue
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_start_6628.asp,
but anything connected to the server would need to handle this loss.
John
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)|||The only issue is that you are blowing away your data cache and query cache,
so this is why queries in the morning run a lot more slowly than they do in
the afternoon.
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)
nightly rebooting of server
SQL 2000 patched up running under SBS2003
we shutdown and reboot automatically at 2AM into DOS and backup entire
server via Ghost onto a backup and drive and restart server
Question: are there any issues with rebooting SQL daily?
a another consultant claims there are but I can find no mentions in MS db or
literature.
craig@.computermagic.net(donotspam)
Hi
If you cleanly shut down SQL server there should be no issue
http://msdn.microsoft.com/library/de...tart_6628.asp,
but anything connected to the server would need to handle this loss.
John
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)
|||The only issue is that you are blowing away your data cache and query cache,
so this is why queries in the morning run a lot more slowly than they do in
the afternoon.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)
we shutdown and reboot automatically at 2AM into DOS and backup entire
server via Ghost onto a backup and drive and restart server
Question: are there any issues with rebooting SQL daily?
a another consultant claims there are but I can find no mentions in MS db or
literature.
craig@.computermagic.net(donotspam)
Hi
If you cleanly shut down SQL server there should be no issue
http://msdn.microsoft.com/library/de...tart_6628.asp,
but anything connected to the server would need to handle this loss.
John
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)
|||The only issue is that you are blowing away your data cache and query cache,
so this is why queries in the morning run a lot more slowly than they do in
the afternoon.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"computermagic" <craig@.computermagic.net(donotspam)> wrote in message
news:716D85E1-E2E7-4EFA-9201-0CFF53556126@.microsoft.com...
> SQL 2000 patched up running under SBS2003
> we shutdown and reboot automatically at 2AM into DOS and backup entire
> server via Ghost onto a backup and drive and restart server
> Question: are there any issues with rebooting SQL daily?
> a another consultant claims there are but I can find no mentions in MS db
> or
> literature.
> craig@.computermagic.net(donotspam)
Monday, March 12, 2012
NH: Best Practices Approach - call stored proc - or run it via linked server?
what pro's cons would there be to having a linked server run a local stored proc against another sql server or create that stored proc on that other sql server and call it from there in the c# code.
i would think that calling the stored proc would be more efficient that running a linked server - but please let me know your thoughts. I'm not sure i can have permission to add a stored proc on that server, so possibly the linked server is the only solution - but if i can put a stored proc on that server should i?
thanks.
Jeff
anyone?|||One obvious thing to keep in mind is the performance. Depending on your network the executiion time could be different.
Now I am not sure if I understand your question. If you do not have permission to create the stored proc on the original server you would still need access to the underlying tables if you want to access them through server B, irrespective of whether its via stored proc or directly T-SQL.
|||well typically I associate using a linked server to pull data from something using openquery such as ibm as400 so my question is do i get access to put the stored proc on the remote sql server (not one of my groups sql servers), or do i ask for setting up a linked server to it and execute the stored proc from my local sql server using the linked server approach.
either way?
get access to put the stored proc right on the sql server and call it in c#?
use the linked server and call it in c#
Just looking for some reason why one way may be better than another, primarily performance, and reducing putting in another possible point of failure.
thanks,
JB
|||
info@.learnbartending.com:
Just looking for some reason why one way may be better than another, primarily performance, and reducing putting in another possible point of failure.
Those are exactly the reasons why you might want to put the proc directly where the data is.
Subscribe to:
Posts (Atom)