Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • Last Modified:

ASP can not open the connection of SQL Server

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
lijin1
Asked:
lijin1
1 Solution
 
rajgnCommented:
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
 
lijin1Author Commented:
Thank you rajgn! but if the answer would have more detail is better.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now