.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

Sorry if this is in the wrong place, but I just had a question regarding MSSQL server installation f

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

Hello folks,

I have been recently discussing with a group of blind individuals the best way for us to be able to install the Express versions of SQLServer 2008 with ease, and best of all, success.  I was wondering if deep on this site or another, there was an ISO image I could possibly grab since I find the online installation center very confusing and also very unfriendly to those like me who must rely on screen readers in order to do their everyday computing tasks.  Any input on this is greatly appreciated.  I am blind myself, and due to a failed installation, and ultimately frustrating experience with this, I now have a desktop workstation at home that has been corrupted with left over remnants of SQLServer 2008 Express R2.  What is my best way at fixing this, and ultimately being able to install it so that I can now continue with my experimentation as planned?  Thanks. 



View Complete Post

More Related Resource Links

SQL Server 2008 R2 Installation and Service Pack 1 Question

I am migrating a SQL 2000 server to a SQL 2008 R2 server (on different physical servers) . When I ordered SQL Server 2008 the volume licensing allowed me to download sql server web 2008, sql server web 2008 R2 and sql server 2008 service pack 1. I don't know why I have three options to download. Don't I just need to just install the sql server 2008 Web R2? Are there any sql 2008 R2 service packs available?   

MSSQL SERVER 2008 installation Error


Hi all,

At the time of installation of SQL SERVER 2008 R2 (work group edition) on windows server 2003 standard editon the below error message was displayed.

TITLE: Microsoft SQL Server 2008 R2 Setup

The following error has occurred:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1&EvtType=0xBA6E21AA%25400x9A41B222



in event viewer i saw

".NET Runtime Optimization Service (clr_optimiz

Well I could not know where to ask this question. Sorry if this is the wrong place. Vb.Net 2010 Expr


Is it possible to operate incorrectly or even not work of a coded VB.Net 2010 Express in W7 with XP SP3 (both oses are 32 bit)? These are details of the situation; original code is in W7 system. I copied, ziped and send the working directory of the code to my home pc installed XP SP3, while the code works perfectly in my pc, it operates incorrectly in my home pc.

In my XP pc these Framework versions are installed: 2.0 SP2, 3.0 SP2, 3.5 SP1, 4 Client Profile, 4 Extended and 4 Multi Targeting Pack. And in my W7 pc these Framework versions are installed: 4 Client Profile, 4 Extended and 4 Multi Targeting Pack.

In my opinion these are no effects in this situation: W7 pc has an Intel based system and my XP SP3 pc has an AMD based system, or am I wrong, are they effective?

Problem in Installation of SQL Server 2008


Dear All,

I have Sqlserver2008 setup.

It is work in wndows Xp.

But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.

Plz some buddy can help the same.


Rakesh gupta

Educational question: How server objects are accessed from multiple client threads?

I will appreciate it if someone can help me to undestand how the following scenario works:   There is remoting server that is registered as WellKnownObjectMode.Singleton. Server implementation: It instantiates a class TestServer that implements interface IFoo interface IFoo { IHelper GetHelper() }   interface IHelper { void StoreString(); }   Implementation of TestServer: internal sealed class TestServer: System.MarshalByRefObject, IFoo { private IHelper> helper = new Helper(); public IHelper GetHelper(string helper){return helper;} }   Implementation of Helper: internal sealed class Helper : System.MarshalByRefObject, IHelper { public void StoreString (string val) {}; }   Implementation of a client (simplified; shown to illustrate the question only): static class Program { public static IFoo TestService; public static IHelper Helper; public TestThreads testmultiplecalls; [STAThread] static void Main() { TestService = (IFoo)Activator.GetObject(typeof(IFoo),"ipc://Channel"); Helper = TestService.GetHelper(); testmultiplecalls.Start(); } }   internal class TestThreads { public Start() { for (int i = 0; i < 20; i++) ThreadPool.QueueUserWorkItem((new TestCall(i.ToString())).DoWork); } }     internal class TestCall { private string m_str; public TestCall (string str) {m_str = str;} public void DoWork() { Program.Helper.StoreString(m_str); } }     Que

SQL Server 2005 OWC11 Installation Failure

Hi, While installing SQL Server Developer Edition I am getting a setup failure for OWC11 component on my machine with XP SP2. When gone through various community sites found this is related with Office Web component. I have tried below solution but none of them worked: 1. Downloaded OWC11 from microsoft.com and tried to install but failed to install. Its coming with an error message 'setup can not remove the older version of the Microsoft Offfice web component can not be removed' 2. Tried to uninstall Microsoft Offfice web componen from control panel but failing to uninstall, its giving an erropackage could not found. 3. Tried uninstalling Microsoft office 2007  from machine but didn't worked. I have Microsoft visual studio 2005 and Microsoft office 2007 installed on my computer. Please help me to get rid of this OWC11 component. Thanks in Advance. Jagdish

clr assembly in sql server - working directory? and exception question

Hello, I have a small assembly in sql server 2008... it's pretty simple, but in the very rare circumstance that it may throw an exception I am catching it and writting to a log file. something like: using (StreamWriter sr = new StreamWriter(@".\ErrorLog.txt", true)) { sr.WriteLine("{0:G} ===> {1}", DateTime.Now, ex.Message); } I believe that should write the file to the working directory... 1. what would the working directory be for sql server 2008? the binn directory? 2. what would happen if a clr assembly added to sql server throws an exception that is not handled by your clr code?

SQL Server 2008 Installation issue in Windows 7 64 bit

I'm trying to install SQL 2008, but an error message keeps appearing: Microsoft .NET Framework 3.5 installation has failed. SQL Server 2008 Setup requires .NET Framework 3.5 to be installed.   My OS is Windows 7 Ultimate 64 bits, so already has de .NET Framework 3.5, I turned on/off a lot of times and the same error occurs! I download the .NET Framework 3.5 and .NET Framework 3.5 SP1 from the links: (http://www.microsoft.com/downloads/details.aspx?FamilyId=333325fd-ae52-4e35-b531-508d977d32a6&displaylang=en http://www.microsoft.com/downloads/details.aspx?familyid=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en) But, when installing the Framework 3.5 or the SP1, I get the message: "Use turn on or off disable features in Windows control panel".   Someone can help me?! - Windows 7 Ultimate 64 bits - SQL Server 2008 Developer (x86, x64, ia64).   Thanks! Marcelo.

SQL Server Installation error. setup.rll

Hi, I am coming to you folks for some help on this issue that has been baffling me. Installing SQL Server 2008 R2 on a Windows Server 2008 R2 generates the same error every time ( "SQL Server 2008R2\Resouces\1033\Setup.rll is either not designed to run on Windows or it contains an error tryinstalling the program again using the original installation media." Then when I click on OK (From the error box) I get the following message: SQL Server MEdia does not support the language of the OS or doewn't have an ENU lcalized files. Use the matching language specific SQL. I am using a full version of both Windows Server and SQL Server.  

SQL Server 2005 - Installation in Cluster Environment - "Service SQL Server Browser (SQLBrowser) fai

Windows Server 2003 R2 Enterprise Edition SP2 32-bit All updates and patches installed Two-node cluster environment configured. Cluster functions perfectly. Trying to install SQL Server 2005 Enterprise Edition (32-bit) as a clustered application. Installation proceeds fine until it begins to install the SQL Server Database Services product. Status window says "Starting Services. Service: SQL Server Browser". Error message is presented: "Service 'SQL Server Browser' (SQLBrowser) failed to start. Verify that you have sufficient privileges to start system services". SQL Server Service Account is in the Administrators group on both local systems, and is a domain account. Account used for the installation is in the Administrators group on both local systems, and is a domain account. Have cancelled out of the install and rebooted both servers numerous times. Exact same error continues to occur. Cluster is active and all resources are owned by node #1 - the node where SQL Server Installation is being run. In the event viewer, I see: Event ID: 10 Description: The SQLBrowser service was unable to establish SQL instance and connectivity discovery". I am also seeing errors like: Source: SQLBrowser. The SQL configuration for SQL is inaccessible or invalid. Source: SQLBrowser. The Configuration of the AdminConnection\TCP protocol in the SQL instance xxxxxx i

How I can remove The Microsoft SQL Server 2008 Express installation manually.

How I can remove The Microsoft SQL Server 2008 Express installation manually ?   Other components uninstalled via Add/Remove but i cant remove SQL Server 2008 Express     From Add/Remove the following is installed:Microsoft SQL Server 2008   I have attempted to uninstall it via the Add/Remove method and this also failed.

SQL Server 2008 - Installation Woe - .NET Framework 3.5 SP1

On a Windows 2003 R2 x64 server, I have been unable to install SQL Server 2008 Enterprise Edition x64. When running setup.exe, I almost instantaneously receive the following Microsoft SQL Server Setup error:"Microsoft .NET Framework 3.5 installation has failed.SQL Server 2008 Setup requires .NET Framework to be installed."What does not make sense is that I successfully downloaded .NET Framework 3.5 from the Microsoft download site (published 8/11/2008) prior to the SQL Server 2008 installation attempt.http://www.microsoft.com/downloads/details.aspx?familyid=ab99342f-5d1a-413d-8319-81da479ab0d7&displaylang=enI do need to note that a few nights ago, prior to downloading the framework (3.5 SP1), I ran the SQL Server 2008 setup executable. I was prompted that in order to install SQL Server 2008, the setup program needed to first install .NET 3.5 SP1 and Windows Installer 4.5. I let the .NET 3.5 SP1 install run for about 1.5 to 2 hours and cancelled (now I wish I had just let it go).It is my understanding (correct me if I am wrong) that the SQL Server 2008 setup program initially checks for any pre-RTM versions of .NET 3.5 SP1 Framework. If one is found, it is then supposed to guide the user through both the installation of the .NET 3.5 SP1 Framework and Windows Installer 4.5. I have removed .NET 3.5 SP1 Framework (Add/Remove programs) and rebooted. However, upon runni

SQL Server 2008 installation fails There was an error generating the XML document. Error code 0x84B

My system config: window XP - SP3 4 GB RAM, I have VS2008 with SP1, VS2010 Ultimate installed First when I tried to install SQL 2008 R2 Dev edition I got an error saying vs2008 SP1 was not installed, infact I had the SP1 installed in my m/c.  I did reinstalled the SP1 and tried to install SQL again. while in the final installation process I got the error  "Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001." I uninstall the SQL server again to remove the files which were created from Unsuccessful installation I removed the register entry as suggested by this forum. reinstalled but no chance, I have tried all the option which I can get know in web. Please help me. here is the log files details  Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException 2010-08-26 14:54:53 Slp:     Message: 2010-08-26 14:54:53 Slp:         There was an error generating the XML document. 2010-08-26 14:54:53 Slp:     Stack: 2010-08-26 14:54:53 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache) 2010-08-26 14:54:53 Slp:   &nb

Error while installation of SQL Server

Got the below mentioned error while installing SQL Server 2005 Express Edition in my Windows XP PC. .NET Framework was successfully installed prior to starting installation of SQL Server 2005 Express. Details of error found in SQLSetup0002_<hostname>_Core.log :- Microsoft SQL Server 2005 Setup beginning at Sat Mar 20 12:56:16 2010Process ID      : 3704g:\2838850d59ac46e224\setup.exe Version: 2005.90.1399.0Running: LoadResourcesAction at: 2010/2/20 12:56:16Complete: LoadResourcesAction at: 2010/2/20 12:56:16, returned trueRunning: ParseBootstrapOptionsAction at: 2010/2/20 12:56:16Loaded DLL:g:\2838850d59ac46e224\xmlrw.dll Version:2.0.3604.0Complete: ParseBootstrapOptionsAction at: 2010/2/20 12:56:16, returned falseError: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:Could not parse command line due to datastore exception.  Source File Name: utillib\persisthelpers.cppCompiler Timestamp: Fri Jul 29 01:13:55 2005     Function Name: writeEncryptedStringSource Line Number: 124----------------------------------------------------------writeEncryptedString() failed   Source File Name: utillib\persisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005      Function Name: writeEncryptedString Source Line Number: 123

MSSQL 2008 R2: Change Server Collation Steps, with user DBs already of desired collation

On the default instance of SQL Server 2008 R2, I want to change the server collation from the usual US default SQL_Latin1_General_CP1_CI_AS to an application vendor's required collation, Latin1_General_BIN.  I understand that changing the server collation is essentially the same as changing the collation of databases master and model -- is that a fair statement? But my main question is, since there are user databases on the server that I would like to preserve, can I not simply detatch the user DBs prior to performing the server collation change, and then reattach?  The database collation of the user databases is already set to Latin1_General_BIN.  This article, Setting and Changing the Server Collation, at http://msdn.microsoft.com/en-us/library/ms179254.aspx says that to preserve the user databases, I should script all DB objects out, and bulk-copy all data out, because the DBs will have to be recreated and repopulated.  Can someone explain why I ought not simply detach and reattach the user DBs, given that they are already of the desired collation (i.e., the same collation that I will be changing the server collation to)? Your help much appreciated. -Tom

SQL Server 2008 R2 installation on a server which is in cluster

Hello, I want to install SQL Server 2008 R2 on a machine which is in a cluster. Is there any issue in doing this? Regards

Cannot install Sharepoint Server 2010 "A previous installation has been detected with a license type

I'm trying to upgrade to Team Foundation Server 2010 and Project Server 2010. After getting TFS 2010 and Project Server 2007 to work with WSS 3.0, I started upgrade to Project Server 2010 which requires update to Sharepoint Server 2010 Enterprise. I installed pre-requisites and run "stsadm -o preupgradecheck" which passed everything. When I tried to run the installation I get Setup Warning "A previous installation has been detected with a license type that does not match the install in progress". I thought that my trial licence for Project Server 2007 stopped this so I completely uninstalled WSS 3.0 and restarted the server but the installation still stops with Upgrade window. Any ideas? Regards    mjsk
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