I cant connect to sql server from a computer on my network

I am trying to log in to sql server on another desktop on my network.
When I open sql management studio I am able to find the server however
when I try to log in I am unable to connect. I have gone into the
configuration tool and enabled tcp/ip and named pipes remote
connections on the computer that is acting as the server but I still
get an error when I try to connect. How do I enable it so that I can
log onto the server on the other computer.npbaker1@.neo.rr.com wrote:
> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>
Hi
What is the error message you get?
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Try the usual suspects:
1. Check whether the instance is running,
2. Try to connect to it locally,
3. Ping the other server from this machine to make sure you can reach it,
4. Try to connect to it using the IP address followed by the port number
after a comma
The messages or error messages from these tests should give you some clue.
Linchi
"npbaker1@.neo.rr.com" wrote:

> I am trying to log in to sql server on another desktop on my network.
> When I open sql management studio I am able to find the server however
> when I try to log in I am unable to connect. I have gone into the
> configuration tool and enabled tcp/ip and named pipes remote
> connections on the computer that is acting as the server but I still
> get an error when I try to connect. How do I enable it so that I can
> log onto the server on the other computer.
>