I have an asp site which I am constructing and I have finished the database design and such. Now I want to start connecting to the DB using ASP. This is my first time doing this with SQL server. I keep getting this error:

I have no idea what is wrong. I have registered the DNS on the system. There is no uname and pwd as far as I am concerned. Does this mean I have to setup a new user in SQL Server? The setting on the systems ODBC is that it connects with "Windows NT authentication using network login ID"

Ok well I was mesin around and boom finally I got it. Thanks your tip helpd. I made a new user, there was one before but it was the database administrator. I made one for the usrs. Then I still counldnt get it but then I went back to the ODBC connector in win. Then changed the uname and pass and sure enough that did it.