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 >>>>> >>>> >>>> >>> >> >
