Help with connection to dababase. - ASP / Active Server Pages

John R

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.

Jul 19 '05 #1

Subscribe Post Reply

2684

Bob Barrows [MVP]

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.

Jul 19 '05 #2

Frederic

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]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@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.

Jul 19 '05 #3

Similar topics

help in designing class

by: Naren | last post by:

Victor Bazarov <v.Abazarov@comAcast.net> wrote: >Naren wrote: >> MyServer class conatins a list of Mysock class. >> >> class Myserver >> { >> private: >> list<Mysock> L1; >> }; >>

C / C++

Help creating connection function

by: Jozef | last post by:

Hello, I'm trying to create a central function that runs a connection to an SQL Server database. The connection etc works, but when I try to call it, I get an error saying "Runtime-Error 91:...

Microsoft Access / VBA

Desperately need help finding connection leak

by: Lior | last post by:

Hi, I have an ASP.NET website that crashes under heavy load. I use a SQL Server DB. I get around 5500 hits per day. I keep getting the timeout expieried connection pool error. Sometimes it even...

ASP.NET

Help - P2P connection in .Net - like Yahoo does for IM

by: Mahesh Devjibhai Dhola | last post by:

Hi, I want to develop p2p (peer-to-peer) communication connection for chat in ..Net (Lang: c# - preferable) NOTE: if two LAN are behind their own router then also it should work as yahoo, msn...

ASP.NET

Any help here???

by: DavidS | last post by:

Have Visual Studio.NET installed on MS 2000 Professional OS laptop. No issue ever with web development and SQL connections. Purchased new laptop with XP Professional SP2!!!!!!!! & Visual...

ASP.NET

How to have multiple worker threads submit to one final processing queue? - HELP

by: James Radke | last post by:

Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...

Visual Basic .NET

HELP! Why is SqlException being caught in this code if it can't connect to SQL Server?

by: Marcus | last post by:

I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...

Visual Basic .NET

ftp_fput() error help

by: BlackKite | last post by:

I have this script I wrote up as a php backend. But its throwing some errors i dont quite understand. Hope someone can help me fix this. Please Error: Line 52: ftp_fput($connection, $bandle,...

PHP

Need Help with Select @@ Identity

by: PinkBishop | last post by:

I am using VS 2005 with a formview control trying to insert a record to my access db. The data is submitted to the main table no problem, but I need to carry the catID to the bridge table...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General