Solved

ASP can not open the connection of  SQL Server

Posted on 1998-11-13
2
145 Views
Last Modified: 2013-12-25
I use "...Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=cargo;UID=cargo;PWD=cargo;;" ..." in my ASP file,it work well in my PWS of WIN95.But when I run this ASP in IIS3.0 in NT,error occur,"Microsoft OLE DB Provider for ODBC Drivers error'80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: _ Reason: Not defined as a valid user of a trusted SQL Server connection"
What's the reason?Thank you very much!
0
Comment
Question by:lijin1
2 Comments
 
LVL 1

Accepted Solution

by:
rajgn earned 100 total points
ID: 1829555
Have you made a DSN on your IIS3.0? If you've made one, check for the permissions related files. For more detailed info., have a look at :

http://www.microsoft.com/workshop/server/feature/morqa.asp#em
0
 

Author Comment

by:lijin1
ID: 1829556
Thank you rajgn! but if the answer would have more detail is better.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Changing Audit Policies through scripting 5 64
Sed question 2 85
A script to extract the important data and calculate if the amounts are correct 12 67
Disk Ram Peak 1 41
In this tutorial I will show you how to make a simple HTML bar chart with the usage of WhizBase, If you want more information about WhizBase please read my previous articles at http://www.experts-exchange.com/ARTH_5123186.html (http://www.experts-ex…
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question