October 11, 2011 at 3:24 am
I want to login Sql server with windows autontecation from a untrusted box from web application but ı can not find the
web.config connection string...
I try it but it doesn't run....
Data Source=xxxx;Initial Catalog=xxxx;Persist Security Info=True;User ID=xxx\WindowsDomainUser;Password=xxxx
October 11, 2011 at 3:49 am
I Have Nine Lives You Have One Only
THINK!
October 11, 2011 at 3:51 am
Can you clarify a couple of things:
a) You say WINDOWS authentication, but are giving a username and password which implies you are ysing SQL Server authentication - which do you want?
b) By "Untrusted box" can you explain exactlyu what do you mean, if its is part of the windows domain (or a trusted domain) you can use windowes auth, otherwise I think you will have to fall back on SQl server authentication.
If you can give more details on the above many people will be able to help more.
Mike John
October 11, 2011 at 3:56 am
I have a web site and it is in a pc and that pc is in a domain but i want to use different domain user to login SQL SERVER
for my website and how can i do it in web.config
October 11, 2011 at 4:37 am
haven't done this myself, but i know you have to use impersonation;
this should help, straight from Microsoft:
http://msdn.microsoft.com/en-us/library/89211k9b%28v=vs.80%29.aspx
Lowell
October 11, 2011 at 5:20 am
I solve my problem with impersonate......
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply