Problem setting a server with SQLDB

Problem setting a server with SQLDB

As you have mentioned in your complain, i think your server suffer from remote connection configuration Problems

so I'll explain to you  how to solve this issue by configuration snapshots from sql server 2005

First of all , we will follow these steps

Open Start menu  ==>  Programs ==> Microsoft SQL Server 2005 ==>  Configuration Tools  then click on

SQL Server Surface Area Configuration and you will see the next window

from the previous screen choose  Surface Area Configuration for Services and Connections after that you will see the next window   

from the previous screen you need to expand SQLEXPRESS ==> Expand Database Engine ==> click on Remote Connections 

Choose second option Local and Remote Connections ==> Using TCP/IP Only then click on Apply

and you will see a prompt screen inform you that the new settings will not take effect until restart Your DB engine

From previous screen you will choose Service then click on Stop and  wait until the MSSQLSERVER service stops 

from the previous screen click on Start to restart the MSSQLSERVER service
 

From Previous screen you need to Expand SQL Server Browser and choose Service

then choose Automatic

for startup type option then click on OK

To open Windows Firewall you will need to  click on  Start ==> Run and type firewall.cpl then click OK

choose Off then Click on OK

That's All Of it

 Regards