when connecting to SQL server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections

Hi- Brand new at SQL server, and trying to connect to a remote database, with SQL Server Manager Studio express, v9.001399.00, and I get this error: when connecting to SQL server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections. Where can I change this setting? (Again, I'm a complete newbie, so please be specific. I don't mind being treated like a dummy. :)
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.

You can do it by executing:

sp_configure 'remote admin connections', 1;

Problem is, how to execute if you cannot log in locally?

It seems the administration connection is different than a query connection. So, can you open a query connection to run the above commands? In SQL Server Management Studio (not express) a query could be opened using "File->New->Database Engine Query". Maybe there is something similar in express?

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
mel150Author Commented:
Ok, so far so good, thanks. After I ran that query, under messages I see: Configuration option 'remote admin connections' changed from 0 to 1. Run the RECONFIGURE statement to install. What next? Thanks again!
mel150Author Commented:
Oops, sorry, I ran the two queries separately.
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

mel150Author Commented:
After those two queries were executed, and it said "command completed successfully", I got the same error when trying to connect. I ran the two queries once more to be sure, and still cannot connect.
Well, I'm out of ideas. Unless SQL Server needs to be restarted. Nothing I can find says it must be.

Another question to ask would be if there is a firewall between you and the server blocking the port used in administrative connections. It looks like that is 1434.
mel150Author Commented:
Hi-I think your first answer is the correct one, and on top of that, I probably have some kind of access problem. So I will accept that answer with my thanks, and check my access.
Is the service started?
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

From novice to tech pro — start learning today.