Hey Steffen, Even I think both should work fine, since they are in the same domain. I am going to try the solution given in this blog: http://geekswithblogs.net/ranganh/archive/2005/05/25/40503.aspx
I am waiting for my Active Directory team to create a domain account with privileges similar to NETWORK SERVICE account, after which I am gonna give this account access to my database - and on my application I might have to use impersonation. I'll give you a heads up if this solution works. Let me know if you find something else. Thanks, Pratik On Thu, Aug 13, 2009 at 4:18 AM, Steffen Sommer <[email protected]>wrote: > Hi Pratik, > well i think if they are in the same domain, both should work, but im not > sure about this. > > Pleas let me know which one worked out for you. I going to face this > problem too, because i want to split database server from iis server in some > months, too. :) > > > On Wed, Aug 12, 2009 at 3:39 PM, Pratik <[email protected]> wrote: > >> Thanks Steffen! >> Before I try this, I would like to make something clear. In Step 8, it is >> said "enter DomainName/UserName and Password in the respective boxes", so >> does it mean we should enter the new domain account that was created or >> should we use the same credentials already populated by IIS i.e. >> IUSER_MACHINENAME and Password? >> >> This is the blog I am talking about: >> http://geekswithblogs.net/ranganh/archive/2005/05/25/40503.aspx >> >> Part 2 applies to me since my Web Server and SQL Server are on different >> machines. >> >> Thanks, >> Pratik >> >> On Wed, Aug 12, 2009 at 2:29 AM, Steffen Sommer < >> [email protected]> wrote: >> >>> There are some settings you may have to check: >>> http://geekswithblogs.net/ranganh/archive/2005/05/25/40489.aspx >>> >>> On Wed, Aug 12, 2009 at 2:21 AM, Pratik <[email protected]> wrote: >>> >>>> Already tried that. Used the account that has highest privileges. >>>> >>>> On Tue, Aug 11, 2009 at 1:28 AM, Yashika <[email protected]> wrote: >>>> >>>>> use with id and password >>>>> >>>>> >>>>> On 8/11/09, Pratik <[email protected]> wrote: >>>>>> >>>>>> Hi, >>>>>> >>>>>> I am developing a Custom Data Grid for displaying the stock >>>>>> information for my company. >>>>>> The stock information is stored in back end database and my program is >>>>>> getting data and displaying it in data grid. >>>>>> >>>>>> Everything is fine except for a login error that I am getting when I >>>>>> try to view that data grid from any client machine. >>>>>> >>>>>> Following login error is displayed in place of datagrid: >>>>>> >>>>>> *Login failed for user '(null)'. Reason: Not associated with a >>>>>> trusted SQL Server connection.* >>>>>> ** >>>>>> This is my connection String: >>>>>> >>>>>> *SqlConnection sqlcon = new SqlConnection("Data Source=DATABASE >>>>>> SERVER NAME; Initial Catalog=Database Name; Integrated Security=SSPI"); >>>>>> * >>>>>> ** >>>>>> Back end SQL Server (2005) is configured to permit both SQL Server and >>>>>> NT (Windows Authentication) i.e. Mixed Mode. >>>>>> >>>>>> Please let me know what am I missing. >>>>>> >>>>>> Thanks, >>>>>> Pratik >>>>>> >>>>> >>>>> >>>> >>> >> >
