Migration From SQL 2000 Enterprise Server To The SQL 2005 Enterprise Server (64 Bit-Itanium Server)
We are migration few database from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server)
Problem :
- The performance difference observer was not much (Just 15-18%)
- The CPU Utilization goes to 100% immediately, when the software login screen appears and it sustains in between 90% to 100%
- Multi-User Access (3 or more concurrent users), the sql performance is tremendously slow.
Steps followed for Migration:
- We have used the backup and restore method to migrate the data from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server).
- We ran the DBCC DBREINDEX for each affected tables
- We executed the sp_updatestats procedure for all the tables
- Upgraded the DB compatibility version to 90
- Installed the SQL 2005 Enterprise Server (64 bit-Itanium Server) Service pack 2.
One thing that we observed, was the memory usage, on SQL 2000 the sqlservr.exe uses around 1.5 GB where as on the SQL 2005 its just 120 MB.
A normal select query on 2000 Server took 11-12 sec, having 10 lac records, and the same query on 2005 took 1 min (3-5 sec CPU process taken by sqlservr and rest by the Sever Management Studio.
The only differance noted was that on 2000 the entire data was displayed at one go where as in 2005 the data was displayed at the 1st sec, and was filling the rest in the buffer, and to finally display entire data it took 1 min.
Also
when we run this query
select * from sys.dm_os_sys_info
one column os_priority_class shows a value = 32 ? what does this means.
In the MSSQLSERVER SERVICES, properties, there is a parameter displaying value
Advanced > Running Under 64 bit OS = No ? what does this means.
Could anyone pls suggest as to how to increase the sqlservr.exe memory area, and also how the enhance the performance.
View Complete Forum Thread with Replies
Related Forum Messages:
Migration From Sql Server Express 2005 To Sql Server 2000 Enterprise
hi, i need some help here,i made a simple data driven website in my development PC, at first, i used MS Access for my data base then i migrate it to sql server express 2005, and it works fine when i try to run it in my development PC with my IIS. but of course i will be deploying it to a real server, in our office were i will deploy my data driven site, we have a PC server Win Server 2003 with SQL Server 2000 Enterprise (im not pretty sure by the name but i know its not a free version, its something like a 2000 sql version with a word enterprise at the end).so my question is, i am developing an ASPdotNET site originally used SQL server 2005 express,how can i migrate my site to the Win Server 2003 and my database from SQL Server 2005 express to SQL server 2000 enterprisewill it work?? if not, what are the possible solution that i can do in cases like mine?i used Visual Web Developer 2008 Express Ed. in making my sites, and its DOES NOT allow databases in SQL Server 2000!!!!!it says "can't recognize the database"i hope you can help me with this.Thanks-SALAMAT PO....=)
View Replies !
SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server. Questions: 1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server? 2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC. Any expected problems when running both 2000 and 2005 SQL Server at the same database server? 3. What is the best configuration for running SQL Server 2005 when we have old 2000 databases? Upgade or not upgrade? TIA, Jeffrey
View Replies !
Can SQL Server 2005 Express Edition Coexist With SQL Server 2000 Enterprise?
Not sure if this was posted but having a hard time finding an answer. I'm currently running sql server 2000 enterprise edition on my machine and was wondering what would happen if i installed 2005 express edition and vice versa? I've found many blogs and post about compatibility issues with the 2005 Express Beta version but couldn't find any news with full version. It would be much appreciated if someone can help me out with this problem. Thanks!
View Replies !
Problem To Install SQL Server 2005 Enterprise Edition 64 Bits On A Cluster With 4 Nodes, With Sql Server 2000 Already Installed
Hi i tray to install a new Virtual SQL Server independent for a SQL Server already installed and when the setup comes to install SQL Server Database commponets it fails, because tray to install on a drive that is not part of the new gruop resource. This is part of the log. MSI (s) (BC8) [11:26:43:107]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServicePrefixRS.9754C2F0_FC41_4ADF_9C17_1D45EA972478 property. Its value is 'SQLServer2005ReportServerUser$CIOSAN04$'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServicePrefixSSIS.9754C2F0_FC41_4ADF_9C17_1D45EA972478 property. Its value is 'SQLServer2005DTSUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServicePrefixRS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005ReportServerUser$CIOSAN04$'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServicePrefixSSIS.6080319C_1466_426E_9E7A_1DD555143E0A property. Its value is 'SQLServer2005DTSUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.2FC2D269_8625_4826_BB3F_F9059090CB38 property. Its value is 'CIOSAN04SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.03BE59F9_3DFA_413B_A99C_B95CA31A7BFE property. Its value is 'CIOSAN04SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupSQLBrowser.879C8BDB_884A_4C3C_80C3_3452EA2B8439 property. Its value is 'CIOSAN04SQLServer2005SQLBrowserUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupADHelper.4695FFBD_7951_480B_8B19_2D6E3E1CF9A6 property. Its value is 'SQLServer2005MSSQLServerADHelperUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupADHelper.4695FFBD_7951_480B_8B19_2D6E3E1CF9A6 property. Its value is 'CIOSAN04SQLServer2005MSSQLServerADHelperUser$CIOSAN04'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding InstanceRegKey.4695FFBD_7951_480B_8B19_2D6E3E1CF9A6 property. Its value is 'Microsoft SQL ServerMSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding DataInstanceTxt.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'S:CIOSQL02SQLSERVERMSSQL'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceNameSQL.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupAgent.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'SQLServer2005SQLAgentUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupAgent.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'CIOSAN04SQLServer2005SQLAgentUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceNameAgent.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'SQLSERVERAGENT'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceGroupAgent.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'SQLServer2005SQLAgentUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding QuotedServiceGroupAgent.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'CIOSAN04SQLServer2005SQLAgentUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding InstanceRegKey.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'Microsoft SQL ServerMSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding InstanceName.96E1321F_B7D1_4051_BEF1_FE74AC590F64 property. Its value is 'MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding ServiceNameAgent.0CAFB83E_07D8_4C80_B8EB_7596DC8C4D50 property. Its value is 'SQLSERVERAGENT'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding DataInstanceTxt.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'S:CIOSQL02SQLSERVERMSSQL'. MSI (s) (BC!88) [11:27:17:060]: PROPERTY CHANGE: Adding InstMap.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'MSSQLSERVER'. RegOpenKeyEx failed on Key(SoftwareMicrosoftMSSQLServerMSSQLServerParameters) with returncode 2 <Func Name='ReadSkuInfo'> <EndFunc Name='ReadSkuInfo' Return='0' GetLastError='0'> MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding checksum.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is '#x38393366666630656238326230343762313035313638323130306362396365633134666664643436343762663361653233323636643238323938326634653832666465333033616133633139386230643935613333396364616634336339353261666565393461643966373533636330323465656665336132653465626434616531643037616530646438376665653038303937336334366661333639356265383735363763663662636366333739383032633200'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding Namechecksum.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'Enterprise Edition (64-bit)'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding ServiceGroupSQL.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'SQLServer2005MSSQLUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding QuotedServiceGroupSQL.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'CIOSAN04SQLServer2005MSSQLUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding ServiceNameSQL.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding ServiceGroupFTS.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'SQLServer2005MSFTEUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding QuotedServiceGroupFTS.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'CIOSAN04SQLServer2005MSFTEUser$CIOSAN04$MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding InstId.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding InstanceName.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'MSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding InstanceRegKey.B2156BC9_6CE8_422F_A957_E99A65256B1D property. Its value is 'Microsoft SQL ServerMSSQLSERVER'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding ServiceNameSQL.443D542A_6987_46FB_A39B_41BB29B0D2C6 property. Its value is 'MSSQLSERVER'. <Func Name='GetSkuIt'> MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding checksum.CB2C9331_83B7_4803_97B5_442EFDC583D7 property. Its value is '**********'. MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding Namechecksum.CB2C9331_83B7_4803_97B5_442EFDC583D7 property. Its value is 'Enterprise Edition (64-bit)'. <Func Name='GetSkuIt'> MSI (s) (BC!88) [11:27:17:076]: PROPERTY CHANGE: Adding checksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C property. Its value is '#x38393366666630656238326230343762313035313638323130306362396365633134666664643436343762663361653233323636643238323938326634653832666465333033616133633139386230643935613333396364616634336339353261666565393461643966373533636330323465656665336132653465626434616531643037616530646438376665653038303937336334366661333639356265383735363763663662636366333739383032633200'.
View Replies !
Using MS SQL Server 2005 Enterprise Manager With MS SQL Server 2000
Hi Everyone,Most of our MS SQL Servers are still running on SQL 2000, but being Iwill soon be upgrading my workstation to Vista Business I'd like toinstall MS SQL 2005 Enterprise Manager to manage them all. When Itried to install MS SQL 2000 Enterprise Manager on Vista, it gave me amessage saying it's not compatible, so I'll have to use 2005 I guess.We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EMwork with these okay? Also I want to make sure SQL 2005 EnterpriseManager won't be adding to, changing, or 'upgrading' the DTS scripts oranything on the SQL 2000 servers as we still have folks using SQL 2000Enterprise Manager.Thanks for any suggestions. I'm always leery when using cross-versionsof Microsoft applications because they are often incompatible or theydo squirly things that often break stuff.Thanks --Alex
View Replies !
Problem Installing SQL Server 2005 Enterprise Edition On Windows Server 2003 Box
While attempting to install SQL Server 2005 Enterprise Edition on a Windows Server 2003 box, it is failing as follows... Microsoft SQL Server 2005 Setup beginning at Thu Sep 20 11:11:35 2007 Process ID : 5440 E:setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/8/20 11:11:35 Complete: LoadResourcesAction at: 2007/8/20 11:11:35, returned true Running: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35 Loaded DLL:E:xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Mon Jun 13 14:30:00 2005 Function Name: sqls::CryptSameUserSameMachine:rotectData Source Line Number: 50 2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5440"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2007/8/20 11:11:35 Complete: ValidateWinNTAction at: 2007/8/20 11:11:35, returned true Running: ValidateMinOSAction at: 2007/8/20 11:11:35 Complete: ValidateMinOSAction at: 2007/8/20 11:11:35, returned true Running: PerformSCCAction at: 2007/8/20 11:11:35 Complete: PerformSCCAction at: 2007/8/20 11:11:35, returned true Running: ActivateLoggingAction at: 2007/8/20 11:11:35 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00CFCFC8Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5440"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2 Any ideas? Thanks in advance.
View Replies !
Windows Server 2008 Enterprise && SQL Server 2005 Express Reporting Services
Does anyone know how to properly install SQL server 2005 express reporting services on windows server 2008. Whenever i try to access the report manager I get an error "Cannot access the remote server" even though the report server is on the local machine. I only have the web server role installed on the server. Im still quite a newbie at managing servers so please keep it as simple as possible. Thanks Matthew
View Replies !
Windows Server 2008 Enterprise && SQL Server 2005 Reporting Services
Does anyone know how to properly install SQL server 2005 express reporting services on windows server 2008. When ever i try to access the report manager I get an error "Cannot access the remote server" even though the report server is on the local machine. I only have the web server role installed on the server. Im still quite a newbie at managing servers so please keep it as simple as possible. Thanks Matthew
View Replies !
Upgrading SQL Server 2000 Standard To SQL Server 2000 Enterprise
I am currently running SQL Server 2000 Standard on my production system, and I am looking to upgrade the system to Windows 2000 Adv. Server. I would also like to upgrade SQL Server 2000 Standard to SQL Server 2000 Enterprise to utilize more than 2GB of memory. Can anyone tell me what is the best way to upgrade the system, and please provide some feedback on your experiences with the upgrade. Thanks in advance.
View Replies !
Failed To Install SQL Server 2005 Enterprise (x86) On One Server
Failed to install SQL Server 2005 Enterprise (x86) on one server I am trying to install SQL Server 2005 Enterprise on one of my test server. I am sure I entered the correct domain user name and password and the account is admin. I€™ve tried several times but I got this error instantly: The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." Some of the other component could be installed properly. The system was just rebuilt with only VSTS 2005 installed. Here is the part of the log €¦ MSI (s) (48:58) [06:04:54:365]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1]) MSI (s) (48:58) [06:04:54:365]: Executing op: CustomActionSchedule(Action=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********) MSI (s) (48:CC) [06:04:54:365]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIE56.tmp, Entrypoint: Do_sqlScript <Func Name='LaunchFunction'> Function=Do_sqlScript <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jul 12 06:04:54 2007 Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jul 12 06:04:54 2007 Unable to start service (1069) Error Code: 0x8007042d (1069) Windows Error Text: The service did not start due to a logon failure. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: sqls:ervice:tart Source Line Number: 316 €¦ Thanks - Andy
View Replies !
Creating A Server Instance On SQL Server 2005 Enterprise
I got sql 2000 installed on my machine. I got a sql 2000 database instance on my computer and I installed sql 2005 server enterprise but I have got no server instance from sql 2005 like what i have in sql 2000 when i first install, i can have an own server instance on my computer. is it becos when i have a previous sql 2000 server instance on my computer??
View Replies !
SQL Server 2000 Enterprise
I have an MSDN License from Microsoft and I am trying to install SQL 2000 enterprise edition to my XP laptop. I get an error stating that SQL is not compatable with this operating system. It is only offering to install the client tools. Can someone give me a heads up here and let me know what is going on, because I know I had this installed before. Thanks Curt
View Replies !
SQL Server 2000 Enterprise
I am having trouble with sql server timing out. I have the timeout set to maximum, and the query I am running is pretty simple. The data is about 10+ million lines, but It should not have a problem running queries on this. plus the timeout comes before the expiration of the timeout setting. The strange thing is, is that sometimes it will work if you just keep running the query. Has anyone run into this, and is there a fix? Also, sometimes if i link the table to an mdb and run the query through access, it will pull the results! what is that about?
View Replies !
Cannot Upgrade SQL Server 2005 Express To SP2 After Upgrading SQL Server 2005 Enterprise To SP2
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 Replies !
Problems Upgrading SQL Server 2005 X64 Evaluation To SQL Server 2005 X64 Enterprise
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 Replies !
Error In Ms Sql Server 2000 Enterprise
dear sir, i have got an error in ms SQL server 2000 enterprise....which is installed on a win2003 enterprise system.... SuperSocket info: (SpnRegister) : Error 1355. can you please tell me what it means?? regards,
View Replies !
Sql 2000 Server Enterprise Eval
Anywhere I can download sql 2000 server enterprise edition eval? I have a database running 2000 standard, wanted to test on 2000 enterprise to see if increased memory and enterprise edtion will help. With the intro of 2005, I can not find 2000 enterprise eval.
View Replies !
SQL Server 2000 Migration To SQL Server 2005 Collation Change - Method?
Scenario Recently moved a SQL2000 database to SQL2005. Collation on SQL 2000 database server was SQL_Latin1_General_CP1_CI_AS Colaltion on SQL 2005 database server is Latin1_General_CI_AS After restoring the SQL 2000 database on SQL 2005 we observed that the database collation was SQL_Latin1_General_CP1_CI_AS. We have altered the database collation to Latin1_General_CI_AS. We understand this will work for all new objects created on the database but existing objects (prior to the collation change) will continue to have the 'SQL_Latin1_General_CP1_CI_AS' collation. What is the best method to change the collation of the older columns to 'Latin1_General_CI_AS' - 1) Run ALTER TABLE ALTER COLUMN <colname> <datatype> COLLATE Latin1_General_CI_AS <nullability> on each varchar/char column or 2) For each table BCP out data DROP TABLE RECREATE TABLE (taking the new collation Latin1_General_CI_AS) BCP in data 3) Other methods? Thanks in advance David.
View Replies !
SQL Server 2000 Diagrams Without Enterprise Manager
Hi,I currently (for a hobby project) am unable to use SQL Server 2005, and rather am stuck with 2000. Since the way diagrams are handled changed, the tool for 2005 doesn't allow for the creation of diagrams when using it for 2000 (work sweet for everything else though!).I do not have access to a developer version of SQL Server 2000's tools, and thus no Enterprise Manager, leading me to my question: Are there any free utilities to replace this functionality? I don't have MS Access or Visio or anything like that unfortunately :(
View Replies !
Sql Server 2000 Enterprise Manager Crashing
I've installed the client tools on my notebook, and EM normally works properly. However, sometimes Enterprise Manager will crash on me for no obvious reason(it generates errors, but this takes forever, so i kill it). It is not consistent, nor can I reproduce the error, but it happens about once a day, never at the same time. Anyone else see this? My pc has win2K professional on it.
View Replies !
SQL Server 2000 Enterprise Manager Error
Hi Guys wondering if you can help me. Im having an issue with SQL Server Enterprise manager. I cannot access an MSDE DESKTOP SQL Server 2000 installation that is on the same machine as enterprise manager. I can access the MSDE Databae from another machine fine, but when I try to register that DB locally in Enterprise manager I get this error. PC007 - Data source name not found and no default driver specified. I had to install sqlserver 2000 using k=dbg and skip the MDAC install as it was giving me an install error but this shouldnt have mattered as I am running XP SP2 and it has MDAC 2.8 installed by default. Any Ideas?
View Replies !
How Can I Reinstall The Enterprise Manager? (SQL SERVER 2000)
I can€™t use the DTS editor because shows an error. So, I want to reinstall the enterprise manager without uninstall the sql server 2000, Is that possible? If the answer is yes, How can I do that? I think that reinstalling only the Enterprise Manager the DTS editor can be fixed. Sql Version: Sql Server 2000 SO: Windows 2003 Server Tanks in advance Ariel.
View Replies !
Registering SQL Server In SQL 2000 Enterprise Manager
When Trying to register a SQL Server using Windows Authentication, I get the following error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. When I edit the properties and make it SQL Authentication, it works fine. The SQL Server Service is starting up with a domain user account. If that makes any difference. Funny thing is, that my co-worker, can register the SQL Server in his Enterprise Manager using Windows Authentication. We are both Domain Admins and members of the servers local admin group. So, I'm not sure what to do now. I checked under Security, Logins...and neither of us are listed under there. Thanks
View Replies !
How Can I Reinstall The Enterprise Manager? (SQL SERVER 2000)
Something happened when the server fall down because of no disk space. Now everything is fine but I have a problem in de DTS (from the Enterprise Manager) editor, I can€™t run, modify and even make a new DTS. What can I do? Is it possible reinstall de DTS components without reinstall sqlserver 2000? Sql Version: sqlserver2000 Enterprise SO Version: Windows 2003 Server Thanks in advance Ariel.
View Replies !
Installing SLQ Server 2000 Enterprise Edition
Dear all, This is the first time using this forum, I hope I can get some help. I have started studying SLQ Server 2000 at home as I have a Video Tutorial but I thought I need to install SLQ Server 2000 to follow the training. I have been trying to instal SLQ Server 2000 Enterprise Edition on both Windows XP Pro Pack2 and Windows 2000 but I get this message saying "Microsoft SQL server 2000 enterprise edition server component is not supported on this operating system only client component will be available for installation " I do not know anything about SQL and I thought I must have been doing something wrong otherwise it would not give me the same warning on both operating systems. I do not know what is it I do wrong and I would appreciate your help and assistance. Thank you
View Replies !
2005 Standard To Enterprise Edition Migration ?
I installed SQL 2005 Standard edition on a failover cluster (Windows 2003). It is in production. Vendor wanted Enterprise Edition. What are my options to migrate to Enterprise? Is there an in-place way to do this, or is it a big deal? Vendor probably doesn't need Enterprise. It's a low volume OLTP application with small databases. No fancy stuff (other than the failover clustering). Vendor simply did not test his application on Standard so he says we need Enterprise. Nevertheless, Management will probably want me to make the change.
View Replies !
Pros/Cons Of Using Win 2003 Over Win 2000 For SQL Server Enterprise ?
We've recently got a new Server in.The server has 16Gb of RAM, 8 cpus etcWe now have a choice of sticking with Windows 2000 Advanced Server orgoing with Windows 2003 Enterprise edition.Besides being able to use more RAM and having to use Service pack 3ain Win 2003Any pros/cons of both ?Any recommendations ?We use Full text, replication, analysis services etcWhat issues / Enhancements has MS introduced for sp3A ?I know that once Service pack 3A is installed all full text indexesare automatically rebuilt..In a replication scenario Is it necessary or just a recommendationthat all participants in the replication scenario are using the sameservice pack ?Anything else to look out for ?
View Replies !
SLOW Connection To SQL Server 2000 From Enterprise Manager
I have had a problem with Enterprise Manager connecting to SQL Server. At first this problem was experienced with one particular network user... whichever PC he logged onto, Enterprise Manager took ages to connect to SQL Server and every operation was painfully slow. Creating a new Windows NT logon fixed the problem. I now have this same problem but only on my PC. It doesn't matter which Windows NT logon I use, using Enterprise Manager is painfully slow. I've tried creating a new Windows NT profile, checking the hard drive for errors, defragmenting the disk, reinstalling Enterprise Manager etc but nothing works. What is strange is that connections from VB applications on my PC are fast. It is only Enterprise Manager that is slow. I am using the latest service pack for SQL Server. I thought it could be a problem with the Enterprise Manager registry values but don't want to start messing with them! Has anyone else experienced this problem? Any advice would be great as I can't find any help from microsoft other than installing the latest service pack for SQL Server. Thanks
View Replies !
MMC Error When Staring Enterprise Manager In SQL Server 2000
Hello, Yesterday I was in SQL Server 2000 Enterprise Manager and it got hung up. I couldn't get out of it without rebooting my machine. When I tried to enter Enterprise Manager again, I got an error message "MMC Cannot Open The Selected File". So I completly shut down my machine and then started it back up, but still go the same message. I stopped the services and then rebooted again,but no luck either. Today, I still cannot open Enterprise Manager. Has anyone experienced this and worked through it? I am debating as to whether or not I should uninstall SQL Server 2000 and reinstall it? Any advice? Thanks Heather
View Replies !
Change Sql Server 2000 Enterprise To Standard Edition
Hi, One of our main servers running on SQL Server 2000 Enterprise edition which has transactional replications on it which replicates to other servers running on the SQL Server 2000 Enterprise edition as well. Due to Hardware problems the server is being migrated to a new machine but the client has installed SQL Server 2000 standard edition on the new machine. We will be using a two processor cpu with 4GB RAM and we are also not planning about clustering. Is there any problem if i migrate the server in Standard Edition will the replications work properly between Standard and Enterprise editions. What other complications can be there if i switch over to standard edition from enterprise edition Thanks in ADVANCE Jacx
View Replies !
MS SQL Server 2000 Enterprise Edition Installation Error
My laptop has VS 2005 installed. I am trying to install MS SQL Server 2000 Enterprise Edition, when i run "install database components", it gave error: "MS SQL Server 2000 Enterprise Edition component is not supported on this operating system. Only client components will be available for installation". then when i click on "ok", then "next", when i click on "next" on the "computer name" page, it gave another error: "A previous program installation created pending file operations on the installation moachine. You must restart the computer before running setup". I restarted my laptop following the instruction, but same thing happened when i run the installation. Plz help
View Replies !
Accessing Remote Sql Server 2000 ( Enterprise Manager Like Tool)
Hi all,I need to gain access to a remote SQL Server 2000 storing my data.The remote SQL machine can only be accessed via an internet connection,that is - it is not part of my network.I know Enterprise Manager can do the job, but EM only comes bundled inMS SQL Server, which is not installed on the client machine.Please let me know which other (preferably free) tools can performsuch remote access.Thanks,Gilad Haimov
View Replies !
Dual Instances In OnSQL Server 2000 Enterprise Manager
I am working on a site's SQL Server 2000 database on a W2k3 machine . I went into Enterprise Manager and saw that their database resides on a named instance. I did not see the default instance listed so I registered that using windows authentication. I noticed that the default instance had a user database that had the same name as the user database on the named instance that I was to work on. I looked at the properties of the databases and saw that on both the default and named instances of SQL Server that the Data Files and Log Files for the user database point to the same location. Is this a problem? Can anyone see any issues with this? Does this mean that someone can simply connect to the named or the default instance of the SQL Server and connect to the same database? Kirk
View Replies !
SQL Server 2005 Enterprise Edition
Working on some performance issues at the database end, our team observed, that the query execution done by SQL Server 2005 was done by using only one processor in our application. The stored procedures are written in T-SQL and have a dedicated Database Server, running SQL Server 2005. Our tests lead to the following observations; SQL Server 2005 Enterprise Edition was executing stored procedures using only 1 processor, when it is a multiple processor Server. Apart from this the stored procedure execution is very linear. We would like to have your suggestions on the same. Regards, Girish
View Replies !
|
TRACKER
