When I try to connect to my sqlserv

[sthmpsn1]

When I try to connect to my sqlserver using .net framework I get an http error code 401 unauthorized. If I use this same string with asp/vbscript it works fine. here is my connection string.
any help would be great!

"Provider=SQLOLEDB;Data Source=AM1ST_FS1;Initial Catalog=HRINFO;User
Id=sa;Connect Timeout=15;"

Scott

 

[link9]

401 unauthorized is a web server security error, not a connection error.

Sounds like you need to set the permissions on the directory where the .aspx file is so that it can be accessed.

If it were the database refusing you, the page would load, and you'd get an application error stating that the connection failed for whatever reason.


paul