"Enable user SQL instances"

I couldn't reply the another thread so I'm continuing here.

Was about "Enable user SQL instances" and the Report Service didn’t started too.

How do I enable this remote connections?

And in the instalation, Should I Add a user to the SQL Server Administration Role?

And also in the step "ready to install" of the SQL Server SP2 shows the following:

The following components will be installed:

· SQL Server Database Services (Upgrade)

(Database Services, Replication, Full-Text Search)

· Reporting Services

(Reporting Services, Report Manager)

· Client Components (Upgrade)

(Connectivity Components, Management Studio Express)

Warning: Setup found that the following components that already exist are at a different service pack level than the components being installed.

Components: Microsoft SQL Server 2005 Tools Express Edition, Microsoft SQL Server 2005 Express Edition (SQLEXPRESS)

After completing setup, you must download and apply the latest SQL Server 2005 service pack to all the components.

Hi Skyler,

You should really click the Help button in the setup UI, all of these options are explain in the setup help.

Enable User Instances - On be default, this enables a special kind of instance of SQL Express that is used by Visual Studio to allow users without Adminstrator privleges to run applications with data stored in SQL Express.

Remote Connections - You can enable them using either the Surface Area Configuration tool or the SQL Server Configuration Manager, both of which can be launched from the Start menu after SQL Express is installed. You should look at the FAQ at the top of this forum and read the answer to the question about remote connections, it will point you to a KB article that explains additional steps you need to take if you have a firewall on your computer.

Add a user to the SQL Server Administration Role: This is important for Windows Vista to allow you to be an adminstrator on your copy of SQL Express. There is more information about issues with Vista in the SQL Express blog at http://blogs.msdn.com/sqlexpress.

The information shown on the ready to install page is telling you that you are upgrading the Database Service and Client Components and installing Reporting Services. It is also telling you that the Express Toolkit has been installed on your computer and that you will need to apply the SP2 update for the Express Toolkit to update those tools once you have finished installing Express with Advanced Services.

If you are still having problems with Reporting Services, I would suggest you post a question about that directly to the Reporting Service forum.

Mike