BIDS, SP1, & Installation Account

On a "day to day" basis, the account I use to do work is not a member of the
Local Administrators group. When I do an install, I'll either do a Run As or
log on as a Local Administrator account to do the install.
On an XP Pro client (1GB RAM, 20 GB HDD), I install the SQL Client tools and
then Visual Studio 2005. All the Business Intelligence Project types work
correctly for both the installation account and the "day to day" account.
When I update the client tools to SQL SP1, the only user that can open a
Business Intelligence Projects is the Administrative account that did the
installation.
Using the "day to day" account, when I try to open an Analysis Services
Project, I get the error:
The Application for Project 'C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\Business Intelligence
Projects\AnalysisServicesProject.dwproj' is not installed.
Make sure the application for the type (.dwproj) is installed.
If the "day to day" account selects a different Business Intelligence
Project type, I get the error:
Object Reference not set to an instance of an Object
I can log on as the installation Administrator to do SQL work, but that
seems to me to be a security risk.
Any ideas on how to get the "day to day" account to work with Business
Intelligence projects? It works fine with all other project types in Visual
Studio?
Al
Sorry, I forgot to day, SQL Server 2005 Enterprise Edition with Client tools
loaded onto XP (SP2) from the Enterprise Edition CD. SQL 2005 SP1 installed
from SQLServer2005SP1-KB913090-x86-ENU.exe
"Al" <zyck@.tconl.com> wrote in message
news:uZ7Lv2NGHHA.2112@.TK2MSFTNGP03.phx.gbl...
> On a "day to day" basis, the account I use to do work is not a member of
> the Local Administrators group. When I do an install, I'll either do a Run
> As or log on as a Local Administrator account to do the install.
> On an XP Pro client (1GB RAM, 20 GB HDD), I install the SQL Client tools
> and then Visual Studio 2005. All the Business Intelligence Project types
> work correctly for both the installation account and the "day to day"
> account. When I update the client tools to SQL SP1, the only user that can
> open a Business Intelligence Projects is the Administrative account that
> did the installation.
> Using the "day to day" account, when I try to open an Analysis Services
> Project, I get the error:
> The Application for Project 'C:\Program Files\Microsoft Visual Studio
> 8\Common7\IDE\PrivateAssemblies\Business Intelligence
> Projects\AnalysisServicesProject.dwproj' is not installed.
> Make sure the application for the type (.dwproj) is installed.
>
> If the "day to day" account selects a different Business Intelligence
> Project type, I get the error:
>
> Object Reference not set to an instance of an Object
>
> I can log on as the installation Administrator to do SQL work, but that
> seems to me to be a security risk.
> Any ideas on how to get the "day to day" account to work with Business
> Intelligence projects? It works fine with all other project types in
> Visual Studio?
> Al
>