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 RepliesI 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,
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)]
===================================
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]
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
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.
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 Relatedhi 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
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
--------------------------------------------------------------------------------
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.
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!!
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
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
I have to build NT server for a SQL database which is just over 1.1 Gb. Does anybody have any suggestions for server configuration that I should look into
i.e.
Splitting the data and trans log across different disks.
Amount of memory ....
etc.
Any info would help
Thanks
Dear Friends
I have windows xp sp2 on my laptop with 512 mb ram , 60 gb hdd. and amd 2 ghz processor. i have installed microsft.net 2.0 framework and every other prerequist for sql server 2005 enterprise edition. i have also installed sql server 2005 enterprise edition. but my problem is that i m not getting any servername to connect in the sql server management studio. plz can anybody tell me how i have to make connection in the sql server 2005 enterprise edition. (i must mention that i m using my laptop stand alone.)
Thanks in advance
If installing SQL Server 2000 ( Standard Edition or EE) on any of theWindows 2000 Server with multiple processor, do we have to to do anyadditions configuration to utilize SMP ?
View 1 Replies View RelatedHello, I am from Brazil, for this my English He/she would like to know how I can
configure SQL Sever Express to Turn in my Local pc. If they can help am very
grateful. Wenderson Castro
I have SQL Server 2000 loaded on my standalone Laptop - using Windows XP Pro.
When adding a system DSN at the prompt "Which SQL server do you want to connect to?" I have five options even though I have I SQL server. I have an option of two (local) servers and three (MYSQLSERVER) servers.
How can I delete the duplications?
Thanks in advance.
I have been tasked with moving our SQL server estate onto new 64bit SQL 2008 Virtual servers on a VM base. Each Virtual server will be attached to our SAN that i will have no control over. Do i ask for multiple LUNs pretending that there is a COS), Etemp), FData) and Glog) disk structure or do I just present a very big space as a single C: drive and let it go.We are consolidating lots of old physical servers onto fewer (more powerful) virtual servers (according to the VM and SAN administrators)
1. Configure your SAN properly
2. Don't overallocate shared resource
I cannot see any services within "SQL Server 2005 Services" in SQL Server Configuration Manager.
I am new to SQL Server 2005 and recently installed all of the SQL Server 2005 64-bit components on to a Windows 2003 64-bit server. I can create and view databases via SQL Server Management Studio. I can also start and stop the SQL Server service for the default instance via SQL Server Management Studio. But I should be able to start/stop the service via SQL Server Configuration Manager and I believe I'm supposed to use SQL Server Configuration Manager to make changes to the services.
I'm concerned that something may have become corrupted and is effected the SQL Server Configuration Manager. Any suggestions?
Thanks in advance,
Joann
After installing SQL Server Express Advanced 2012 64-bit edition, we are unable to see the 64-bit Server Network Configuration in the left pane. Â We need to edit the TCP/IP and Named Pipes to enable them. Â All that is showing is the 32-bit instance for our Acronis backups.how to view or add a SQL server instance to the Server Network Configuration msc?
View 3 Replies View RelatedI have got problems with installation of a default instance on SQL Server 2008 on Vista Home Premium. During the step of Server Configuration you should enter UserName and password for each service. I do not know what user name to type. I tried every possible combination but the outcome is always the same - after typing usernames and passwords, installation suddenly fails without casting any exception. I'm not sure if I do something wrong (wrong User Name or Password) or is it a problem with installation application or with OS. Please, help.
View 4 Replies View RelatedI am trying to install SQL Server 2014 on W10. SQL Server installed, but failed to create a server that be connected to. SQL Server Configuration Manager has no options for creating a server either. How do I create the server.
View 4 Replies View RelatedHi,
I want to configure SQL Server 2005 Express to work with profiles and that kind of ASP.NET 2.0 things :)
The problem is, when I run aspnet_regsql.exe I can't get a list of databases, and when I manually enter the database name, I get the same error."(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
I've enabled the named pipes and tcp/ip connections in the Server Configuration Manager.I've also tried multiple logins.
I run the sql server locally.I can connect with my website to it, I can use the Management Studio Express (with win auth).
But I can't get those tables configured :(
Anybody got an idea?
Thanks in advance.
I have an application ready to transfer to the web hosting server with MS SQL 2005.
Database and tables were created with the VWD on the local machine (SQLEXPRESS).
I am using MS SQL Server Managenemt Studio Express to create the SQL to add the local tabales and data to the hosting database.
My connect to the hosting server is great.
Problem: My connection to SQLEPRESS is good but it only allows me to map Database from this directory C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData. I need to map to another directory as follows C:Documents and SettingsdflournoyMy DocumentsVisual Studio 2005WebSitescolumbushapps/app_data. So I can get to the tables I created locally.
Also has someone put together a process to migrate from SQLEXPRESS (Local) to Remote or Production SQL 2005 or 2000.
Hi,
How do i backup sql server configuration that we have done over all these days, As of now our server seem to be in its best condition so we want backup all the configuration settings to a place.
We could refer in future this if something goes wrong
Thanx
Is there a way that anyone knows of that I can get a
printout of my server and database configuration?
I don't want 'Generate Scripts'. I'm looking for a
stored procedure or something that will give me a
text document listing the configuration.
I'm running SQL 7 with sp1 on most servers and sp2
on a few.
I would appreciate any info.
Thanks!
Toni
Is there no longer a graphic interface for the parameters that are output with sp_configure?
There are many options that are settable that are not in the Sql Server Propreties, but
these items were in the 6.5 graphic interface through EM ex. number of open objects.
Is there a script to save these settings so the installation can be recreated?
Hi,
I have been asked to help in a situation where a sql server (ver 6.5 - running on NT 4.0) was migrated to a new machine. This machine has 4 processors and about 2 G of memory.
The problem is that queries are running a lot longer than they used to. A complex query that used to take approx 4 minutes to complete on the old machine now takes over 11 minutes on the new machine. These are canned querries produced by a reporting system, and are not able to be optimized. The indexes were reviewed and appeared to be appropriate.
These more complex queries had a lot of aggregation within them, as well as a lot of case statements, so there was significant processing aside from the join. To address this, tempdb was loaded RAM. There was no improvement because of this.
the cpu usuage and memory usage on the new machine is very low (cpu below 10%, mem below 10%). The data was stored on raid 10. The disk controller was improved yesterday and we are still waiting to hear the results of this.
my feeling (wether it's right or wrong) is there is some sort of bottleneck.
Any thoughts or suggestions?
Jim
Hi,
What should be ideal windows server configuration to support 300 GB database in SQL Server 2000 & 2005? I mean number of processors, RAM, etc.
Thanks
Prashant
I have a recommended configuration for production server. But, is there any guidelines for determining the test server configuration when compared to production. I know test server need not be as powerful as production, but I am not sure how to decide the test server configuration. Any help would be appreciated
View 3 Replies View RelatedFor some reason, when opening up the SQL Server Configuration Manager for one of my SQL Servers, the 'Requesting data from WMI provider..' message stays there. It never gets the data. This is in regards to services management. Its not a big deal, because I can log on to the server to accomplish this, but it would be nice to do it from SSMS. It works for other SQL Servers. Has anyone experienced this before?
View 4 Replies View RelatedHello, I can't resolve the following problem, I think it is a very stupid task, but I can't find it:
0. I need to access to SQL dbs through jdbc from my java application. Before to create java I did as follow:
1. I installed SQL Server Express
2. I created a user with password (SQL authentication)
3. I set both Windows e SQL authentication in surface area cfg
4. I set only TCP/IP remote connections
5. I set specific port 1433 in the protocols tcp in "All IPs"
6. I can't connect through sqlcmd or osql.
7. I CAN connect through SQL Server Manager studio or how hell it is called!
The error is (I have italian version, so I try to transalte for you):
say user id is cometk and pass is 123
c:>sqlcmd -U cometk
Password: HResult 0x4818, level 14, state 1
Login failed for user 'cometk'.
HResult 0x2746, level 16, state 1
Provider TCP: Connection interrupted from the remote host
slqcmd: error: Microsoft SQL Native Client : connection error while communicating.
Can anyone help me? Can anyone guide me to configure SQL Server to make remote connections? :)
Thanks bye from Italy
CometKeeper... A Dream Guardian...