SQL,access denied: win2000

Showing posts with label win2000. Show all posts

Sunday, March 11, 2012

Activating Server Logs

I have two remote Win2000 servers running SQL2000. There are no items under
SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log database
activity?
Thanks,
John Steen
remove (nospam) from e-mail address to send me a messageNever heard we must activate something for the log. What do you see in
\Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
named ERRORLOG.
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>I have two remote Win2000 servers running SQL2000. There are no items
>under
> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> database
> activity?
> Thanks,
> John Steen
> remove (nospam) from e-mail address to send me a message|||Hi
SQL Server does not log activity like inserts and deletes. You need to run
SQL Server Profiler to do that.
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/
"ME" <ME@.hotmail.com> wrote in message
news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
> Never heard we must activate something for the log. What do you see in
> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
> files named ERRORLOG.
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>>I have two remote Win2000 servers running SQL2000. There are no items
>>under
>> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> database
>> activity?
>> Thanks,
>> John Steen
>> remove (nospam) from e-mail address to send me a message
>|||My bad. Didn't read the last part of the post.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ugABXMVYFHA.2572@.TK2MSFTNGP14.phx.gbl...
> Hi
> SQL Server does not log activity like inserts and deletes. You need to run
> SQL Server Profiler to do that.
> 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/
> "ME" <ME@.hotmail.com> wrote in message
> news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
>> Never heard we must activate something for the log. What do you see in
>> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
>> files named ERRORLOG.
>>
>> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
>> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>>I have two remote Win2000 servers running SQL2000. There are no items
>>under
>> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> database
>> activity?
>> Thanks,
>> John Steen
>> remove (nospam) from e-mail address to send me a message
>>
>|||There are log files in the log folder, but the latest one is dated May 17,
2004, which is around the time they were moved there from the location where
they were set up. The IP addresses were also changed when they were moved to
their current location. I don't what else may have changed.
Could that have something to do with why the logs stopped recording?
Thanks,
John
"ME" wrote:
> Never heard we must activate something for the log. What do you see in
> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
> named ERRORLOG.
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >I have two remote Win2000 servers running SQL2000. There are no items
> >under
> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> > database
> > activity?
> >
> > Thanks,
> > John Steen
> > remove (nospam) from e-mail address to send me a message
>
>|||I'm not trying to log inserts and such, Mike, just normal DB activtiy
(startups, shutdowns, recoveries, DBCC jobs, etc.) you see in the server logs.
Thanks,
John
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server does not log activity like inserts and deletes. You need to run
> SQL Server Profiler to do that.
> 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/
> "ME" <ME@.hotmail.com> wrote in message
> news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
> > Never heard we must activate something for the log. What do you see in
> > \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
> > files named ERRORLOG.
> >
> >
> > "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> > news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >>I have two remote Win2000 servers running SQL2000. There are no items
> >>under
> >> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> >> database
> >> activity?
> >>
> >> Thanks,
> >> John Steen
> >> remove (nospam) from e-mail address to send me a message
> >
> >
>
>|||Right-click the server in EM, properties, Parameters. Verify that you have an -e parameter and the
path that the parameter points to.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:04B3D2BC-6E90-4103-96E6-EB998BD613A0@.microsoft.com...
> There are log files in the log folder, but the latest one is dated May 17,
> 2004, which is around the time they were moved there from the location where
> they were set up. The IP addresses were also changed when they were moved to
> their current location. I don't what else may have changed.
> Could that have something to do with why the logs stopped recording?
> Thanks,
> John
> "ME" wrote:
>> Never heard we must activate something for the log. What do you see in
>> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
>> named ERRORLOG.
>>
>> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
>> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>> >I have two remote Win2000 servers running SQL2000. There are no items
>> >under
>> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> > database
>> > activity?
>> >
>> > Thanks,
>> > John Steen
>> > remove (nospam) from e-mail address to send me a message
>>|||Thanks, Tibor, that did it!
John
"Tibor Karaszi" wrote:
> Right-click the server in EM, properties, Parameters. Verify that you have an -e parameter and the
> path that the parameter points to.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:04B3D2BC-6E90-4103-96E6-EB998BD613A0@.microsoft.com...
> > There are log files in the log folder, but the latest one is dated May 17,
> > 2004, which is around the time they were moved there from the location where
> > they were set up. The IP addresses were also changed when they were moved to
> > their current location. I don't what else may have changed.
> >
> > Could that have something to do with why the logs stopped recording?
> >
> > Thanks,
> > John
> >
> > "ME" wrote:
> >
> >> Never heard we must activate something for the log. What do you see in
> >> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
> >> named ERRORLOG.
> >>
> >>
> >> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> >> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >> >I have two remote Win2000 servers running SQL2000. There are no items
> >> >under
> >> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> >> > database
> >> > activity?
> >> >
> >> > Thanks,
> >> > John Steen
> >> > remove (nospam) from e-mail address to send me a message
> >>
> >>
> >>
>
>

Thursday, February 9, 2012

Accessing network drive from SQL Analyzer

Not sure if this posted or not before, so just in case, I'm doing it again.
I have SQL2000 on a Win2000 server. Using windows explorer, I have mapped a
network drive to letter "F"
While in SQL Analyzer, I'm trying to access "F" but I can't. I can access C
and D which are local drives, but not F.
If you are curious, I'm trying to access it by simply doing xp_cmdshell 'dir
f:'
Once this works, I'm planning to use a restore operation which we will read
from that drive.
Does anyone know how to access a mapped network drive from SQL Analyzer? It
will greatly appreciated.
thanks,
PPHi
Did you log onto the SQL Server using the SQL Server service account, map
the drive and then log off again?
If not, that is the way you should do it.
Generally, it is best to use UNC naming (\\machinename\sharename\) when
accessing resources over the network.
Backup and restores have to be done via UNC paths as mapped drives are not
supported for those operations.
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/
"PP" <PP@.discussions.microsoft.com> wrote in message
news:422C6736-9887-450A-B83D-3F7A9B30799B@.microsoft.com...
> Not sure if this posted or not before, so just in case, I'm doing it
> again.
> I have SQL2000 on a Win2000 server. Using windows explorer, I have mapped
> a
> network drive to letter "F"
> While in SQL Analyzer, I'm trying to access "F" but I can't. I can access
> C
> and D which are local drives, but not F.
> If you are curious, I'm trying to access it by simply doing xp_cmdshell
> 'dir
> f:'
> Once this works, I'm planning to use a restore operation which we will
> read
> from that drive.
> Does anyone know how to access a mapped network drive from SQL Analyzer?
> It
> will greatly appreciated.
> thanks,
> PP

Sunday, March 11, 2012

Activating Server Logs

Activating Server Logs

Activating Server Logs

Thursday, February 9, 2012

Accessing network drive from SQL Analyzer

SQL,access denied

Blog Archive

About Me