SA,

Many thanks for your help.

My boot.ini did not have the following line:

C:\CMDCONS\BOOTSECT.DAT="Microsoft Windows Recovery Console" /cmdcons

Should I add the above line and what for?

I did not see the...

Hi SA,

I have the similar issues on your posting questions.

I have Window 2003 Enterprise sp2 32-bit and SQL 2008 and my hardware configuration:

DELL Dual Socket Demps/Woodcrest/PowerEdge 1900/2900

Intel 2.0 GHx...

Tim,

Thanks for you value advice. I went to Microsoft help and support pages and an article indicted that

“PAE is automatically enabled only if the server is using...

How to determine the SQL Server 2008 memory use after the configuration completed?

Thanks,

Edwin

Hi Markus,

I figured out the problems. When I installed my SQL 2008, I login my Window 2003 OS with "SQLAdmin" user that did not have sufficient privileges.

Note: The "SQLAdmin"...

Thanks. When I clicked on New menu, I also did not see the Project submenu?

Here how I setup my SQL 2008 installations.

1. Create SQL Service Accounts

...

I am using the Microsoft SQL Server Management Studio version 10.0.1600.22.

hi Markus,

I tried Ctl+Alt+L and Go to View menu. Both attempt did not bring up the solution explorer.

Weizrr..

I uninstalled SQL Server 2005, VS 2005 and Net Framework and SQL Server 2008 still won't install. SQL Server 2008 complained about Microsoft Window Installer 4.5.

Also, I...

I have similar problems. My Window Business Vista installed Visual Studio 2005, and SQL Server 2005 Dev edition and RED Gate tools.

When I installed the SQL...

Thanks for your help and advise.

I got it. 🙂

hi Steve,

Can you please provide the steps on windows server 2003 environment?

Many thanks for your help.

Edwin

Hi Raj,

Questions:

The SQL Server 2008 is running on a window account “SQLAdmin”.

SQLAdmin is the local User and Group account.

Can you clarify/explain on how to add the “SQLAdmin” to lock pages...

Performing the following step of configurations:

1. use master

go

exec sp_configure 'AWE enable', 1

go

exec reconfigure with override

...

Many thanks for your help and advise.

Yes. I have the SQL Server 2008 32 bit.

The RAM is 8GB. Some advised me not to configure/change the AWE settings.

The forums advised...