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

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

"sqlrun_sql.msi" needed to complete Visual Studio 2005 SQL server installation

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

I had a hard drive failure at work so had to reinstall my whole development environment :(

I installed Windows 7 Professional.

I installed Visual Studio 2005 full install.

It suggested I installed Service Packs for the components to make them compatitible with Windows 7.

Windows update attempted to install "Security Update for SQL Server 2005 Service Pack 3" which always fails.

I looked at the help that came with the failure error and it said to got to "Control Panel -> Programs and Features -> Visual Studio 2005 SQL Server -> Change" then finish up the suspended installation.

I do this and the installation asks for "sqlrun_sql.msi" which I cannot find on any installation disc or anywhere on the internet.

I have tried to repair Visual Studio 2005 and that didn't help.

Will reinstalling Visual Studio 2005 help.

This is so annoying as everytime I shutdown, windows trys to install the VS SQL update and it fails.

Any ideas?




View Complete Post

More Related Resource Links

Use The Source, Luke: Source Server Helps You Kill Bugs Dead In Visual Studio 2005


The latest releases of WinDBG and Visual Studio know exactly how to use source server, so its benefits are available to both .NET and native C++ developers. See why this is so important in tracking down bugs.

John Robbins

MSDN Magazine August 2006

Bootstrapper: Use the Visual Studio 2005 Bootstrapper to Kick-Start Your Installation


There are plenty of times when you need to get information on running processes, not the least of which is during performance tuning. Using the techniques in this article and special .NET classes you'll see how to get a process' ID, name, priority, number of threads, kernel handle, and memory consumption, as well as its user-mode, kernel-mode, and total elapsed running time and put them to use in a custom app called AssemblyBrowser.

Sean Draine

MSDN Magazine October 2004

How to start SQL Server 2005 (Visual Studio 2008)

I am just starting to work with Visual Studio 2008 (VB) to creat WPF apps and am trying to work with sql server. I want to create databases on my computer to be used with single client applications. When I try to see if the server is running it doesn't appear to be. Is there some special process that I need to do to start the server so I can create some sample databases to work with in Visual Studio? Working with Windows XP, Visual Studio 2008, SQL Server 2005.

Visual Studio 2008 and SQL Server 2005 SSIS packages


My home machine has sql 2005  and Visual Studio 2005 installed. I uninstalled VS 2005 (RTM) and installed VS 2008 (RTM) in its place. I then found that the SSIS templates were missing. Lesson: don't uninstall VS 2005 if you want to use SSIS 2005!


1. Is there any "workaround" to this issue?


2. (If the answer to 1 is "No") I will install VS 2008 side-by-side with VS 2005 on the same box.  When the SSIS issue is finally resolved, can I uninstall VS 2005 without doing damage to the VS 2008 install?










SQL Server Management Studio (2005) and Visual Studio 2008


Help -

I had been using SQL Management Studio, from sql server 2005, reciently I installed Visual Studio 2008 on my machine.  I use it for VB coding.  I still use the same Management studio.  It all works fine except when I try and Export or Import a table in Management Studio using the wizard.  I get the following error:

TITLE: Microsoft SQL Server

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476


Exception has been thrown by the target of an invocation. (mscorlib)


Specified method is not supported. (System.Data.SqlServerCe)



Any help would be appreciated.

Thank you

Cannot connect Visual Studio 2008 to Sql Server 2005


I have Windows 7 and installed Visual Studio 2008 Pro and also installed SQL server developer addiotion that comes with VS. After creating a test database in SQL maangement studio and adding the standard asp.net membership provider tables with the aspnet_regsql tool, I created a web project and added a connection string to the web.config file to connect to the database.

No matter what, I cannot connect to the database.

I can create a connection through the server explorer in visual studio and when I drag a sqldatasource onto my page and configure it I can connect to the database etc. But no web.config connection.

This worked on my XP pro machine but not Windows 7.

Has anybody had this problem and what am I doing wrong.


Web Application Deployment with Visual Studio 2010 and SQL Server 2005?



Is it possible to do a web application deployment(create package/publish sql & package/publish web) with Visual Studio 2010 and SQL Server 2005?

I'm trying my  hand at this new feature - I have an application created in VS2010 and the backend is SQL Server 2005

I read on msdn that the pre-requisites for the database part of the web application deployment is SQL Server Express 2008 or later versions for the tutorial they posted...Is that mandatory for any deployments??

Thanks for your help! Smile


Deployment issue using SQL CLR, visual studio TFS GDR 2, SQL Server 2005.


I have a solution project that consists of database project, CLR database project, C# projects. The database project references the CLR database project. Thus, by clicking deploy on the database project will auto-deploy all projects under the solution. It is successfully depolyed locally to either SQL Server 2005/2008 wihtout TFS GDR 2.

However, in addition to those compoments, on the staging server, there are TFS GDR 2 and the Windows Server running on virtual machine. The deployment failed. The reason is that my custom SQL CLR assembly that is loaded into database requires other additonal assemblies. Those assemblies have a dependent hierarchy, which requires deletion in a certain sequence (e.g. assemblyA depends on assemblyB, thus, assemblyB must be deleted from database first before deleting assemblyA.). When the deployment happens on the staging server, the generated database tsql script try to delete those assemblies, but in a wrong way/sequence. That is the reason it failed. As I said, it is working locally. But local deployment has no TFS GDR2 and virtual machine server, which might or might not be the cause. Because the auto-generated database script is done via visual studio.

I have tried using the pre/post deployment script, but it still failed on staging server.  We want to auto-deploy the solution for staging and production server.

installing SQL Server 2005 on Windows 7 with Visual Studio 2010 already installed



Last year I had Vista on machine with Visual Studio 2008 and SQL Server 2005 running fine. Last week I decided to wipe the hard disk, install Windows 7 and make the move to Visual Studio 2010. I still need SQL Server 2005 to be able to test code for clients using this.

Anyway, Visual Studio 2010 Professional went on OK. This installed SQL Server 2008 Epxress.

I then try to install SQL Server 2005. I know that there is a compatibility problem, so following advice from other sources, I want to install it without running the server, then install SQL Server 2005 SP3. Then I should be up and running.


The problem is that even though I make sure the 'Start SQL Server' check box is UNchecked, part way through the installation it throws up an error saying it can't start the server and this part of the installation is unrolled.

I've tried running 'setup.exe SKUUPGRAGE=1' which gets rid of the only warning I was getting up to this point, but the setup seems to insist on running the server even though I tell it not to. So I don't get a chance to run SP3 on it.


I wonder if the problem is that SQL Server 2008 Epxress is already installed but can't see an easy way of uninstalling it. It doesn't appear as an uninstall option using the Visual Studio 2010 disk and if I look at uninstall programs I get the f

Compatibility issues between Microsoft Visual Studio 2005 and Windows Server 2008 R2


Dear sirs,

When I was installing SQL Server 2005 64 bit on Windows Server 2008 R2, I received a notice informing the software Microsoft Visual Studio 2005 has known compatibility issues with this version of Windows.

So how can I get around these problems?

I need to use Visual Studio 2005 to create the Integration Services packages.

Also, I need to migrate directories of Integration Services packages from a server with SQL Server 2005 32 bit on Windows Server 2003 32 bit for a server with SQL Server 2005 64 bit on Windows Server 2008 R2. How can I proceed to do this?

Thanks in advance.

Jose Luiz

HttpHandler works with Visual Studio Development Server debugging, but not otherwise


Hi all,

I'm new to HttpHandlers.  I am writing an HttpHandler that reads uploaded files directly from the request stream to provide progress that can be queried using an AJAX request.  For large files, this seems to be faster than having ASP.NET load the file contents into Request.Files and then streaming the file from there to wherever it goes (Linq to SQL into a VARBINARY column in an SQL Server database.)

My HttpHandler works perfectly when I'm debugging using the Visual Studio Development Server, but doesn't work otherwise.  The application pool for this application in IIS 7 is set to run in Classic Mode, and the Handler Mappings screen in IIS says that I must manage managed handlers in system.web/httpHandlers. 

I set up in my applications Web.config file.

<add verb="GET,POST" path="*.upload" type="Namespace.For.UploadHandler, AssemblyForUploadHandler"/>

It works great, so long as I don't debug with the "Use Local IIS Web server" option.

What else do I need to do to get this to work?


Data Joins The Team: Introducing Visual Studio 2005 Team Edition for Database Professionals


Here Brian Randell presents everything you need to know to get started with Visual Studio 2005 Team Edition for Database Professionals.

Brian A. Randell

MSDN Magazine February 2007

C++ at Work: Managed Code in Visual Studio 2005


Many of you are no doubt in the process of upgrading to Visual Studio® 2005, so I thought now would be a good time to relate some of my own experiences with the new compiler. What took me so long? Hey, I'm a retro kind of guy! Better late than never!.

Paul DiLascia

MSDN Magazine June 2006

Visual Studio 2005: Create Reusable Project And Item Templates For Your Development Team


Visual Studio 2005 introduces a new model that lets you define your own project templates and starter kits, something developers have been requesting for some time. Here Matt Milner shows you how to consume, create, and customize these templates.

Matt Milner

MSDN Magazine January 2006

Team Up!: Get All Your Devs In A Row With Visual Studio 2005 Team System


In this article, Chris Menegay shows you how to use Team System throughout your software development lifecycle. He covers both the client tools available with Visual Studio Team Suite and the server features enabled by Team Foundation Server.

Chris Menegay

MSDN Magazine Visual Studio 2005 Guided Tour 2006

Editor's Note: Visual Studio 2005 Guided Tour


2005 was a truly exciting year for us here at MSDN Magazine. We launched a new magazine. We covered all sorts of amazing advances for the programmer, courtesy of Visual Studio 2005. We lost a couple of weeks, because of that dodgy falafel cart on 49th Street.

MSDN Magazine Visual Studio 2005 Guided Tour 2006

Safe!: Repel Attacks on Your Code with the Visual Studio 2005 Safe C and C++ Libraries


When Visual Studio 2005 ships, it will include a major upgrade to the Visual C++ Libraries that was the result of a complete security review of the functions contained in the C Runtime Library, Standard C++ Library, ATL, and MFC. From that extensive review came the Safe C and C++ Libraries, which can improve the security and robustness of your apps.

Martyn Lovell

MSDN Magazine May 2005

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