Member Avatar for Qcdms21

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
  • 182 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by chmonalisa
Member Avatar for campkev

password is spelled wrong

Member Avatar for chmonalisa

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.