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