Help with connection to dababase.

Discussion in 'ASP General' started by John R, Sep 20, 2004.

  1. John R

    John R Guest

    Error Type:
    Microsoft OLE DB Provider for SQL Server (0x80004005)
    Login failed for user 'kingkong'. Reason: Not associated with a
    trusted SQL Server connection.
    /samples/db_paged_search.asp, line 84

    below is my connection string.

    cnnSearch.Open "Provider=SQLOLEDB;Data Source=192.168.1.100;" _
    & "Initial Catalog=testdbs;User Id=userid;Password=password;" _
    & "Connect Timeout=15;Network Library=dbmssocn;"
    I am currently using a windows account instead of sql server.
    John R, Sep 20, 2004
    #1
    1. Advertising

  2. John R wrote:
    > Error Type:
    > Microsoft OLE DB Provider for SQL Server (0x80004005)
    > Login failed for user 'kingkong'. Reason: Not associated with a
    > trusted SQL Server connection.
    > /samples/db_paged_search.asp, line 84
    >
    > below is my connection string.
    >
    > cnnSearch.Open "Provider=SQLOLEDB;Data Source=192.168.1.100;" _
    > & "Initial Catalog=testdbs;User Id=userid;Password=password;" _
    > & "Connect Timeout=15;Network Library=dbmssocn;"
    > I am currently using a windows account instead of sql server.


    Your error is covered in this article:
    http://www.aspfaq.com/show.asp?id=2009

    HTH,
    Bob Barrows
    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.
    Bob Barrows [MVP], Sep 20, 2004
    #2
    1. Advertising

  3. John R

    Frederic Guest

    wow great link. thanks didn't know www.aspfaq.com

    --
    Frederic
    MCP, IT Project+, i-Net+, CIW Associate, A+
    ----------------------------------------------------------------------------
    http://fredsfastcram.netfirms.com
    ----------------------------------------------------------------------------

    "Bob Barrows [MVP]" <> wrote in message
    news:%...
    > John R wrote:
    > > Error Type:
    > > Microsoft OLE DB Provider for SQL Server (0x80004005)
    > > Login failed for user 'kingkong'. Reason: Not associated with a
    > > trusted SQL Server connection.
    > > /samples/db_paged_search.asp, line 84
    > >
    > > below is my connection string.
    > >
    > > cnnSearch.Open "Provider=SQLOLEDB;Data Source=192.168.1.100;" _
    > > & "Initial Catalog=testdbs;User Id=userid;Password=password;" _
    > > & "Connect Timeout=15;Network Library=dbmssocn;"
    > > I am currently using a windows account instead of sql server.

    >
    > Your error is covered in this article:
    > http://www.aspfaq.com/show.asp?id=2009
    >
    > HTH,
    > Bob Barrows
    > --
    > Microsoft MVP -- ASP/ASP.NET
    > Please reply to the newsgroup. The email account listed in my From
    > header is my spam trap, so I don't check it very often. You will get a
    > quicker response by posting to the newsgroup.
    >
    >
    Frederic, Sep 21, 2004
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mythran
    Replies:
    5
    Views:
    4,923
    Mythran
    Oct 5, 2005
  2. Dave Johnson

    Using Connection Class VS Connection Module

    Dave Johnson, Dec 9, 2005, in forum: ASP .Net
    Replies:
    5
    Views:
    618
    Dave Johnson
    Dec 11, 2005
  3. Linus Nikander
    Replies:
    5
    Views:
    527
  4. Replies:
    3
    Views:
    40,163
    Roedy Green
    Nov 16, 2005
  5. R
    Replies:
    1
    Views:
    561
Loading...

Share This Page