my computer name is HUANG
sql server instance is (LOCAL)
DATABASE NAME is:thePhile
user:sa
pass:sa

I want to know how to "Change the connection string settings in web.cong file Change the connection string settings in all the config files residing in the config folder"

Now I set:
Web.Config
    <sessionState
            mode="InProc"
            stateConnectionString="tcpip=127.0.0.1:42424"
            sqlConnectionString="data source=local;user id=sa;password=sa"
            cookieless="false"
            timeout="20"
    />

Other config:
<ConnectionString>server=HUANG;database=thePhile;u id=sa;pwd=sa;</ConnectionString>

But I IIS show error,
SQL Server does not exist or access denied
who can help me,thank you !

OK,now

    <sessionState
            mode="InProc"
            stateConnectionString="tcpip=127.0.0.1:42424"
            sqlConnectionString="data source=127.0.0.1;user id=sa;password=sa"
            cookieless="false"
            timeout="20"
    />
----------------------------------------------------
other xml

server=(local);uid=sa;pwd=sa;Database=thePhile

Most of us aren't using sql server session state so we should change that connection string in web.config.

For most of us users of ThePhile, the config files in the config folder are the only place where we need a valid connection string.

Can any one help me out, for the above topic, i changed the user id and password according to my settings, but the problem still persists...
It says:
--------------------------------------

An unexpected error has occurred on this page.The system administrators have been notified.

The error occurred in:
http://localhost/ThePhileVB/Default.aspx

Error Message:
SQL Server does not exist or access denied.
--------------------------------------


Success if often just an idea away...

I use:

 <sessionState
            mode="InProc"
            stateConnectionString="tcpip=127.0.0.1:42424"
            sqlConnectionString="SERVER=sqlservername;DATABASE =thephile;UID=sqluseraccountname;pwd=sqluseraccoun tpassword"
            cookieless="false"
            timeout="20"
    />

Like I said, this connection string is not used if you're not using SQL Server session state. Check out the "InProc" value - that means "in process", which means you are NOT using SQL server session state.

The only connection strings that matter are in the config folder.