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.

isogulaleb (isogulaleb (AT) discussions (DOT) microsoft.com) writes:
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, esquel (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

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: