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

cant login

Hi friends
I installed sql2000 dev edition on XP professional.i created a login in
sql.but whenver try to login to sql it says "this login is not associated
with trusted connection" and i cant login!!
am wondering how to fix that.
Thanks
Cheers
cheers
Hi
SQL Server is only setup to be using NT Integrated security.
On the Server Properties page, you can configure SQL Server to be "Mixed
Mode" and restart SQL Server.
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/
"rajani" <rajani@.discussions.microsoft.com> wrote in message
news:B8A81541-B555-430E-8067-4F2C00BB24EE@.microsoft.com...
> Hi friends
> I installed sql2000 dev edition on XP professional.i created a login in
> sql.but whenver try to login to sql it says "this login is not associated
> with trusted connection" and i cant login!!
> am wondering how to fix that.
> Thanks
> Cheers
> --
> cheers
|||Thanks Mike.
i was looking for that option everywhere.
cheers
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> SQL Server is only setup to be using NT Integrated security.
> On the Server Properties page, you can configure SQL Server to be "Mixed
> Mode" and restart SQL Server.
> 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/
> "rajani" <rajani@.discussions.microsoft.com> wrote in message
> news:B8A81541-B555-430E-8067-4F2C00BB24EE@.microsoft.com...
>
>
|||I'm still looking ...can you tell me where you found it? I'm not
sure where the Server Properties page is...
jared
On Sun, 10 Jul 2005 21:25:01 -0700, rajani
<rajani@.discussions.microsoft.com> wrote:

>Thanks Mike.
>i was looking for that option everywhere.
|||Hi jaredea
if u open enterprise manager on left hand side look for ur server name(under
"sql server group")
normally server names (local), server etc.,
right click and properties and go to security tab and you'll find it there.
if u still cant find it then send me ur emailid i will send u screenshot
cheers
"jaredea" wrote:

> I'm still looking ...can you tell me where you found it? I'm not
> sure where the Server Properties page is...
> jared
> On Sun, 10 Jul 2005 21:25:01 -0700, rajani
> <rajani@.discussions.microsoft.com> wrote:
>
>

cant login

Hi friends
I installed sql2000 dev edition on XP professional.i created a login in
sql.but whenver try to login to sql it says "this login is not associated
with trusted connection" and i cant login!!
am wondering how to fix that.
Thanks
Cheers
--
cheersHi
SQL Server is only setup to be using NT Integrated security.
On the Server Properties page, you can configure SQL Server to be "Mixed
Mode" and restart SQL Server.
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/
"rajani" <rajani@.discussions.microsoft.com> wrote in message
news:B8A81541-B555-430E-8067-4F2C00BB24EE@.microsoft.com...
> Hi friends
> I installed sql2000 dev edition on XP professional.i created a login in
> sql.but whenver try to login to sql it says "this login is not associated
> with trusted connection" and i cant login!!
> am wondering how to fix that.
> Thanks
> Cheers
> --
> cheers|||Thanks Mike.
i was looking for that option everywhere.
--
cheers
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> SQL Server is only setup to be using NT Integrated security.
> On the Server Properties page, you can configure SQL Server to be "Mixed
> Mode" and restart SQL Server.
> 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/
> "rajani" <rajani@.discussions.microsoft.com> wrote in message
> news:B8A81541-B555-430E-8067-4F2C00BB24EE@.microsoft.com...
>
>|||I'm still looking ...can you tell me where you found it? I'm not
sure where the Server Properties page is...
jared
On Sun, 10 Jul 2005 21:25:01 -0700, rajani
<rajani@.discussions.microsoft.com> wrote:

>Thanks Mike.
>i was looking for that option everywhere.|||Hi jaredea
if u open enterprise manager on left hand side look for ur server name(under
"sql server group")
normally server names (local), server etc.,
right click and properties and go to security tab and you'll find it there.
if u still cant find it then send me ur emailid i will send u screenshot
--
cheers
"jaredea" wrote:

> I'm still looking ...can you tell me where you found it? I'm not
> sure where the Server Properties page is...
> jared
> On Sun, 10 Jul 2005 21:25:01 -0700, rajani
> <rajani@.discussions.microsoft.com> wrote:
>
>