|
 |
asp_database_setup thread: urgent help needed with sql server6.5
Message #1 by "Eric Van Camp" <eric.vancamp@c...> on Sat, 9 Dec 2000 13:28:00 -0000
|
|
hi,
i want to use my sql server 6.5 over the internet anabling users to get info
from the tables,
i am connected to the local server as administrator;
how do i configure the database?security options on windows nt integrated??
and which accound do i give as default?the sa account?
if i go to my asp pages, i get the following error:
Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason:
Not defined as a valid user of a trusted SQL Server connection.
what is going on?
txs
Message #2 by "StephenB" <stephenb@w...> on Mon, 11 Dec 2000 10:57:34 -0000
|
|
You need to grant access to IUSR_<webservermachinename> on the database.
Stephen
"Eric Van Camp" <eric.vancamp@c...> wrote in message
news:24212@a..._database_setup...
>
> hi,
> i want to use my sql server 6.5 over the internet anabling users to get
info
> from the tables,
> i am connected to the local server as administrator;
> how do i configure the database?security options on windows nt
integrated??
> and which accound do i give as default?the sa account?
> if i go to my asp pages, i get the following error:
> Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason:
> Not defined as a valid user of a trusted SQL Server connection.
>
> what is going on?
> txs
>
>
>
|
|
|
View Cart
