It's working now. More simple solution would be to use SQL Server Authentication, but if Windows Authentication is required, this solution will work.
Thank You all for your help, Pratik On Thu, Aug 13, 2009 at 10:12 PM, Pratik <[email protected]> wrote: > 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 >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >
