Barcode not Printing when exported to PDF

This seems to be an issue for a lot of people. Is there a workaround for
this?
I am using 3of9.ttf it is on the report server and my local machine. the
barcode shows up inthe web view but disappears in the saved/printed pdf.Hi Eric,
Based on research, this issue seems to be a known issue that is caused by
Acrobat related driver. Usaing different Acrobot version may have different
results. When exporting a report with a barcode font (AdvI25d_.TTF) to a
PDF, the first two characters of the font run together and become
unreadable. The workaround at present is using TIFF image other than this
Font.
http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREAT
E/htm/rcr_creating_layout_v1_0rz9.asp
You may want to contact Microsoft Customer Support Services (CSS) for more
information on this issue because they may have update on the processing of
resolving this issue with Acrobat because it is more dependent on their
support. I appreciate your understanding on this.
If anything is unclear or you have further questions on this, please feel
free to let us know. Have a great day!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||This issue was solved for printing directly to PDF by increasing the size of
the text box 3x
if you are viewing this first in HTML this fix will not work.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:BdnGWCbGHHA.2300@.TK2MSFTNGHUB02.phx.gbl...
> Hi Eric,
> Based on research, this issue seems to be a known issue that is caused by
> Acrobat related driver. Usaing different Acrobot version may have
> different
> results. When exporting a report with a barcode font (AdvI25d_.TTF) to a
> PDF, the first two characters of the font run together and become
> unreadable. The workaround at present is using TIFF image other than this
> Font.
> http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREAT
> E/htm/rcr_creating_layout_v1_0rz9.asp
> You may want to contact Microsoft Customer Support Services (CSS) for
> more
> information on this issue because they may have update on the processing
> of
> resolving this issue with Acrobat because it is more dependent on their
> support. I appreciate your understanding on this.
> If anything is unclear or you have further questions on this, please feel
> free to let us know. Have a great day!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Thank you. For whatever reason, that fixed the issue for me too.
Wei's suggested work-around of converting to tiff doesn't do the job
completely, as the barcode printed from the tiff file is not
scannable.
-Prabhakar
On Dec 13 2006, 8:28 am, "Eric Cathell"
<depicture...@.community.nospam> wrote:
> This issue was solved for printing directly toPDFby increasing the size of
> the text box 3x
> if you are viewing this first in HTML this fix will not work.
> "Wei Lu [MSFT]" <w...@.online.microsoft.com> wrote in messagenews:BdnGWCbGHHA.2300@.TK2MSFTNGHUB02.phx.gbl...
> > Hi Eric,
> > Based on research, this issue seems to be a known issue that is caused by
> > Acrobat related driver. Usaing different Acrobot version may have
> > different
> > results. Whenexportinga report with abarcodefont (AdvI25d_.TTF) to a
> >PDF, the first two characters of the font run together and become
> > unreadable. The workaround at present is using TIFF image other than this
> > Font.
> >http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/...
> > E/htm/rcr_creating_layout_v1_0rz9.asp
> > You may want to contact Microsoft Customer Support Services (CSS) for
> > more
> > information on this issue because they may have update on the processing
> > of
> > resolving this issue with Acrobat because it is more dependent on their
> > support. I appreciate your understanding on this.
> > If anything is unclear or you have further questions on this, please feel
> > free to let us know. Have a great day!
> > Sincerely,
> > Wei Lu
> > Microsoft Online Community Support
> > ==================================================> > Get notification to my posts through email? Please refer to
> >http://msdn.microsoft.com/subscriptions/managednewsgroups/default.asp...
> > ications.
> > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> > where an initial response from the community or a Microsoft Support
> > Engineer within 1 business day is acceptable. Please note that each follow
> > up response may take approximately 2 business days as the support
> > professional working with you may need further investigation to reach the
> > most efficient resolution. The offering is not appropriate for situations
> > that require urgent, real-time or phone-based interactions or complex
> > project analysis and dump analysis issues. Issues of this nature are best
> > handled working with a dedicated Microsoft Support Engineer by contacting
> > Microsoft Customer Support Services (CSS) at
> >http://msdn.microsoft.com/subscriptions/support/default.aspx.
> > ==================================================> > (This posting is provided "AS IS", with no warranties, and confers no
> > rights.)

Bar Chart uses Same color on one machine, but renders OK on others

In some of my reports, I have both a bar and a pie chart. The pie chart
renders the correct color, howerver the bar chard renders only green for the
three bars when they should be different colors. This seems to be isolated
as other machines render the correct colors... Suggestions on where I would
go to troubleshoot this problem? Thankscheck to see if the color is standard, web, etc color. The system where it
doesn't display correctly might have a different color depth that doesn't
support the selected color,
--
Floyd
"CMP" <CMP@.discussions.microsoft.com> wrote in message
news:6878CE03-CC97-4F2E-A022-4328726F0CB2@.microsoft.com...
> In some of my reports, I have both a bar and a pie chart. The pie chart
> renders the correct color, howerver the bar chard renders only green for
> the
> three bars when they should be different colors. This seems to be
> isolated
> as other machines render the correct colors... Suggestions on where I
> would
> go to troubleshoot this problem? Thanks

Bad Installation, can't uninstall, can't re-install

Something happened to my SQL installation on my development machine, and I can't fix it. I can't uninstall, I can't re-install. I even booted safe mode, deleted the SQL directory and tried to install -- that failed too. The best I have been able to manage
is installing the client tools.
I have a regular server but I prefer to do development on a local installation so as not to slow the server down or clutter it with my experiments.
The client tools cannot see my real server. The curious thing is that an Access ADP that I run CAN see the server, and hit its database with no problem.
I'm running winXP with all the service packs.
The message that I get when I try to run EM or QA locally is:
[Microsoft] ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed.
I have no idea what this message means.
Can I forcibly uninstall everything do to with SQL Server and start over? Are there registry settings I have to kill as well? Or is my only choice to back up everything and then reformat and start over? That could take days! I have a LOT of software tools
installed on the development machine.
Arthur Fuller
Chief Code Monkey
Artful Development Organization
This error: "[Microsoft] ODBC Driver Manager] Driver's SQLAllocHandle on
SQL_HANDLE_ENV failed.
" seems to indicated a problem with the ODBC components on the machine.
Try installing MDAC 2.7 sp1Refresh on the box.
http://www.microsoft.com/downloads/d...0f2-cae7-493d-
b0f3-ae36c570ade8&languageid=f49e8428-7071-4979-8a67-3cffcb0c2524&displaylan
g=en
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Bad Installation, can't uninstall, can't re-install

Something happened to my SQL installation on my development machine, and I c
an't fix it. I can't uninstall, I can't re-install. I even booted safe mode,
deleted the SQL directory and tried to install -- that failed too. The best
I have been able to manage
is installing the client tools.
I have a regular server but I prefer to do development on a local installati
on so as not to slow the server down or clutter it with my experiments.
The client tools cannot see my real server. The curious thing is that an Acc
ess ADP that I run CAN see the server, and hit its database with no problem.
I'm running winXP with all the service packs.
The message that I get when I try to run EM or QA locally is:
[Microsoft] ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_E
NV failed.
I have no idea what this message means.
Can I forcibly uninstall everything do to with SQL Server and start over? Ar
e there registry settings I have to kill as well? Or is my only choice to ba
ck up everything and then reformat and start over? That could take days! I h
ave a LOT of software tools
installed on the development machine.
Arthur Fuller
Chief Code Monkey
Artful Development OrganizationThis error: "[Microsoft] ODBC Driver Manager] Driver's SQLAllocHandle on
SQL_HANDLE_ENV failed.
" seems to indicated a problem with the ODBC components on the machine.
Try installing MDAC 2.7 sp1Refresh on the box.
http://www.microsoft.com/downloads/...00f2-cae7-493d-
b0f3-ae36c570ade8&languageid=f49e8428-7071-4979-8a67-3cffcb0c2524&displaylan
g=en
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Bad Installation But Cannot Uninstall Reporting Services - Need He

I seem to have had a problem regarding my installation of SQL Server 2005 -
Developer Edition on my Windows XP Pro machine. I have tried to uninstall
either Reporting Services or all of SQL Server. However, it keeps getting
stuck in the Uninstall of Reporting Services and then does a rollback.
The error that I am getting in each case is as follows:
Setup failed to read IISMEMMAP TABLE. The Errorcode is -2147024893.
Does anyone know how to get out of this so I can try to fix the installation?
Thanks for any advice.
--
John GallagherHi John,
You may try using the tools below to remove SQL Server 2005 manually
Description of the Windows Installer CleanUp Utility
http://support.microsoft.com/kb/290301/en-us
Sincerely yours,
Michael Cheng
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.

Bacon in the fire

I have installed MSDE sp3 with the SAPWD and DISABLENETWORKPROTOCOLS=0
switches set. The server works fine on the local machine but attempts to
access it respond with a 'server does not exist or access denied' message.
How do I verify (via osql) that the NetLib is installed correctly for
TCP/IP? If it is not how do I configure it?
Semper Fi,
Red
Please post to newsgroup only
hi Stephen,
"Stephen J Bement" <spam@.null.net> ha scritto nel messaggio
news:%23RtoNK$nEHA.708@.TK2MSFTNGP09.phx.gbl
> I have installed MSDE sp3 with the SAPWD and DISABLENETWORKPROTOCOLS=0
> switches set. The server works fine on the local machine but attempts
> to access it respond with a 'server does not exist or access denied'
> message.
> How do I verify (via osql) that the NetLib is installed correctly for
> TCP/IP? If it is not how do I configure it?
if you are running Windows XP service pack 2, perhaps
http://support.microsoft.com/default.aspx?kbid=841249 is worth reading
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||the system is running XP sp1 not sp2. It does not have any firewall software
running. It can connect to the Server system (i.e. connect drives copy files
and PCAnywhere) but cannot communicate with the SQL Server.
TIA
Semper Fi,
Red
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2rb1i1F17ftttU1@.uni-berlin.de...
> hi Stephen,
> "Stephen J Bement" <spam@.null.net> ha scritto nel messaggio
> news:%23RtoNK$nEHA.708@.TK2MSFTNGP09.phx.gbl
> if you are running Windows XP service pack 2, perhaps
> http://support.microsoft.com/default.aspx?kbid=841249 is worth reading
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||You might want to check out following article.
BUG: You may not be able to connect to an instance of Microsoft SQL Server
2000 Desktop Engine SP3a or to an instance of Microsoft SQL Server 2000
Desktop Engine (Windows) after you enable the server network libraries
http://support.microsoft.com/?id=827204
To checkout if network libraries are enabled, you can just see errorlog and
see if SQL Server is listening on named pipe and tcp/ip libraries.

backups getting huge

Is replication suppose to continually grow the database backups on the
distribution machine? I had to remove replication because the backups grew a
couple gig in about a months time. Am I missing something? I've tried this
twice now with the same results. Thanks.
for merge it may. For transactional it shouldn't if your log reader agent is
running frequently.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"s" <s@.discussions.microsoft.com> wrote in message
news:9B0AD4A6-D102-486C-9FAF-9091B954E9A3@.microsoft.com...
> Is replication suppose to continually grow the database backups on the
> distribution machine? I had to remove replication because the backups grew
a
> couple gig in about a months time. Am I missing something? I've tried this
> twice now with the same results. Thanks.
|||Thanks for the reply. I was using snapshot replication. Would this also
create continually growing backups? Is there any way to get around this
effect?
"Hilary Cotter" wrote:

> for merge it may. For transactional it shouldn't if your log reader agent is
> running frequently.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "s" <s@.discussions.microsoft.com> wrote in message
> news:9B0AD4A6-D102-486C-9FAF-9091B954E9A3@.microsoft.com...
> a
>
>

backups

Need to do sql server 2000 database and transaction log
backups. Using the backup wizard. Can back up on the
server machine no problem.
But I need to back up to another M/C which is visibly
connected by the network, and to a CD burner (which is
drive d on the server mc.) I have typed in a variety of
paths for each scenario and nothing is working.
Thank you
AnnAnn,
You need to use the UNC pattern.First create a share in that remote server,
make sure that the account under which SQL Server is running has the
required privileges/permissions on that share.After that, do the backup as:
BACKUP DATABASE <dbname>
TO DISK = '\\destserver\d$\dbbackup.BAK'
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"ann" <akukich@.plaind.com> wrote in message
news:025801c37d32$23687170$a101280a@.phx.gbl...
> Need to do sql server 2000 database and transaction log
> backups. Using the backup wizard. Can back up on the
> server machine no problem.
> But I need to back up to another M/C which is visibly
> connected by the network, and to a CD burner (which is
> drive d on the server mc.) I have typed in a variety of
> paths for each scenario and nothing is working.
> Thank you
> Ann|||Use the UNC paths. Example:
\\MachineName\ShareName
or
\\MachineName\Driver$\Folder1\Folder2
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"ann" <akukich@.plaind.com> wrote in message
news:025801c37d32$23687170$a101280a@.phx.gbl...
Need to do sql server 2000 database and transaction log
backups. Using the backup wizard. Can back up on the
server machine no problem.
But I need to back up to another M/C which is visibly
connected by the network, and to a CD burner (which is
drive d on the server mc.) I have typed in a variety of
paths for each scenario and nothing is working.
Thank you
Ann

Backup/Restore Versus Detach/Attach

Hi All,
when I've to deploy my applications (c# and MSDE), generally I make a backup
on th edevelopment machine of the SQL Database the on the deployment machine
I make a restore and restoring from the backup I get my database up and
running (so boiring that I've to change the data/log file path at any
restore...).
Are there any real differences if instead of backup/restore I detach the
database file from the development machine (running sql developer edition)
then copy the file on the deployment machine and then make an attach to that
file?
which one is the best way?
Thanks, Davide.
Davide Piras
Naxo Software
hi Davide,
Davide Piras wrote:
> Hi All,
> when I've to deploy my applications (c# and MSDE), generally I make a
> backup on th edevelopment machine of the SQL Database the on the
> deployment machine I make a restore and restoring from the backup I
> get my database up and running (so boiring that I've to change the
> data/log file path at any restore...).
> Are there any real differences if instead of backup/restore I detach
> the database file from the development machine (running sql developer
> edition) then copy the file on the deployment machine and then make
> an attach to that file?
> which one is the best way?
please remember to add the log file to your distribution too, as it's part
of the dabase files set... and reattaching without the log file can end in
attaching problems...
the restore scenario only requires a little more physical space as you have
to consider the backup size in addition to the database files size...
both scenarios are simple to run but you have to consider some potential
issues..
MSDE usually set the "autoclose" database property, where the full blown SQL
Server editions do not, so you'll end up with a database that does not
reflect this standard MSDE setting, but it could be a choice...
you do not inherit database settings/options/objects from the end user model
database but from yours...
this can bring up some problems regarding orphaned users you will have to
fix by use of the sp_change_users_login system stored procedure
(http://msdn.microsoft.com/library/de...ca-cz_8qzy.asp
, http://www.sqlservercentral.com/colu...okenlogins.asp )
personally I go this way, http://tinyurl.com/dyjjg , that will even help in
structure upgrade to, and can grant a database deployment based on version
control check ... and the best article I found for this kind of situation is
http://msdn.microsoft.com/msdnmag/is...baseinstaller/
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Ciao Andrea,
thanks for you help, I will read those articles BEFORE the next deployment
loop...
you know I use your DbaManager 0.12.0 as a Client User Interface?! :-)
Nice and useful Tool, thanks!
Davide.

Backup to Network Resource from a Server Machine Service Account

SQL Server 2000 SP4
Trying to backup to a network resource when SQL uses the machine service
account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_name',
'\\filer_name\share_name\path\file_name.ext' would be used but this doesn't
work because of permissions.
Fairly new to DBA stuff so please have patience with me.
How can you do this?
Regards,
Richard.
You would need to have SQL Server using a service account that has permissions on that share.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_name',
> '\\filer_name\share_name\path\file_name.ext' would be used but this doesn't
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.
|||I don't think Windows security works like that:
Services Using The System Account
Services that use the system account start in the system context (without
credentials). In Windows NT 3.5 and later, Windows NT services with no
credentials (no domain name, user name, or password) that attempt to connect
to network resources are denied access because they have no credentials and
they are using a null session. For additional information, click the article
number below to view the article in the Microsoft Knowledge Base:
from: http://support.microsoft.com/kb/132679
Essentially the local system account has no credentials so cannot
athenticate to anything on the network.
Is there anyway round this?
"Tibor Karaszi" wrote:

> You would need to have SQL Server using a service account that has permissions on that share.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
> news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
>
>
|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk',
> 'device_name',
> '\\filer_name\share_name\path\file_name.ext' would be used but this
> doesn't
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.
|||>I don't think Windows security works like that:
I don't see in what way what I said differs from the text you quoted.

> Is there anyway round this?
Not AFAIK...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:C2D36167-F2BE-464E-9404-3A689C9A0A22@.microsoft.com...[vbcol=seagreen]
>I don't think Windows security works like that:
> Services Using The System Account
> Services that use the system account start in the system context (without
> credentials). In Windows NT 3.5 and later, Windows NT services with no
> credentials (no domain name, user name, or password) that attempt to connect
> to network resources are denied access because they have no credentials and
> they are using a null session. For additional information, click the article
> number below to view the article in the Microsoft Knowledge Base:
> from: http://support.microsoft.com/kb/132679
> Essentially the local system account has no credentials so cannot
> athenticate to anything on the network.
>
> Is there anyway round this?
> "Tibor Karaszi" wrote:
|||As Tibor pointed out you need an account to run SQL Server Service under
that has the appropriate permissions to that share. A LOCAL account has no
permissions outside that box. So change it to a Domain account with the
appropriate permissions.
Andrew J. Kelly SQL MVP
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:C2D36167-F2BE-464E-9404-3A689C9A0A22@.microsoft.com...[vbcol=seagreen]
>I don't think Windows security works like that:
> Services Using The System Account
> Services that use the system account start in the system context (without
> credentials). In Windows NT 3.5 and later, Windows NT services with no
> credentials (no domain name, user name, or password) that attempt to
> connect
> to network resources are denied access because they have no credentials
> and
> they are using a null session. For additional information, click the
> article
> number below to view the article in the Microsoft Knowledge Base:
> from: http://support.microsoft.com/kb/132679
> Essentially the local system account has no credentials so cannot
> athenticate to anything on the network.
>
> Is there anyway round this?
> "Tibor Karaszi" wrote:
|||Hello,
To solve the issue you have start the SQL Server service using an Domain OS
user which got write
access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk',
> 'device_name',
> '\\filer_name\share_name\path\file_name.ext' would be used but this
> doesn't
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.

Backup to Network Resource from a Server Machine Service Account

SQL Server 2000 SP4
Trying to backup to a network resource when SQL uses the machine service
account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_name',
'\\filer_name\share_name\path\file_name.ext' would be used but this doesn't
work because of permissions.
Fairly new to DBA stuff so please have patience with me.
How can you do this?
Regards,
Richard.You would need to have SQL Server using a service account that has permissions on that share.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_name',
> '\\filer_name\share_name\path\file_name.ext' would be used but this doesn't
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.|||I don't think Windows security works like that:
Services Using The System Account
Services that use the system account start in the system context (without
credentials). In Windows NT 3.5 and later, Windows NT services with no
credentials (no domain name, user name, or password) that attempt to connect
to network resources are denied access because they have no credentials and
they are using a null session. For additional information, click the article
number below to view the article in the Microsoft Knowledge Base:
from: http://support.microsoft.com/kb/132679
Essentially the local system account has no credentials so cannot
athenticate to anything on the network.
Is there anyway round this?
"Tibor Karaszi" wrote:
> You would need to have SQL Server using a service account that has permissions on that share.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
> news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> > SQL Server 2000 SP4
> >
> > Trying to backup to a network resource when SQL uses the machine service
> > account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_name',
> > '\\filer_name\share_name\path\file_name.ext' would be used but this doesn't
> > work because of permissions.
> >
> > Fairly new to DBA stuff so please have patience with me.
> >
> > How can you do this?
> >
> > Regards,
> > Richard.
>
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk',
> 'device_name',
> '\\filer_name\share_name\path\file_name.ext' would be used but this
> doesn't
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.|||>I don't think Windows security works like that:
I don't see in what way what I said differs from the text you quoted.
> Is there anyway round this?
Not AFAIK...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:C2D36167-F2BE-464E-9404-3A689C9A0A22@.microsoft.com...
>I don't think Windows security works like that:
> Services Using The System Account
> Services that use the system account start in the system context (without
> credentials). In Windows NT 3.5 and later, Windows NT services with no
> credentials (no domain name, user name, or password) that attempt to connect
> to network resources are denied access because they have no credentials and
> they are using a null session. For additional information, click the article
> number below to view the article in the Microsoft Knowledge Base:
> from: http://support.microsoft.com/kb/132679
> Essentially the local system account has no credentials so cannot
> athenticate to anything on the network.
>
> Is there anyway round this?
> "Tibor Karaszi" wrote:
>> You would need to have SQL Server using a service account that has permissions on that share.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
>> news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
>> > SQL Server 2000 SP4
>> >
>> > Trying to backup to a network resource when SQL uses the machine service
>> > account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_name',
>> > '\\filer_name\share_name\path\file_name.ext' would be used but this doesn't
>> > work because of permissions.
>> >
>> > Fairly new to DBA stuff so please have patience with me.
>> >
>> > How can you do this?
>> >
>> > Regards,
>> > Richard.
>>|||As Tibor pointed out you need an account to run SQL Server Service under
that has the appropriate permissions to that share. A LOCAL account has no
permissions outside that box. So change it to a Domain account with the
appropriate permissions.
--
Andrew J. Kelly SQL MVP
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:C2D36167-F2BE-464E-9404-3A689C9A0A22@.microsoft.com...
>I don't think Windows security works like that:
> Services Using The System Account
> Services that use the system account start in the system context (without
> credentials). In Windows NT 3.5 and later, Windows NT services with no
> credentials (no domain name, user name, or password) that attempt to
> connect
> to network resources are denied access because they have no credentials
> and
> they are using a null session. For additional information, click the
> article
> number below to view the article in the Microsoft Knowledge Base:
> from: http://support.microsoft.com/kb/132679
> Essentially the local system account has no credentials so cannot
> athenticate to anything on the network.
>
> Is there anyway round this?
> "Tibor Karaszi" wrote:
>> You would need to have SQL Server using a service account that has
>> permissions on that share.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
>> news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
>> > SQL Server 2000 SP4
>> >
>> > Trying to backup to a network resource when SQL uses the machine
>> > service
>> > account. Obviously something like EXEC sp_addumpdevice 'disk',
>> > 'device_name',
>> > '\\filer_name\share_name\path\file_name.ext' would be used but this
>> > doesn't
>> > work because of permissions.
>> >
>> > Fairly new to DBA stuff so please have patience with me.
>> >
>> > How can you do this?
>> >
>> > Regards,
>> > Richard.
>>|||Hello,
To solve the issue you have start the SQL Server service using an Domain OS
user which got write
access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk',
> 'device_name',
> '\\filer_name\share_name\path\file_name.ext' would be used but this
> doesn't
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.

Backup to Network Resource from a Server Machine Service Account

SQL Server 2000 SP4
Trying to backup to a network resource when SQL uses the machine service
account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_name'
,
'\\filer_name\share_name\path\file_name.ext' would be used but this doesn't
work because of permissions.
Fairly new to DBA stuff so please have patience with me.
How can you do this?
Regards,
Richard.You would need to have SQL Server using a service account that has permissio
ns on that share.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk', 'device_nam
e',
> '\\filer_name\share_name\path\file_name.ext' would be used but this doesn'
t
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk',
> 'device_name',
> '\\filer_name\share_name\path\file_name.ext' would be used but this
> doesn't
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.|||Hello,
To solve the issue you have start the SQL Server service using an Domain OS
user which got write
access to the remote share.
So go to Control Panel -- Admin Tools -- Services -- MSSQL Server sercice--
Double click and select the "Log on" option.
There you give a Valid Domain OS user and password to start the service. Now
stop and start the MSSQL Serevr service.
Note: That domain user should have previlages in the remote share to write
the file as well as prev. to start the SQL server.
After this you try to execute the Backup database command in Query
Analyzer:-
Backup database <dbname> to Disk='\\backup\tmp\networkdatabase.dat' with
init ( With init will overwrite the backup file every time)
Thanks
Hari
"BQ_rmsterling" <richard.sterling@.bluesq.com> wrote in message
news:77F10996-5141-4C32-BE8B-6CF9A973FC0C@.microsoft.com...
> SQL Server 2000 SP4
> Trying to backup to a network resource when SQL uses the machine service
> account. Obviously something like EXEC sp_addumpdevice 'disk',
> 'device_name',
> '\\filer_name\share_name\path\file_name.ext' would be used but this
> doesn't
> work because of permissions.
> Fairly new to DBA stuff so please have patience with me.
> How can you do this?
> Regards,
> Richard.

Backup to Network Drive

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
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.
>
|||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...
>
|||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...
>
|||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...
>
|||hi Kevin
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.shtmhttp://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
|||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.
"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...
>

Backup to Location over VPN

Hi,
I am having problems with creating a backup onto a machine that is connected to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specified, yet when i use Windows explorer I can copy and paste to my hearts content.
I was just wondering if the backup of a database can be done to a location over a VPN.
Thanks in Advance
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Backups are done under the account that SQL Server runs under, not the
account you are using when you log in to QA or EM. SQL Server is most
likely running under the local service account which knows nothing of the
VPN or the Domain.
Andrew J. Kelly SQL MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uhIiucxbEHA.252@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having problems with creating a backup onto a machine that is
connected to the domain via a VPN connection.
> When i do the back up it does not recognize the directory that I have
specified, yet when i use Windows explorer I can copy and paste to my hearts
content.
> I was just wondering if the backup of a database can be done to a location
over a VPN.
> Thanks in Advance
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Backup to Location over VPN

Hi,
I am having problems with creating a backup onto a machine that is connected
to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specif
ied, yet when i use Windows explorer I can copy and paste to my hearts conte
nt.
I was just wondering if the backup of a database can be done to a location o
ver a VPN.
Thanks in Advance
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.Backups are done under the account that SQL Server runs under, not the
account you are using when you log in to QA or EM. SQL Server is most
likely running under the local service account which knows nothing of the
VPN or the Domain.
Andrew J. Kelly SQL MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uhIiucxbEHA.252@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having problems with creating a backup onto a machine that is
connected to the domain via a VPN connection.
> When i do the back up it does not recognize the directory that I have
specified, yet when i use Windows explorer I can copy and paste to my hearts
content.
> I was just wondering if the backup of a database can be done to a location
over a VPN.
> Thanks in Advance
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Backup to an USB Device

Hi:
Can anyone help me with backing up SQL Server Databases to a Shared USB
Device over a Network. I am able to Map the USB Drive on the machine. However
when I am trying to configure Backup using the Maintainence Wizard it does
not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
Server SP1. Please let me know if this is possible.
Thanks
Mitul
Hi,
You'll have to enter the UNC path to the device and then the account
that runs SQL server needs to have permissions to the share.
You problem right now is most likely that you have mapped the USB drive
with a different account than SQLserver/SQL server agent runs under and
that's why it doesn't appear.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Mitul Z wrote:
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine. However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul
|||http://support.microsoft.com/kb/555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine.
> However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul
|||Thanks for the reply.
The article states that this needs to be configured with a Domain account.
However we don't have an domain environment, then will SQL Server Services
running under Administrator Account suffice.
Thanks
Mitul Z
"Geoff N. Hiten" wrote:

> http://support.microsoft.com/kb/555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
>
|||The domain acount is necessary to access network resources. It provodes a
common security context. Administrator is only valid for the local machine
and has no meaning across the network. In short, no, it won't work
reliably.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:3F91A798-3779-4A21-A91C-983E3024A645@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply.
> The article states that this needs to be configured with a Domain account.
> However we don't have an domain environment, then will SQL Server Services
> running under Administrator Account suffice.
> Thanks
> Mitul Z
> "Geoff N. Hiten" wrote:

Backup to an USB Device

Hi:
Can anyone help me with backing up SQL Server Databases to a Shared USB
Device over a Network. I am able to Map the USB Drive on the machine. Howeve
r
when I am trying to configure Backup using the Maintainence Wizard it does
not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
Server SP1. Please let me know if this is possible.
Thanks
MitulHi,
You'll have to enter the UNC path to the device and then the account
that runs SQL server needs to have permissions to the share.
You problem right now is most likely that you have mapped the USB drive
with a different account than SQLserver/SQL server agent runs under and
that's why it doesn't appear.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Mitul Z wrote:
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine. Howe
ver
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||http://support.microsoft.com/kb/555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine.
> However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||Thanks for the reply.
The article states that this needs to be configured with a Domain account.
However we don't have an domain environment, then will SQL Server Services
running under Administrator Account suffice.
Thanks
Mitul Z
"Geoff N. Hiten" wrote:

> http://support.microsoft.com/kb/555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
>|||The domain acount is necessary to access network resources. It provodes a
common security context. Administrator is only valid for the local machine
and has no meaning across the network. In short, no, it won't work
reliably.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:3F91A798-3779-4A21-A91C-983E3024A645@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply.
> The article states that this needs to be configured with a Domain account.
> However we don't have an domain environment, then will SQL Server Services
> running under Administrator Account suffice.
> Thanks
> Mitul Z
> "Geoff N. Hiten" wrote:
>

Backup to an USB Device

Hi:
Can anyone help me with backing up SQL Server Databases to a Shared USB
Device over a Network. I am able to Map the USB Drive on the machine. However
when I am trying to configure Backup using the Maintainence Wizard it does
not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
Server SP1. Please let me know if this is possible.
Thanks
MitulHi,
You'll have to enter the UNC path to the device and then the account
that runs SQL server needs to have permissions to the share.
You problem right now is most likely that you have mapped the USB drive
with a different account than SQLserver/SQL server agent runs under and
that's why it doesn't appear.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Mitul Z wrote:
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine. However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||http://support.microsoft.com/kb/555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> Hi:
> Can anyone help me with backing up SQL Server Databases to a Shared USB
> Device over a Network. I am able to Map the USB Drive on the machine.
> However
> when I am trying to configure Backup using the Maintainence Wizard it does
> not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> Server SP1. Please let me know if this is possible.
> Thanks
> Mitul|||Thanks for the reply.
The article states that this needs to be configured with a Domain account.
However we don't have an domain environment, then will SQL Server Services
running under Administrator Account suffice.
Thanks
Mitul Z
"Geoff N. Hiten" wrote:
> http://support.microsoft.com/kb/555128
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
> > Hi:
> >
> > Can anyone help me with backing up SQL Server Databases to a Shared USB
> > Device over a Network. I am able to Map the USB Drive on the machine.
> > However
> > when I am trying to configure Backup using the Maintainence Wizard it does
> > not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
> > Server SP1. Please let me know if this is possible.
> >
> > Thanks
> > Mitul
>|||The domain acount is necessary to access network resources. It provodes a
common security context. Administrator is only valid for the local machine
and has no meaning across the network. In short, no, it won't work
reliably.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
news:3F91A798-3779-4A21-A91C-983E3024A645@.microsoft.com...
> Thanks for the reply.
> The article states that this needs to be configured with a Domain account.
> However we don't have an domain environment, then will SQL Server Services
> running under Administrator Account suffice.
> Thanks
> Mitul Z
> "Geoff N. Hiten" wrote:
>> http://support.microsoft.com/kb/555128
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "Mitul Z" <MitulZ@.discussions.microsoft.com> wrote in message
>> news:630D134F-F808-41B1-932B-5E8746466A40@.microsoft.com...
>> > Hi:
>> >
>> > Can anyone help me with backing up SQL Server Databases to a Shared USB
>> > Device over a Network. I am able to Map the USB Drive on the machine.
>> > However
>> > when I am trying to configure Backup using the Maintainence Wizard it
>> > does
>> > not show the Mapped Drive. I am using SQL 2000 Server with Windows 2003
>> > Server SP1. Please let me know if this is possible.
>> >
>> > Thanks
>> > Mitul
>>