about SQL connection

Results 1 to 2 of 2

Thread: about SQL connection

  1. #1
    Join Date
    Dec 1969

    Default about SQL connection

    hi I want to connect with sql database from my asp page.when I installed SQL I chose windows authentication mode instead of server authentication. so in my connectionstring i wrote<BR>"provider=sqloledb;data source=(local);database=atiq;" but it doesn&#039;t work; so i again wrote<BR>provider=sqloledb;data source=(local);database=atiq;uid=sa;pwd=; <BR><BR> then I get error like this<BR>Error Type:<BR>Microsoft OLE DB Provider for SQL Server (0x80004005)<BR>Login failed for user &#039;sa&#039;. Reason: Not associated with a trusted SQL Server connection.<BR><BR> How to solve this problem?

  2. #2
    Join Date
    Dec 1969

    Default Change SQL mode?

    If it&#039;s viable, just change the SQL server to mixed mode and specify a valid UID/PWD. I would advise you create a SQL login with relevant permissions rather than use sa.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts