I have to make a new installation of an MS SQL 2000 EE on a Windows 2003 Std. Edt.
HW: --------------------- Dual Xeon 2,4 + 1 GB Ecc 1 x 32 MB Adaptec 2100S RAID Controller 2 x 18 GB 10K HD 4 x 18 GB 15K HD ---------------------
So far I have made following configuration.... --------------------- 2 x 18 GB 10K HD / RAID 1 - C:OS - D:MSSQL program files + System DB's (Master, pubs ect.)
4 x 18 GB 15K HD / RAID 5 - E:TempDB - F:Data + Logs --------------------- But I'm not sure that this is the optimal configuration, and I'm willing to start all over :)
So my q's are....... -------------------- Which RAID configuration would you suggest? Which partitions on the raids would you suggest? Which usage would you assign the various partitions? How do I move the system and temp db's? --------------------
i have the same problem with dotnetnuke installtion in 2003 server sp 1 that it can't connect with the database the message below is appearing in my url:
Error Installing DotNetNuke Current Assembly Version: 04.03.04 ERROR: Could not connect to database specified in connectionString for SqlDataProvider even i uninstall the sql server 2000 but still this problem came . on the other hand i installed it to windows Xp it works there. i dont know what to do and here is my connection string:
<connectionStrings> <!-- Connection String for SQL Server 2005 Express --> <add name="SiteSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" /> <!-- Connection String for SQL Server 2000/2005 <add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" /> --> </connectionStrings> can anyone help me !
Hi, I've a problem to install SQL Server Express 2005 on Win 2003 SP1. Do you know how to solve the problem ??
It displays error message after I click the setup file:
SQL Server Setup unexpetedly failed. For more information, review the Setup summary log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt
Then I open the Summary.txt, it contains:
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 1 (Build 3790) Time : Thu Sep 21 11:17:18 2006
And review the SQLSetup0001_PCNAME_Core.txt in the Log Files directory:
Microsoft SQL Server 2005 Setup beginning at Thu Sep 21 11:17:18 2006 Process ID : 688 D:MasterSQLExpress2005setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/8/21 11:17:18 Complete: LoadResourcesAction at: 2006/8/21 11:17:18, returned true Running: ParseBootstrapOptionsAction at: 2006/8/21 11:17:18 Loaded DLL:D:MasterSQLExpress2005xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2006/8/21 11:17:18, 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::ProtectData 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", "", "688"} 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: 2006/8/21 11:17:18 Complete: ValidateWinNTAction at: 2006/8/21 11:17:18, returned true Running: ValidateMinOSAction at: 2006/8/21 11:17:18 Complete: ValidateMinOSAction at: 2006/8/21 11:17:18, returned true Running: PerformSCCAction at: 2006/8/21 11:17:18 Complete: PerformSCCAction at: 2006/8/21 11:17:18, returned true Running: ActivateLoggingAction at: 2006/8/21 11:17:18 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" 00D3CFC8Unable 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
Class not registered. 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", "", "688"} 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
i have a windows 2003 server up and running and a client workstation connected via a crossoever cable. they both can ping each other.
my next step, i would like to replicate a "real world" scenario where i have the database engine and the sample databases on the server and i would like to be able to write to and from the cleint to main database which is going to be on the server.
so my question is, do i need a full install on both machines?
I am trying to do a new install on Windows Server 2003 R2 (32 bit). I have a disk (DVD) that contains SQL 2005 Standard edition in two folders, Disk 1 and Disk 2. It also has SP1 in a third folder.
First, it will not auto-play. I can find the "splash.hta" file, and when I run it, I get the splash screen that says SQL 2005 install, disk 1 of 2. If I use the options that I was told to by my electronic medical record software company, the installation begins and goes ok. It installs about 2/3 of the components, and then says "Please insert disk 2." I do not have a second disk!!
I even tried copying each folder, Disk 1 and Disk 2 to two separate CDs and tried to install that way. I still get "Please insert disk 2" and the installation will not complete?
I have a Windows 2003 Enterprise x64 edition cluster setup and functioning normally. Now, I am trying to get SQL Server 2000 installed as a failover cluster but am having some difficulty. When installing, I get the message '[sqsrvres] ODBC sqldriverconnect failed' in the event log. The message happens when the installer is trying to bring the SQL Server Service resource online.
I am able to ping the name of the instance successfully. I am able to manually start the 'MSSQL$InstanceName' service. I have turned off the firewall on both machines, but this did not help. I have the DTC Service setup as a resource in the same cluster group.
I also read http://support.microsoft.com/default.aspx?scid=kb;en-us;815431 which seemed promising, but did not reolve the problem.
I need a hand here, referring to this knowledge base on Microsoft (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811) i applied this knowledge base, and it worked, the MSSQL and SQLSERVERAGENT have run under local non admin account.
But after i installed SP1, MSSQL service is ok, but SQLSERVERAGENT wont run. The warning message is : "Some service run and then stop if they have no work to do."
Is there any way i can install SP1 but in the same time run SQLSERVERAGENT under local non admin account?
I found sql2005 Enterprise cannot be installed under Simplied Chinese win 2003, the only thing i suspect is that win2003 is an envaluation copy with netframework 2.0 be installed.
i am facing problem in the installation of SQL Server 2005. I am installing sql server 2005 on Windows Server 2003 with SP1. When I start the setup error occurs. It says, Microsoft Windows Installer 3.0 is not installed. I think Windows Installer comes with windows server 2003. what should i do now..
Hi, I need to import an SQL string from MS Excel 2003 to SQL SERVER 2000. The string I need to import is composed by 5 different several blocks and looks like:
The detail of the SQL string is at: http://forums.microsoft.com/msdn/showpost.aspx?postid=2093921&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1
I am trying to implement OJ's suggestion: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2117223&SiteID=1 to use multi - batch processing to import the string to SQL SERVER, something like:
Code Snippet Dim SqlCnt, cmd1, cmd2, cmd3 'set the properties and open a connection
cmd1="use my_db" cmd2="create table mytb" cmd3="insert into mytb"
I may not be the best forum for this post, however I believe some onecan still help me or direct me somewhere else.I'm finding that win 2003 x64 and SQL 2005 CTP is slower than win 2003and SQL 2000.Machine A: Opteron 2.2 (248) w/ 2 cpus. 8GB memory. SCSI disk array.Windows Enterprise 2003 x64 final release. SQL Server 2005 enterpriseCTP.Machine B: Opeteron 2.2 (248) w/ 2 CPUs. 4GB Memory. IDE Drives.Windows Server 2003 (32bit) and SQL Server 2005 (standard).I'm using Cognos' DecisionStream as the ETL tool (32bit). I have theidentical job on both machines. Machine A is slower to do my nightlybuild (1h 20m) vs. Machine B (50m).I've done no tweaking of the databases. I Used SQL 2005's studio tocopy the database from Machine B to Machine A.The only major difference is the O/S and SQL, the machines are samespeed, however Machine A has twice the memory and faster disk; so Iwould expect it to be faster.Can anyone think of smoking guns I might be missing?TIA
The 6:th of march Sql server data tools for Visual Studio 2012 was released.
[URL]
I seem to be unable to install this using the link provided on the blog page. I'm getting a "Same architecture installation" error. Running on the machine is Visual Studio 2012 Premium & Sql Server 2012 (64bit).
I am trying to install SQL Server 2000 on a Win2K OS machine but Iget this error message:"A previous program installation created pending file operations onthe installation machine. You must restart the computer before runningsetup."I see others have had this problem but have fixed it using the solutionin:http://support.microsoft.com/defaul...kb;en-us;312995I have tried the solution but to no avail. The registry key:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetContro lSessionManagerPendingFileRenameOperations keeps reappearing as soon as Iclose RegEdit.Any ideas?Thanks,lq
Please help,I am trying to install MSDE 2000 so that Backup exec will run on thisserver. I have gotten so far as to find an entry in my SQLSTP.TXT filethat says that c:mssql7 was detected so the install fails.Now, to start with there is no directory called C:mssql7 on thisserver. I have gone through all MS articles on manual removal of SQLserver and instances. I have searched the registry for mssql7 andremoved any keys that matched, as per MS article I have searched onSQLBOOT.dll and it is not present anywhere on my system and I still getthe same results.2:07:44 Begin Action: Detection12:07:44 SQL Server version already installed: 7.00.62312:07:44 Previous Install SQL Path: C:MSSQL712:07:44 Previous Install SQL Data Path: C:MSSQL712:07:44 End Action Detection12:07:44 Begin Action: ODBCLocked12:07:44 End Action ODBCLocked12:07:44 GetDefinition returned: 112:07:44 Previous SQL Server ProductType: MSDE [0x4]12:07:44 This combination of Package and Operating System allows a fullproduct install.can anyone think of anything here..what else could be causing the server to think there is a previousversion of SQL 7 on this box!!!?
I get an error when trying to install the SQL Native Client. It says it cannot find the installation package and to use a valid copy of 'sqlncli.msi'. I've downloaded the Express setup twice and get the same error from both of them.
I'm attempting this in a VMWare session setup for Windows 2K, Advanced Server. I am trying to test my installation and setup procedures. This is not a production setup, just install testing and documentation. I have allocated only 272MB to the VMWare session, which is why the system doesn't meet the recommended settings.
Any help would be greatly appreciated.
Below is the Summary.txt output file.
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Wed May 03 09:54:23 2006
CPCWIN2KVM1 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Setup Support Files (English)
Error : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
Error String : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.
I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .
Can I use VB.NET 2003 with SQL Everywhere on desktop? Is it possible to create and populate data into .sdf with VB.NET 2003? Please advice, thank you very much.
I am in the process of creating another database for one of our departments, I'm creating a diagram of the structure in visio 2003. I'm done with the diagram but when I try to export to sql it wont let me. Anyone ever had this problem before?? This is the Error message I'm getting
ODBC Error: 01000 [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: The table 'Audit_Tbl' has been created but its maximum row size (20070) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
We are running SQL 7, using Access 2000 as a front end. Our network personis wanting to migrate to Windows 2003 (we're currently on Windows 2000), andwants to know if we should migrate to SQL 2003 at the same time. Are theremajor changes between SQL 7 and SQL 2003, and how hard of a task would it beto migrate our single database to a new version of SQL?Thanks,Neil
Has anyone heard of any problems running SQL 7 under Windows Server 2003?We're upgrading to 2003 and are wondering if we can keep SQL 7 with the newOS.Question 2: If we upgrade SQL to SQL 2005, can I run our database in SQL 7mode? Or would it be better to just convert it to SQL 2005?Thanks!Neil
i've installed the SSRS 2000 ENT Edition i trying to add reportviewer dll in my webapplication but i haven't find that dll so could any help in this issue ?
I would like to install SQL express on a PC which already has SQL 2003 - I use enterprise manager to manage a database. I require express as part of a teaching role (my students have installed it). Is is possible to do this or should I remove the full version
Writing an installer to handle switching the DLLs depending on OS version is somewhat of a pain. The SQL CE dlls that we are told to install for PocketPC 2003 and WM5 PPC are different... but I noticed that the 2003 DLLs seam to work fine on a WM5 PPC. Is there a perf hit or some other problems I will run into for doing this that I just haven't hit yet? Will this work for any WM5 PPC?
How do i execute a SSIS package (dtsx) in vb.net 2003
i've tried
Dim app As Application = New Application Dim p As Package = app.LoadPackage(pkg, Nothing) p.Variables("varFileDirectory").Value = FileDirectory p.Variables("varUserID").Value = UserID p.Execute()
but it does not recognize Package. what do i have to import for Package to be recognized. Is there another way to execute a SSIS package from vb.net 2003?
I dont know if i am in the right place to post this.
Is there any release of SQL server called SQL server 2003. I came accross this in a couple of job descriptions and also in a couple of interviews that i had. I Have been working on SQL Server since SQL Server 6.5, but hadnt heard about any release by that name. I really appreciate it if some one could provide some information on this. Thanks in advance.
