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.

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23HIGnfznEHA.3564@tk2msftngp13.phx.gbl...
> 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.
>
>