Why I cannot see log in Management Studio log file viewer?

24 Feb 2009 12:30 PM

isogulaleb

I have SQL server 2005 express installed on my machine and also installed
management studio. I use Business Contact Manager database and have a login
failed error. However, when I try to see the log in Management\SQL Server
Log, I can see the log names but nothing appear.

Any idea? I connected to the server with my login with which I created the
database.

Thanks for any suggestions.

24 Feb 2009 11:19 AM

Ekrem_Ã–nsoy

As you mentioned it's a SQL Server 2005 Express Edition instance, I believe
you are using SQL Server Management Studio Express which does not have a Log
File Viewer as SSMS' s. So that must be why you see the logs under the
Management node in the Object Explorer but you can't view them via SSMSE.

You can view them either connecting to your Express Edition instance using
SSMS (not SSMSE) or going to the Logs directory and view them using Notepad
or some else editor as Erland suggested.

--
Ekrem Ã–nsoy

Show quoteHide quote

"isogulaleb" <isogula***@discussions.microsoft.com> wrote in message
news:60D394EE-65FC-4905-B7B9-2F6AD93C3A61@microsoft.com...
>I have SQL server 2005 express installed on my machine and also installed
> management studio. I use Business Contact Manager database and have a
> login
> failed error. However, when I try to see the log in Management\SQL Server
> Log, I can see the log names but nothing appear.
>
> Any idea? I connected to the server with my login with which I created the
> database.
>
> Thanks for any suggestions.

25 Feb 2009 1:57 PM

isogulaleb

Thanks for your answers both of you. Ekrem, I suppose this version is not for
free, am I right?

I knew I can see the logs opening them manually, just feel frustrated why it
is a menu option when it is unusable in Express Edition?

Anyway, thanks again for your answers, it was useful.

Show quoteHide quote

"Ekrem Ã–nsoy" wrote:

> As you mentioned it's a SQL Server 2005 Express Edition instance, I believe
> you are using SQL Server Management Studio Express which does not have a Log
> File Viewer as SSMS' s. So that must be why you see the logs under the
> Management node in the Object Explorer but you can't view them via SSMSE.
>
> You can view them either connecting to your Express Edition instance using
> SSMS (not SSMSE) or going to the Logs directory and view them using Notepad
> or some else editor as Erland suggested.
>
> --
> Ekrem Ã–nsoy
>
>
>
> "isogulaleb" <isogula***@discussions.microsoft.com> wrote in message
> news:60D394EE-65FC-4905-B7B9-2F6AD93C3A61@microsoft.com...
> >I have SQL server 2005 express installed on my machine and also installed
> > management studio. I use Business Contact Manager database and have a
> > login
> > failed error. However, when I try to see the log in Management\SQL Server
> > Log, I can see the log names but nothing appear.
> >
> > Any idea? I connected to the server with my login with which I created the
> > database.
> >
> > Thanks for any suggestions.
>

25 Feb 2009 3:26 PM

Ekrem_Ã–nsoy

> Thanks for your answers both of you. Ekrem, I suppose this version is not
> for
> free, am I right?

Although some MS guys say you don't need a license for Client Tools (I asked
this question to those who were talking about licensing in some seminars),
SSMS ships only with not-for-free editions of SQL Server and it's not
downloadable from MS' s website as a stand-alone tool.

Despite the fact that MS guys say we don't need a license for Client Tools,
SSMSE is released and this is some kind of contradiction to me. I have not
found anyone from MS to give me a straightforward answer for this question
but I believe I'll find it out soon.

--
Ekrem Ã–nsoy

Show quoteHide quote

"isogulaleb" <isogula***@discussions.microsoft.com> wrote in message
news:D5B22B97-40A3-4941-A82E-B591B29D0160@microsoft.com...
> Thanks for your answers both of you. Ekrem, I suppose this version is not
> for
> free, am I right?
>
> I knew I can see the logs opening them manually, just feel frustrated why
> it
> is a menu option when it is unusable in Express Edition?
>
> Anyway, thanks again for your answers, it was useful.
>
> "Ekrem Ã–nsoy" wrote:
>
>> As you mentioned it's a SQL Server 2005 Express Edition instance, I
>> believe
>> you are using SQL Server Management Studio Express which does not have a
>> Log
>> File Viewer as SSMS' s. So that must be why you see the logs under the
>> Management node in the Object Explorer but you can't view them via SSMSE.
>>
>> You can view them either connecting to your Express Edition instance
>> using
>> SSMS (not SSMSE) or going to the Logs directory and view them using
>> Notepad
>> or some else editor as Erland suggested.
>>
>> --
>> Ekrem Ã–nsoy
>>
>>
>>
>> "isogulaleb" <isogula***@discussions.microsoft.com> wrote in message
>> news:60D394EE-65FC-4905-B7B9-2F6AD93C3A61@microsoft.com...
>> >I have SQL server 2005 express installed on my machine and also
>> >installed
>> > management studio. I use Business Contact Manager database and have a
>> > login
>> > failed error. However, when I try to see the log in Management\SQL
>> > Server
>> > Log, I can see the log names but nothing appear.
>> >
>> > Any idea? I connected to the server with my login with which I created
>> > the
>> > database.
>> >
>> > Thanks for any suggestions.
>>

24 Feb 2009 11:01 PM

Erland Sommarskog

isogulaleb (isogula***@discussions.microsoft.com) writes:

> I have SQL server 2005 express installed on my machine and also
> installed management studio. I use Business Contact Manager database and
> have a login failed error. However, when I try to see the log in
> Management\SQL Server Log, I can see the log names but nothing appear.

What happens if you right-click and select View SQL Server log?

You can also access the logs directly from
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG.

The exactl location depends on your installation. MSSQL.1 could be something
else.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx