Showing posts with label tools. Show all posts
Showing posts with label tools. Show all posts

Saturday, February 25, 2012

can't open adventure works example

after running msi, can't open this solution

C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Standard, select the file Adventure Works DW.sln

error msg
Microsoft Visual Studio

The application for project 'C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\standard\Adventure Works DW Standard Edition.dwproj' is not installed.

Make sure the application for the project type (.dwproj) is installed.

error msg

Did you install it some other folder than the one stated below ? Or did you not install the samples libarary ? Then you won′t find the information in this folder. You can install the samples from disks afterwards, juzst launch the explorer and use the custom installation type.

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||It's installed exactly where shown, but there are no instructions on how to install .dwproj|||ARe you installing SQL Server Express ? SQL Server Analysis Services isn′t shipped with Express so you should get the project files from another edition than express.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||yes I'm using sql express the advanced edition which is supposed to support the adventureworks sample|||Express does not support Analysis Services, you are trying to open the analysis services sample for adventure works, try one of the others.

Friday, February 24, 2012

can't make a view

When I attempt to make aview I get the error:
Microsoft Access can't start the client server visual design tools. This
feature is not availabel. To make this feature available please run setup
again, select "Add or Remove Features"....
When I run the msde setup again I don't see any option to Add or remove
features...
What do I need to do?
Thanks.
hi,
SAC wrote:
> When I attempt to make aview I get the error:
> Microsoft Access can't start the client server visual design tools.
> This feature is not availabel. To make this feature available please
> run setup again, select "Add or Remove Features"....
> When I run the msde setup again I don't see any option to Add or
> remove features...
> What do I need to do?
I'm not an Access guy, but I do think this is related to Access itself and
not MSDE..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks. I'll check it out.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:44ef3tF1lvu6U1@.individual.net...
> hi,
> SAC wrote:
> I'm not an Access guy, but I do think this is related to Access itself and
> not MSDE..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||ACTUALLY. This helped a GREAT DEAL. It does say Access, doesn't it!
Thanks again!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:44ef3tF1lvu6U1@.individual.net...
> hi,
> SAC wrote:
> I'm not an Access guy, but I do think this is related to Access itself and
> not MSDE..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Sunday, February 19, 2012

Can't launch SQL 2005 Tools

Hi,
I couldn't launch SQL server Management Studio from my SQL 2005 server.
There is no error message indicated after trying to launch this program.
However, if I try to launch other programs except SQL Server Configuration
Manager, I all got the following message.
To run this application, you first must install one of the following
versions of the .Net Framework: v2.0.50727 Contact your application publisher
for instructions about obtaining the appropriate version of the .Net
Framework.
SQL 2005 SP2 installation failed. How I can fix this issue and install SQL
2005 SP2 successfully?
Please advise ASAP. Tks.
Best Regards,
Lynn
Lynn (Lynn@.discussions.microsoft.com) writes:
> I couldn't launch SQL server Management Studio from my SQL 2005 server.
> There is no error message indicated after trying to launch this program.
> However, if I try to launch other programs except SQL Server Configuration
> Manager, I all got the following message.
> To run this application, you first must install one of the following
> versions of the .Net Framework: v2.0.50727 Contact your application
> publisher for instructions about obtaining the appropriate version of
> the .Net Framework.
> SQL 2005 SP2 installation failed. How I can fix this issue and install
> SQL 2005 SP2 successfully?
Download and install the .Net Framework from
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||The .Net Framework is corrupted in the machined. So, run the setup and
recovered the compnent. Problem solved.
Best Regards,
Lynn
"Lynn" wrote:

> Hi,
> I couldn't launch SQL server Management Studio from my SQL 2005 server.
> There is no error message indicated after trying to launch this program.
> However, if I try to launch other programs except SQL Server Configuration
> Manager, I all got the following message.
> To run this application, you first must install one of the following
> versions of the .Net Framework: v2.0.50727 Contact your application publisher
> for instructions about obtaining the appropriate version of the .Net
> Framework.
> SQL 2005 SP2 installation failed. How I can fix this issue and install SQL
> 2005 SP2 successfully?
> Please advise ASAP. Tks.
> --
> Best Regards,
> Lynn

Thursday, February 16, 2012

Cant install SQL Server 2005 on vista..

I'm loading the dev version of sql 2005 on vista ultmate. I'm not seeing the manager tools. I've installed sp2. In the services it says sql express but not sql server. I read the requirments for the dev version and it didn't list vista. Any ideas?

Two issues.

First, you may have SQL Express installed. SQL Express is NOT installed by SQL Developer Edition. You may wish to remove the SQL Express instance.

Second, the client tools are not automatically installed when you install SQL Server. You will need to insert the installation media, and select [Client Tools] to install SSMS.

|||

Thanks Arnie.

I'll take a look. However when I had xp pro setup SQL and SQL Express were both runnning. And I did the client tools and I'll revisit that. I want to make sure there are no issues between Vista Ultmate and SQL 2005. I think I've seen a few problems out there, but none like this particular issue.

|||

I am unable to download the following modules/components with my installation on Vista. As for not seeing the management console, I am using the trial download, so I cannot access any of the management tools on the media you are referring to, as well. Once I finish the installation, I do not see any reference to the SQL Server application in the Program directory, however, a directory has been created for it. I suppose this is because most of the key components are failing to install. In addition, IIS is installed, enabled, and running on my system, but I continually receive the error message during the first stage of installation indicating that IIS has not been detected and needs to be installed and enabled. I have tried stopping the service during installation, and it has not made a difference. I would greatly appreciate any good advice. Thanks.

==================================

BUTTONS:

&Retry
Cancel

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29513&EvtType=sqlca%5csqlmofca.cpp%40Do_sqlMofcomp%40Do_sqlMofcomp%40x7349


BUTTONS:

&Retry
Cancel

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29513&EvtType=sqlca%5csqlmofca.cpp%40Do_sqlMofcomp%40Do_sqlMofcomp%40x7349


BUTTONS:

&Retry
Cancel

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29513&EvtType=sqlca%5csqlmofca.cpp%40Do_sqlMofcomp%40Do_sqlMofcomp%40x7349


BUTTONS:

&Retry
Cancel

Can't install SQL Server 2005 Mobile Edition Server Tools Beta 1

I'm working with VS.NET 2005 Beta2 and SQL Server 2005 April CTP. My
SQL Server 2005 installation was more or less full, that is, I
installed everything related to Client Connectivity. I was bound to
build a merge replication scenario when I've noticed I needed "SQL
Server 2005 Mobile Edition Server Tools Beta 1".
Download the installer and execute it, obtaining the following error:
"You must first install the Replication Components for SQL Server 2000
SP 3a or higher or the SQL Server 2005 Client Connectivity Components."
What is the problem here if I have installed all Client components?
Any help will be greatly appreciated.
Instead of downloading "SQL Server 2005 Mobile Edition Server Tools
Beta 1" from Microsoft, which still warns me that I cannot replicate
with SQL Server 2005 because I don't have Client Connectivity
Components installed, I finally read this on MSDN2:
http://msdn2.microsoft.com/en-us/library/ms171908
The setup file is "sqlce30setupen.msi", located at "C:\Program
Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE". This
setup process went ok and did not warn me about anything.
Hope it helps people having the same problem.
PS: How does MS redirect developers to download Server Tools Beta 1 in
order to setup replication and then setup fails or warns the user
wihout any logical reason. Incredible! Can anybody explain me this?