Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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