Link to home
Start Free TrialLog in
Avatar of KentDBerry
KentDBerry

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KentDBerry
KentDBerry

ASKER

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?
Thanks guys.  I assigned some permissions and that fixed it.