[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

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

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.

-Rodolfo
0
noverb
Asked:
noverb
  • 3
  • 2
1 Solution
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
You installed the FULL Version of SQL Server or SQL Express?

Also, what type of license do you have for Visual Studio?  

Jeff
TechSoEasy
0
 
noverbAuthor Commented:
My apologies for being incomplete in my description. I installed SQL Server Developer EDTN 2005 that comes with Visual Studio 2005 Professional Edition
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
So why can't you "revert back to the Original state" of your SQL installatioin?  Just install it and then reinstall.

Then, my suggestion for you would be to take the appropriate Virtual Lab as a way to easily learn what is necessary to do in your own environment.  See: http://msdn2.microsoft.com/en-us/virtuallabs/default.aspx for all the available labs.

Jeff
TechSoEasy
0
 
noverbAuthor Commented:
Jeff,

Thanks for the recommendation. I found ample information in the virtual lab to answer my question.

Rodolfo
;-)
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Terrific!  The Virtual Labs are pretty cool... and very few people take advantage of them.

Jeff
TechSoEasy
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now