Can't see mapped drives

Hi,
Am unable to see mapped drive when going to restore db in
sql 2000 enterprise manager. Service is set to start
with a lan acct. acct is in the local machine admin grp
and remote machine admin grp.
Any suggestions:-)
Thanks in advanceDo not use mapped drives for backup\restore with SQL server. Use UNC names
instead. SQL may or may not see a mapped drive correctly but will always
find a UNC share that it has permission and connection to.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:8f9b01c40541$3ade3230$a301280a@.phx.gbl...
> Hi,
> Am unable to see mapped drive when going to restore db in
> sql 2000 enterprise manager. Service is set to start
> with a lan acct. acct is in the local machine admin grp
> and remote machine admin grp.
> Any suggestions:-)
> Thanks in advance|||Hi,
You cant see the mapped drives in Enterprise manager. Rather you can
directly mention the UNC path directly in Enterprise manager or use
Restore database command from Query Analyzer.
Restore database <dbname> from disk='\\machinename\share\backupfile.bak'
with stats=10 With
Move 'logicaldatafile' to physcaldatafile',
Move 'logiallogfile' to physcallogfile'
stats will show the restore status
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:8f9b01c40541$3ade3230$a301280a@.phx.gbl...
> Hi,
> Am unable to see mapped drive when going to restore db in
> sql 2000 enterprise manager. Service is set to start
> with a lan acct. acct is in the local machine admin grp
> and remote machine admin grp.
> Any suggestions:-)
> Thanks in advance|||It is possible to get SQL Server to use mapped network drives, through the u
se of trace flag 1807.
Check out knowledge base article #304261 for full details
http://support.microsoft.com/defaul...1&Product=sql2k

Can't replicate with DB on LAN

Hi all,
I'm doing merge replication sql2000 to sql2000, handled programatically
in my c# application.
Everything is working perfectly when the publisher and subscriber are
on the same SQL Server registration, but not when I try to replicate
with SQL Server on our server.
The Server DB registration is listed in my local Enterprise Manager.
In my application, the working version of my setup includes these
variables:
// Publisher Info
private string strPublisher = "BCN"; //the local machine name
private string strPublisherAddress ="localhost"; // the local machine
private string strPublisherDatabase ="Pub1";
But if I simply change the publisher name:
// Publisher Info
private string strPublisher = "MON"; //the server machine name
I get an unspecified error.
- The DB Instance names are identical to the server names.
- Using TCP-IP Network protocol, tried Multi-protocol to no avail.
Can anyone help? I am really stuck at this point.
Thanks,
JJ
Update - If I switch away from TCP-IP to Default Network, it works.
I wonder how well it will work when I go back to TCP-IP when i test the
app's connection over a WAN.
JJ