Wednesday, March 24, 2010

SQL Server Network Service for ASP.NET User

if not exists (select * from master.dbo.syslogins where loginname = N'NT AUTHORITY\NETWORK SERVICE')
exec sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'
GO
exec sp_grantdbaccess N'NT AUTHORITY\NETWORK SERVICE', N'NT Authority\Network Service'
GO
exec sp_addrolemember N'db_owner', N'NT Authority\Network Service'
GO

Tuesday, March 23, 2010

WebDev.WebServer.Exe Stop has stopped working

Edit the solution file and find this:

VWDPort = "58332"

The assigned port here might be blocked so you have to
change the port to "8083"