a server of our customer has an adhoc ERP system (managed by another company) with database SQL Server 2005 Express and ArcServe (software for backup).
In the database SQL Server 2005 Express there are a pair of databases for the ERP and more than 20 db concerning the software of backup (CA ArcServe).
The customer and ERP company asked us to migrate the 2 db of ERP to version SQL 2008 Express R2.
I ask you if it was possible, on this server Windows 2003 R2, to create a new istance of SQL 2008 Express R2 maintaning actual istances of SQL 2005 Express used until now to avoid configurations problems of backup
software or if there are problems about this strategy.
View Complete Post
We are upgrading SQL server2005 Express to SQL Server 2008 R2. We want to replace 2005 Express with 2008 R2 on existing system. We have lots of questions about how to perform the upgrade safely and pull in our existing databases. The existing
database files are in C:\Program Files\Microsoft SQL Server\MSSQL.1. Also, we'll want to use the existing instance name to avoid having to reconfigure all of the installed clients at our user's workstations.
Should we uninstall the 2005 Express version first? Will that keep the existing databases on the system?
Will 2008 R2 use the same data folder or create a new one? If it uses the same folder will it automatically recognize our existing databases? If it creates a new one, I suppose we can use the migration Wizard.
Thanks for any help....
I want to install MS SQL 2005 Exp. edition in windows server. For that I had already downloaded the SP2 MS SQL 2005 exp. edition from Microsoft web site. I am geeting error while trying to install SQL: "The SQL service failed to strat . For more information
see the SQL server books online topics, "How to view SQL server 2005 setup log files and starting SQL server manually." Our Server configuration is windows 2008 R2 with 32 bit prcessor.
Before that i had install the same but SQL Server Management Studio icon is not showing, so I unstalled SQL and then trying to fresh installation.
Please help me to resolve this issues.
Thanks in advance.
When installing & configuring MOSS 2007 the default settings were choosen. So now when we try to access the SSMS I get a message "The evaluation period has expired. Please buy the product at the following url.". I do have a product key for SQL Server
2008 standard but when I am trying to perform a edition upgrade it doesn't detect the SQL Server Instance "OFFICESERVERS" so I am unable to upgrade the server. Because of the limitation in size we are unable to create new doc libraries or pages on the SP site.
Here are the details of the environment:
OS : Windows Server 2008 Standard SP1 64-bit
MOSS 2007 version : 184.108.40.20635, Current License : Office SharePoint Server with Enterprise Client Access License
Database : SQL Server 2005 Express SP1 32-bit
Does anyone know of any links on how to side by side install SQL 2008 Express edition on XP SP3 machine where there are instances of SQL 2005 Express edition already installed.
These 2005 Express instances are development databases and I must reduce any risks of screwing them up when I install 2008.
Hi people, I'm trying to install SQL Server 2005 or 2008 express, but I'm getting an error:
Error inesperado en el programa de instalacion de SQL Server. Para obtener mas informacion, revise el archivo de registro de resumen de la instalacion ... Summary.txt. (This is in spanish).
When I check the summary.txt file, it doesn't have any help, the content is:
Microsoft SQL Server 2005 9.00.4035.00
OS Version : Microsoft Windows XP Professional Service Pack 3 (Build 2600)
Time : Tue Apr 05 15:08:07 2011
What could the problem be?
Hello, I bet someone else already asked this but i couldnt find it. I have sql server 2005 installed which allows me to see sql agent task and so on but does not allow me to see compact 3.5 sql database files. I learned i need to install 2008 to open
these files. also i know i cant have sql 2008 and sql 2005 ssms installed at the same time. I am stuck between 2 things i need. Do i go 2008 express lose my ability to see sql agent or do I stay at sql 2005 and do not open compact 3.5 databases.
Is there an alternative to my dilemma?
I can't get my C# app to connect to the DB. I have tried numerous diff ways to connect. The DB is there, I can get to it thru sql server, just not from C#. I keep getting the following message -
Error accessing the database, a network-related or instance-specific error occurred while establishing a connection to sql server. The sever 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: sql network interfaces, error 26 - error locating server / instance specified.
All is on my home PC running XP Home Edition.
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)2- UserLT\SQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLT\SQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?
I have a series of Crystal Reports that I can view/edit using Visual Studio 2005 with no issues. The method I'm using is to simply click on the *.rpt file and it opens in the VS crystal editor with no issues. The problem I'm having is that we are upgrading to Visual Studio 2008, and when I open the *.rpt file in 2008 it opens as a binary file. I guess I'm used to everything else in Visual Studio prompting me to convert the older version to the newer version, so I'm not sure what to do in this case.
Is this normal? Is there an easy conversion method that I'm simply overlooking? Am I screwed? Who invented liquid soap, and why?
Answers to any of these questions would be greatly appreciated...
Hi and thanks.
I'm getting an error on serveral reports that I built in VWD2005 (express) using the reportviewer control. Trying to edit the rdlc file in VS2010, VS2010 asks if i want to convert the file to RDLC 2008 format and I click ok. When I build the site, I get this error (and of course also when the report is ran):
Error 1 The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. C:\inetpub\wwwroot\mastercardlcm\Reports\WorkLists\OpenSRStatus.rdlc 1
Here is my web.config concerning the RDLC assemblies, etc.
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=220.127.116.11, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
<add assembly="Microsoft.ReportViewer.WebForms, Version=18.104.22.168, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
I'm trying to embed a flv in my web page and I don't have a clue how to do it.
I downloded and installed ASPNetFlashVideo and the tools do not appear in my toolbox.
So if anyone has a work around it would be greatly appreciated.
I have several css style sheets I want to work with. I have copied them into the appropriate directory structure in my project. The styles are applied correctly.
But the manage CSS styles tool bar on the left margin doesn't seem to work correctly. At one point I had generated a style sheet and worked with it there, but now it not only can't find the one it generated, but the attach style sheet link doesn't respond at all, nor does anything in this bar. Same deadness with the CSS Properties bar. With or without a style sheet loaded in the editor -- a style sheet that is active in the project such that when I run it, the styles are applied.
VB version of studio, running on Vista home basic.
PS, the design mode works a lot better than the professional version I use in my day job on XP and server 2003.
Am in the process learning C#, My instructor uses Visual C# 2005 Express and on my side I have Visual Studio 2008 Pro.
Do you think it will affect me in my Coding practice due to the different IDE Versions? Wha do I have to heed when coding?