SQL Server Configuration Manager: SSL And Multiple Instances Problem
Mar 31, 2008
Hi
We are trying to setup a number of SQL Server 2005 database instances on a single server. The server has multiple IP addresses bound to its network interface (card). Each instance is configured to listen on a specific (unique) port on 127.0.0.1 and port 1433 on a specific (unique) IP address configured on the network interface. Finally, there is another instance of SQL Server (which also has the Reporting Services, Analysis Services and Integration Services installed) that does not allow remote connections and has TCP/IP disabled.
SSL is configured for all instances, apart from the non-remote connections instance, as follows: The same self-signed certificate is specified for every instance. This certificate has been configured for all 127.0.0.1 ports and port 1433 on all IPs in use for any of the instances using httpcfg as documented. The Force Encryption option is enabled and the Hide Instance option is disabled.
All appears to work correctly, and the "The certificate was successfully loaded for encryption" message appears when sp_readerrorlog is run, for the instances it is supposed to. However, at some point a problem occurs. The Force Encryption and Hide Instance labels _disappear_ (leaving blank spaces in the grid) from the interface, with the drop-down settings still visible. This seems to happen after installing an additional instance, although on one occasion it was after the 3rd was installed and on another occasion the 4th. Uninstalling the instances (even all of them) does not seem to help - only removing SQL Server 2005 completely and re-installing allowed the labels to re-appear.
Another concern is that after problem occurs, it appears that the settings are not being interpreted correctly. Even if the certificate is disabled for an instance, the message "The certificate was successfully loaded for encryption" appears, instead of the instance using a self-signed certificate. Additionally, on some occasions, the values for the Force Encryption and Hide Instance are swapped (or at least the values in the positions that used to be inline with the labels for these options).
As an additional note, various IIS Web Sites are configured on each of the IPs on the network interface. These are also using the same self-signed certification for SSL and are all using port 443, which none of the SQL server instances are configured to use.
Any feedback or suggestions on this would be appreciated. Thanks.
View 1 Replies
ADVERTISEMENT
Sep 18, 2014
We are just finishing our migration to SQL 2012. In our old environment, the instance which held our SharePoint databases also served other applications. We did not experience any performance related issues in the past due to this.
SharePoint basically requires MAXDOP to be 1, which is correct on the old server. Since this configuration may not be ideal for other applications that may be put within our environment, we our entertaining the idea of isolating SharePoint into its own instance, probably on the same box.
My manager wants me to come up with performance trace data to better prove that we need to go this route since we apparently have had issues in the past by blindly following Microsoft's best practices.
1.MAXDOP configuration - I understand this may be a 2 pronged approach that would require looking at various execution plans and CPU related counters in Perfmon. SharePoint likely requires a maxdop of 1 due to the nature of the application (lots of concurrent processes). What is the best way to show this need graphically?
2. Memory configuration for multiple instances - Does the Total Server Memory reveal all the memory that a given SQL instance is utilizing? Should I use this counter to identify appropriate min/max memory configurations for multiple instances on a single cluster?
The problem with the perfmon approach is that it's scope is limited to just the server. Since our SharePoint environment is currently being shared with other applications, I understand that I may have to utilize DMV statistics to narrow down my analysis.
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
Dec 3, 2007
Hi,
I think this is a question for the specialists among us.
Can I use one general reporting server (installed on instance MAINREPORTING)
for multiple customers who all have their own sql instance (CUST1, CUST2, CUST3, ..)
I would use UserAuthenciation on the reportserver url to display the specific reports customers can use.
Is this possible, and what do i have to take care off concerning installation and/or configuration (especially on
the reporting side) ?
Greetings
Vinnie
View 3 Replies
View Related
Feb 16, 2007
I am working on a site's SQL Server 2000 database on a W2k3 machine . I went into Enterprise Manager and saw that their database resides on a named instance. I did not see the default instance listed so I registered that using windows authentication. I noticed that the default instance had a user database that had the same name as the user database on the named instance that I was to work on. I looked at the properties of the databases and saw that on both the default and named instances of SQL Server that the Data Files and Log Files for the user database point to the same location.
Is this a problem? Can anyone see any issues with this? Does this mean that someone can simply connect to the named or the default instance of the SQL Server and connect to the same database?
Kirk
View 1 Replies
View Related
Feb 26, 2008
Hi, i have created a database in business contact manager which is currently been used by five toher employees. I was trying to move that database to my server. Well I found this tool online called "Business contact manager 2007 database tool". I am trying to run it on the server but it is giving me a following error:
"Cannot retrive the list of SQL Server instances. Please make sure that SQL Server 2005 or SQL 2005 Express is installed and that the service is running."
I have SQL 2005 installed on my computer and I dont have any idea how to resolve this issue. It would be great if someone could help me.
View 1 Replies
View Related
Apr 27, 2006
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.
View 3 Replies
View Related
Jun 6, 2008
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 Related
May 25, 2007
Guys,
can you guys pls let me know how do you access sql server configuration manager from command line?
Thanks
View 1 Replies
View Related
May 2, 2007
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
View 5 Replies
View Related
May 23, 2006
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.
View 1 Replies
View Related
Sep 5, 2007
when i open services in the computer management console i get the error message
sql server configuration manager .... error... snap in...restart mmc
View 2 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
Dec 5, 2007
SQL Server 2005 (9.00.3042.00)
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?
View 5 Replies
View Related
May 22, 2008
I cannot find sql server configuration manager installed in cluster. but the installation is complete. what should i do
View 4 Replies
View Related
May 22, 2001
I am running SQL 7.0 as the default instance and SQL 2K as a named instance. Each is using a different port....7.0 is using port 1433 and 2K is using 1024. Everything appears to be up and running fine on the server. However, I am not able to access the 2K instance from a client. I have tried to use both TCP IP and named pipes setting them up using the server network utility and the client network utility. No luck anywhere. I continue to get connection errors...check network documentation...
ANY IDEAS??????
View 3 Replies
View Related
May 8, 2008
Is there any limit on SQL server Multiple Instances? if we require to run 60+ Instances on single machine what will be the minimum hardware requirements.
View 3 Replies
View Related
May 12, 2002
Dear Listers,
1.) Is it possible to install Analysis Services on multiple SQL Server 2000 instances? If it is, then can you instruct me as to how to perform the install. If it is not possible, then does one restrict access to cube data via the Database Role Manager?
ie. The host box is - DOILAB30 with Analysis Services & SP2
Instance - DOILAB30/DOILAB30_FIN (Can AS be installed here?)
Do I severely restrict the membership of OLAP Admins?
2). Re. AS maintenance. - How do I backup and restore OLAP dbs/cubes etc. Following a restore, what issues, such as cube users/permissions should I be aware of? (if any).
TIA
John
View 1 Replies
View Related
May 31, 2007
Hello,
There are several instances in SQL Server. I use RDA method to access SQL Server from mobile devices. But RDA method only gets the server IP,not the instance name. So, how can I define RDA to access to the instance that I need?
View 3 Replies
View Related
Dec 17, 2007
Hello all,
I am trying to built a general demo machine for our multiple resellers.
Is it possible to have multiple database instances (one per reseller) with each of them their own reporting instance, running on the same server (also same IIS). In our DNS and in the IIS settings i will reroute the specific reseller to his specific reporting url (eg: http://www.demosite.reseller1.com/reports (this is not a real url), will be rerouted via dns to the
specific reporting url for reseller one ... and so on.)
Each reseller must be able to has it own reports, subscriptions, models and access to reportbuilder.
Can this be accomplished ?
I have tried already a few times but get stuck when i want to upload reports/datasources to the specific websites. Also i have encountered the fact that if i succeed in uploading data to one reporting site and i want to upload different data to
another site, the initial site is also changed with the data of the second upload.
Can anyone point me into the right direction how to solve this problem .
Greetings
Vinnie
View 7 Replies
View Related
Jan 25, 2008
When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace
What is the problem and how to solve it.
View 1 Replies
View Related
Sep 2, 2006
I have just installed SQL 2005 enterprise and every apeared to install ok. But using SQL config manager nothing is showing up under SQL 2005 Services tab.
Anyone got any ideas?
View 1 Replies
View Related
Oct 29, 2007
Hi all,
Can a MIRROR server have mirrored databases on many instances or must all of the mirrored databases on a server reside on one instance?
This initial implementation worked fine:
PRINCIPAL ServerPROD1instance01 endpoint1430
MIRROR ServerDRinstance01 endpoint1440
WITNESS ServerZ endpoint1450
This second implementation (different PRINCIPAL server to same MIRROR but to a different instance)
PRINCIPAL ServerPROD2instance5 endpoint1430
MIRROR ServerDRinstance02 endpoint1440 <<same mirror server but different instance
WITNESS ServerZ endpoint1450
I know that you can only install one endpoint on each server. Does that mean that the endpoint can only resolve to one instance though?
The second implementation looks fine until the final step (start mirroring). I get the following error:
An error occured while starting mirroring
Alter failed for database 'test'
An exception occurred while executing transaction-sql statement or batch
The remote copy of database 'test' does not exist. Check the database name and resissue the command
I have created the test database in instance02 and rolled a log onto it. It is currently in recovery mode - waiting patiently for another log.....
I have read books online and 2k5 unleashed but can't see anything that relates to an implementation across mutliple instances on the DRmirrored servers.
Has anyone tried to do this? Can you confirm its possible?
Many thanks in advance...
View 3 Replies
View Related
Aug 18, 2015
Is it possible to have more than one instance of SQL Server on a failover Active/Passive cluster? What are the concerns/ramifications if that indeed is possible?
View 4 Replies
View Related
Sep 18, 2007
Greetings... I'm working at consolidating several Reporting Services installations into one so we can decommission some old servers. We have two Report Servers that are in SQL Server 2000 and three that are in SQL Server 2005 (none are in a web farm configuration). I can upgrade the 2000 databases to 2005 format just fine, but now how do I merge these five ReportServer/ReportServerTempDB databases into one? I'm reluctant to redeploy reports to the "official" Report Server because we lose security, subscription, and scheduling information by doing that. So redeploy would cost us time and data loss over hundreds of reports, thus my hope to merge the databases at a data level. Is there a tool to automate this process, or has anyone tried this before? Thanks in advance.
Austin
View 8 Replies
View Related
Jun 18, 2014
I was told that if I wanted to setup mirroring between multiple instance on the same server that each endpoint had to be different number. Is that true? Or can I use the default 5022 for each instance?
Ex.
Server1Instance1
Use endpoint 5022
Server1Instance2
Use endpoint 5022
VS
Server1Instance1
Use endpoint 5022
Server1Instance2
Use endpoint 5023
View 4 Replies
View Related
May 18, 2015
i want to run a transaction across mulitpule instences of sqlserver with out linked server.
distributed trnasaction can do it with link server , can it do it with out linked server.
View 9 Replies
View Related
Jul 23, 2005
Hi,I'm having a problem running a distributed transaction between twolinked servers that both have multiple instances of SQL Serverinstalled on them. This is the error message that I receive:"The operation could not be performed because the OLE DB provider'SQLOLEDB' was unable to begin a distributed transaction.[OLE/DB provider returned message: New transaction cannot enlist in thespecified transaction coordinator. ]OLE DB error trace [OLE/DB Provider 'SQLOLEDB'ITransactionJoin::JoinTransaction returned 0x8004d00a]."The query follows the format:"BEGIN DISTRIBUTED TRANUPDATE [LINKEDSERVER1INSTANCE_NAME].DB.OWNER.TABLENAMESET fieldname = alias2.fieldnameFROM tablename alias2JOIN [LINKEDSERVER1INSTANCE_NAME].DB.OWNER.TABLENAME alias1on alias2.urn=alias1,urn"[color=blue]>From what I can gather from various sources the SQL Server must be[/color]named the same as the computer which it is installed on. However, if Ihave two instances of SQL Server, they cannot both be named the same asthe computer. Does anyone know of a way around this or whether I'mbarking up the wrong tree completely?Many thanks.
View 2 Replies
View Related
May 9, 2006
I have a website running under Windows Server 2003 which I am trying to deploy Reportin Services to using a custom security extension using Forms authentication. There is also another website which is just a Report Server running on this IIS 6.
On my development machine, XP with IIS 5.1, the Website with Reporting Services using forms authentication works fine, shares cookies for authentication and all that jazz. but trying to configure a second instance of Reporting Services on Server 2003 is not behaving.
Is there some trickery or details involved with running two instances of Reporting Services?
Also in the Configure Report Server tool it is failing and so not initializing on the last step of the Database Setup
Setting Connection Info for Reporting Server
ReportServicesConfigUI.WMIProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.
---> System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
--- End of inner exception stack trace ---
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)
View 1 Replies
View Related
Jul 13, 2015
I am currently having publisher(database A), subscriber (database B) and distributor on the same instance for a test environment that is using a uni directional transactional replication. Now I need to setup another unidirectional transactional replication in the same test instance but for a different database. Publisher database is D and subcsirber database is E.
View 4 Replies
View Related
Jan 31, 2008
I have a situation where I would like to set up one DB server instance for US and anther one for AUStralia. The Instance should share the same data base/hardsisk. One of the instances will be running in using US time zone and anothe one in Australia time zone.
There will be 2 Application instaces one poinint to each SQL Server instance. This applications does write into the database
So the underlying requirment is to have 2 database server running in differnet time zones but accessing the same disk/set of data
What is the best way to do this? Is it linked servers?Girish
View 3 Replies
View Related
May 10, 2006
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
View 5 Replies
View Related
May 1, 2015
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 Related
