CAL question

I have a CAL to access a SQL Server that is installed on a local network. I
also have MSDE installed on my local machine.
Can I use this CAL to install the client tools of SQL Server (viz Enterprise
Manager, Query Analyzer) on my local machine to access my MSDE '
Thanx in advance,
Amol.A CAL lets you install the SQL Client tools on your PC BUT as far as
managing MSDE I'm afraid you need to be a lawyer to work that out. There are
some circumstances that allow you to use the client tools against it legally
but you would really need to speak to MS to understand what they are and
they probably won't really know either - it's a bit of a nightmare :-(
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Amol Kasbekar" <apk@.nospam.cbord.com> wrote in message
news:%23cymQ9ptEHA.260@.TK2MSFTNGP11.phx.gbl...
>I have a CAL to access a SQL Server that is installed on a local network. I
>also have MSDE installed on my local machine.
> Can I use this CAL to install the client tools of SQL Server (viz
> Enterprise Manager, Query Analyzer) on my local machine to access my MSDE
> '
> Thanx in advance,
> Amol.
>|||Wasn't the license for the Client Tools granted only with Visual Studio,
Office Developer and SQL Server?
AFAIK, having a CAL to access SQL Server doesn't give you the rights to use
their client tools to do so, and less if you plan to admin a *gasp* free
product.
Now regarding MSDE, there are some free alternatives to EM like DbaMgr and
Visendo SQL Admin. Go google them!
Regards,
Eric Garza
AMIGE
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eN2BLcstEHA.2788@.TK2MSFTNGP09.phx.gbl...
> A CAL lets you install the SQL Client tools on your PC BUT as far as
> managing MSDE I'm afraid you need to be a lawyer to work that out. There
are
> some circumstances that allow you to use the client tools against it
legally
> but you would really need to speak to MS to understand what they are and
> they probably won't really know either - it's a bit of a nightmare :-(
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Amol Kasbekar" <apk@.nospam.cbord.com> wrote in message
> news:%23cymQ9ptEHA.260@.TK2MSFTNGP11.phx.gbl...
I[vbcol=seagreen]
MSDE[vbcol=seagreen]
>

CAL question

I have a CAL to access a SQL Server that is installed on a local network. I
also have MSDE installed on my local machine.
Can I use this CAL to install the client tools of SQL Server (viz Enterprise
Manager, Query Analyzer) on my local machine to access my MSDE ?
Thanx in advance,
Amol.
A CAL lets you install the SQL Client tools on your PC BUT as far as
managing MSDE I'm afraid you need to be a lawyer to work that out. There are
some circumstances that allow you to use the client tools against it legally
but you would really need to speak to MS to understand what they are and
they probably won't really know either - it's a bit of a nightmare :-(
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Amol Kasbekar" <apk@.nospam.cbord.com> wrote in message
news:%23cymQ9ptEHA.260@.TK2MSFTNGP11.phx.gbl...
>I have a CAL to access a SQL Server that is installed on a local network. I
>also have MSDE installed on my local machine.
> Can I use this CAL to install the client tools of SQL Server (viz
> Enterprise Manager, Query Analyzer) on my local machine to access my MSDE
> ?
> Thanx in advance,
> Amol.
>
|||Wasn't the license for the Client Tools granted only with Visual Studio,
Office Developer and SQL Server?
AFAIK, having a CAL to access SQL Server doesn't give you the rights to use
their client tools to do so, and less if you plan to admin a *gasp* free
product.
Now regarding MSDE, there are some free alternatives to EM like DbaMgr and
Visendo SQL Admin. Go google them!
Regards,
Eric Garza
AMIGE
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eN2BLcstEHA.2788@.TK2MSFTNGP09.phx.gbl...
> A CAL lets you install the SQL Client tools on your PC BUT as far as
> managing MSDE I'm afraid you need to be a lawyer to work that out. There
are
> some circumstances that allow you to use the client tools against it
legally[vbcol=seagreen]
> but you would really need to speak to MS to understand what they are and
> they probably won't really know either - it's a bit of a nightmare :-(
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Amol Kasbekar" <apk@.nospam.cbord.com> wrote in message
> news:%23cymQ9ptEHA.260@.TK2MSFTNGP11.phx.gbl...
I[vbcol=seagreen]
MSDE
>

c# 2005 express edition install difficulty

I just installed express and found out that it won't connect to any of our
production Sql Server 2000 data or Sql Server 2003 MSDE (my local
development db). Another one of our developers installed Sql Server 2005
express with the c# 2005 express and couldn't connect to his production box
(also SS 2000) and screwed up Enterprise manager.
Has anyone else had this problem'Peter
> express with the c# 2005 express and couldn't connect to his production
> box (also SS 2000) and screwed up Enterprise manager.
>
Any errors?
"Peter Lux" <pete.lux@.theheritagegrp.com> wrote in message
news:ubejqfDSGHA.4608@.tk2msftngp13.phx.gbl...
>I just installed express and found out that it won't connect to any of our
>production Sql Server 2000 data or Sql Server 2003 MSDE (my local
>development db). Another one of our developers installed Sql Server 2005
>express with the c# 2005 express and couldn't connect to his production box
>(also SS 2000) and screwed up Enterprise manager.
> Has anyone else had this problem'
>|||The default setup of Express Edition does not enable network connection from
off the box where it is installed. Have you enabled network connections and
opened any firewalls to allow connections?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Peter Lux" <pete.lux@.theheritagegrp.com> wrote in message
news:ubejqfDSGHA.4608@.tk2msftngp13.phx.gbl...
>I just installed express and found out that it won't connect to any of our
>production Sql Server 2000 data or Sql Server 2003 MSDE (my local
>development db). Another one of our developers installed Sql Server 2005
>express with the c# 2005 express and couldn't connect to his production box
>(also SS 2000) and screwed up Enterprise manager.
> Has anyone else had this problem'
>

C drive not big enough

I am installing the X86 Executable version of SQL Server. I copied it to my desktop and clicked RUN. It extracts the files and then the Install Wizard tells me there is not enough space on the C Drive to load the program. I have 23 gigabits of free space and the program only takes about 900 megabits.

Is there a solution to this problem?

Thanks,

Modez

Hi Modez.

Is this Sql 2000 or Sql 2005?

Try creating a 'dummy' text file that is a few hundred mb in size or more (just create some garbage in the file and copy/paste it until the file becomes large enough), then try running the setup. If that works, you can delete the garbage file on completion.

Repost if you continue to have troubles,

HTH

|||

Chad:

It is 2005. I tried making a txt. file and got the same message. Then I tried to download it again and run it from the web site instead of saving it to my desktop but it stills says my C: drive is not big enough.

Do you have any other suggestions?

Thanks,

Modez

bypass login screen

Well im trying to install some software on someone's cpu. I dont know his password, and he has forgotten. How do I get pass the login screen? and assign a new name and password. :confused:This sounds like a network logon issue, no SQL Server. See your network administrator.|||Wouldn't that defeat the purpose of having a login screen?

HELLOOOOOOOOOOOOOOOOOOOOOOOOOOO!!!!!!!!

For everything else, there's MasterCard. You might also want to explore the power option.

Business Scorecard Manager 2005 server requirements

Attempting to install Microsoft Business Scorecard Manager 2005 on a server
that has all components of SQL Server 2005 installed including Reporting
Services w/IIS. The install lists several pre-requisites that are not on
server:
Microsoft XML Core Services (MSXML) 4.0
Microsoft OLE DB Provider for OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)
Microsoft ADOMD.NET 8.0
These pre-requisites look like something that would be present on a SQL
Server 2000 install, which is not on this server. If these 2000 components
are installed, will it overwrite something critical in SQL Server 2005?Hi,
there is equivalent 2005 tools / drivers
msxml 6
OLAP drivers v9
ADOMD.Net
download here:
http://www.microsoft.com/downloads/...&DisplayLang=en
"bhorwatt" <bhorwatt@.discussions.microsoft.com> wrote in message
news:A64F6A76-0680-436A-902F-37CD80FB27AD@.microsoft.com...
> Attempting to install Microsoft Business Scorecard Manager 2005 on a
> server
> that has all components of SQL Server 2005 installed including Reporting
> Services w/IIS. The install lists several pre-requisites that are not on
> server:
> Microsoft XML Core Services (MSXML) 4.0
> Microsoft OLE DB Provider for OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)
> Microsoft ADOMD.NET 8.0
> These pre-requisites look like something that would be present on a SQL
> Server 2000 install, which is not on this server. If these 2000
> components
> are installed, will it overwrite something critical in SQL Server 2005?
>

Business Scorecard Manager 2005 server requirements

Attempting to install Microsoft Business Scorecard Manager 2005 on a server
that has all components of SQL Server 2005 installed including Reporting
Services w/IIS. The install lists several pre-requisites that are not on
server:
Microsoft XML Core Services (MSXML) 4.0
Microsoft OLE DB Provider for OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)
Microsoft ADOMD.NET 8.0
These pre-requisites look like something that would be present on a SQL
Server 2000 install, which is not on this server. If these 2000 components
are installed, will it overwrite something critical in SQL Server 2005?Hi,
there is equivalent 2005 tools / drivers
msxml 6
OLAP drivers v9
ADOMD.Net
download here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en
"bhorwatt" <bhorwatt@.discussions.microsoft.com> wrote in message
news:A64F6A76-0680-436A-902F-37CD80FB27AD@.microsoft.com...
> Attempting to install Microsoft Business Scorecard Manager 2005 on a
> server
> that has all components of SQL Server 2005 installed including Reporting
> Services w/IIS. The install lists several pre-requisites that are not on
> server:
> Microsoft XML Core Services (MSXML) 4.0
> Microsoft OLE DB Provider for OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)
> Microsoft ADOMD.NET 8.0
> These pre-requisites look like something that would be present on a SQL
> Server 2000 install, which is not on this server. If these 2000
> components
> are installed, will it overwrite something critical in SQL Server 2005?
>

Business Scorecard Integration with SQL server 2000/2005

I was trying to install Business Scorecard Manager Server , for that i have installed SQL server 2000, Analysis services and Service Pack 4 and also have taken mixed mode of authentication . Then i have installed sharepoint portal server 2003 and extended a site .
Now when i install BSM server at the end of installation it gives me error that user administrator does not exist in Scorecard server database( Database which is created during installation process itself ). This error comes when installation package is trying to create a query string to already existing SQL server database.
Same thing happens even if i take SQL server 2005.
Any help in this regard will be really appreciated.

Thanks
Inder

If this problem occurs during the installation of Business Scorecard Manager Server, then you should post on a forum dedicated to that product.

For example, I see there are some posts about installation issues with BSMS on the following forum: ISV Open Discussions. Try posting your question on that fourm if it was not already answered there.

Thanks
Laurentiu

|||

Please see click-by-click install instructions available from http://cpminsider.com/deployment.aspx

Business Scorecard Integration with SQL server 2000/2005

I was trying to install Business Scorecard Manager Server , for that i have installed SQL server 2000, Analysis services and Service Pack 4 and also have taken mixed mode of authentication . Then i have installed sharepoint portal server 2003 and extended a site .
Now when i install BSM server at the end of installation it gives me error that user administrator does not exist in Scorecard server database( Database which is created during installation process itself ). This error comes when installation package is trying to create a query string to already existing SQL server database.
Same thing happens even if i take SQL server 2005.
Any help in this regard will be really appreciated.

Thanks
Inder

If this problem occurs during the installation of Business Scorecard Manager Server, then you should post on a forum dedicated to that product.

For example, I see there are some posts about installation issues with BSMS on the following forum: ISV Open Discussions. Try posting your question on that fourm if it was not already answered there.

Thanks
Laurentiu

|||

Please see click-by-click install instructions available from http://cpminsider.com/deployment.aspx

Business Intelligence Studio Missing

This post is for advice to anybody who cannot install BIDS.
Originally I installed SQL Express (with advanced services) onto a
virtual machine with Visual Studio 2005 Professional present. I then
attempted to install the reporting services toolkit so I would have
access to BIDS.
Each time I tried to install the toolkit It told me that the
components I have requested cannot be installed because they are
already installed. This is a flaw in the reporting services toolkit.
It searches for the visual studio executable, once fount it assumes
that BIDS is already present and it aborts the installation.
To resolve this issue remove Visual Studio. Install the reporting
services toolkit. At this point BIDS is available. Then install
Visual Studio. Finally the BIDS project types are available for use
under Visual Studio.On Jan 10, 11:57 am, brian...@.gmail.com wrote:
> This post is for advice to anybody who cannot install BIDS.
> Originally I installed SQL Express (with advanced services) onto a
> virtual machine with Visual Studio 2005 Professional present. I then
> attempted to install the reporting services toolkit so I would have
> access to BIDS.
> Each time I tried to install the toolkit It told me that the
> components I have requested cannot be installed because they are
> already installed. This is a flaw in the reporting services toolkit.
> It searches for the visual studio executable, once fount it assumes
> that BIDS is already present and it aborts the installation.
> To resolve this issue remove Visual Studio. Install the reporting
> services toolkit. At this point BIDS is available. Then install
> Visual Studio. Finally the BIDS project types are available for use
> under Visual Studio.
Just out of curiosity, did you install SQL Server 2005 Express Edition
w/Advanced Services SP2 or an older version?
Regards,
Enrique Martinez
Sr. Software Consultant

Business Intelligence Install

Hi,
How to install "Business Intelligence" to design SRS Reports?
I thought that this component would be in Visual Studio 2005 or 2003
but i can't find it.
I only try to get the "Report design Project" in Visual Studio.
Thank you
EmmanuelBIDs (SQL Server Business Intelligence Development Tool) is not in Visual
Studio install. It is in the SQL Server client install (tools section)..
So go through the SQL Client and Tools install and you will be good to go!
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"emsab" wrote:
> Hi,
> How to install "Business Intelligence" to design SRS Reports?
> I thought that this component would be in Visual Studio 2005 or 2003
> but i can't find it.
> I only try to get the "Report design Project" in Visual Studio.
> Thank you
> Emmanuel
>|||OK, Thanks for you answer.
Easy with SQL 2005, and it works...
But what about SQL 2000 ?
I don't find the necessary tools on the install CD...Do i need to go in
the "control panel" , "Add, Delete programs" or something like this ?
Thank you.

Business Intelligence Development Studio not installing from Toolkit

Everytime I went throught the express Toolkit install and I chose, all components, it just responded with "nothing to do."

I installed the BIDS by just executing vs_setup.msi. as mentioned above.

This seems to have worked partially. Visual Studio is now there.

However, no templates are available except "Blank Solution"

The case seems some Report Builder/Model Builder templates should exist?

What am I doing wrong?

What can I do to fix the problem?

Where can I find the "report building templates?"

Thanks.

AIMDBA

Hi AIMDBA,

I split this post into a new thread since it seemed like a distinct problem from the thread that you added it to. It's usually not a good idea to add new questions onto the bottom of a thread that has been marked as answered since not everyone reads the Answered threads unless they are looking for an answer.

Onto your issue...

vs_setup.msi is not BIDS, which is why your are not seeing the Reporting projects. What other SQL and VS products do you have installed on your computer when you are installing the Toolkit? Could you take a look at the setup logs (C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG) to see if there is any additional information about what went wrong?

Regards,

Mike Wachal
SQL Express team

Mark the best posts as Answers!

|||

Basically,

I installed the following, in the following order:

(1) Net Framework 2.0

(2) SQL Server Express 2005 with Advanced services.

I installed all components. This includes the report server.

I tested the report server. This works!

This install included SQL Server Management Studio.

(3) I tried next to install

SQL Server 2005 Tookit SP1.

I chose all components including Business Intelligence Studio.

I message came back saying somethin similar to "Nothing to do."

I tried other variations. I tried X'ing out the the other components, then tried instaling the Business Intelligence Studio. Again, I recieved the message back saying "Nothing to do."

My general impression is that since Management Studio Express is already installed, the installer thinks that Business Intelligence Studio is also installed? Is this true?

About the log directory, man /files logs exist in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files.

Is there any particular log I should be looking at? Like *tools.log?

Is there a good keyword to "search" on? E.g. "error" or similary

Thank you very much.

AIMDBA

|||

I'm was having the same problem. The log file you mention says, "SQL Server Setup was interrupted. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt." Cute - that's the file I was reading.

I looked at the files in the LOG\Files directory but they didn't help. I have VS2003 and VS2005 (Enterprise Edition) on my desktop. At least I hope it's still the Enterprise Edition after installing SQL Server 2005 Express, I hope I didn't mess up my VS2005 install.

The DTS directory was not in the /90 directory or the /90/Tools directory.

I FINALLY tried downloading the software, rather than just running it from the internet. I used WinZip to extract the files, then ran the setup.exe and THIS time it worked. BTW the DTS directory is there now.

Carol

|||

Carol,

The DTS directory has nothing to do with the Business Intellegence Development Studio. I'm not sure where you're going with this.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

AIMDBA wrote:

My general impression is that since Management Studio Express is already installed, the installer thinks that Business Intelligence Studio is also installed? Is this true?

No, Management Studio Express and BIDS don't interact and don't impact each others installation.

I just performed this same action of only installing BIDS on a computer that had everything else from Express Advanced and it seemed to work fine. I'm not sure what's going on here. I'd say as a next step, try Carol's method of extracting all the file and install from a flat. You can either use WinZip, or you should just be able to run <path>\SQLEXPR_TOOLKIT.EXE /x and then pick a directory to extract to.

Let us know if that works.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

The laptop I was using, ended up being inadequate for my project. I am getting a newer and better laptop.

I will try to do the installs again.

Maybe, next time, I will do the installs backwards.

(1) Install the optional Windows XP IIS server.

(2) Install Windows Installer

(3) Install .Net 2.0 Framework.

(4) Install ALL components of the Express toolkit. (Perhaps this will include SQL Server Express itself.)

(5) Install SQL Server Advanced Services ((SQLExpress if not already installed AND the report server in particular.)

I will try this order next time (maybe next week some time).

Mike Wachal what do you think about that?

It may be a while before I get the other laptop.

I will post back when I get the other laptop and try the install.

Does anyone else have any other comments?

Thanks.

AIMDBA

|||

Hi Aimdba,

I would reverse steps 4 & 5. SQL Express Toolkit does not contain the SQL database engine, it only contains the shared SQL Tools. So...

1 - 3. Yes, install the prerequisites first.

4. Install SQL Express with Advanced Services

5. Install the SQL Express Toolkit

Granted, it sounds like you've done this and it wasn't working, but this is the way that I install them and it has worked several times. I've never tried installing in the order that you suggest, but I don't see any reason that it wouldn't work.

Regards,

Mike

|||

Mike,

I did as you recommended.

I did "5. Install the SQL Express Toolkit"

Next, I did "4. Install SQL Express with Advanced Services"

All installs worked correctly.

Thanks.

AIMDBA

|||Hi Mike,

I might have the same problem (or I just might be totally clueless).

If I:

1) install 2005 Express with Advanced Services, selecting all available options.

2) install the Toolkit

The toolkit won't install, it says it has nothing to do. If I ask for details it says that the only available option is "upgrade"

So I:

1) Reverted back (This is all taking place on a VM).
2) Installed the Toolkit, selecting all options.
3) Installed Express Advanced Services, selecting Everything from all the options except Client Tools. For Client Tools I only select "Software Development Kit" (because the Management Studio Express and Connectivity Components were installed by the Toolkit"

It tells me it can't install the Client Tools (specifically "Workstation components and development tools 9.1.2047.00".

So, it seems to me, if you install any "Client Tools" with the Express install, you won't be able to install "Client Tools" from the Toolkit, even though the Client Tools don't match up 100%.

I think, in the end, by installing backwards I got all the things I will need, but I;m not sure I got the Software Development Kit. I'm also not sure what that is, or if I will need it, or how to know if I got it (this is the clueless part I mentioned earlier).

Any thoughts?

Business Intelligence Development Studio not installing from Toolkit

Everytime I went throught the express Toolkit install and I chose, all components, it just responded with "nothing to do."

I installed the BIDS by just executing vs_setup.msi. as mentioned above.

This seems to have worked partially. Visual Studio is now there.

However, no templates are available except "Blank Solution"

The case seems some Report Builder/Model Builder templates should exist?

What am I doing wrong?

What can I do to fix the problem?

Where can I find the "report building templates?"

Thanks.

AIMDBA

Hi AIMDBA,

I split this post into a new thread since it seemed like a distinct problem from the thread that you added it to. It's usually not a good idea to add new questions onto the bottom of a thread that has been marked as answered since not everyone reads the Answered threads unless they are looking for an answer.

Onto your issue...

vs_setup.msi is not BIDS, which is why your are not seeing the Reporting projects. What other SQL and VS products do you have installed on your computer when you are installing the Toolkit? Could you take a look at the setup logs (C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG) to see if there is any additional information about what went wrong?

Regards,

Mike Wachal
SQL Express team

Mark the best posts as Answers!

|||

Basically,

I installed the following, in the following order:

(1) Net Framework 2.0

(2) SQL Server Express 2005 with Advanced services.

I installed all components. This includes the report server.

I tested the report server. This works!

This install included SQL Server Management Studio.

(3) I tried next to install

SQL Server 2005 Tookit SP1.

I chose all components including Business Intelligence Studio.

I message came back saying somethin similar to "Nothing to do."

I tried other variations. I tried X'ing out the the other components, then tried instaling the Business Intelligence Studio. Again, I recieved the message back saying "Nothing to do."

My general impression is that since Management Studio Express is already installed, the installer thinks that Business Intelligence Studio is also installed? Is this true?

About the log directory, man /files logs exist in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files.

Is there any particular log I should be looking at? Like *tools.log?

Is there a good keyword to "search" on? E.g. "error" or similary

Thank you very much.

AIMDBA

|||

I'm was having the same problem. The log file you mention says, "SQL Server Setup was interrupted. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt." Cute - that's the file I was reading.

I looked at the files in the LOG\Files directory but they didn't help. I have VS2003 and VS2005 (Enterprise Edition) on my desktop. At least I hope it's still the Enterprise Edition after installing SQL Server 2005 Express, I hope I didn't mess up my VS2005 install.

The DTS directory was not in the /90 directory or the /90/Tools directory.

I FINALLY tried downloading the software, rather than just running it from the internet. I used WinZip to extract the files, then ran the setup.exe and THIS time it worked. BTW the DTS directory is there now.

Carol

|||

Carol,

The DTS directory has nothing to do with the Business Intellegence Development Studio. I'm not sure where you're going with this.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

AIMDBA wrote:

My general impression is that since Management Studio Express is already installed, the installer thinks that Business Intelligence Studio is also installed? Is this true?

No, Management Studio Express and BIDS don't interact and don't impact each others installation.

I just performed this same action of only installing BIDS on a computer that had everything else from Express Advanced and it seemed to work fine. I'm not sure what's going on here. I'd say as a next step, try Carol's method of extracting all the file and install from a flat. You can either use WinZip, or you should just be able to run <path>\SQLEXPR_TOOLKIT.EXE /x and then pick a directory to extract to.

Let us know if that works.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

The laptop I was using, ended up being inadequate for my project. I am getting a newer and better laptop.

I will try to do the installs again.

Maybe, next time, I will do the installs backwards.

(1) Install the optional Windows XP IIS server.

(2) Install Windows Installer

(3) Install .Net 2.0 Framework.

(4) Install ALL components of the Express toolkit. (Perhaps this will include SQL Server Express itself.)

(5) Install SQL Server Advanced Services ((SQLExpress if not already installed AND the report server in particular.)

I will try this order next time (maybe next week some time).

Mike Wachal what do you think about that?

It may be a while before I get the other laptop.

I will post back when I get the other laptop and try the install.

Does anyone else have any other comments?

Thanks.

AIMDBA

|||

Hi Aimdba,

I would reverse steps 4 & 5. SQL Express Toolkit does not contain the SQL database engine, it only contains the shared SQL Tools. So...

1 - 3. Yes, install the prerequisites first.

4. Install SQL Express with Advanced Services

5. Install the SQL Express Toolkit

Granted, it sounds like you've done this and it wasn't working, but this is the way that I install them and it has worked several times. I've never tried installing in the order that you suggest, but I don't see any reason that it wouldn't work.

Regards,

Mike

|||

Mike,

I did as you recommended.

I did "5. Install the SQL Express Toolkit"

Next, I did "4. Install SQL Express with Advanced Services"

All installs worked correctly.

Thanks.

AIMDBA

|||Hi Mike,

I might have the same problem (or I just might be totally clueless).

If I:

1) install 2005 Express with Advanced Services, selecting all available options.

2) install the Toolkit

The toolkit won't install, it says it has nothing to do. If I ask for details it says that the only available option is "upgrade"

So I:

1) Reverted back (This is all taking place on a VM).
2) Installed the Toolkit, selecting all options.
3) Installed Express Advanced Services, selecting Everything from all the options except Client Tools. For Client Tools I only select "Software Development Kit" (because the Management Studio Express and Connectivity Components were installed by the Toolkit"

It tells me it can't install the Client Tools (specifically "Workstation components and development tools 9.1.2047.00".

So, it seems to me, if you install any "Client Tools" with the Express install, you won't be able to install "Client Tools" from the Toolkit, even though the Client Tools don't match up 100%.

I think, in the end, by installing backwards I got all the things I will need, but I;m not sure I got the Software Development Kit. I'm also not sure what that is, or if I will need it, or how to know if I got it (this is the clueless part I mentioned earlier).

Any thoughts?

Business Intelligence Development Studio Installation doesn't work

Hello,

I have just tried to install (among other things) BIDS, and have found it hasn't worked. I tried it once over an old SQL Server 2005 Express Edition installation, and that failed, so I followed the advice of others and removed it. In fact I removed everything I could find to do with SQL Server 2005, and started right from the beginning (restarted after removing everything). My steps were:

1) Install SQL Express with Advanced Services (SQLEXPR_ADV.EXE, 240 MB, downloaded today from http://msdn.microsoft.com/vstudio/express/sql/download/). Choose to install all components, with default options. Restart when complete.

2) Install SQL Express Tools (SQLEXPR_TOOLKIT.EXE, 218 MB, dowloaded today from http://msdn.microsoft.com/vstudio/express/sql/download/). Choose only to install BIDS (one of four components).

When it was all over, I tried to fire up BIDS via the start menu (All Programs / Microsoft SQL Server 2005 / SQL Server Business Intelligence Development Studio), and got an error to say the shortcut to "devenv.exe" couldn't be found. Sure enough, it isn't where it should be - in fact it is not there at all.

As a note, I observed that when I went to install BIDS as per step 2 above, the installer made some claims about it already being installed, and that it would perform an upgrade...?

Something is not right here... By the way, I have installed BIDS on another machine some months ago, with no problems. Probably an older version at the time...

Hope someone can help.

Nick

A couple of additional details:

*) I have the full set of Visual Studio Express tools installed (Visual C# Express etc).

*) I just tried to uninstall SSMSE, and then use Express Tools installer to reinstall everything - this didn't work.

The thick plottens...

|||

So it turns out I had to do like many others - extract the Express Toolkit and run the vs_setup.msi. Hardly a particularly intuitive solution.

Judging by the many similar issues raised in this forum, many spanning back a number of months, Microsoft could do worse than fix what is clearly a bug...

Business Intelligence Development Studio Installation doesn't work

Hello,

I have just tried to install (among other things) BIDS, and have found it hasn't worked. I tried it once over an old SQL Server 2005 Express Edition installation, and that failed, so I followed the advice of others and removed it. In fact I removed everything I could find to do with SQL Server 2005, and started right from the beginning (restarted after removing everything). My steps were:

1) Install SQL Express with Advanced Services (SQLEXPR_ADV.EXE, 240 MB, downloaded today from http://msdn.microsoft.com/vstudio/express/sql/download/). Choose to install all components, with default options. Restart when complete.

2) Install SQL Express Tools (SQLEXPR_TOOLKIT.EXE, 218 MB, dowloaded today from http://msdn.microsoft.com/vstudio/express/sql/download/). Choose only to install BIDS (one of four components).

When it was all over, I tried to fire up BIDS via the start menu (All Programs / Microsoft SQL Server 2005 / SQL Server Business Intelligence Development Studio), and got an error to say the shortcut to "devenv.exe" couldn't be found. Sure enough, it isn't where it should be - in fact it is not there at all.

As a note, I observed that when I went to install BIDS as per step 2 above, the installer made some claims about it already being installed, and that it would perform an upgrade...?

Something is not right here... By the way, I have installed BIDS on another machine some months ago, with no problems. Probably an older version at the time...

Hope someone can help.

Nick

A couple of additional details:

*) I have the full set of Visual Studio Express tools installed (Visual C# Express etc).

*) I just tried to uninstall SSMSE, and then use Express Tools installer to reinstall everything - this didn't work.

The thick plottens...

|||

So it turns out I had to do like many others - extract the Express Toolkit and run the vs_setup.msi. Hardly a particularly intuitive solution.

Judging by the many similar issues raised in this forum, many spanning back a number of months, Microsoft could do worse than fix what is clearly a bug...

Business Intelligence Development Studio 2005 Installation Error

Hello,

I'm trying to install the Business Intelligence Component ONLY of the Microsoft SQL Server 2005 Enterprise Edition. We are interested in only giving the BI Development Studio to a User to allow to create reports. The documentation makes it seems as if this is possible - am I wrong?

It allows me to walk through and select this component, and then it fails and I receive the following error:

There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=packageengine%5cinstallpackageaction.cpp%40InstallToolsAction.11%40sqls%3a%3aInstallPackageAction%3a%3aperform%400x643

When I followed the link and received "Sorry no additional information".

The System Requirements all meet - with the exception of the min. hardware I receive a warning message. Would this hault the execution?

Any help/advice would be appreciated.

Thanks!

what do the install logs say?|||I only quickly reviewed the logs and didn't see anything that was truly helpful...not sure what to look for?|||

Went back over the logs and the following seems to be an issue, just not sure how to fix it:

Running: InstallToolsAction.11 at: 2006/5/23 16:41:59
Error: Action "InstallToolsAction.11" threw an exception during execution. Error information reported during run:
Target collection includes the local machine.
Fatal Exception caught while installing package: "11"
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: sqlchaining\sqlprereqpackagemutator.cpp
Compiler Timestamp: Tue Aug 9 01:14:20 2005
Function Name: sqls::SqlPreReqPackageMutator::modifyRequest
Source Line Number: 196

- Context --
sqls::InstallPackageAction::perform

WinException caught while installing package. : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: packageengine\installpackageaction.cpp
Compiler Timestamp: Fri Jul 1 01:28:25 2005
Function Name: sqls::InstallPackageAction::perform
Source Line Number: 167

- Context --
sqls::InstallPackageAction::perform

|||

does this log exist? SQLSetup[xxxx]_[ComputerName]_WI.log.

Also, I did successfully install SQL 2005 BI Studio by itself without the other sql related components. It's on my alienware box so hardware is no problem. You had me curious as I have never tried this before :)

|||

Yes I did. It's a pretty large file - do you want to see it, or just a portion of it?

We were trying to install the software from the server. Some of what I've been able to dig up is that it sometimes causes issues, so we are going to try to install it from the cd directly today. I'll keep you posted.

Thanks!