There is no business intelligence studio tool after SQL Server is installed.

I believe that many users have spent a lot of time installing SQL Server 2005 and find that they cannot use it because bids is missing. dizzy. what's more strange is that after deletion, You can reinstall it.

After my research, I found that when we installed vs2005, the system automatically installed an SQL Server 2005 Express. When we installed SQL Server 2005, the system Checked that workstation was already installed, so it is no longer installed.

 

How can this problem be solved? The best solution is not to install SQL Server 2005 express when installing vs2005.

If the installation is complete, use the following solution:

Change the SQL Server installation in the control panel, and delete the last item (as a workstationgroup creation component). Then, install the setup.exe tool again.

If you have any questions, leave me a message.

 

In addition, I found a problem after I killed the last component, and all kinds of services were gone. I had to re-install the instance again. Of course, this can save a lot of time compared to the re-installation of SQL Server.

I don't know if I forgot to install the service or uninstall workstation when I first installed it.