Can not connect to SQL server

I am using SQL server 2005 express edition. I have instaled the managment studio, so I can create the databases and login. Than after it I have changed from Windows authentication to SQL server authentication. So I opened the VWD on another client pc and I tried to connect to specified database, but I get the error COULD NOT CONNECT TO SQL SERVER, check if the server allow the remote connections.

I have chenked it and it is configured to allow remote connections. Why this happens ?? I had never these problems when I used the sql server 2005 beta version. The client pc and this sql server have connections so there is no problem with network connection at all.

Any suggestions ??

PS: I also tried using syntax:

Server name: myserver\SQLEXPRESS (instance)

Best regards

This might occur also if you didnt specify the correct username/password for the SQL authentication method.

Make sure that the database contain that user and is already mapped to the db.

Regards

|||

Hello !! Thank You for answering !!

Actually I found that problem was DISABLED TCP / IP on the SQL server. I have enabled it and now it work fine. When installing the SQL server express the tcp/ip is disabled so it will not respond on the request for other pc`s.

Best regards