| Title: | Microsoft SQL Server Support |
| Notice: | Please Registar, Note #11 |
| Moderator: | AMCUCS::BETTS |
| Created: | Tue Aug 23 1994 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 382 |
| Total number of notes: | 1233 |
I try to use the guest access to a MS-sql database from a webpage.
How it looks like:
The weg page idc specifies username GUEST
The webserver runs on a PDC, with iusr_'node' as username
The MS-sql server run on the PDC as well in mixed mode.
The ODBC entry contains the use trusted connection not checked.
It does not work: in the SQL server error log it tells me:
login failed: user guest
I've user guest and 'domain_guest' as user on the ms-sql server
Iusr_'node' account is part of the guest group.
Question:
1) What account guest needs to be setup on the MS-sql (a PDC) ? is it
'domain_guest' or is it 'guest' ?
2) Does the 'guest' (or 'domain_guest') account need an entry in a
database group where I like to use tables from as well or us guest as
user in MS-SQL a guest user for all databases on the server ?
3) Does the guest account of the domain needs a passw which corresponds
with the guest account on the ms-sql server ?
It's very hard to troubleshoot when only the error 'login failed'
pops-up.
Eric
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 371.1 | XSTACY::imladris.ilo.dec.com::grainne | Grainne Ni Choiligh | Tue May 13 1997 07:59 | 17 | |
Could the problem described in Microsoft KB article http://www.microsoft.com/kb/articles/q152/8/28.htm apply to you ? One of our IIS applications also connects to an SQLServer database, although it doesn't use IDC files (it uses ASP and ADO.) We found we had to follow the recommendations of this article to allow the IIS server access the SQLServer database. You don't say whether or not you're using named pipes to connect to the database - as I understand it, the solution given only applies to named pipe connections. Regards, Grainne Ni Choiligh European Software Centre @ILO mail: nichoiligh@mail.dec.com | |||||
| 371.2 | guest without password | HLFS00::ERIC_S | Eric Sonneveld MCS - B.O. IS Holland | Tue May 20 1997 03:13 | 8 |
The hint to above article provide some other usefull articles.
The problem in .0 was solved by:
1) nt account guest change to nopassw.
2) ms sql account guest change to nopassw.
Is it ok to have a guest account without password ??
eric
| |||||