Re: Connect problem MSDE ADO ASP
From: PeterWR (pwr_at_post4.tele.dk)
Date: 06/30/04
- Next message: LCaffrey: "'Auto-extending' partitioned views"
- Previous message: Uri Dimant: "Re: Prioritizing Stored Procedures."
- In reply to: Aaron [SQL Server MVP]: "Re: Connect problem MSDE ADO ASP"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 30 Jun 2004 10:14:05 +0200
Hi Aron,
Thanks for Your reply. Your FAQ#2168 did solve the issue - there was some
problems on setting the IIS User password. Thanks a lot.
Well answering Your questions - the added code was just the status after NNN
versions of testing/trying.
Administrator is the Windows-administrator, but also SQLsa user ended same
result - and both can access the MSDE SQL via the webinterface (I am aware I
have to change not using administrator account for final
user-data-processing, but this is internal system for evaluation, so right
now it is just a matter of "action").
I surfed a lot, but ended with these two links ...
299980 - HOW TO Hand Code an ADO Data Connection in ASP.htm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmscadocodeexamplesinvbscript.asp
... and when having problems, I ends keeping strictly to the sample-code
untill "break thrue". But one issue mentioned more than once is, when using
"sqloledb" you also have to use "Integrated Security=SSPI"
Best regards
Peter
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OkStVilXEHA.644@tk2msftngp13.phx.gbl...
> Why are you using Integrated Security and passing a user id and password?
>
> Is "Administrator" a windows account or a SQL Server account?
>
> Do you want to use SQL Authentication, or Windows authentication?
>
> If the former, you will need to remove the integrated security portion of
> your connection string, and put in a valid SQL USER ACCOUNT, not a Windows
> account.
>
> If the latter, you will need to remove the User ID / Password from the
> connection string, and either add WDWORK3\IUSR_ABIZZ-EC0EJYNNE as an
account
> on the server hosting the database, or change the anonymous user on the
web
> server to a domain user that has already been (or can be) granted access
to
> the database.
>
> See http://www.aspfaq.com/2168 for some information about adding the local
> anonymous IIS user to a separate server for access rights, and
> http://www.aspfaq.com/2126 for some valid connection string formats
against
> both SQL and Windows Auth.
>
> Also, are you meaning to connect directly to tempdb???
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
> "PeterWR" <pwr@post4.tele.dk> wrote in message
> news:Ok%23ckAlXEHA.2716@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Hope this is the proper newsgroup - there are more newsgroup my issue
> > fints
> > into.
> >
> > Have just installed MSDE 2000 on an internal Windows 2000 Server for
> > evaluation - this W2000 Server has been running for month and are fully
> > patched/updated.
> >
> > The web-interface to MSDE is working fine, and I can connect both using
> > Windows administrator and SQl "sa"-"sapwr" login from the webinterface.
> >
> > After a lot of surfing around, I have ended with following ADO
connection
> > usinf IIS 5.0 ASP
> >
> >
> >
> > Dim Cnxn, strCnxn
> > Dim rsCustomers, strSQLCustomers
> > Dim rsProducts, strSQLProducts
> >
> > ' open connection
> > Set Cnxn = Server.CreateObject("ADODB.Connection")
> > strCnxn = "Provider='sqloledb';Data Source=" &
> > Request.ServerVariables("SERVER_NAME") & ";" & "Integrated
> > Security='SSPI';Initial Catalog='tempdb';" & _
> > "User ID='Administrator';Password='pp';"
> >
> > Cnxn.Open strCnxn
> >
> >
> > ... ending with following problem
> >
> > Microsoft OLE DB Provider for SQL Server error '80040e4d'
> > Login failed for user 'WDWORK3\IUSR_ABIZZ-EC0EJYNNE'.
> > /test/imgINFO14.asp, line 25
> >
> > No matter what I do or which kind of "user-name" - "password" I use, the
> > result is the same - and I can not figure out where to fix this
problem -
> > probably some access-right, but I'm administrator on the W2000 Server
and
> > the MSDE - so ... !
> >
> > I spend about 7 - 8 hours on this - I hope somebody have a hint.
> >
> > Thanks and best regards
> > Peter
> >
> >
>
>
- Next message: LCaffrey: "'Auto-extending' partitioned views"
- Previous message: Uri Dimant: "Re: Prioritizing Stored Procedures."
- In reply to: Aaron [SQL Server MVP]: "Re: Connect problem MSDE ADO ASP"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
