Database connection settings and Login failed for user 'sa'.

  •  04-08-2011, 4:39 AM

    Database connection settings and Login failed for user 'sa'.

    hi,
     
    My computer named 'Home', from local computer, i use microsoft sql server 2008 to create Cutechat database. My sql server connect with:
     
    name: sa
    passwork: abcd123456
     
    After creating Cutechat database by runing sql script (included installation package). Copying Cutechat.mdf and CuteChat.log to Web directory, modifying web.config like this (in Web directory):
     
    <?xml version="1.0"?>
    <configuration>
        <appSettings>
            <add key="ConnectionString" value="server=(local);database=Cutechat;uid=sa;pwd=abcd123456"/>
               <add key="OnlineTimeout" value="300"/>
        </appSettings>
        <system.web>
            <customErrors mode="Off"/>
            <authentication mode="Forms">
                <forms name=".UserManagementASPXAUTH" loginUrl="~/Login.aspx"/>
            </authentication>
            <authorization>
                <allow users="*"/>
            </authorization>
            <trace enabled="true"></trace>
            <sessionState mode="InProc" timeout="20"/>
            <globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
        </system.web>
    </configuration>
     
    Then i upload all of Web's content on my host by FTP like this:  www.xyz.cn/online. But i receive an error like: Login failed for user 'sa'.
     
    What was i wrong ? Please help me, thanks
     
     
    I'm sorry, i clicked two times to post
View Complete Thread