Configuration Manager - Which Configuration Type To Chose ?
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...)
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
Each time you start a SSIS project you have Solutions Configuration showing "Development". In the drop down box you can select "Configuration Manager..."
Can someone tell me the use of this, and is it related to the package configurations somehow. I've tried to create new Solution Configurations like "Test" and "Production" with the purpose of binding different configuration files and deplymentfolders to each Solution Configuration but still it seems like this isn't the way i should be used...
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
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]
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.
For 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?
We deployed Reporting Services recently to a customer with a latest release and build. When they type in http://<server>/ReportServer, this just comes up with a screen like a navigation sreen showing folders and links to reports. What needs to be done to get the Report Manager screen showing?
It has been a while since I actually installed Reporting Services. When they go into configuration, all of the green checks are there (except for Web Service Identity, which is Red).
I've had weeks trying to establish connections between my PC and Small Business Server 2003 running SqlExpress. Finally sorted out the problem, and wanted to go into Sql Exp Configuration Manager.
This I've been using for weeks, yet today I get a message that " MMC could not create the snap-in".
I thought that MMC update 3.0 may be the problem., however, cannot find any indication that my server has been updated to MMC 3.0.
If that does happen to be the cause, how do I get around it.?
I just installed 3 instances of SQL Server 2005, installing the two named instances first and then the defaul instance third.
My configuration Manager only shows the two named instance services and the default does not show up.
Under Services in Computer Manager, it does show.
Any one run across this, and I would think it might cause some problems now that all the service configuration changes need to be performed in SQL Server Configuration Manager.
I am getting this error when i clicked on configuration manager. "Cannot connect to WMI provider. You do not have permissions or the server is unreachable. Note that you can only manage SQL server 2005 and later servers with configuration manager only."
We changed the IP addresses for several SQL Servers and we're a little confused by what we see in Configuration Manager. The TCP/IP properties "IP Addresses" tab still shows the old IP address, even after a restart. On "Protocol" tab, Listen All is set to "Yes".
We've found one source that says this setting causes the listening on an individual IP to be ignored.
Hi, I dont know if I should post this question here, or on oracle forums, but here goes ...
I made a simple package that performs 2 Excecute SQL Tasks, one task does a select query on a SQL Server DB Table, the other task does a select query on an Oracle DB Table.
The package runs fine in BIDS when debugging, but when I deployed the package to a file system and added it to an sql server agent Job, it all went wrong ...
I tried the ms oledb dataprovider (ole db) for oracle but also the oracleclient data provider (ado.net) but the package always fails.
message Failed to acquire connection "aaa.bbb.oracleClient". Connection may not be configured correctly or you may not have the right permissions on this connection.
the OnError logrow for the package itself says almost the same.
Now my question is: What do I need to configure to get it all working? I think I need to configure the oracle db no? What should I configure? ...
I want know how to config SSIS Package With different connection Manager.
Sample .
When Design time i gave The Connection Manager(Devlopement Server) Name : STG1.XXXSchema
Server Name STG.ssss
Password : xxxxx
I make the The XML configuration file .
after deploy the Package i want from Development Server to Production Server . so i will change the Package Config File Open wiht Notepad .
Server Name STG.qqq
Password :xxxxxx
after Edit Connection String I run the Package . It Always Taking Whatever igave the Connection String When Design time only .is not taking what connection string edit hte in the Package Config File. Please Any one give the Solution .
How we can Change the connection string in XML Config File .Whne I tested . It always taking what ever we given in the Desing Time .
But when i try to enable the certificate using Configuration manager i cant see the certificate. I can see the
certificate using MMC console. I followed the instructions and all the "Certifcate Requirements" from BOL is looking fine, but still cannot able to see the certificate in the configuration manager.
Greetings All; I am having trouble getting an indirect configuration to work. Can someone offer a hand?
Here's the deal.... I have a package the currently has an OLE DB Connection manager. I have an XML configuration file set up to acquire the connection string. That works fine. I have a package variable that contains the absolute path to the .dtsconfig file.
How can I get the connection manager to read the package variable (which has the path to the *.dtsconfig file) instead of the hard coded value?
I need another opinion about the SQL Server Configuration Manager's TCP/IP settings...
Recreation steps: Start, (All) Programs, SQL Server 2005, Configuration Tools, SQL Server Configuration Manager. Expand the "SQL Server 2005 Network Configuration" Select the "Protocols for x" where "x" is the named-instance or "MSSQLServer" for default. On the right-hand pane, right-click "TCP/IP" and select "Properties." Select the "IP Addresses" tab.
Visually on the screen I have this: _______________________________________ - IP1 Active Yes Enabled No IP Address 106.xx.xxx.xx TCP Dynamic Ports TCP Port 1433
- IP2 Active Yes Enabled No IP Address 127.0.0.1 <-loopback TCP Dynamic Ports TCP Port 1433
-IPAll TCP Dynamic Ports TCP Port 1433 _______________________________________
Questions: 1. If I want to change the listening port, I change all three at the same time? 1a. Does a value in the IPAll section override the individual IPx sections? 2. What does "enabled" mean? How can IP1 and IP2 not be enabled? 3. What does "active" mean? How can something be both active yet not enabled? (4. Any plans to change the "NULL=False, 0=True" values for the Dynamic Ports?)
I have a 2 node cluster in an active/active configuration. Install is SQL 2005 Enterprise Edition x64, patched to KB934458
If I try and run SQL Server Configuration Manager on node 1 the application does not start and I get the following message: "Connection to target machine could not be made in a timely fashion." This happens for both SQL Server instances (SQL01 and SQL02). I can connect fine on the 2nd node with both instances.
Further to this, if I try and run the Surface Area Configuration tool on node 1 - I can't connect to either SQL Instance (SQL01 and SQL02) If I run the SAC tool on the second node, I can connect to the instance SQL02 that is active on node 2. If I fail that SQL Instance over to node 1, I can no longer connect I think there is clearly something not quite right about node 1.
I understand there are different package configuration type like... · XML configuration file · Environment variable · Registry entry · Parent package variable · SQL Server
Of the above which is best configuration type to use.
I installed SQL Server 2012 on a windows server 2012 that had an existing 2008 R2 SQL installation.
After the install I can see only the 32 bit network configuration options in SQL Server Configuration Manager for both versions. Before the install they were available in the 2008 R2 version of the tool.
I have done a fresh sql 2012 standalone installation but the instance services are not getting reflected in SQL server configuration manager
Although I can find the instance details in services.msc and also in n/w configuration of configuration manager but in the sql services tab of config manager , it is not showing .
The hide instance is unchecked when I check the protocol properties.
The servers are actually a cluster in an active / passive configuration. There are 2 servers with internal IP addresses and then a virtual server. We'll call them 192.1, 192.2 and VirtualBox. If I remote desktop into VirtualBox and run the config manager, nothing will happen for about 45 seconds and then I get a dialog with this message "Connection to target machine could not be made in a timely fasion.". Other than 'fashion' is misspelled :), I'm unable to determine what could cause this. Are there issues running this on a clustered environment? Or are there some things I can look at to diagnose this issue?
Hello, I am new to SSIS. Could someone please tell me how to make the Connection Manager use the connection string from the configuration file? I am trying to have connection information set in one place for all the packages to use. I have already created a .dtsConfig file based on my existing Connection Managers. Do I need seperate dtsConfig files for each database?
When I open SQL server configuration manager / expand SQL server 2005 network configuration, I have a Protocols for SQLEXPRESS but under SQL server 2005 services branch, I cannot find a reference to my SQLEXPRESS database service. This causes a problem because, I cannot enable or disable SQLExpress.
I've tried to remove the SQLExpress instance by going to Add/Remove Programs but it doesn't work. After I restart the computer, the entry SQLEXPRESS: database service is still there.
I cannot reinstall SQLEXPRESS either because it saids instance name already exist.
When I try 'net start mssql$sqlexpress' it saids "the service name is invalid"
When I try 'sqlcmd -S <my server name here>SQLEXPRESS it saids
HResult 0x274D, Level 16, State 1 TCP Provider: No connection could be made because the target machine actively re fused it.
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
I'm pulling my hair out because according to the error message above, I should use surface area configuration tool to enable remote connections but I can't even see the SQLEXPRESS entry inside the tool!!!
HELP!! I have an asp.net app that uses Membership Provider and it used to work. but somehow it doesn't work because of this strange sqlexpress issue.
When I run the app I get 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
I've got an error when I want to initialize the Report Server by means of RS Configuration Manager.
All points are check in green except "Encryption Keys" that is in "Optionnal configuration" and "Initialization" that is in "Not Configured".
When I click on "Initialization" an error occured :
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)
When I want to browse the report this error occured:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError). Cannot generate SSPI context.
I am attempting to set up SQL 2005 reporting on my local system. When I get to the "Initialization" step I get the following error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: Keyset does not exist (Exception from HRESULT: 0x80090016) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)
Can anyone provide assistance or suggestions on resolving this error? Many Thanks!!
Hi, I have a problem with SQL Server 2005 Reporting Service. I installed Reporting Service in my machine. When I was trying to configure the Reporting Service, Report Manager Virtual Directory got disabled. I need to enable this Report Manager Virtual directory. I can see the disabled link for Report Manager Virtual Directory and it shows the error: Report Manager Virtual Directory is not configurable for the current mode. Kindly help me out of this problem. Thanks Subhendu
i have installed a new sql server 2005 instance. as usual the data and log devices went to standard location. as per my company policy i have to put data and log in different drives..
for eg. k:data j:log
i have move master and other db's device files to new location and i can modify it using configuration manager
but i ahve to do it on many servers so thought if i can do it from command line could save me lot of time ( i can eventually automae whole procedure)
what commands are available to change such paramter.. i need to change startup parameters options -d -l -e
