Re: user account settings for vs.net

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: lukasz (bbla32_at_op.pl)
Date: 09/13/04


Date: Mon, 13 Sep 2004 18:01:30 +0200

comments inline

> I do not see IIS_WPG as a user or group, so I think I have work to do on
IIS
> before I can continue. Any suggestions on what I need to do with IIS_WPG?
I
> know it means worker process, so maybe I'm misunderstanding what you told
me
> to do.

It's a group created after ASP.NET was created & registered. If you don't
have IIS installed on your machine the group is not likely to be there. If
you want ADO.NET to access SQL Server, you need to open SQL Server and grant
access for IIS_WPG in there.

> I don't think I need this account to be a member of the Power Users Group
> since I am not using legacy applications. Correct me if I'm wrong.

I am working on two machines, on one I'm an admin, on the other a power
user. I have no experience with more restrictive users, so in case you can't
work try adding yourself to the power users group and see if that helps.

> At those times that I am using Access as a back end database, do I need to
> have SQL started? Does VS.NET use SQL Server itself for any reason other
> than if I connect to SQL via ADO.NET?

No. You can stop SQL Server.

> If not then I would like to stop it
> for security reasons. How much of a security threat is having SQL on an
XP
> computer if it is Stopped? Any? Are there still open ports to contend
with?
> Or other vulnerabilities related to SQL if it is Stopped?

I believe you have all Service Packs and bug fixes installed.

To the best of my knowledge, SQL Server is a Windows service. As such, when
it is stopped, it is not running at all and no ports are open. But ask this
question to nntp://microsoft.public.sqlserver.server newsgroup for a more
reliable answer.

> I am still very unclear about what I need to do
> with IIS if I am only developing and testing on one machine, versus if I
am
> developing on this machine and uploading and debugging on another server,
and
> the role that IIS plays in both scenarios. I want to be clear about what
is
> needed and security on this machine in both situations, so I have some
> reading to do. If you have any suggested KB or articles, please post
them.

If you want to develop & test on local machine, setting up the account as I
said in previous post should suffice. I haven't done remote debugging with
web apps, only windows forms, and to debug code remotely I needed an account
on the server that was in the Debuggers group. I do not have any articles
covering this subject. Try searching the newsgroup or MSDN for "remote IIS
debugging."



Relevant Pages

  • Re: Questions about prep for Analytics application
    ... to keep the control on which program runs under you IIS. ... Turned ON Remote Connections on SQL Server Surface Area utility. ... Why does Proclarity need WebDAV? ...
    (microsoft.public.sqlserver.olap)
  • Re: New to Merge/Replication
    ... ADO.NET 3.0 includes "Synchronization Services" that does not require IIS. ... Hitchhiker's Guide to Visual Studio and SQL Server ... It was my deepest hope that Merge/Replication between SQL Compact Edition and SQL Server 2005 Enterprise Edition would have it's own sync services NOT dependent on IIS. ... You can use merge replication with SQL Server on your main desktop serving as the publisher with SQL Compact on PPC, TabletPC, or other desktops as subscribers, so that would probably be the easiest solution for you. ...
    (microsoft.public.sqlserver.ce)
  • Re: Help on synch to SQL server
    ... from SQL CE to SQL Server from your smart-device application's code. ... This can occur whenever the device has a network path to IIS, ... Unlike merge replication between SQL Servers where you can use RMO ... Ideally I would like to use Sql CE to synch with a SQL ...
    (microsoft.public.sqlserver.ce)
  • Re: SMS_MP_CONTROL_MANAGER error 4960
    ... When I try to restart the IIS it says nothing.... ... Manually restart the SMS Agent Host service on the MP. ... MP encountered an error when connecting to SQL Server. ... The Default Web Site is disabled in IIS. ...
    (microsoft.public.sms.setup)
  • RE: IUsr can not login
    ... I too am not sure what the IIS lockdown tool does (I am a SQL Server ... that had been assigned permission to login into SQL ... Amongst the NT account names will be the account/group that IIS ...
    (microsoft.public.sqlserver.security)