Re: Error In Loging to Sqlserver2k via web
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 02/18/04
- Next message: Troy: "Access Logs"
- Previous message: Jasper Smith: "Re: EM losing Server registrations in XP"
- In reply to: mzz: "Error In Loging to Sqlserver2k via web"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 18 Feb 2004 19:39:05 -0000
Have you added a login for the IUSR account ? You can add a login using
Enterprise Manager or by running the following in Query Analyzer
sp_grantlogin 'MZZ\IUSR_MZZ'
You then need to give the login access to the database(s) required by your
application. Again this can be done through Enterprise Manager or by using
the stored procedure sp_grantdbaccess. BOL has lots of information about
this.
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "mzz" <mzarbei@yahoo.com> wrote in message news:4A545675-A858-4354-A619-D4A486F24408@microsoft.com... > Dear Kevin i am encoutered suchh an error > Technical Information (for support personnel) > > Error Type: > Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) > [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MZZ\IUSR_MZZ'. > /ostandari/TMPhlpojrsohe.asp, line 5 > > > Browser Type: > Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; iOpus-I-M; .NET CLR 1.0.3705) > > Page: > GET /ostandari/TMPhlpojrsohe.asp > mzarbei@yahoo.com
- Next message: Troy: "Access Logs"
- Previous message: Jasper Smith: "Re: EM losing Server registrations in XP"
- In reply to: mzz: "Error In Loging to Sqlserver2k via web"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
