I have windows 7 x64 ultimate. I have installed vs.net 2008 and sql server 2008 R2. Right now in the sql configuration manager I saw following services are ""Running":
SQL Sever Integration Services 10.0
SQL Full-text Filter Daemon Launder
SQL Server Browser
SQL Sever Agent is showing "Stopped".
I can connect to both the server XXX and sqlexpress from SSMS.
Here is my newbie questions:
1) I only installed R2, but why there is sqlexpress there?
2) why SQL Sever Agent is "Stopped"? is it normal?
3) since I don't use sql often, in order for the pc runs faster, I want to have sql server be turned off by default and only turn it on when I needed. Can I just put all above services into manual and turn them on when I needed?
View Complete Post