Cannot Connect Sql Server 2008 From Another Computer

Possible Duplicate: System.Data.SqlClient.SqlException A network-related or instance-specific error i have winform application in c# which connect to my own db and its working f

Solution 1:

Data Source=ITPL_PC1

Identifies a server called ITPL_PC1. You're connecting to the default instance on this server.

Data Source=192.168.0.28\ITPL_PC1

Identifies an instance called ITPL_PC1 running on a server with IP address 192.168.0.28. We don't know the name of this server.

If the instance you want to connect to is the default instance on ITPL_PC1, then the first version should always work (provided ITPL_PC1 can be resolved).

Solution 2:

The Windows security might be preventing the access. You can try the below. 1.Go to the service management console of windows by typing services.msc in the run window. 2. In the window displayed you can see a list of services. From the list find out Base Filtering Engine. 3.Right click and stop it. Its done

I have fixed the same issue like this after lot of googling.(For me it was not working even after enabling TCP/IP from sql configuration manager)

Solution 3:

First you openSQL managnebt studio andconnectto another pc sql server :

         Please follow bolew step :
            Strat -> program ->windowsql server 2008-> configuration tools 
            --> sql server Configuration manager -->Startsql server browser service
    -----------
    Next --->Sql serverNetework COnfiguration  --> Enable all Protocls and
    also Sql Native Client.. --> Enable all Protocls  then--------------
    reatsrt all service andconnecttosql-------------------------------------------------
If you get connection thenSQL Database toconnect database from visual studio from there to find connection string andcopyand paste to connection string.