SQL Server Build (Pagefile Configuration)
Mar 14, 2008
Need some recommendations on . I have been tasked with building some SQL servers. The hardware config is:
4 Quad-core processors
64 GB of RAM (128GB of RAM coming in next group of servers)
4x73GB hard drives.
We normally build the servers with two Raid 1 disk groups. Mirroring the OS on one Raid group and keeping the default pagefile (for crash dumps) and then create another large pagefile on the other Raid group. We have been told from our parent company that we are to build the servers with a RAID 5 config and place the pagefile onto the same raid group as the OS. I know this is wrong and I need evidence to support my thoughts. If anyone has any links to whitepapers or research I would greatly appreciate it.
View 1 Replies
ADVERTISEMENT
Jul 10, 2006
Can you please consider the following scenario:
Windows Server 2003 Enterprise Edition (32-bit)
SQL 2000 Enterprise Edition
Server with 8GB memory
1. If we enable /3GB and /PAE, the server can see and use 8GB memory, OS has 1GB, applications can use the remaining 7GB, can install 2 instances of SQL with a max server mem set to 3GB each, SQL should be able to allocate memory from the upper 4GB RAM. (True / False)
2. We only need to enable AWE if any single instance need to cache more than 4GB of data so we could for example configure one instance with AWE and set the max mem to 5GB and set the second instance to use 2GB max . (True / False).
3. 32-bit windows server OS can support a maximum of 4GB virtual memory, does this mean setting the pagefile to more than 4GB is a waste of disk space or does PAE extend this limitation ?
4.With AWE enabled, anything above the 4GB virtual space is used for data caching only (can't be used to manage user connections, locks, stored procedure compilations...etc). How does this work when running 2 separate instances with 3GB each and AWE disabled? would they receive 4GB of virtual pageable address space each ?
Regards,
AE
View 7 Replies
View Related
Dec 19, 2006
Hello, I've been reading about this topic, and I've gotten myself moreconfused, not less.We have a single-processor license SQL Server Standard 2005 (xeon 2.8ghz) with 4 GB RAM in Windows Server 2003 SP1 Standard.I turned on the /3GB switch in boot.ini but not PAE or AWE, would it begood to have either one??
Quote:
View 3 Replies
View Related
Sep 19, 2007
I know the standard Microsoft recommendation is to make the pagefile at least 1.5 to 3 times larger then the amount of physical memory. However, if you're talking about a server with lots of memory such as 16GB or 32GB, would following this rule be unnecessary. With SQL 2000 running on Windows 2000 Server or Windows Server 2003 I typically see pagefile usage no more then 12% for a 2GB pagefile. Anything over 15% means I need to look at other indicators to see if a memory bottleneck has developed. If I have 32GB of physical memory and make the pagefile only 1.5 x 32GB I have a 48GB pagefile. 10% of this is 4.8GB, which I would hope I never see consumed.
Any thoughts?
Thanks, Dave
View 11 Replies
View Related
Mar 22, 2006
Hello,
we have automated build on every night. In our solution is SSIS project, where each package is encrypted per password. We call build process per command line like this..
C:ProgrammeMicrosoft Visual Studio 8Common7IDEdevenv.exe (c:DevelopmentX3\X3.sln /build Release)' in 'c:DevelopmentProjectsDailyBuild
Through build process we get a error:
External Program Failed: C:ProgrammeMicrosoft Visual Studio 8Common7IDEdevenv.exe (return code was 1):
We think a reason is, that on build of SSIS project must be entered a password. You can wonder for what we need that SSIS packages are part of our build. We hope that on build process is also created Deployment Utility, if so set in dtproject.user. Is it so? Is there any way to create Deployment utility on automated build process? Can be a password provided pre command line?
with best regards
Anton Kalcik
View 5 Replies
View Related
Sep 22, 2007
I am getting following error when trying to install SQL express 2005 on XPSP2.
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342
I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.
Do i need IIS installed? Its not installed on this box...
please suggest something... i am stuck...
Thanks,
View 3 Replies
View Related
May 2, 2007
I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv Server, SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could see and configure all services via SQL Configuration Manager and SQL Server Surface Area Configuration tools. This worked for a couple of days and now both configuration tools no longer detect SQL2005 components. SQL Server Surface Area Configuration issued an error that said "No SQL Server 2005 components were found on specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLAC)". SQL Configuration Manager did not list any installed services. I don€™t know what caused this. Anyone has any idea? Please help! Below is the Installation Report which shows installed components.
===================================
The following components are installed on this server
DEV
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Reporting Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
QA
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Common components
Integration Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Notification Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Workstation Components
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
===================================
View 1 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
May 30, 2013
1-We have sql server 2008 with 2 nodes with cluster(Active/Passive).
2-Due to performance problem we are going to separate the reports from database.
3-I want to create reporting server,as i am new for this pls let me know the step by step process to create reporting server.
4-Is it possible to create new instance for reporting in passive node and shear the cluster resources??
View 2 Replies
View Related
Apr 2, 2008
I would like to install this on my server which is a cluster. The server has 2 instances on it. I only want to install it on the dev instance. I got the executable from Microsoft. There is a hotfix.txt file but that doesn't have any installation information. Could someone please help me to find some documentation so that this will only update our dev instance. If there is documentation, could someone please send it to me?
Thanks.
View 6 Replies
View Related
Apr 4, 2007
All,
I'm currently running SQL Server 2005 SP2 with the 3050 hotfix. I just noticed that KB Articles 934458 and 934459 came out, which are more hotfixes for SQL Server 2005 SP2. However, I'm confused.
KB Article 934458 refers to patching versions 3042 - 3053 whereas KB Article 934459 refers to patching versions 3150 - 3158. What's the difference between the 30xx and the 31xx builds? I thought all SQL Server versions used the same build number.
Thanks for any clarification you can provide!
Jason
View 6 Replies
View Related
Dec 7, 2006
Hi,
how to build a sql server instance in the network using sql express?
thank you.
View 7 Replies
View Related
Jun 5, 2015
I have 3 tables, a supplier table, a types table and a relationship table between the two..I want to build a query that put the different types in columns, and use a Boolean value to identify if the supplier supplies that type.
CREATE TABLE #Suppliers(
id INT,
nam NVARCHAR(50)
[code]...
It's possible to do this in "one" query?
View 2 Replies
View Related
Oct 6, 2015
IF OBJECT_ID('tempdb..#test') IS NOT NULL
DROP TABLE #test
CREATE TABLE #test (TestID CHAR(5) NOT NULL PRIMARY KEY)
INSERT INTO #test
SELECT '1'
[code]....
i am trying to build a dynamic where "or" clause finding difficulties.
View 7 Replies
View Related
Aug 2, 2006
Hi,I have a problem, when I want to access to my SQL Server Expressdatabase from my ASP.NET application.My workstation ID is KITOLAP-HPMy username is user01Now I built the following connection String (VB.NET):Dim workstation As String =System.Environment.GetEnvironmentVariable("computername")connectionString = "workstation id=""" & workstation & """;packetsize=4096;user id=user01;integrated security=SSPI;data source=""" &workstation & "SQLExpress"";persist security info=True;initialcatalog=webshop"connection = New SqlConnection(connectionString)Although I put as user id "user01" the application makes an error whenI try to open the connection, saying that the login with user "aspnet"failed.How can I change it so that as login-user "user01" is taken and not"aspnet" or otherwise, how can I create a new user in the SQL Serverdatabase with which I could access the DB??thanks,kito
View 1 Replies
View Related
Oct 12, 2007
Hi all -
We are planning to use a 2-node SQL Server 2005 cluster as part of a new Biztalk 2006 project, and I would like some advice regarding SQL Server service packs and editions.
Testing has already been running for some time without problems, but the test environment (a) is not clustered, (b) is using SQL Server 2005 Standard Edition rather than Enterprise and (c) has neither of the SQL Server service packs installed.
As this is a major project for us, my instinct would be to use Enterprise Edition (maximise performance and scalability)
and to apply SP2 (because I thought it was best practice to be up-to-date). I would have liked to do this before we go Live so we don't run the risk of having to change afterwards if we hit a problem.
Understandably, the project guys' perspective is this: testing so far has not been affected by SQL Server bugs, and we should go Live with the environment we have tested in, albeit with the planned 2-node cluster which is seen as a 'must have'.
I have trawled Books Online, Technet and other resources without success, so any thoughts or info on required, recommended or preferred combinations of Biztalk 2006 with SQL Server 2005 editions and service packs in a clustered
environment would be greatly appreciated - thanks!
Michael
View 5 Replies
View Related
Aug 3, 2006
I have SQL Server 2005 Standard installed on a Windows XP SP2 PC. I tried to install the SP1 upgrade from http://www.microsoft.com/downloads/details.aspx?familyid=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC&displaylang=en, which is listed as build 2047. I installed the upgrade and each upgraded component reported success, and I rebooted the PC. However, checking the version of my SQL Server as per KB321185 results in version 9.00.2040.00. There are errors at the end of the SQL9_Hotfix_KB913090_sqlrun_sql.msp.log log file as follows :
MSI (s) (54:A8) [15:57:42:059]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' installed successfully.
MSI (s) (54:A8) [15:57:42:059]: Note: 1: 1728
MSI (s) (54:A8) [15:57:42:059]: Transforming table Error.
MSI (s) (54:A8) [15:57:42:059]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (54:A8) [15:57:42:059]: Transforming table Error.
MSI (s) (54:A8) [15:57:42:059]: Transforming table Error.
MSI (s) (54:A8) [15:57:42:059]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (54:A8) [15:57:42:059]: Transforming table Error.
MSI (s) (54:A8) [15:57:42:059]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (54:A8) [15:57:42:059]: Transforming table Error.
MSI (s) (54:A8) [15:57:42:059]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (54:A8) [15:57:42:059]: Transforming table Error.
MSI (s) (54:A8) [15:57:42:059]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (54:A8) [15:57:42:059]: Transforming table Error.
MSI (s) (54:A8) [15:57:42:059]: Transforming table Error.
MSI (s) (54:A8) [15:57:42:059]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (54:A8) [15:57:42:059]: Transforming table Error.
MSI (s) (54:A8) [15:57:42:059]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (54:A8) [15:57:42:059]: Transforming table Error.
MSI (s) (54:A8) [15:57:42:059]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (54:A8) [15:57:42:059]: Product: Microsoft SQL Server 2005 -- Configuration completed successfully.
Attempting to reinstall SP1 resulted in the same errors. I need to fully upgrade to build 2047 so that I can install the cumulative hotfix build 2153. Does anyone have suggestions as to what causes this behavior?
Thanks,
Gary Thorne
HAL Systems
View 8 Replies
View Related
May 12, 2008
Hi all
I have Re-Builld index Job,it is runnining evry week.now a days my queries are runnign very slow.eben after running re-build indexs.Please guide me how to check where was the problem.
I am suspecting Stastitics how check the stastitics updation.
any help appreciated.
View 1 Replies
View Related
May 23, 2006
Hi --I was wondering if this is a bug when I add new data in my table SSIS Confiurations and give wizard a new Configuration filter the package configuration wizard can not see the new values --the old values from the previous configuration are still showing---is there any known workaround or forced refresh I can do
thanks in advance Dave
Background:
SQL Package Configurations are most important because they provide the possibility of a central configuration store for your entire enterprise!!!!!!!! and is in my mind the only way to go
http://sqljunkies.com/WebLog/knight_reign/archive/2005/01/24/6843.aspx
Wizard results:
Name:
ETL
Type:
SQL Server
Connection name:
ETLConfiguration
Any existing configuration information for selected configuration filter will be overwritten with new configuration settings.
Configuration table name:
[dbo].[SSIS Configurations]
Configuration filter:
PT_CUST_ABR
Target Property:
Package.Variables[User::gsPreLoad].Properties[Value]
Package.Variables[User::gsPostLoad].Properties[Value]
Package.Variables[User::gsLoad].Properties[Value]
Package.Variables[User::gsFlatFilename].Properties[Value]
Package.Variables[User::gsFileName].Properties[Value]
Package.Variables[User::gsCDOMailTo].Properties[Value]
Package.Variables[User::gsCDOMailSubject].Properties[Value]
Package.Variables[User::giRecordCount].Properties[Value]
Package.Variables[User::giFileSize].Properties[Value]
Package.Variables[User::giBatchID].Properties[Value]
Package.Variables[User::gdFileDateCreated].Properties[Value]
Package.Connections[MyDatabase].Properties[ServerName]
Package.Connections[MyDatabase].Properties[InitialCatalog]
USE [ETLConfiguration]
GO
/****** Object: Table [dbo].[SSIS Configurations] Script Date: 05/23/2006 13:34:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SSIS Configurations](
[ConfigurationFilter] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValue] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
[PackagePath] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValueType] [nvarchar](20) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
View 3 Replies
View Related
Apr 3, 2008
I have no idea how to apply "fixes" or updates to SQL Server when it is running on a cluster.
We are currently running SQL Server 2005 with SP2. The version would be Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
I am hoping that someone can tell me of a document that exists, that includes the very basics, on how to do this. I need something that says go to the cluster and do these steps in this order, etc. from start to finish.
Thank you.
View 3 Replies
View Related
Feb 21, 2008
Hi,
I want to build a silent setup/installation of MS-SQL-Server-Express 2005 for installation on customers computers.
I want to integrate it in my own setup/installation routine of my application.
How can I do that?
Where can I get Infos or tutorials? Perhaps here ?
Sorry for my bad english
Regards Tron
View 7 Replies
View Related
Jan 14, 2006
It seems to me, that the best way is to have one Environment Varible containing the name of the SQL Server, so that you can look up the configuration in the SSIS Configuration Table when you run the package.
Is this the preferable way of doing it ? I would like to hear some positive/negative comment of why chosing a configuration type instead of another.
It seems to me that putting all of the configuration in the Environment variable is harder work but most secure (server breakdown vs table corruption/database error...)
Let's have some comments
View 3 Replies
View Related
Mar 8, 2007
I've read about this hotfix at http://www.kbalertz.com/Feedback_933097.aspx but I can't find anything on microsoft.com about it. It sounds like a worthwhile hotfix, but I'm wondering about the absence of an announcement on microsoft.com.
Anyone else know about this hotfix?
Thanks!
View 3 Replies
View Related
Feb 5, 2007
I believe that I mistakenly attempted to apply the Analysis Services component of this update before applying the SQL Server component. The update now fails continuously with the following message:
02/05/2007 17:58:24.990 ================================================================================
02/05/2007 17:58:25.021 Hotfix package launched
02/05/2007 17:58:27.615 Product discovery successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.630 SP Level check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.646 Product language check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.661 Product version check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.677 Command-line instance name check completed during the install process
02/05/2007 17:58:27.693 Baseline build check completed during the install process
02/05/2007 17:58:34.864 Attempting to install instance: MSSQLSERVER
02/05/2007 17:58:34.974 Attempting to install target: CHARLIDEVSRV
02/05/2007 17:58:35.005 Attempting to check for locked files: sqlrun_sql.msp
02/05/2007 17:58:35.052 Attempting to check for locked files: \CHARLIDEVSRVf$44923e05996203228c1608bea1hotfixsqlFilessqlrun_sql.msp
02/05/2007 17:58:35.067 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB918222_sqlrun_sql.msp.out
02/05/2007 18:01:52.978 MSP returned 1635: This patch package could not be opened. Verify that the patch package exists and is accessible, or contact the application vendor to verify that this is a valid Windows Installer patch package.
02/05/2007 18:01:53.009 Unable to check MSP file: \CHARLIDEVSRVf$44923e05996203228c1608bea1hotfixsqlFilessqlrun_sql.msp
02/05/2007 18:01:53.025 The following exception occurred: Unable to install Windows Installer MSP file Date: 02/05/2007 18:01:53.025 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 689
02/05/2007 18:01:53.212 Failed to install instance: MSSQLSERVER
02/05/2007 18:01:53.259
02/05/2007 18:01:53.259 Product Status Summary:
02/05/2007 18:01:53.290 Product: SQL Server Database Services 2005
02/05/2007 18:01:53.306 MSSQLSERVER - Failure
02/05/2007 18:01:53.321
The update fails although I have cleaned the registry of any reference to it. Another article indicated that the hotfix may delete registry keys required, for instance, to operated SSIS if applied in the wrong order. Here, it appears to be preventing the hotfix from being reapplied. I have ensured that all necessary permissions are available and the services are running in domain user accounts with the necessary rights. I'm the administrator on the machine.
Is there a way to get this hotfix applied without having to completely rip and rebuild my server instance?
View 4 Replies
View Related
Feb 18, 2008
hi ; everybody
i have almost installed sql server 2005 enterprise edition on windows xp sp2 and i havent connected to any server .i have taken error:40 with my all attempts.tcp/ip protocol have been enabled on sql server configuration manager.i have tried to start sql server surface area configuration but every my attempt have been resulted a fault which is below.
[No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)]
i dont suppose that i did something wrong when i setupped.because i read every article on the internet about how to make setup.also; i setupped numbers of times on my pc.
but i didnt accomplished.
i thank for any help.please; give your solution explicitly.
View 8 Replies
View Related
Nov 3, 2015
I'd like to capture the change event when it happens and have both a record posted to a table and an email notification to the DBA.
View 7 Replies
View Related
Jan 2, 2008
hi all
i get the following message error when installing sql server 2005 express :
<< sql server setup could not connect to the database service for server configuration the error was :[microsoft][gestionnaire de pilotes odbc] source de données introuvable et nom de pilote non spécifié >>
is there any help
thanks and best regards
View 6 Replies
View Related
Jun 4, 2006
OS: XP-SP2
Not able to install SQL Express 2005.
------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
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.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x80090325
Needles to say, above link is useless..
I had managed to install previously, but ran into problems while trying to upsize an MS-Access database, I've tried everything from creating certificate to hacking away at the registry...Log-on with a different account, etc...Anybody knows how to get around this?
Here's part of the log file:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Sat Jun 03 20:09:53 2006
Machine : YANICK
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
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.
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------
View 3 Replies
View Related
May 8, 2006
I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition.
Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhostinstancename, but reports the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)
I'm logged into the virtual server via Remote Desktop, but the SAC tool thinks I'm logged into the physical server supporting the virtual server. I seem to be caught between a rock and a hard place here, as I can't enable remote connections without first gaining access on the server itself.
Any help will be greatly appreciated.
View 3 Replies
View Related
Mar 10, 2008
Hi All,
Using Visual studio 2005 you can create a simple database to enable the use of login using asp.net configuration by clicking on website on the menu bar. By default the database is created and stored in the App_data file. However my service provider has a separate server for SQL (SQL Server), therefor it will not work.
How can I use this Asp.Net Configuration to create a database on my sql server?
Hope this question makes sense!!
View 3 Replies
View Related
Apr 6, 2001
To get an understanding of the SQL Server technology and the hardware requiremnets. To configure a VLDB system for OLTP what is a typical hardware configuration that will be used.
No of Rows:10 Million
No of Tables : 50
Will have to spilt this out into many databases, or will one database be able to handle this. Assume that the database is normalized.
Any suggestion or information will be of great help. Does MS have any information relating to this information on their web site?
Murali Vallath
View 2 Replies
View Related
Jul 20, 1998
I am about to rebuild the primary SQL Server 6.5 server at our site. i would like to hear from those experienced in this regarding the optimal configuration settings. I have Microsoft`s recommendations, but want to hear from some real-world experiences. I have 1GB of RAM and a 27 GB hard drive.
View 2 Replies
View Related
Jun 21, 2002
We are upgraded from sql 7.0 to sql 2000. We have a brand new server in which we are installing it on. We are trying to decide on the best setup for it. The db are a datawarehouse. So mainly used for input. Gets updated with new data once a day.
We were going to have:
Partician 1 : Raid 1 - OS and Applications
Now we are trying to decide on the other particians:
We have 6 36 Gig Drives to work with. One of them is going to be a hot swappable So basically we have 5 36 Gig drives to work with. I've read that its better to divide up the data/logs/tempdb. Would the following setup be good for performance or if not what would you recommend: We were thinking of making all of them Raid 5. My network guys say that with Raid 5 I'll end up with about 70 % so that accounts to about 127 Gig. So I was thinking the following:
partition 2 - Data Files 112 gig
Partition 3 - Logs 10 Gig
Partition 4 - Tempdb 5 gig
Any suggestion would be greatly appreciated - trying to get this set up with the best possible scenerio for performance.
Stacy
View 3 Replies
View Related
