Problem with ASP connecting to SQL Server

<i><b>Originally posted by : Peter (petersgyoung@hotmail.com)</b></i><br />I try to connect to SQL Server with DSN. When I test the connection in DSN configuration window, the status is OK. <br /><br />However, when I use browser and ASP with DSN to connect to the SQL Server, the Server treat me as anomymous logon and the ASP page connection failed.<br /><br />What is the correct set setting in SQL server? Or do I have to set anything in the web server?<br /><br />Please advise. <br />

<i><b>Originally posted by : arrow (arrowy@163.net)</b></i><br /><br /><br />You need to add a user in the SQL server,and give it a password.Then ,in the DSN,you must write the word--"dsn=sqloledb;uid="username(you add just now!)";pwd="the password you add!"<br /><br />------------<br />Peter at 4/28/2001 3:06:12 AM<br /><br />I try to connect to SQL Server with DSN. When I test the connection in DSN configuration window, the status is OK. <br /><br />However, when I use browser and ASP with DSN to connect to the SQL Server, the Server treat me as anomymous logon and the ASP page connection failed.<br /><br />What is the correct set setting in SQL server? Or do I have to set anything in the web server?<br /><br />Please advise. <br />