Rgain,
When you use ASP.NET, the default security context is the aspnet_wp account (or NetworkService account, for an application that runs on IIS 6.0) for both Aspnet_wp.exe (or W3wp.exe, for an application that runs on IIS 6.0) and the request to SQL Server.
By default, the aspnet_wp account (or NetworkService account, for an application that runs on IIS 6.0) does not have any permissions in SQL Server, and therefore it cannot access the database.
To resolve this issue, use any of the following method:
Grant the correct permissions on SQL Server so that the aspnet_wp account (or NetworkService account, for an application that runs on IIS 6.0) has the appropriate access to the required resources.
exec sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'
go
use ****
go
exec sp_grantdbacess N'NT AUTHORITY\NETWORK SERVICE'
go
asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
asp wysiwyg html editor: http://cutesoft.net/ASP
asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
Live Support: http://cutesoft.net/live-support/default.aspx