Window Authentication Log In

 made my first web application using vb script. I am trying to use window authentication for my web page and try to give all permission based on window domain user account. Here is the connecting string I was using to connect to the sql server and it was working fine.

 

Protected

Const sql_connection_string
As
String = _


    "workstation id= DATA-02;" & _

"packet size=4096;" & _

"user id=ASP;" & _

"password=ASP;" & _

"data source=ARENS-DATA-01;" & _

"persist security info=True;" & _

"initial catalog=SupplierTrack;"

 

I made couple of changes so it run on based on window domain user.

1) my server is set on window and sql server

2)
 Web.config file – I set Authentication mode = “ Windowâ€?

3) I also added under set

 
<
authorization
>


 
 
 
 
<
deny

users
="?"

/>

</
authorization
>

 

4) change the connecting string to : ( Added
"Integrated Security=True;"
 and removed line for user and password)


 

Protected

Const sql_connection_string
As
String = _


    "workstation id= DATA-02;" & _

"packet size=4096;" & _

"Integrated Security=True;" & _

"data source=ARENS-DATA-01;" & _

"persist security info=True;" & _

"initial catalog=SupplierTrack;"

 

5) run the application and now I am getting error said “Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.�
I was expecting window pop up log in to enter domain
 user and password and then verity the user and password against sql server
 and the take it from there. Where I made mistake. Need help.