Thread: SQL server...
View Single Post
  #4 (permalink)  
Old February 3rd, 2004, 03:58 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

(I said MSDN a couple of times, but of course I meant MSDE)

Sorry it took me a while to answer you. I first had to get humiliated on the squash-court... ;)

Anyway, yes, you're getting closer. Your ASP.NET pages can now at least see your SQL Server. Now you have to make sure that the ASPNET account has sufficient rights to the database Friends.

By default, your ASPX pages will run under the context of the ASPNET account. (For "classic ASP", this was the IUSR_MachineName account).
To add this account, add it to you Login list under Security in SQL Server first, then grant it access to the Friends database.

If you have the SQL Server Enterprise Manager, this is easy to do. If you have just the MSDE, you'll need to execute some SQL statements to add the account.

Hope this helps, and if not, let me know.....

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.