|
|
You're in the
sql server msde
group:Backup to Network Drive
sql server msde:
OK. Then you need to setup SQL Server to use a local account that exists on your machine. The same local account must exist on the other PC too, with exactly the same password. You change the account the SQL Server uses to login through Enterprise Manager, Server Properties, Security Tab. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ [quoted text, click to view] "Kevin" <kevgrim@tesco.net> wrote in message news:u9IoaX4uFHA.2948@TK2MSFTNGP15.phx.gbl... > Thanks Mike > > The PC has rights to the other one. > Am not sure what you mean by a domain account as am only using peer to > peer networking. > > Kevin > > "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message > news:OKetdH4uFHA.1560@TK2MSFTNGP09.phx.gbl... >> Hi >> >> The SQL Server service account needs to be a domain account, and must >> have rights on the destination share. >> >> Regards >> -------------------------------- >> Mike Epprecht, Microsoft SQL Server MVP >> Zurich, Switzerland >> >> IM: mike@epprecht.net >> >> MVP Program: http://www.microsoft.com/mvp >> >> Blog: http://www.msmvps.com/epprecht/ >> >> "Kevin" <kevgrim@tesco.net> wrote in message >> news:%23ZmdjA4uFHA.2312@TK2MSFTNGP14.phx.gbl... >>> Am trying to backup to a network drive as the other machine has loads of >>> space. >>> Am using:- >>> BACKUP database TO DISK='\\myserver\backup\database.bak' >>> >>> Keep getting backup device not available, when can see it via Network >>> Places etc. >>> Am using Windows 2000 Pro on both machines. >>> >> >> > >
But since you are using MSDE, Start > Control Panel > Services, modify the
Service Account startup for your MSDE installation there. The account must be local administrator on both machines. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ [quoted text, click to view] "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message news:eIfkjp4uFHA.3000@TK2MSFTNGP12.phx.gbl... > Hi > > OK. Then you need to setup SQL Server to use a local account that exists > on your machine. The same local account must exist on the other PC too, > with exactly the same password. > > You change the account the SQL Server uses to login through Enterprise > Manager, Server Properties, Security Tab. > > Regards > -------------------------------- > Mike Epprecht, Microsoft SQL Server MVP > Zurich, Switzerland > > IM: mike@epprecht.net > > MVP Program: http://www.microsoft.com/mvp > > Blog: http://www.msmvps.com/epprecht/ > > "Kevin" <kevgrim@tesco.net> wrote in message > news:u9IoaX4uFHA.2948@TK2MSFTNGP15.phx.gbl... >> Thanks Mike >> >> The PC has rights to the other one. >> Am not sure what you mean by a domain account as am only using peer to >> peer networking. >> >> Kevin >> >> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message >> news:OKetdH4uFHA.1560@TK2MSFTNGP09.phx.gbl... >>> Hi >>> >>> The SQL Server service account needs to be a domain account, and must >>> have rights on the destination share. >>> >>> Regards >>> -------------------------------- >>> Mike Epprecht, Microsoft SQL Server MVP >>> Zurich, Switzerland >>> >>> IM: mike@epprecht.net >>> >>> MVP Program: http://www.microsoft.com/mvp >>> >>> Blog: http://www.msmvps.com/epprecht/ >>> >>> "Kevin" <kevgrim@tesco.net> wrote in message >>> news:%23ZmdjA4uFHA.2312@TK2MSFTNGP14.phx.gbl... >>>> Am trying to backup to a network drive as the other machine has loads >>>> of space. >>>> Am using:- >>>> BACKUP database TO DISK='\\myserver\backup\database.bak' >>>> >>>> Keep getting backup device not available, when can see it via Network >>>> Places etc. >>>> Am using Windows 2000 Pro on both machines. >>>> >>> >>> >> >> > >
hi Kevin
[quoted text, click to view] Kevin wrote: > Thanks Mike > > The PC has rights to the other one. > Am not sure what you mean by a domain account as am only using peer > to peer networking. just a side note on Mike indications.... all this works becouse of the underlying OS gets somehow confused and a sort of "embezzlement" where 2 differents accounts, YourPC\YourAccount and OtherPC\YourAccount "share" a kind of uniqueness becouse of netbios intrusion... a preventive netbios connection, even on a share or using NET USE can help... but this is not granted to work in future releases or even OS service packs... -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
Hi
The SQL Server service account needs to be a domain account, and must have rights on the destination share. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ [quoted text, click to view] "Kevin" <kevgrim@tesco.net> wrote in message news:%23ZmdjA4uFHA.2312@TK2MSFTNGP14.phx.gbl... > Am trying to backup to a network drive as the other machine has loads of > space. > Am using:- > BACKUP database TO DISK='\\myserver\backup\database.bak' > > Keep getting backup device not available, when can see it via Network > Places etc. > Am using Windows 2000 Pro on both machines. >
Am trying to backup to a network drive as the other machine has loads of
space. Am using:- BACKUP database TO DISK='\\myserver\backup\database.bak' Keep getting backup device not available, when can see it via Network Places etc. Am using Windows 2000 Pro on both machines.
Thanks Mike
The PC has rights to the other one. Am not sure what you mean by a domain account as am only using peer to peer networking. Kevin [quoted text, click to view] "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message news:OKetdH4uFHA.1560@TK2MSFTNGP09.phx.gbl... > Hi > > The SQL Server service account needs to be a domain account, and must have > rights on the destination share. > > Regards > -------------------------------- > Mike Epprecht, Microsoft SQL Server MVP > Zurich, Switzerland > > IM: mike@epprecht.net > > MVP Program: http://www.microsoft.com/mvp > > Blog: http://www.msmvps.com/epprecht/ > > "Kevin" <kevgrim@tesco.net> wrote in message > news:%23ZmdjA4uFHA.2312@TK2MSFTNGP14.phx.gbl... >> Am trying to backup to a network drive as the other machine has loads of >> space. >> Am using:- >> BACKUP database TO DISK='\\myserver\backup\database.bak' >> >> Keep getting backup device not available, when can see it via Network >> Places etc. >> Am using Windows 2000 Pro on both machines. >> > >
Not true - the user does NOT need to be administrator on both machines. If
you run SQL Server under the Local System account, it never has any network credentials and cannot access either UNC paths or shared drives. But if you run SQL Server as any other user, you can see the network (although you may have to make this account a local administrator for it to run). If you can set your remote machine up so that you can see the share (which doesn't necessarily mean a matching username or password - you may be able to allow access to "Everyone" or "Anonymous Logon" or "Guest"), you don't even need an account on the remote machine. You certainly don't need an administrator account there. Ideally you should apply the principle of least privilege - run SQL Server under an account with the least privilege it needs to do its job, then create a matching account on the remote machine with access just to the share. [quoted text, click to view] "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message news:%2359rIB5uFHA.2396@TK2MSFTNGP14.phx.gbl... > But since you are using MSDE, Start > Control Panel > Services, modify the > Service Account startup for your MSDE installation there. > The account must be local administrator on both machines. > > Regards > -------------------------------- > Mike Epprecht, Microsoft SQL Server MVP > Zurich, Switzerland > > IM: mike@epprecht.net > > MVP Program: http://www.microsoft.com/mvp > > Blog: http://www.msmvps.com/epprecht/ > > "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message > news:eIfkjp4uFHA.3000@TK2MSFTNGP12.phx.gbl... >> Hi >> >> OK. Then you need to setup SQL Server to use a local account that exists >> on your machine. The same local account must exist on the other PC too, >> with exactly the same password. >> >> You change the account the SQL Server uses to login through Enterprise >> Manager, Server Properties, Security Tab. >> >> Regards >> -------------------------------- >> Mike Epprecht, Microsoft SQL Server MVP >> Zurich, Switzerland >> >> IM: mike@epprecht.net >> >> MVP Program: http://www.microsoft.com/mvp >> >> Blog: http://www.msmvps.com/epprecht/ >> >> "Kevin" <kevgrim@tesco.net> wrote in message >> news:u9IoaX4uFHA.2948@TK2MSFTNGP15.phx.gbl... >>> Thanks Mike >>> >>> The PC has rights to the other one. >>> Am not sure what you mean by a domain account as am only using peer to >>> peer networking. >>> >>> Kevin >>> >>> "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message >>> news:OKetdH4uFHA.1560@TK2MSFTNGP09.phx.gbl... >>>> Hi >>>> >>>> The SQL Server service account needs to be a domain account, and must >>>> have rights on the destination share. >>>> >>>> Regards >>>> -------------------------------- >>>> Mike Epprecht, Microsoft SQL Server MVP >>>> Zurich, Switzerland >>>> >>>> IM: mike@epprecht.net >>>> >>>> MVP Program: http://www.microsoft.com/mvp >>>> >>>> Blog: http://www.msmvps.com/epprecht/ >>>> >>>> "Kevin" <kevgrim@tesco.net> wrote in message >>>> news:%23ZmdjA4uFHA.2312@TK2MSFTNGP14.phx.gbl... >>>>> Am trying to backup to a network drive as the other machine has loads >>>>> of space. >>>>> Am using:- >>>>> BACKUP database TO DISK='\\myserver\backup\database.bak' >>>>> >>>>> Keep getting backup device not available, when can see it via Network >>>>> Places etc. >>>>> Am using Windows 2000 Pro on both machines. >>>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |