SQL Server Performance

Connection Failed with ASP

Discussion in 'General Developer Questions' started by tkchaw80, Aug 5, 2003.

  1. tkchaw80 New Member

    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 />
  2. satya Moderator

  3. gaurav_bindlish New Member

    Satya, Other post deleted as directed.

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

    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
  5. gaurav_bindlish New Member

    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

Share This Page