troubleshooting Question

SQL 2005 step-by-step configuration for intranet, Windows XP Pro, IIS and VS 2005

Avatar of noverb
noverb asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
5 Comments1 Solution241 ViewsLast Modified:
Just installed MS SQL Server 2005 on an XP Pro machine with IIS and Visual Studio 2005 on it.

I have created a user account for anonymous access: IUSR_SQL with no special privileges.

Using the SQL server configuration manager I have changed the Logon As account to  IUSR_SQL for all the services, which probably was not the right thing to do, and for which I am asking for help in here.

What is the step-by-step way of configuring my SQL installation so I can run my internal website written in .NET without running into privileges problems?

I wish I could revert back to the Original state of my SQL installation (which didn't work either), at least to start from a standard standing point.

Any help will be greatly appreciated since I've spent 4 days on this already and am totally out of ideas.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros