Connection Failed with ASP

I#%92m now developing shopping cart using ASP. I need to connect my ASP pages to SQL Server using this code : <br /><br />set conn=server.createobject("adodb.connection")<br />conn.connectionstring="driver={SQL Server};"_<br />& "server=(local);uid=chaw"_<br />& "<img src='/community/emoticons/emotion-4.gif' alt=';p' />wd=1234567890; database=master"<br />conn.open<br /><br />Then I receive an error message :<br />·Error Type:<br />Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)<br />[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'chaw'. Reason: Not associated with a trusted SQL Server connection.<br />/grocery/shopping/default.asp, line 13<br /><br />I already create new login in SQL Server with the name and password, but this error still appear. Then I try with “uid=sa” and so on, it still not working.<br /><br />Then I try with ODBC , the same error appear.<br /> <br />Is it something wrong with my SQL Server (Personal Edition) setting? <br /><br />

Satya, Other post deleted as directed.

Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Make sure that your SQL Servers security setting is set to Mixed mode and not Windows Authentication only. That's most likely the issue you are having.

Right click on the server in Enterprise Manager -> properties -> security -> select "SQL Server and Windows" as authentication mode.

/Argyle

Please do not repeat a post. I have deleted the new post in Devloper questions and have moved this old post from SQL Server DBA Forum.

For solution, also refer...
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=654
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20313428.html
http://www.dotnet247.com/247reference/msgs/27/139598.aspx
http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/31/pid/855/qid/525741

Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard