Upgrading To Sql Server 2005: A Many-headed Hydra
Nov 14, 2007
What are the pro's and con's of these Sql Server 2005 Editions:
WorkGroupStandard
I am having to choose between the two for upgrade, and would be interested to know what your experience would tell me. Though it would be entertaining to go with the victor of a google fight(http://googlefight.com/index.php?lang=en_GB&word1=sql+server+2005+workgroup&word2=sql+server+2005+standard), I should probably be responsible about this.
Thanks,
Jason Knight
Developer
View 1 Replies
ADVERTISEMENT
Mar 4, 2006
Hello,
Thanks for reviewing my question. I have installed VisualStudio 2005 on a computer and would like to know if I can install SQL 2005 Server and replace the SQL Express version? Will VS recognize it?
Many Thanks to the Experts
Peter
View 2 Replies
View Related
Feb 18, 2008
How do I upgrade Sql Server 2005 Express to SP2 if I also have SQL Server 2005 Enterprise SP2 already on the same box? I installed Sql Server 2005 Enterprise first, then applied SP2, then installed Visual Studio 2008 (which installed SQL Server 2005 Express).
When I try to upgrade Sql Server 2005 Express to SP2 using the special Express edition of SP2, I get an error message that says "None of the selected features can be installed". I end up having to cancel the install of SP2.
I'm left with SQL Server 2005 at level 9.0.3054 and SQL Server 2005 Express at 9.0.3042. How can I bring SQL Server Express 2005 to the same level as SQL Server 2005 Entperprise?
View 2 Replies
View Related
Mar 29, 2007
Hello!! How can I upgrade from SQL Server 2005 Express Edition to SQL Server 2005 Enterprise Edition? I see allot of example of upgrading from SQL Server 2000 to SQL Server 2005, but no example on upgrading from SQL Server 2005 Express to SQL Server 2005 Enterprise or Standard. Is this possible?
View 6 Replies
View Related
Oct 25, 2007
I first tried installing the DVD and of course it told me I must use the command prompt installation method to include the line SKUUPGRADE=1. I found good references to this in the following links:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2208593&SiteID=1
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Below is the command I issued at the command prompt:
start /wait d:serverssetupsetup.exe ADDLOCAL=ALL INSTANCENAME=URHCS63SQL2005DSS UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
My servername is URHCS63 and my instance is SQL2005DSS.
When I execute this command, a installation dialog box opens briefly and then disappears and nothing else happens. Here are the results of the bootstrap log file:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Time : Thu Oct 25 16:17:48 2007
URHCS63 : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
SQL Server Setup was interrupted. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Thu Oct 25 16:20:08 2007
Any ideas on why this is not working for me?
View 9 Replies
View Related
Feb 6, 2007
Hello All,
I'm running Windows XP SP2 and I had SQL Server 2005 running on my box. I needed to run the SP1 upgrade but it doesn't seem to work. I ran Windows Update and the list showed I need to install SP1 and it looked like it ran fine but when I checked the version after the upgrade it hadn't upgraded to .2047. I went back to Windows Update and it said I still needed SP1. So I tried downloading SP1 and running it myself still no luck. So then I decided to uninstall SQL Server 2005 completely, reinstall it and try the SP1 again (using Windows Update) and nothing in fact I'm now getting the error...
"Error Code: 0x2BC4"
...which I haven't been able to find anything on. Does ANYONE have any ideas on what might be happening?
Thanks in advance for any help.
Mike
View 3 Replies
View Related
Jun 28, 2007
Hello,
I have a new HP ProLiant ML115 Server with the "Windows Server 2003" operating system. I will be upgrading from SQL Express 2005 to SQL Server 2005 and I wanted to know will the upgrade run smoothly and what are the necessary, if any, measures I may need to take before and/or after I upgrade to ensure that all my databases and files are carried over?
View 1 Replies
View Related
Oct 10, 2005
A lot of vs.net 2005 documentation talks about how asp.net 2.0 developers can easily build web apps using SQLX and then easily upgrade to SQL Server 2005 when we go to production.Can someone point me to the details? How exactly do I take an .MDF file from my development environment and ??import/attach/restore?? it too a full blown SQL Server 2005.TIA,g
View 1 Replies
View Related
Oct 11, 2006
Hello, everyone:
Currently our system is .NET workframe 1.1 / Visual.NET 2003 plus SQL Server 2000. The developer will upgrade to .NET workframe 2.2. Should I have to update database to SQL Server 2005? And some reasons please.
Thanks
ZYT
View 1 Replies
View Related
Aug 19, 2007
I have upgraded my server from SQL Server 2000 to SQL Server 2005. After upgrading, I noticed that an important option in a specific application isn't working, giving a generic error message ("Cannot update the database").
Using SQL Profiler, I found that the query that fails includes the expression:
Code Snippet
DateAdd(DateInteval.Day, ..., ...)
And the error message is: "'DateInterval.Day' is not a recognized dateadd option".
This query:
Code Snippet
SELECT DateAdd(DateInterval.Day, 2, getdate())
Works on SQL Server 2000 servers, while failing on SQL Server 2005 servers, with the same error message as above.
However, this query:
Code Snippet
SELECT DateAdd(Day, 2, getdate())
Works on both SQL Server 2000 servers and SQL Server 2005 servers.
I searched for documentation of this problem, and couldn't find any.
The code for the original application is lost, so changing it is impossible.
Any help or guidance would be appreciated.
View 8 Replies
View Related
Nov 29, 2006
I restored a 2000 database back up in to my 2005 database and it works fine. THe only problem is that I cannot create diagrams.
I get the following message:
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
I have checked the db_owner and that is a valid owner.
I changed a few times to different owners and still could not install the diagrams..
Any ideas?
thanks
View 1 Replies
View Related
May 9, 2006
I have to upgrade and move SQL Server 2000 databases from a platform using Server 2000 to one running SQL Server 2005. The server nameinstances will need to be the same so that a number of third party applications and front end systems that connect, and are outside of my control, will not need any data source changes. The servers will be on the same network and can't co-exist with the same name so I guess that I have to go "big bang".
Does anyone have any suggestions for a strategy that I can use?
Does anyone know of any issues that I should be aware of?
I have run the SQL Server 2005 Upgrade Advisor and it tells me the databases should upgrade OK with a few minor issues that can be fixed after.
Thanks,
View 1 Replies
View Related
Feb 15, 2007
I had a SQL2000 DB Server with a simple database. I did an "in place" upgrade to SQL2005 expecting the DB Server and databases to upgrade. However, now when I run SQL Server Management Studio and enter the query:-
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
I get the answer:-
8.00.2039 SP4 Enterprise Edition
Why didn't it upgrade? And how do I upgrade it now? I'm very confused!
View 4 Replies
View Related
May 16, 2007
Hi I currently have this edition of SQL server on my laptop:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
It is running on SQL Server Management Studio 2005.
I wish to upgrdade to Developer Edition (as my laptop won't support Enterprise as it's running on Windows XP).
I have some questions, which I would be grateful if somebody could help answering:
1- will all my database remain as they are?
2- Will I loose any functionality?
3- Will it upgrade or intstall a separate edition?
4- Can anybody recommend where to purchase Developer 2005 edition?
5- I currently have 2gb capped database limit on my version, will I get a no capped limit?
6- Will the 2gb Capped limit increase to uncapped once I install (i.e. can i use my previous 2gb database and add more data to above 2 gb)
The main issues are that I need an uncapped limit for my DB's and that I will keep my existing db's.
Many thanks!!!!!
View 2 Replies
View Related
Dec 23, 2007
Hello all,
I'm finding the documentation online to upgrading from 2000 to 2005 fairly poor.
What are the upgrading options and which one is the best option for a web server database.
Also what are best practices pre-upgrade, during upgrade and post-upgrade.
Cannot find much online.
Also since this question will be asked often might as well make it a sticky.
Thanks
View 3 Replies
View Related
Oct 15, 2007
Hello
I'm trying to upgrade a Microsoft SQL 2000 (8.00.760 SP3) server to SQL 2005.
It€™s a standard install, std version, not very big databases, default instance, plenty of memory etc. OS is a 2003 server recently upgraded from 2000. All patches etc are installed.
Upgrade was going fine and had got approx 90% through, had started the 2005 db service and converted the databases before it got the following error:
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Invalid connection string attribute Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
The 'For help' link returned the helpful... €˜We are sorry but we can€™t help€™...
Worked through http://msdn2.microsoft.com/en-us/library/ms143698.aspx but not 100% applicable and didn€™t resolve.
Partially rolled back, rebooted and resumed install but failed in the same place. Ended going back to a backup snapshot so is now back running as SQL 2000.
Excerpt from install log is below...
Thanks in advance for any assistance.
<Finished SQL statement: Wed Oct 10 21:25:21 2007>
<Started SQL statement: Wed Oct 10 21:25:21 2007> BEGIN DECLARE @GroupName AS nvarchar(4000) SET @GroupName = QUOTENAME(N'PROPMAN-DATASQLServer2005MSFTEUser$PROPMAN-DATA$MSSQLSERVER') EXECUTE(N'grant execute on sp_fulltext_getdata to ' + @GroupName) END
<Finished SQL statement: Wed Oct 10 21:25:22 2007>
Service MSSQLSERVER is being stopped at Wed Oct 10 21:25:22 2007
Service MSSQLSERVER with parameters '' is being started at Wed Oct 10 21:25:34 2007
Attempt to start service when it is already running
SQL service MSSQLSERVER started successfully waiting for SQL service to accept client connections
Service MSSQLSERVER started at Wed Oct 10 21:25:40 2007
<EndServerDowntime Wed Oct 10 21:25:40 2007>
Loaded DLL:
C:WINNTsystem32Odbc32.dll
Version:
3.526.3959.0
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=01S00, level=-1, state=-1, native_error=0, msg=[Microsoft][SQL Native Client]Invalid connection string attribute
Error Code: 0x8007ea62 (60002)
Windows Error Text: Source File Name: libodbc_connection.cpp
Compiler Timestamp: Fri Jul 29 01:13:53 2005
Function Name: OdbcConnection::connect@upgradeconnect
Source Line Number: 148
---- Context -----------------------------------------------
sqls:equenceInstaller::launchAction
Staring action SqlScript
SqlUpgradeScriptHlpr
Connecting to SQL Server
ExecuteUpgradeSqlCommands
sqlConnect
Originial error was 8007ea62 (60002)
Error Code: 60002
MSI (s) (5C!20) [21:26:20:164]: PROPERTY CHANGE: Adding SqlUpgradeMessage property. Its value is 'SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Invalid connection string attribute Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.'.
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Invalid connection string attribute Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Loaded DLL:
C:WINNTsystem32Odbc32.dll
Version:
3.526.3959.0
SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=01S00, level=-1, state=-1, native_error=0, msg=[Microsoft][SQL Native Client]Invalid connection string attribute
Error Code: 0x8007ea62 (60002)
Windows Error Text: Source File Name: libodbc_connection.cpp
Compiler Timestamp: Fri Jul 29 01:13:53 2005
Function Name: OdbcConnection::connect@upgradeconnect
Source Line Number: 148
---- Context -----------------------------------------------
View 1 Replies
View Related
Jan 3, 2008
Help please...
We have developed a system for a medium size company in NYC using SQL Server 2000.
We are about to go live and thought it may be a good idea to upgrade first from SQL Server 2000 to 2005.
I believe standard edition would be sufficient but I am not 100% sure... There isn't a whole lot of data but high availability is crucial. I was thinking of a 2-node fail over cluster setup and/or mirroring.
We need only one instance of SQL Server with about 30 client machines accessing the same databases.
Any thoughts/comments as far as:
Standard or Enterprise?
What type of licensing? Support agreement?
What about the best setup for highest availability? (fail over cluster vs. mirroring vs. replication)
Thanks,
Toshu.
View 1 Replies
View Related
Aug 6, 2007
Hello,
at the moment I have the following problem:
We have installed a version of the MSDE 2000 Sp3 with our software since 2005. Now we install SQL Server Express 2005 in order to use the latest version and to be compatible with Vista.
We have never had any problems with the MSDE, so it was no problem that we installed the german version (by mistake) because there never was any output at installation time.
When we now upgrade the existing MSDE installing the new version of our software, there are often problems and there are error messages, unfortunately in german, which cannot be read by most of our international users.
The problem is, that there seems to be no possibility to upgrade the existing (german) MSDE with the english version of SQL Server Express 2005.
My question is, if it is possible to upgrade the german MSDE to the english SQL Server 2005 to enable our international users to read the error messages at installation time in english?
Thanks in advance.
Best regards,
Peter
View 4 Replies
View Related
Nov 7, 2005
has anybody tried to do that yet? any experiences? how-tos?
View 3 Replies
View Related
Sep 6, 2006
I recently upgraded from SQL Server 2000 to SQL Server 2005. I have Oracle databases I need to share data with. I was using the Heterogeneous Services (hsodbc) from Oracle and connected to SS 2000 fine. Since I've upgraded, I can't use hsodbc to connect to my SS 2005 database. I get the following error:
ORACLE GENERIC GATEWAY Log File Started at 2006-09-06T09:40:07
hoainit (3): ; hoainit Exited with retcode = 0.
hoalgon (7): ; hoalgon Entered. name = edw.
DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL Server]Login
failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)
DRV_InitTdp: DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL
Server]Login failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)
nvRETURN (F:WorkConnect_4_6_3srcdrvDRV_BIND.C 356): -2220
nvRETURN (F:WorkConnect_4_6_3srcavNAV_BIND.C 293): -2220
hoalgon (7): ; hoalgon Exited with retcode = 28500.
View 6 Replies
View Related
Sep 13, 2007
My upgrade of SQL Server 2000 to SQL Server 2005 is being blocked as follows:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding
FTCATALOGPATH
DEPRECATEDSP
FTCATALOGNAMERESTRICTION
FTNONPERSISTEDCOMPCOL
Many thanks
JMX
View 3 Replies
View Related
Apr 26, 2006
Hi - quick question.
I wanted to upgrade pre-release version of SQL Express to the latest version, and wanted to make sure that none of the database information would be lost. The thing that concerns me is that it states to uninstall previous versions of SQL Server 2005 Express before installing the latest version. I threw the database tables into a backup directory, and I think this should be fine, but I want to be sure. Let me know. Thanks!
View 4 Replies
View Related
Mar 6, 2007
Hi,
We just upgraded 2 sql servers from sql server 2000 sp3a to sql server 2005 build 2153, and merge rep exists between these 2 servers.
However, after sql server upgrade, we had to reinitialize merge replication and now the merge agent is reporting 2 errors
1)
Error messages:
The Merge Agent failed to upgrade triggers, metadata and stored procedures on the Subscriber to versions compatible with SQL Server 2005. Restart synchronization, and if this failure continues to occur reinitialize the subscription. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199403)
Get help: http://help/MSSQL_REPL-2147199403
Invalid column name 'metadata_select_proc'. (Source: MSSQLServer, Error number: 207)
Get help: http://help/207
Invalid column name 'delete_proc'. (Source: MSSQLServer, Error number: 207)
Get help: http://help/207
2)
Command attempted:
{call sp_MSensure_single_instance (N'Merge Agent Name', 4)}
Error messages:
The merge process could not connect to the Publisher 'Server:database'. Check to ensure that the server is running. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199368)
Get help: http://help/MSSQL_REPL-2147199368
Another merge agent for the subscription(s) is running or the server is working on a previous request by the same agent. (Source: MSSQLServer, Error number: 21036)
Get help: http://help/21036
looking inside the sp_MSensure_single_instance stored procedure, it's trying to obtain an exclusive lock on resource 'Merge Agent Name' but fails and returns -1
this is the stored procedure executed by sp_MSensure_single_instance and @retcode = -1 and thus cannot obtain exclusive lock on resource
EXEC @retcode = sys.sp_getapplock @Resource = 'Merge Agent Name',
@LockMode = 'Exclusive',
@LockOwner = 'Session',
@LockTimeout = 0,
@DbPrincipal = 'MSmerge_PAL_role'
so i think it's failing because for some reason MSmerge_PAL_role database role does not have enough rights to obtain exclusive lock on necessary resources
i've tried many things to fix this, including scripting out and dropping all merge rep, turning off replication db option and reapplying replication create scripts on the server, and even manually deleting the MSmerge_PAL_role database role but still doesn't work
can anyone help?
Thanks
View 9 Replies
View Related
Jun 28, 2007
Hi,
I just upgraded to SQL server 2005 and some of my Openrowset to Oracle doesnt work. I found out that the issue occur with field with structure Numeric.
The issue is not solve even when I try to cast the field to varchar. sometimes it succeeded and sometimes I get error 7320 & 7321.
I'm using Oracle connector from SQL to Oracle.
I've 64 bit SQL Server.
Attach the code, the Numeric field is SCORE.
select *
FROM
OPENROWSET('ORAOLEDB.ORACLE',aaaa;bbbb;cccc,
'SELECT AUDIT_OPRID, AUDIT_STAMP, AUDIT_ACTN,EMPLID, ACCOMPLISHMENT, MAJOR_CODE,
CAST(SCORE AS Varchar(250))
FROM SYSADM.PS_RTA_ACCOMPLISHM WHERE 1=2')
Anyone can advice on resolution?
Thanks,
Assaf
View 6 Replies
View Related
Mar 14, 2007
Hello all.
I upgraded a SQL 2000 installation to SQL 2005 this past weekend. Minimal issues overall, but one that did crop up relates to a linked server to an Oracle database. The linked server worked before the upgrade, and stopped working immediately after.
We're running on Windows 2003 x64, latest service pack. The linked server is set up using the MSDAORA provider. The error I'm getting post-upgrade is:
=====================
OLE DB provider "MSDAORA" for linked server "PROD" returned message "ORA-06413: Connection not open.".
Msg 7303, Level 16, State 1, Procedure RDM_GET_REP_LIST_SP, Line 12
Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "PROD".
=====================
A tnsping from the server works fine. I've also tried recreating the linked server. Any help would be appreciated. Let me know what other information would be useful.
Thanks,
Adam
View 3 Replies
View Related
Jun 6, 2006
Hello, you all,
I did all the stuff necessary for the upgrading (the Upgrade Advisor didn't say anything special), but the Setup says the following:
"
Name: Microsoft SQL Server 7.00.1063
Cause: The update is blocked. You can obtain more informations in the online help "Versions- and editionsupdates".
Editions problem:
The update is blocked because of rules for the editions update.
"
Is it possible that an upgrade is not possible with the evaluation edition? Or can there be another cause?
Thanks in advance
Oliver
View 4 Replies
View Related
May 15, 2007
I have attached the SAN, configured the Windows Clustering and I'm ready for SQL. SQL Server 2005 was already on this machine as a stand alone. I removed all of the software and I'm reinstalling SQL. The cluster option is not enabled. Any ideas why?
View 1 Replies
View Related
Aug 8, 2007
I don't have any idea about upgrading databases.I am been given this task.
It would be great if you let me know what are all the things to be considered upgrading the sql server 2000 databases to sql server 2005.
Please let me know
Thanks
View 1 Replies
View Related
Oct 4, 2006
If i have been using sql server 2005 express for developing my application and i decide to upgrade to sql server 2005 express with advanced services while still working on the same application, what will happen to my application's database. Can i be able to continue with my work with out any major regrets.
View 1 Replies
View Related
Feb 2, 2006
Is it just me, or are features missing in Management Studio? I mean, where is the "Export Objects" option when exporting data? Why is it so difficult to register a remote server? Why do the object views suck? And most important, why is the documentation the worst software documentation I have EVER SEEN?!
Things that were easy in Enterprise Manager with Client Network Utility and Query Analyzer seem impossible, difficult, or maybe just hidden in Management Studio. If it is there, the documentation sure doesnt tell you how to find it.
Please someone tell me that it's just me. Tell me that the features are there but Im not doing something right. I feel like putting my head in between my door opening and banging the door against it.
View 2 Replies
View Related
Jun 27, 2006
I upgraded a MS SQL 2005 Enterprise Evaluation/Trial to MS SQL 2005 Standard Edition with 5 User CAL.
I used the following command to upgrade:
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 PIDKEY=<mykey> /qb
Once complete, "select SERVERPROPERTY('LicenseType')" returns DISABLED, but I expected that it would return PER_SEAT.
Thankfully, after the upgrade it does show EDITION=Standard Edition.
Questions:
1. How do I verify the license installed is the Client Access License of 5?
-- SQL Server 2005 does not seem to have the same SQL Licence control panel as did SQL 2000. It is not listed under Control Panel -> Licensing (only thing listed is 'Windows Server') nor under Administrator Tools -> Licensing.
2. How do you add CALs or change license type in SQL 2005?
-- I was also puzzled that I was not asked during setup of the license mode and/or number of licenses ( I did not get this on a fresh install of SQL 2005 SE either ).
Thanks for any assistance you can provide.
Ajay
View 3 Replies
View Related
Nov 17, 2015
I have reports developed in SQL Server 2005 (.rdl file) and using report viewer in my ASPX page.Now we have upgraded SQL Server 2005 to 2012, how I can use exsisting .rdl file or what change I need to do.
View 7 Replies
View Related
Jan 3, 2007
I just received my licensed disks for upgrading my SQL Server 2005 Evaluation version to a fully licensed version. Do I simply run the two disks over top of the evaluation version or is it a little bit more complicated? Any input would be greatly appreciated. A little new to SQL.
Thanx
Chad
View 1 Replies
View Related
