0

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"

%>

3
Contributors
2
Replies
3
Views
11 Years
Discussion Span
Last Post by chmonalisa
0

hello,


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.

Thanks,
Chaitanya.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.