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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:
try Pinging the server, if it is success, you can probably connect using the IPAddress
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wjesterCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.