.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

Easy install package vs MsSQL server 2008

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :ASP.Net
Is there anything i wont be able to do if i use SQL Server Express Database from the downlod install package offered on asp.net? Ive used MSSQL server 2008 and 2005, but to be honest i think it might be overkill cause im not very familiar with those applications. I just need the database for creating websites. Will i be able to remote connect to my webbhotel host and remotely modify the database on the remote server?Now i have a mess, i have installed both MsSQL 2005 and 2008 and im not even sure wich database is created with what. I would love to just have one simple setup, but im not sure if i can manage to migrate the databases to the new computer with this easy install package.The easy install package contains: ASP.NET and ASP.NET MVC Visual Studio 2010 Express Development Tool SQL Server Express DatabaseThanks for your time!

View Complete Post

More Related Resource Links

MSSQL Server 2008 Workgroups install to Win 7 - Compatibility issues

I attempted to install MSSQL Server 2008 Workgroups from the DVD to a Win 7 workstation.  Error "This Program has known compatibility issues.  The directions are to download the MSSQL Server Service Pack.  I downloaded SP 1 and SP 2.  Neither SP will install.  The DVD install also has a run option displayed along with the Compatibility message.  I select "Run" and it appeared to install, with Start\Programs\Microsoft SQL Server 2008\Configuration Tools\ SQL Server Installation Center 64bit.  However, running the 64bit installation process results in no change.  My question is how to install the MSSQL Server 2008 Workgroups on the Win 7 machine.  I would appreciate your thoughts.

MSSQL Server 2008 Workgroups install to Win 7 - Compatibility issues

The DVD install for MSSQL Server 2008 Workgroups to Win 7 fails due to known compatibility issues.  I asked for help in the Getting Started with SQL Server Forum and followed a recommendation to slipstream installation with SP1. I followed the procedures at http://blogs.msdn.com/b/joaol/archive/2009/03/20/how-to-install-sql-server-2008-with-sp1-built-in-slipstream-installation.aspx I then ran Setup.exe from the C:\SQLServer2008 folder.  It failed with the following .Net Framework error.  (I previously installed .Net Framework Version 4 which is required by the application needing SQL Server.)  Thanks for help. Microsoft.NET Framework Unhandled exception has occurred in your application.  If you click Continue, the application will ignore this error and attempt to continue.  If you click Quit, the application will close immediately. An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System. Version= PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\users\PC User\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thcltsvyyx\\user.config line 5). Details... See the end of this message for details o

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

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

SQL Server 2008 R2 Install on Vista

Hi folks, I am trying to install the 32 bit trial version of sql server 2008 R2 on my PC, which has windows vista premium. I launch the setup, I choose the install sql server 2008 R2 option, it goes through the first step, then i choose evaluation version and accept the terms, then get the window saying installing rules etc for the setup, hit the next button, nothing happens, I get the main setup window with all the options. The setup is not going through fully neither i get any error,,, what is the issue here, I have been trying to do this for the last couple of days. I have .net 3.5 framework SP1. Thank you RamdasRamdas

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 Install failure - Reporting Services Rule Failures

I'm installing SQL Server 2008 on Windows 7.  I'm going through the install and on the "Installation Rules" page I have two failures: Reporting Services Catalog Database File Existance Reporting Services Catalog Temporary Database File Existance Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation" Clicking the "Help" button tells me to "Rename, move, or delete the files" This is the only information I can find on this exact failure.  I'm not technical enough to know exactly where these files are or what they are named.  I cannot proceed any further without correcting this issue.  I'll include some of the shorter summary log files.  I can include other detail log files if that would help. Thank you so much for any help. Select Log Files: SUMMARY GLOBAL RULES LOG: Overall summary:   Final result:                  Passed   Exit code (Decimal):           0   Exit message:                  Passed   Start time:                &n

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  

Can't install SQL Server 2008 Enterprise on Windows 2008 Enterprise

A new fresh Windows 2008 installed and install all avaliable updates. Then install SQL server 2008, it firstly install some update too. Then reboot and run setup.exe again, it always give me the following message:Managed SQL Server Installer has stopped workingWhat's wrong with it? how to solve this issue?

named instance sql server 2008 install on cluster

I have a production two-node cluster with sql server 2008 sp1 cu7 running over windows server 2008 sp2. If I were to install a new named instance on this live environment, would it impair the default sql server instance functionality? I'm not referring to processor/io while the install is in progress. My question specifically is would the install process by its nature bring down the default instance. I'm pretty sure it won't, but don't see any documentation that would confirm this. thanks.

SQL Server 2008 Express impossible to install.

As part of ARCserve backup r15, SQL Server 2008 Express is to be installed on a windows 2003 sp2 server (french language). All the prerequistes are present (power shell, .NET 3.5, Windows Installer 4.5...). The install fails with an -2147024893 error. I have not found anything conclusive about this error on the net. To get down on the issue I tried to install sql 2008 Express SP1 manually first. It fails with no error, returning to the main installation screen after installing the support files. The SQLSetup.log shows no apparent error but stop abruptly with the following : "Attempting to launch process d:\23ab1738a0f035434457b033\x86\setup100.exe"... as if this attempt was "suspended in the air". I have already tried to uninstall/install .NET 3.5 SP1, PowerShell, Windows Installer 4.5. No previous version of SQL had never been existed on this server. I even run "caspol.exe /machine -reset". I have tried the installation with SQL 2008 Express in english... I made registry cleanups... It's been one week of investigation and for the first time in my career I'm "dry". Is my case desperate ? Thanks   ******************* I enclosed the summary.txt when it's ARCServe r15 which is installing. I notice that "requested action" is "RemoveNode". I suppose it's related to any cluster. But we have not any cluster on the

Location Error on Install on Virtual Server - SQL Server 2008 R2

I'm trying to install SQL Server 2008 R2 on a Xen Server running Server 2008 R2. I get the following error.   The disc has been used to successfully install on other machines in my office. The virtual machine location settings are also all United States English. Any thoughts?


I want to install  SQL REPORTING SERVICES and curretnly i have SQL SERVER 2008 R2 installed with SQL Management studio.

How to create a SSIS package to import records form SQl Server 2008 tables to text files

I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

SQL server 2008 failover cluster install

Hello all, Looking for the definitive answer with supporting documentation (link). Does a SQL server 2008 cluster have to be installed as or run as a domain service account or can local accounts be used?  I looked for a document that stated yes or no and could not find one. If anyone can provide info it would be much appreciated. Have all ready looked at these 2 links of interest. http://msdn.microsoft.com/en-us/library/ms143504.aspx#Service_SID http://technet.microsoft.com/en-us/library/cc731002(WS.10).aspx Thanks in advance,  

SQL*Server 2008 SP1 applied but still tries to download and install from Windows Update

I had previously posted this on the windows update forum and was advised here was more appropriate. I have installed SQL*Server Express 2008 on laptop with windows7 and appled the SP1 update. This shows as applied correctly when looking at programs/updates from control panel, update logs. The management console confirms version 10.1.2531 is running. Each time I use windows update  the service pack is listed as needing download / install - the same KB968369 is given as the reference. I have run this a couple of times but the update is shown as outstanding each time. Any ideas how to resolve this? Thanks Colin
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