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.
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 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.
Is it possible to grant access to SQL Server Configuration manager? I mean just the SQL Configuration manager alone?
View 2 Replies View RelatedI 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.
I am sure I'm being blind here (it wouldn't be the first time - and won't be the last time).
I have a package that retrieves some values from SQL table to allow me to dynically create an email message, so it retrieves To Addresses, From Address, Header, Body from a table, populates variables, and uses expressions to assign those to the SEND MAIL TASK.
That is working (after a bit of head/wall/banging to get my default virtual SMTP server running locally).
Now I am trying to make the SMTP Server Name dynamic. The Property SMTPConnection specifies the SMTP Connection Manager to use, and not the server, so it doesn't seem as though I can configure a property on the SEND MAIL TASK to achieve this.
Now I'm focussing on using SQL Package Configurations to try and drive this. As I see it, just like XML configurations, if you change a value in the configuration source, then when the package runs, it get's that value, and uses it.
I have change the configuration value (outside of the package). I confirm it is actually changed by running a SQL Task that gets the value from the configuration table, and view the value assigned to the variable in watches. The value returned is a different value (in my case I changed it to an invalid servername), and yet the task still runs through successfully, using the previous SMTP servername.
huh?
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 would like to know how to get a list of configuration settings for adatabase.Is there a table that I can select this info from?Or a file (perhaps an ini file?) of some kind?Things like timeout settings, rollback space, table space, etc.Thanks
View 2 Replies View RelatedOK, here's the scenario:
I have some libraries (DLL) that I call from a regular console application. The data access methods get the connection string from the app.config, nothing special there.
The thing is: now I need to use the libraries inside a SSIS package. I call them from a script task, and everything is fine, except for the connection string.
Is there a way that I can get the connection string from the SSIS package configuration like I would from the app.config? Maybe some alternative to ConfigurationManager.AppSettings["ConnString"] in the DTS Runtime?
Thanks in advance...
We have build configuration setup for each environment that we automatically deploy to (DEV, UA, PROD 1, PROD 2, etc.) Â We've recently come across a scenario where one environment will now be running a different version of SQL Server than the others.
Is it possible to tie the Target Platform version to a configuration. Such that one configuration could target 2012 while another targets 2014?
Hello Everybody,
I have developed a SSIS package to pull data from a remote SQL Server.
I have specified Database related settings in a dtsconfig file.
I was just wondering if we have any way of encrypting the config file so that only my package can read information out of it.
Or is there any other better way where i can store my database configuration (uid, pwd) so that it is not viewed by anyone.
please help me with this issude, thanks in advance...
Regards,
Sudhir Kesharwani
Hi,
I developed a report in development environment, which will later be deployed to QA, Staging and then Production. This report has more than 10 datasets and if the report is moved through each of the databases, datasource has to be changed for all the datasets. is there anyway that I can do it globally, what i mean is can i set up any configuration files which I can use in QA, Staging and Production.
Any ideas
Thanks,
Priya T
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
I installed the samples and tutoriales on the same server as SQL Server 2005 and VS 2005 Team Suite.
Living in Belgium, the local settings are:
language = Duch (Belgium)
code page = 850
e.g. in the database samples (AdventureWorks database €“ AdventureWorks Warehouse database)
my date notation is: 26-12-2005
my number notation is: 1,0013016921998599
all demo samples and tutorials are developed using
language = English (United States)
code page 1252
e.g. in SampleCurrencyData.txt
the date notation is: 12/26/2005 00:00:00
the number notation is: 1.0013016921998599
I do not have any problems to test the diferent services (Data Base Engine Services, Analysis Services, reporting & notifications services ..) but I do not succeed to deploy any samples of integration services !
e.g. for Integration Services Tutorial - lesson 1: €œCreating the Project and Basic Package€?
there are no error messages, 1097 rows are processed
but, checking the result in the database, no data is updated in the FactCurrencyRate table of the AdventureWorksDW database !
Why?
- is the problem related to the local language settings? how to solve this?
- what is the influence of the code page ? is there any compatibility between 1252 and 850 as code page?
- Server collation (e.g. Latin_1_General_CI_AS) is reported as key for the Unicode notation for character strings but what about notation of numbers?
- when to use float data type DT_R4 or DT_R8?
- I have remarked that the DT_DBTimeStamp is undependent from the source time notation €“ Is this correct?
- what is the difference between DT_Date and DT_DBDate or DT_DBTime, or DT_DBTimeStamp?
- Is Integration Services dependant of the local settings of the database engine?
- how to set / modify additional regional properties in a SSIS and SSRS package?
- how to change the default setting of the Flat File Connection Manager [starting the wizard, the local setting for the language €“ Dutch appears and this is OK for me but as codepage appears 1252 (ANSI Latin) and this is not OK as my server code page = 850]?
- how to work with e.g. US based data as source and Belgium settings for reports?
Suppose 2 environments on a single machine.
Each environment has different configuration settings....different
databases etc.
All the packages in the first environment have a hardcoded config files
referencing the local drive.
In order to create the second environment do I have to
go into each package and manually change the location of the
hardcoded config files. If I don't it will it not use the config files
from the first environment.
Thanks
I want to be able to view site settings in Report Manager, but when I connect to http://localhost/Reports in the upper right all that is shown is:
Home | My Subscriptions | Help
Does anyone know how I can get Site Settings to be displayed?
Also I am using Windows Vista Ultimate & IE 7 - I run IE7 as Administrator
I want to be able to view site settings in Report Manager, but when I connect to http://localhost/Reports in the upper right all that is shown is:
Home | My Subscriptions | Help
Does anyone know how I can get Site Settings to be displayed? example -> site settings
Installed SQL Server 2008 with Reporting Services to a Windows Server 2008 box. Tried to open the Report Manager and had no tabs and no Site Settings link - just a blank home page. I am logged onto the server with local administrator rights, so it shouldn't be a permissions issue.
Thinking the installation was bad (IIS was not installed before installing SSRS), I uninstalled and re-installed SSRS after setting up IIS 7 on the server. Still the same issue - just a blank home page in report manager with no ability to add users or assign roles or see anything except the links for "Home", "My Subscriptions", and "Help".
SMSS installed on my client forgets all the settings I entered under tools / options.maybe it has something to do with installation of system updates.
View 0 Replies View RelatedI am trying to reproduce a problem that is probably related to how a particular SQL server is configured. Is there a tool or best practice that is useful to compare all of the configuration settings between two SQL Servers (same version)?
View 2 Replies View RelatedEach 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...
I have a VM set up for offloading DBCC checks. Specs are below. I've read through this, but I'm not seeing the performance gains by enabling the trace flags and using the physical only switch.
Is the whole drawback that I'm on SATA storage? Is there a VM configuration with the CPU I can/should change? I've been playing with MAXDOP trying to see if I can get any benefits but I'm not seeing a much.
wait_type wait_time_spctrunning_pct
CXPACKET 561191.4228.7128.71
OLEDB 387136.7619.8148.52
PAGEIOLATCH_SH 340674.5817.4365.95
TRACEWRITE 321598.8416.4682.41
[code].....
We have a new set up on VM to run an application running 24*7 (migrated from SQL server 2008R2) with below configs:
1. OS- Windows server 2012 Standard 64 bit hosted on Virtual Machine
2. Memory 16 GB and Cores =4 with 2.4GhZ processor
3. SQL server 2012 SP2 , 64 bit Standard edition.
4. Total size of databases as of now 15 GB with biggest being 5 GB.
How should i go around in setting the MAX and MIN server memory settings. I have this set up for many of SQL 2005 and 2008R2 servers, but for 2012 i heard that things has slightly changed.Â
How should i start analyzing and setting the right value of this MAX and MIN?
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?
View 4 Replies View RelatedGuys,
can you guys pls let me know how do you access sql server configuration manager from command line?
Thanks
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).
Thanks for any information.
Hi,
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.?
Thanks for any advice
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.
Thanks
Trying to setup local server agent.
SQL Server Configuration Manager---->SQL Server 2005 Services-->Nothing showed up??? No single items there.
So strange, Anyone could tell me what is wrong with this.
2005 Developer Ed
Windows Xp professional 32 I guess.
I am currently designing a SSIS package that will migrate data from Syabse to Sql server. If these packages are to be deployed to file system (as this is one time run for migrating data) or to SSIS catalog or to Sql server.
Also, I have not changed the default protection level value in packages during design time and would like to know if I have to change it while handling the deployment using DTutil (yes, i need to deploy & execute using command line utilities).
Please note that I do not have access to PROD, UAT environments and deployment team will use my BAT file that is expected to deploy and execute the packages.
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."
View 10 Replies View RelatedHi, 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.
The error messages in the logfile are these:
event
OnError
computer
ComputerName
operator
NT AUTHORITYSYSTEM
source
Execute SQL Task PLSQL
sourceid
{B29C4FC9-3345-4657-8680-F770B8C2E136}
executionid
{7312A7EC-2555-4268-BB29-38659507BADD}
starttime
14/04/2006 16:40
endtime
14/04/2006 16:40
datacode
-1073573396
databytes
0x
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? ...