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?
KentDBerryAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
try Pinging the server, if it is success, you can probably connect using the IPAddress
0
 
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.
0
 
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?
0
 
wjesterCommented:
are you using sql or windows authentication?
0
 
KentDBerryAuthor Commented:
Thanks guys.  I assigned some permissions and that fixed it.
0
All Courses

From novice to tech pro — start learning today.