You will need Integration Services if you create maintenance plans in SSMS since they use SSIS. SSIS is also used to transfering data in and out if you need that...

No, it was a 32-bit machine.

I had a SQL Server with my previous employer that had 16GB of RAM installed using AWE. I had SQL Server setup to use a max of 14GB and it...

Real basic question here:

It looks like you are trying to connect to 2008? If so, I assume it is a new installation? Did you run the surface are config to...

If you are using all of those services, you need to take your total installed RAM to 8GB. 4GB is not enough to run all of those services. 8GB may...

Generally, 2048 should be fine.

Do you have anything else running on the server? How about any of the additional SQL Server services (SSIS, SSRS, SSAS)?

Not necessarily. There are good resources on MS's website that will help you determine the max memory that SQL Server should be set to. Generally, a system up to 8GB,...

No, it doesn't make any sense. I'm hoping someone else watching this...

Yes, that is the default that it installs with.

Does it...

I actually recycle my error log on a daily basis. I don't like having to look through it for some obscure entry when I have to weed through all of...

1073741824 is 1024 TB. If you want to set the maximum server...

Your max memory needs to be set at 2048. That value is represented in MB...

What about the following:

SELECT CHAR(0) TEST1, CHAR(0) TEST2

After a little searching on this issue, I found one reference where someone had to add themselves to the local administrators group on the server so they could log in...

As Colin suggested above, I would definitely move to 4GB. I personally won't run on less than 8GB but that is personal preference. If you use 4GB, set the max...