Hello:

I am working on the DataGrid Sorting Example and recieve the following error when I load up the webpage:

Login failed for user 'ADAIR001\ASPNET'.

I am not sure what the problem is. Here is the connection string I am using to connect to the 'pubs' db:

objConnection = New SqlConnection("Data Source=(local);Initial Catalog=pubs;Integrated Security=SSPI")

This is the same connection string I used for the binding examples in Chapter 16(windows forms) and everything was well. What could be the problem?

thx,
tim

Your application is running as the ADAIR001\ASPNET user account, which doesn't exist ing the database you are connecting to. Add that to the database and give it dbo permissions.

Brian

I have the same problem. It looks like IIS uses the username ASPNET. Since I am using the MSDE I am not show I can add a new user APSNET to the database as dbo. It seems MSDE has only one user account "sa". Can any one help ? please!

Hi Brian,

Thanks for the response. I am a newbie to MSDE and .NET and am not quite sure how to add 'ADAIR001\ASPNET' to the db and give it permissions. Will have to look into that, but if anyone can help me out by posting the solution or a link to useful info that would be greatly appreciated.

Also, I am puzzled by the fact that I was allowed access to the database when using Winforms. Why do I need permissions all of a sudden to use Webforms?

tim

Hi,

I resolved this issue by not so hardway. Reinstall MSDE so that SQL authentication is used instead of Windows and reattach the pubs database. I used the following command while reinstalling the MSDE.

setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"

Now in the code use the user id and password as used above, and it works.

Another way to fix the issue as Brian mentioned is to use a tool call SQL Web Administrator and add make the ASPNET as dbo (I didn't try this solution)