.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

Studying for MCTS - SQL Server 2008 DBA, need advise on best setup for home laptop.

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server

I have laptop with XP Professional 2002 SP3, 64 bit, 1,79GHz, 2.37g RAM.

I am wondering if doing a vmplayer virtural appliance with Windows Server 2003 R2 and evaluation edition of SQL Server 2008 Developer edition is the best setup.  It really is getting tedious with reinstalling everything every 30 days.  My school is not yet registered with DreamSpark.  I found the virtual labs and will go through those but I was wondering if there was a better setup to study with. 

Thanks for your time.

View Complete Post

More Related Resource Links

Error during SQL Server 2008 setup on windows 7 home premium



I have Windows 7 home Premium on 64 bit machine. I have installed Visual Studio 2008 sucessfully and SQL Server 2008 installer also shows "successful" installation. However when I try to login thru Sql mgmt Studio, I get error " No process is on the other end of the pipe". I checked SQL Server configuration and Named Pipes configuration, that seems all right. When I checked event log, it had following msg:

The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.

on googling, some of posts suggest to download .Net f/w 2.0 SP1. I downloaded the same from MS site, but on instllation, I get msg "this version is not supported on windows vista".

Please suggest any solution/workaround, i have been struggling with this for sometime now.

thanks in advance


SQL Server Express 2008 Setup fails. Support Rule "Restart Computer" Failed

Hi, I have been trying to install SQL Server Express for most of the day now without any luck.  Whatever I do setup fails at the stage of Setup Support Rules, Rule "Restart Computer" - Failed.  Needles to say I have restarted (several times!) and I have tried downloading  and installing the "Advanced", "Tools" and "Basic" versions, all give the same error.  Trying a repair does the same.  I have been searching the net for an answer without success, any help would be MUCH appreciated. Further info: I am trying to install a stand-alone installation on to a single PC running under XP SP 3 with .NET 3.5 SP1 installed.  The PC did have some earler versions of SQL server installed but I (?hopefully?) removed all of these through Control Panel.  Before trying the first SQL install I installed Windows installer 4.5 and PowerShell 1.0 as per the Microsoft Instructions. Running SQL Server Configuration Manager results in an error (MMC could not create the snap-in. The snap in might not have been installed correctly).  A directory structure for SQL server exists in "Program Files".  Services MSC shows SQL Server (SQLEXPRESS) as Automatic Statup (not running).  Trying to start this manually gives error 14001: "application configuration incorrect - re-install to fix" .......... Which is precisely what I'm trying to do.........:(

How to setup windows server 2008 to enable socket communication?

I wrote a simple socket program, which listens to the 82 port, then receives and sends data through it. I tested the program on my local machine and it works fine, but after I published the program onto my windows server 2008, it does not work anymore. I guess it should be the firewall causing the problem, so I added rules to allow 82 port for both in and out bound, and I also add my application to the allowed program list for passing firewall, but still doesn't work, how could I solve it?   The windows server 2008 machine has a public network IP address, while my workstation is in a local network without public IP address, I connect to server 2008 through a router which has a public IP address. Is that the problem?   thanks! Regards! directfriends.net

How to setup port forwarding for SharePoint server on home network

I have a SharePoint 2010 server running on my home network.  I want to be able to access the server from the internet and edit pages, create sites etc.  The web applications is running on a specific port (1234) not port 80. I've configured my router to forward port 1234 to the server's IP address and I can access the site fine from the internet using the routers IP address and adding the port number.  Viewing the site works fine but the problem is when I try to access a page in the _layouts folder for any of the sub sites I get a "File not found" error.  Also, if I go to a sub site and create a new site (no _layouts page required) it works but the new site is created directly under the root and not the sub site. It seems that the port forwarding from the router is messing up the context for the _layouts folder.  Is there any way around this? Thanks.

SQL Server 2008 Express Setup failure: Unknown Property Error

I am trying to install SQL server 2008 on windows 7 but it returns the following error when almost done with installation: TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: Unknown property. . ------------------------------ BUTTONS: OK ------------------------------   Can someone please assist me with this, I have tried for more than a week to go around it. I have also searched online for solutions but in vain. Looking into the log files, I see these: 2010-09-05 21:04:41 Slp: Running Action: Install_SqlBrowser_Cpu32_Action 2010-09-05 21:04:41 Slp: Target package: "C:\Softwares\Database and Management\SQLEXPRADV_x86_ENU\x86\setup\sqlbrowser.msi" 2010-09-05 21:04:46 Slp: InstallPackage: MsiInstallProduct returned the result code 0. 2010-09-05 21:04:46 Slp: RunMsiCore succeeded. 2010-09-05 21:04:46 Slp: Checkpoint: INSTALL_SQLBROWSER_CPU32_ACTION 2010-09-05 21:04:46 Slp: Completed Action: Install_SqlBrowser_Cpu32_Action, returned True 2010-09-05 21:04:46 Slp: ---------------------------------------------------------------------- 2010-09-05 21:04:46 Slp: Running Action: Install_SqlSqmShared_Cpu32_Action 2010-09-05 21:04:47 Slp: Error: Action "Install_SqlSqmShared_Cpu32_Action" threw an exception during execution. 2010-09-05 21:04:47 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExec

Testing setup of SQL Server 2008 R2 developer

The "Windows Package Manager" has the error "Operation failed with 0x80070643" and "Fatal error during installation." I have tried a few basic approaches to the installation problem, including downloading the ISO image to a different computer.  I have burned the ISO image onto four different DVDs using different media and two computers but only succeeded in verifying the burned media is Ok.  I have verified the SHA1 key with the two installation ISO images that were downloaded.  I have tried repairing the installation, but that generated a different kind of error message, "Error 1316.A network error occurred while attempting to read from the file E:\1033_ENU_LP\x64\setup\SSCERuntime_x86-enu.msi".  And then there is the "SQL Server 2008 R2 Setup has stopped working" message indicating "Windows is checking for a solution to the problem...". How fatal are the errors being encountered?  Is everything Ok?  How can I test that SQL Server 2008 R2 is fully functional?  T.69.72.

SQL Server 2008 R2 Express Bootstrapper Package for Setup Projects

Has anybody got a workaround for the issue mentioned here: https://connect.microsoft.com/SQLServer/feedback/details/560030/sql-server-express-2008-r2-bootstrapper-package?wa=wsignin1.0 ?    

SQL Server 2008 R2 Setup & Service Packs

Hello I installed SQL Server 2008 R2. (Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor) ) Are there any Service Packs for SQL Server 2008 R2 available i need to apply? Thanks V

Setup of SQL Server 2008: Restart required but I have restarted

Hello,I have tried to install SQL Server 2008. I cannot install, because I get the errormessage the prerequistite "Restart the computer is required".But every time I restart my computer and try to execute the setup of SQL Server 2008, I get the same message, I have to restart the computer.I cannot install the SQL Server 2008. What can I do?Thanks

Windows 7, SQL Server 2008 Express & VWD 2008 Express Setup Problems

Hi I have Windows 7 Home Premium, and Visual Web Developer Express 2008 (which came with SP1) installed. SQL Server 2008 Express never worked - Windows 7 won't allow the Management Studio to be installed and VWD was asking for SQL Server 2005.  Looking on the web, I found advice to try the 32 bit version of SQL Server instead.  This would work with VWD, apparently.  I referred to these instructions (http://download.microsoft.com/download/1/6/3/163A851B-D956-42E9-B426-F5C0EBE6B654/ReleaseNotes.htm) and used the latest links and instructions, but I could not install SQL Server at all - apparently something to do with WOW64... This has been going on for a WHILE and I'm going nuts.  I am reluctant to uninstall VWD and start again, because I had to manually fix a few things, and now it's working...  PLEASE can someone tell me of a working configuration, I have read SO MUCH advice on this, and none works, including those release notes (unless I missed something) :(

Installing SQL Server 2008 R2 Enterprise on Windows 7 - Setup Suport Files

The problem is when i try to install a new instance of SQL Server 2008 R2 Enterprise the wizard stops working when is trying to install Setup Support Files, and nothing happens. I cannot add the entire log file of the instalation, so i leave only the last lines. : ---------------------------------------------------------------------- 2010-09-10 11:46:24 Slp: Skipping Action: FinishPage 2010-09-10 11:46:24 Slp: Action is being skipped due to the following restrictions: 2010-09-10 11:46:24 Slp: Condition "Is the user's scenario set to EditionUpgrade" did not pass as it returned false and true was expected. 2010-09-10 11:46:24 Slp: ---------------------------------------------------------------------- 2010-09-10 11:46:24 Slp: Skipping property RequireMode of class: StopAction 2010-09-10 11:46:24 Slp: Input of property will not be set due to the following failed restriction(s): 2010-09-10 11:46:24 Slp: Condition "Is the user's scenario set to ComponentUpdate" did not pass as it returned true and false was expected. Can you help me?    

Installing SQL Server 2008 R2 Standard on Windows 7 - Setup Suport Files not start

    I try the SQL 2008 R2 Standard version, and know it works, on a clean machine with Windows 7. But in another machine a user has uninstall the old version of the SQL and after the step of install the Setup Support Files nothing happens. I had copy the log files that are on C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log I think that something on the uninstall of the old verion went wrong and this version cannot be installed. Can you help me?   Summary_Component UPdate Overall summary: Final result: Passed Exit code (Decimal): 0 Exit message: Passed Start time: 2010-09-14 15:22:09 End time: 2010-09-14 15:23:33 Requested action: ComponentUpdate Machine Properties: Machine name: PC1 Machine processor count: 2 OS version: Windows 7 OS service pack: OS region: United States OS language: Português OS architecture: x64 Process architecture: 64 Bit OS clustered: No Package properties: Description: SQL Server Database Services 2008 R2 ProductName: SQL Server 2008 R2 Type: RTM Version: 10 SPLevel: 0 Installation location: E:\x64\setup\ Installation edition: STANDARD User Input Settings: ACTION: ComponentUpdate CONFIGURATIONFILE: ENU: True FARMACCOUNT: <empty> FARMADMINPORT: 0 FARMPASSWORD: ***** HELP: False IACCEPTSQLSERVERLICENSETERMS: False INDICATEPROGRESS: False PASSPHRASE: ***** PID: ***** QUIET: False QUIETSIMPLE: False UIMODE: No

Error occurred while SQL Server 2008 R2 Setup

I already have sql server 2005 running on my computer (Win XP SP2) and I have been trying to install the Sql server 2008 R2 version. (I've downloaded in last week.)   While I'm installing, I got the following msg box : The following eror has occurred: The service did not respond to the start or control request in a timely fashion. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.   At that time, Installation progress show "ASConfigAction_install_postmsi_Cpu32". So I assumed something is wrong in SSAS installation.   I just click "Cancel" in the above msg box as I have no choice.   After completed, it show "Failed" in "Analysis Services".   Then I restarted my PC. When I try to start SSAS service manually, I got the following msg box.   The SQL Server Analysis Services (Instance_Name) service failed to start due to the following error:  Error 1053 : The service did not respond to the start or control request in a timely fashion.    Actually I just want to try CUBE in this version. (my deadline is coming friday.)  :(   Please advise & thanks in advance.

SQL Server 2008 R2 Setup fails to install properly


Hello, I am not able to install 2008 R2 on my laptop. I have 2005 and 2008 installed previously. It says in one of the attached screenshots that the OLAP service cannot be started. I have attached the errors in screenshots and also my summary log, please advise thank you.

Edit: I am able to manually startup the SQL 2008 R2 service, and can login as "sa" without a password... but strangely I did select mix mode authentication and did supply a password during the installation wizard too..


Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the

reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server

  Exit code (Decimal):           -733426222
  Exit facility code:         &nbs

SQL Server 2008 R2 Installation Problem - The language ENU is not supported by this setup package.


I am trying to install SQL Server 2008 Standard R2 on a Windows Server 2008 R2 64bits machine (all updates applied)... 

I run the setup.exe on the command line and I get the following error :

The language ENU is not supported by this setup package.
An error occurred during the SQL Server 2008 R2 Setup operation.

Error result: -2067529698
Result facility code: 1220
Result error code: 30

For more information, review SQL Server 2008 R2 Setup logs in your temp folder.

There is no log generated.

My regional settings + locale are all English-US

Any ideas?



Setup Remote IIS server for Visual studio 2008


I tried to setup the remote web server (IIS6.0) for visual studio 2008 . I get the following error. Can you please somebody help me?

Thank you in advance.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'System.Web.Extensions, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Assembly Load Trace: The following information can be helpful to determine why t

SQL Server 2008 R2 Setup: How to set Collation during interactive setup?



Did I miss something when running SQL 2008 R2 Setup.exe on Win2008 Server R2?  I did not notice my opportunity to set the server collation to something other than my regional default.  Was it on a tab that I missed?

Are my choices either (a) set collation at the OS level through Control Panel...Regional...Advanced, or (b) run setup.exe at the command prompt while specifying the desired server collation?  Because I get that impression from reading this: http://msdn.microsoft.com/en-us/library/ms144260.aspx

Have I read that correctly?




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