>>Are you sure the SQL Server Service is running on the machine?
>>Do you see it when you click on the 'browse for more' ???
>
>After verification, there doesn't seem to be any SQL Server service on that server. I have sent an email to the tech team to request verification.

ahh ok. I've noticed that this little thing sure comes in handy too if you're on SQL Server 2005 or 2008....

http://www.sqldbatips.com/showarticle.asp?ID=46