.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Can I install BIDS without installing SQL Server?

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server




Can I install just Business Intelligence Development Studio without installing SQL Server?



Salman Shehbaz.


View Complete Post

More Related Resource Links

Unable to install SQL Server 2008 Express R2 after installing .NET 4.0

Hi experts, I intend to redistribute SQL Server 2008 Express R2 in my installer. I've extracted the setup files from SQLEXPR32_x86.exe and pass in the appropriate command line parameters during the setup. Recently, I noticed if I applied the following Windows Update: .NET 4.0 Client Profile, I will hit into the following error when I installed SQL express. .NET Runtime 4.0 Error Reporting EventType clr20r3, P1 setup100.exe, P2 10.50.1600.1, P3 4bb67524, P4 mscorlib, P5, P6 4ba1da6f, P7 44f0, P8 32, P9 system.security.security, P10 NIL. .NET Runtime Application: setup100.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Security.SecurityException Stack: at Microsoft.SqlServer.Chainer.Setup.Setup.DebugBreak() at Microsoft.SqlServer.Chainer.Setup.Setup.Main() Running the setup.exe from a file server will give these errors but if I copied the entire setup files to a local folder and run setup.exe from there, it runs fine. May I know what am I missing? I definitely need to support to install SQL express running from a file server location. Thanks, MK  

re-install SQL Server BIDS


dear all,


i was successful installing SQL Server 2008 with all of its features, including the BIDS.

yesterday, BIDS was crashed. i can't even started it, so i removed it from Add/Remove Programs (SQL Server BIDS only).

now, i'm unable to reinstall SQL Server BIDS. i've choose the add features of SQL Server 2008, but none of the features i could select so the installation stopped by itself because i haven't choose anything.

anyone knows how to add BIDS to an existing SQL Server 2008?





When installing VS 2010 SQL server doesn't install properly


I have tried to install Visual Studio 2010 Professional from DVD onto a freshly installed copy of Windows 7 Ultimate 64 bit.I was logged on to an account that is an adminstrator and I right clicked and chose "run as administrator" on the autorun on the DVD.  Although it said it was successful the SQL Server 2008 R2 did not install properly. The messages in the installation log are of the kind:

[11/16/10,15:43:28] Microsoft SQL Server 2008 R2 Management Objects (x64): ISetupManager::GetGlobalCustomProperty() failed to find global prop in CBaseComponent::GetGlobalCustomProperty()

I also got in the event viewer 224 copies of error event id 63 with text:

A provider, SQLServerEventProvider, has been registered in the Windows Management Instrumentation namespace root\Microsoft\SqlServer\ServerEvents\SQLEXPRESS to use the LocalSystem account. This account is privileged and the provider may cause a security violation if it does not correctly impersonate user requests.

 and 2 copies of warning event id 1101 with text:

failed in installing SQL Server due to the MSI install error - Failed to connect to server. Error: 0


Hi All,

i don't know why but i'm very frustrated today, I always failed in installing any kind of SQL Server express edition on my XP SP3 laptop:

2005 into 2008 Standard and Advanced 32 bit all will always failed with the following error attached.

can anyone suggest to me what to do next please ?

FYI: here's my MSI version Windows ® Installer. V 4.5.6001.22159 



=== Verbose logging started: 01/04/2011 9:54:13 Build type: SHIP UNICODE 4.05.6001.00 Calling process: C:\WINDOWS\system32\msiexec.exe ===
MSI (c) (70:3C) [09:54:13:978]: Resetting cached policy values
MSI (c) (70:3C) [09:54:13:978]: Machine policy value 'Debug' is 0
MSI (c) (70:3C) [09:54:13:978]: ******* RunEngine:
      ******* Product: c:\e5b11aa2dbc7aa520a0d2551fe01\setup\sqlncli.msi

how i can install sql server in my system


which edition of sql server  are best for me  Developer edition or express editon for development purpose.

i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.

How can Install Office 2007 on Windows server 2008 R2 64 bit machine in WSS 3.0

I have  64 bit machine  and Windows server 2008 R2 has installed. i have successfully install WSS 3.0  , but  when i tried to install  office 2007 ,  one  error  has  come  "OS is not compatible "  i thought  it was asking  for 64 bit office  2007   and i go through the  google and R&d find no 64 bit office is available ,  i have used   excel .dll in my custom code  so my problem is that   how can  install office 2007  on 64 bot OS 2008 r2  machine .  if anyone can help   me  , please let me know . thanks in advance

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


SQL Server Reporting Services not able to install on Windows Vista Home Premium


Recently I had a weird problem while trying to install SQL Server Reporting Service in my local PC. I am using Windows Vista Home Premium and I wanted to configure SSRS in my PC. During the installation, the setup wizard listed all the services that we want to install and I found that only Reporting Server checkbox option was disabled and I wondered why??? I thought it may be becuase of some installation problem and tried again and its useless... I googled lot of sites for 3 days and finally found that due to some IIS issues, it is not possible to install Reporting Server in Vista Home Premium version. Reporting Server needs some specific IIS features to be installed in the machine.

But unfortunately those features are not available for Home Premium users which in term restricts users not to install reporting server in our PCs... Also, Microsoft has accepted it as an issue and its not possible to get it install in Home Premium...just wanted to share and might be useful for someone like me.

Reference: http://support.microsoft.com/kb/920201/en-us

SQL Server 2008 R2 BIDS PageHeader's PrintOnFirstPage=False Not Behaving Like SQL Server 2008 BIDS

I have recently upgraded from SQL Server 2008 SP2 Enterprise edition to 2008 R2 Enterprise, and was in the process of validating that the process did not have any adverse affects on my existing 150 reports originally designed and managed via BIDS 2008. Several reports were designed where the first page has a header different from the rest of the pages.  I created the generic header in the PageHeader and set PrintOnFirstPage to False.  This worked great in 2008...but in 2008 R2 the real estate on the first page is not "freed," so the first page looks like it has an enormous top margin when rendered as a PDF. Even playing around with the visibility of the text box doesn't eliminate the whitespace - and setting visibility properties was not required to get it to work in SQL Server, which rendered as a PDF perfectly just yesterday before our upgrade! I noticed that there were three patches available, but I did not see a Fix available that addressed this issue, therefore I did not install them as advised on the site. Is there any way to do free up the real estate so my first page can use it (maybe a setting in 2008 R2 that wasn't there for 2008)? Or is this a known bug between the two and a patch/hotfix is in the works? I'd hate to have reports that were specifically designed with certain paging to have to be revisited one by one. Thank you fo

Need to install Report View Redistributables on the report server?

Hi there:   I've developed a webapps utilizing MS reporting service reports and it works fine on my local machine. When I promoted to production server, it failed . People say I need to install MS reportViewer redistributables on the report server.   1. What is this MS ReportView redistributables anyway??? I've already included ReportView control in my apps and can someone explain to me why I need to install on the report server?   2. If I can not install the redistributables on the report server as the client may refuse to install due to whatsoever reasons, it there anyway to get around?   3. For any winForms apps, do I need to install the redistributables on the report server?   thanks    Hui--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

How do I install SQL Server 2005 JDBC driver

I'm an new bie to "SQL Server 2005 JDBC Driver". I have downloaded SQL Server 2005 JDBC driver and extracted it to C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\. Is the installation complete now? How can I use this driver from my application? If there is a step-by-step instruction on whether we need to run some scripts in SQL Server or to configure some system variables, it would be great. Thanks in advance for your time in this.Cheeeeerrzzzz! S@kthi http://blogs.msdn.com/sqlsakthi | http://twitter.com/PowerSakthi Mark as Answer if it helps. This posting is provided "AS IS" with no warranties and confers no rights.

Error 2908 while installing sql server 2005 management objects collection on Win 7

I have SQL Server native client 2005 installed on Win 7 64-bit machine. While installing SQL Server XMO 2005 it gives error 2908 and aborts installation. Any suggestion on the error?

SQL-DMO Install on SQL Server 2005 Express Client

I am installing a Client side SQL 2005 Express that needs SQL-DMO. The Client computer does not have SQL Server 2005 Express installed. I have installed all the MDAC and .Net 2.0. The command line I'm using to try and install the SQL-DMO and XML modules is: SQLEXPR_ADV ADDLOCAL=Tools_Legacy,SQLXML I get a message something like 'SQL Server 2005 Version does not support this install option.' How do I get SQL-DMO installed on a SQL Server 2005 Express Client computer?

Having problems installing/setting up SQL Server 2008 Express/R2 for ASP.NET user management on deve

I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me. I'm currently building a couple of ASP.NET MVC 2 sites.  I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool.  The problem is that ASP.NET can't 'see' the database. I have SQL Server 2008 installed on my laptop.  It's the version which is available on the Web Platform Installer (I believe it's Express).  When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that I'm running any version of SQL Server at all.  I get an exception about 'named pipes', and some other things I don't understand at the moment. Obviously, this is all a bit over my head.  Is there an idiot proof guide or tutorial available that describes, step-by-step, how to: 1. Install SQL Server 2008 on a development PC 2. How to configure it to be used by Visual Studio 2010 Professional 3. How to properly upload/modify the db on the production server with what's on the development PC Essentially, all the things that the ASP.NET tutorials gloss over.  Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.

Cannot install SQL Server 2008 R2

I download the SQL Server 2008 R2  and cannot complete set up because Windows Power shell failed the details stated that it has not been installed. Setup cannot not be completed.  How do I install Windows Power shell? I choose 64 bit setup because I have a  Vista Home Premium   Service Pack 2 64 -bit Operating System. Should I try to use 32-bit installuation set up?

SQL Server 2008 R2 fails after Windows XP Pro SP3 install

We recently encountered an issue with SQL Server 2008 R2 failing to run after the upgrade from Windows XP Pro SP2 to SP3. This was tested and reproduced (with varying results) on more than one computer. Steps to reproduce this. On a Windows XP Pro machine with Service Pack 2 installed, install SQL Server 2008 R2. Next upgrade Windows to Service Pack 3. Now upon opening SSMS or trying to start the SQL server service you receive the following message: "This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem". In some instances reinstalling/repairing SQL Server 2008 R2 does fix the issue.  In other cases the installer crashes and you need to use msizap to clean it up before you can reinstall.  In other cases you do not receive any errors at all. After testing in multiple virtual machines it looks like the cleaner the Windows install the more likely you are to run into this issue.  On machines with most or all windows updates (prior to SP3) installed you do not necessarily even get the failure.  On machines with just Windows XP Pro SP2 installed with no additional updates you get the failure every time. Obviously the SQL Server 2008 R2 prerequisites are installed in all cases in order to be able to install SQL server to begin with. Any help with this would be appre

Install on New Windows7 - Getting Invalid SQL Server Agent credentials

Hi: I have a Developer License for MSSQL Server 2008.  Have just upgraded to Windows 7 Professional Edition.  When installing MS SQL Server, the setup shows that I have an instance of SQL Server Express already installed.  I am given a choice between Default Instance and Named Instance.  First time I chose named instance and then used the name of my machine - RBS1.  I received the following message:  The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service. Went back and tried Default instance and got same answer.  Can't proceed to install.  Any help in this greatly appreciated. roger  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend