mel150
asked on
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. :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oops, sorry, I ran the two queries separately.
ASKER
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.
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.
ASKER
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?
ASKER