connect allowed from all except asp ?

I have servers working with that combination
a few serwers IIS 5.0 with asp pages
and one with SQL 2000 sp3
All of them running on Windows 2000 Adv Server sp4
And What I get:
Using Enterprise Manager, query analizer, VB application I can
connect to database with mixed creditenitals or with nt auth
(EntManager and Query analizer).
But when I'm trying from asp - it is not working at all
I have tried these connections strings
CF="DSN=XXSQL;SERVER=XX;DATABASE=XXX;Network=DBMSS OCN;Address=10.10.10.10,1433;UID=XXuser;PWD=xxpass ;"
CF="Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=xxuser;Initial Catalog=XXX;Data Source=XX"
CF="Provider=SQLOLEDB;Data Source=XX;Initial Catalog=XXX;Integrated
Security=SSPI"
CF= "dsn=xxsql;uid=xxuser;pwd=xxpass;database=xxx;app= ASP;Connect
Timeout=60;Network Library=dbmssocn"
And nothing of them works.
I always get
"SQL Server does not exist or access denied"
Any idea what's wrong with connection?
Maybye with sql server something is not configured ?
Did you add the IUSR_machine to the list of users that can log int to the
database in question?
Francisco
"ML" <maluleszek@.poczta.onet.pl> wrote in message
news:48fba10e.0407120244.102a5311@.posting.google.c om...
> I have servers working with that combination
> a few serwers IIS 5.0 with asp pages
> and one with SQL 2000 sp3
> All of them running on Windows 2000 Adv Server sp4
> And What I get:
> Using Enterprise Manager, query analizer, VB application I can
> connect to database with mixed creditenitals or with nt auth
> (EntManager and Query analizer).
> But when I'm trying from asp - it is not working at all
> I have tried these connections strings
>
CF="DSN=XXSQL;SERVER=XX;DATABASE=XXX;Network=DBMSS OCN;Address=10.10.10.10,14
33;UID=XXuser;PWD=xxpass;"
> CF="Provider=SQLOLEDB.1;Persist Security Info=False;User
> ID=xxuser;Initial Catalog=XXX;Data Source=XX"
> CF="Provider=SQLOLEDB;Data Source=XX;Initial Catalog=XXX;Integrated
> Security=SSPI"
> CF= "dsn=xxsql;uid=xxuser;pwd=xxpass;database=xxx;app= ASP;Connect
> Timeout=60;Network Library=dbmssocn"
> And nothing of them works.
> I always get
> "SQL Server does not exist or access denied"
> Any idea what's wrong with connection?
> Maybye with sql server something is not configured ?
|||Yes, this user was added, because this connection was working before.
And now I remove it and added it again.
But I found in logs that during weekend, when I lost ability to connect,
the power was goes down for a few second. (I have UPS)
It is possible to lost any login information because of that ?
(ups software or something ?)
"Francisco" <nomail@.baseball.net> wrote in message news:<OgdcL5QaEHA.596@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> Did you add the IUSR_machine to the list of users that can log int to the
> database in question?
> Francisco
>
> "ML" <maluleszek@.poczta.onet.pl> wrote in message
> news:48fba10e.0407120244.102a5311@.posting.google.c om...
> CF="DSN=XXSQL;SERVER=XX;DATABASE=XXX;Network=DBMSS OCN;Address=10.10.10.10,14
> 33;UID=XXuser;PWD=xxpass;"