Configuration Parameters -- I've changed them and need advice

Question

I've just downloaded & installed SQL Server for the first time, v2008 Standard Edition. Everything was successful, and SP1 applied.

I was having problems with loading AdventureWorks (error ~ unable to login to server), so I changed the "Log On As" parameters via the Configuration Manager, now I don't remember how they were originally set.

Can someone advise me on how each of these should be setup. 

Name   - State  - Start Mode - Log On As?
-SQL SSIS
-SQL Full-text...
-SQL Server ..
-SQL Server Agent..
-SQL Server Browser...
-SQL SSAS...
-SQL Reporting....


I'm looking for maximum ease of use on a single, non-networked machine that will be use for learning purposes only, yet still don't want to do anything silly w/r security.

Thank you!! Looking forward to learning more.

Answer 1

I've just downloaded & installed SQL Server for the first time, v2008 Standard Edition. Everything was successful, and SP1 applied.  I'm running Windows 7

I was having problems with loading AdventureWorks (error ~ unable to login to server), so I changed the "Log On As" parameters via the Configuration Manager, now I don't remember how they were originally set.

Can someone advise me on how each of these should be setup. 

Name   - State  - Start Mode - Log On As?
-SQL SSIS
-SQL Full-text...
-SQL Server ..
-SQL Server Agent..
-SQL Server Browser...
-SQL SSAS...
-SQL Reporting....


I'm looking for maximum ease of use on a single, non-networked machine that will be use for learning purposes only, yet still don't want to do anything silly w/r security.

Thank you!! Looking forward to learning more.

Answer 2

Hi,

You can change "Log On As" back to Local System. It should be ok in your non networked machine.

BR,

JoukoK

Answer 3

Hi HoaryHound

If this is a simple learning installation, you could just set the services to use LocalSystem.

HTH

Ewan

---

If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).

If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.

Answer 4

    Hi,

       Please refer the following links you will get an idea...

         http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/

         http://msdn.microsoft.com/en-us/library/ms143219.aspx

         http://www.packtpub.com/article/microsoft-sql-server-2008-installation-made-easy

---

Lakshman

Answer 5

Hi TheHoaryHound,

Thank you for your post!


There are some default settings for these services, you can refer to the Books Online here: http://msdn.microsoft.com/en-us/library/cc281953.aspx.

Based on your description, If you are using SQL Server of learning purposes, I think the Developer Edition which is cheaper than Standard Edition or Express Edition which is free for use is better for you.

Hope this helps! If you have any concern, please feel free to let me know.

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.