I cannot login in the system. it gives this error. i m using sql server 2000. do i need to make changes in sql? plz help me. :sad:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.
/ikim/streg.asp, line 4

this is my code in streg.asp.

set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=SQLOLEDB.1;Persist Security Info=False; user name= ikim; pasword=ikim;Initial Catalog=ol;Data Source=localhost"


password is spelled wrong


try this :!:

conn.open "Provider=SQLOLEDB.1;Persist Security Info=False; uid= ikim; pwd=ikim;Initial Catalog=ol;Data Source=localhost"

Note that u mentioned "pasword" instead of "password".

if you dont' remember the password u can also use this

conn.open "Provider=SQLOLEDB.1;integrated security=true;Initial Catalog=ol;Data Source=localhost"
which takes windows authentication mode instead of sql authentication.