Login failed for user 'SERVER-2000IUSR_SERVE

Results 1 to 2 of 2

Thread: Login failed for user 'SERVER-2000IUSR_SERVE

  1. #1
    Join Date
    Dec 1969

    Default Login failed for user 'SERVER-2000IUSR_SERVE

    Hello everybody,<BR><BR>I am bit new to sqlserver. I created a dsn to with ODBC on my Win2k server.Where SQLserver also resides.When i written the below code as follows<BR><BR>&#060;%<BR>Dim ObjConn<BR>Dim ObjRS<BR>Dim strsql<BR>strsql="select name,passwd,email from Members"<BR>Set ObjConn=Server.CreateObject("ADODB.Connection")<BR >ObjConn.Open "dsn=bettingo"<BR><BR>Set ObjRS=Server.CreateObject("ADODB.Recordset")<BR>Ob jRS.Open strsql,ObjConn,OpenForwardOnly,adLockReadOnly<BR>< BR>While NOt ObjRS.EOF<BR> Response.Write "[" & ObjRS("name") & "]--------[" & ObjRs("passwd") &"]------------[" & ObjRs("email") & "]<BR>"<BR> ObjRS.MoveNext <BR>Wend <BR><BR>set ObjRs=nothing<BR>ObjConn.Close<BR>set ObjConn=nothing<BR><BR>%&#062;<BR>It is working offline fine in same environment but not working <BR>online server.Is there any problem with code or any security reason.<BR><BR>Any help is really appreciated.<BR><BR>With Regards<BR>Nagaraj.A

  2. #2
    Join Date
    Dec 1969

    Default RE: Login failed for user 'SERVER-2000IUSR_S

    Yes, that is security problem.<BR>Go to Users in SQL Server and give access to &#039;internet guest user&#039;.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts