Connecting to SQL Server

Another department installed SQL Server 2005 on a server.  Presently there are only the default databases installed.  From my computer, the server name is not showing up in the list of servers when I am trying to connect to it using VS Studio 2005.

What has to be done to expose the server so that I can connect?
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
try Pinging the server, if it is success, you can probably connect using the IPAddress
wjesterConnect With a Mentor Commented:
If the server doesn't show up in the list of available servers, you can type in the name of the server instead of selecting it from the dropdown box.
KentDBerryAuthor Commented:
I can ping but if I type the IP address or the name of the server, it still does not give me the options to choose a database.

I can remote into the the server, and I setup a user for myself.

Is there something else on the server side that has to expose the server to the rest of the company?
are you using sql or windows authentication?
KentDBerryAuthor Commented:
Thanks guys.  I assigned some permissions and that fixed it.
All Courses

From novice to tech pro — start learning today.