February 29, 2008 at 2:12 pm
I am trying to create a connection to a remote db. It has sql server 2005, windows authentication and permit remote connections is checked, however when I try to create the connection in asp .net it says that it cannot log me in (it displays my user info). What is the issue?
February 29, 2008 at 3:05 pm
If the IIS server and SQL Server are not on the same box, ASP.NET will not pass Windows credentials easily. I am not an ASP.NET guy, so you will need to search for ASP.NET SQL Server Trusted Authentication and you will get a ton of hits, some of which may be useful.
I believe the easiest way is if you have Kerberos setup.
Good Luck and let me know how you get it working.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply