I am trying to ASP.Net to sql server 2005 thro oledb or sql adapter...but when i run Login failed "servername/asp.net" error message has beeb displayed.Do i need to add permission in sql server?
2006-06-15 03:16:17 · 3 answers · asked by puppy 1 in Computers & Internet ➔ Programming & Design
try:
2006-06-15 12:06:22 · answer #1 · answered by rmpbklyn 4 · 0⤊ 0⤋
i'd recommend replacing from domicile windows authentication, and using sq. authentication. I have in no way considered all and sundry effectively take advantage of the domicile windows authentication, and it consistently looks to create issues. to succeed in this, you may ought to ensure a consumer account on the sq. Server, and make positive you take advantage of a similar consumer call and password for it, and the the relationship. reliable success, and please enable me comprehend if that would not artwork - i'm emailable by YA. reliable success : )
2016-11-14 19:37:46 · answer #2 · answered by durgin 4 · 0⤊ 0⤋
what does your connection string look like??
2006-06-15 04:13:08 · answer #3 · answered by sinkablehail1978 5 · 0⤊ 0⤋