I have installed SQL Server 2008 on Windows Server 2003 OS and when I go to the client machine and try to access via an ODBC Driver I can not see any of the SQL Server 2008or any of its databases.

I have on the server checked the SQL Server Browser is running.
Shared Memory = Enabled
TCP/IP = Enabled
SQL Server is running

I have with cmdprompt run OSQL -L and I cannot see the MS Server intance which I belive to be MSSQLServer that I checked in services where it is Started.

Any ideas?
HelpMePlease

Maybe Microsoft learned something about security in the last few upgrades. Try this instead;

I get a message saying Login failed for user

Go to the SQL Server machine, and if you have login failure auditing on, then you should see a record of the login failure in SQL Server's errorlog. If you have login failure auditing on, and there is no mention in the errorlog of the actual login failure, then this is likely a firewall problem.

I don't think I have an option for Audit although I am not 100% sure where I should chek this?
I am using SQL server 2008 standard.

In SSMS right click on the server in the Object Explorer. Go to properties, then security. Login auditing should be in the middle somewhere.

Ok in with you on there I have:

Windows Authentication Checked
and
Failed Logins Only Checked

Where can I view the report on this?

Thanks for your patience

I have located the error log report using

EXEC sp_readerrorlog

Is this the correct way of doing so?

I seem to be having the same problem.

sp_readerrorlog is good enough. Try to log in from the remote client, then check the errorlog to see if a new failed login record comes up.

What did you do to get it working?

Thanks MCrowley, this actually helps me out a lot.

Thanks - Yup, dang firewall issue with me. That helped a lot.
Amazing how things change and start going wrong when you have ZERO configuration management in your environment and work with a bunch of cowboys! (and yes, I'm part of the problem too)