Hello friends,

   I have downloaded SQL server 2000 eval from microsoft site. And i installed in my win 2000 server. I have created one user named "raj"

conn.connectionstring="Provider=SQLOLEDB.1;Integra ted Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=RAJANI;"

its giving error that connection failed "raj" not associated with trusted sql server connection.
Whats it?

I want to assign the user(raj and password) to my database and connect thru ASP. How can i do?

Thanx in advance

Its because you have 'Integrated Security=SSPI' in your conn string - this tells it to connect as the Windows user who is running the code. For a SQL Server login you need a slightly different connection string, like this:
conn.connectionstring="Provider=SQLOLEDB.1;User Id=raj;Password=myPassword;Initial Catalog=Northwind;Data Source=RAJANI;"

Also, make sure your SQL Server is configured to allow SQL Server logins, not just Windows logins. You can do this from Enterprise Manager by right-clicking the server, choosing properties, looking at the 'Security' tab and make sure the Authentication is set to 'SQL Server and Windows'