.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Post New Web Links

Different SQL Server instances on one server

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
Good afternoon. I have a Windows Server 2003 with SP2 loaded. On it I have SQL Server 2000 - 8.00.760 SP3 Developer Edition along with SQL Server 2005 - 9.00.1399.06 RTM Developer Edition. Can I also install an instance of SQL Server 2008 on this server without cauing a problem with the otherSQL instances? Thank you.

View Complete Post

More Related Resource Links

Network failure in Cluster Environment,will it stop the SQL Server Instances?

Hi All I have problem with cluster Environment that is there is network failure in Cluster Environment,will it stop SQL Server Instances Event viewrer Information 6:22:09 The MSSQLSERVER service entered the stopped state. 6:22:05 The MSSQLSERVER service was successfully sent a stop control. 6:22:04 The SQLSERVERAGENT service entered the stopped state. 6:21:43 The node lost communication with cluster node 'MSSQL0002' on network 'LAN'. 6:22:02 The SQLSERVERAGENT service was successfully sent a stop control. 6:22:02 Cluster resource 'SQL IP Address1(SQLCLUSTER)' in Resource Group 'SQL' failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 Cluster network 'LAN' is operational (up). All available server cluster nodes attached to the network can communicate using it. 6:21:58 The interface for cluster node 'MSSQL0002' on network 'LAN' failed. If the condition persist

Detect other versions of SQL Server, or SQL server instances on a computer

Hi All, I want to detect other versions of SQL Server, or SQL server instances on a computer. I used the recommended Microsoft C# example by using the SQL Server Windows® Management Instrumentation (WMI) provider. http://msdn.microsoft.com/he-il/library/dd981032(en-us,SQL.100).aspx SQL server 2005 has been correctly identified on my PC with Windows 7 64 bit OS. Then I uninstalled the SQLserver and all its tools/components. But even after uninstall the utility detects the SQL server 2005 as if it was not removed. What is an alternative for the correct detection of the SQL server installed on PC? Thanks in advance Dmitry

SSRS2005: Is it safe to manually remove instances from the Keys table in the report server database?

I have a problem with redundant reporting services instances still hanging around in the initialization pane of the RS configuration wizard and I can't get rid of them. The problem arose when we had new webfarms and before I had removed all references to the old ones from the initialization screen, the old webfarms had been switched off, removed from the network and dismantled. Therefore when I try to 'de-initialize' them, I get an error stating that reporting services cannot connect to them and when I run reports, a fair few are trying to run on the old webfarms which no longer exist and are disappearing into the void. There's a table in the report server database called Keys whch contains details of these intances and i'm wondering if its safe to remove these via SQL commands without breaking reporting services on other machines.   As a side note: All this stems from the fact that when you uninstall Reporting Services, not all of the files / references are removed. So as a general word of warning, if you do an uninstall of RS2005, you'll need to make sure everything's gone before re-installing, throwing away old machines etc. These include folders in IIS and these old instances as mentioned above.  

Can I have two instances (SQL 2005 - 2008) at the same server?

Hello, I have a Windows 2008 R2 with sql server 2005 x64. I would like to have both instances (SQL server 2005 x64 and 2008 x64) at the same server, each one having its own databases. Is the possible? What should I pay attention to? Thank youChristos

Rebooting one Instance on a SQL 2008 Server with multiple instances installed

Hello, Hoping someone can answer the following questions ... If I have SQL Server 2008 with multiple Named Instances configured on it, can I reboot one Named Instance without rebooting any of the other Named Instances, or without having to reboot the entire server ? For example, if I have an application that needs to be re-booted and it requires the Database to be re-booted. Regards, JD

Installing multiple instances of SQL Server R2 creates permissions issues - first instance won't st

After installing two named instances of SQL Server 2008 R2 DataCenter edition (R2D2 and C3P0) I found the first instance would no longer start.  The errorlog showed the reason to be an invalid path. 2010-09-14 18:15:39.12 Server      Error: 17113, Severity: 16, State: 1. 2010-09-14 18:15:39.12 Server      Error 3(The system cannot find the path specified.) occurred while opening file 'C:\MSSQL\SQLDAT\MSSQL10_50.R2D2\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary. Finding the files in the proper location I check the ACLs and found the Local Group created for the second instance on the ACL for the first instance.  That is to say for instance R2D2 I found MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$C3P0 instead of the MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$R2D2 that was originally there. C:\MSSQL\SQLDAT\MSSQL10_50.R2D2\MSSQL\DATA>icacls master.mdf master.mdf NT AUTHORITY\SYSTEM:(F)            BUILTIN\Administrators:(F)            MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$C3P0:(F) It seems that creating the second instance causes this problem.  I have been u

bootstrapping config process when there are two instances on server!


Have a package (several actually) that first reads c:\apps\config\mypackage.dtsconfig.  This sets the servername and catalog for my database and the main bunch of config values from an SSISConfigurations table.  Let's make believe we just *have* to use that table to hold the real config values.  Well, this all worked fine until they decided to put a second "test" environment on the dev server.  When a package is loaded in the test environment, it should use the test instance, etc.  But it shares the c:\apps\config folder with the other instance!  So now, I have trouble (at least) bootstrapping the configs into the proper environment.  This is SQL 2008, btw, which seems to be extremely important as to the order in which configs are applied.


Has anybody dealt with this?

I think I can squeeze through here as long as I only have to finagle this in dev/test, and production only has a single instance.  Do you see why?

Of course the goal here is to let the package configure correctly without opening it up and changing stored values just to move between environments.

Help!  and TIA,


ps - yes it would be nice if you could put a "p

Multiple instances - max server memory setting?

Please let me know any practical guidelines of max server memory setting if you have multiple instances on the same box. Brand new server and not much of historical data available. What are some safe guidelines and tweaking instructions?

Error opening site using SPSite and SPWeb instances using VS 2010, Win Server 2008 R2


Hi I am trying to open my site using SPSite and SPWeb instances and getting an error message as below-

The Web application at http://url could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

  CODE is -



                    SPSite siteCOll = new SPSite(siteURL);

                    SPWeb oWeb = siteCOll.OpenWeb("url");



I can access site using browser perfectly.

I am running VS as administrator.

I have done permission checking aswell.


please help!





Three instances of SQL server

can I install one instance SQL server 2008 and two instances SQl server 2008 express on the one computer (Windwos server 2008 standard)?
Thank You

Enable User Instances in SQL Server


I'm just starting out and trying to connect to my first database using the following string:

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RFPdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True

I get the following error during debug:

"Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."

I've done this on every database - Master, Model, Tempdb, etc, and my database.

Still get the error.  I may not be enabling it correctly.  Any help would be appreciated.

The documentation suggests that I use user instances so that users without Admin rights can work with the database.  Add, delete, edit data.  Is this true?


Multiple SQL Server installations on different machines vs multiple instances



i've got a question concerning the topology of SQL Servers in a enterprise. Until now we had a single SQL Server to serve the need of user databases throughout the enerprise.
Now were facing a change of our infastructure: The servers will be moved to a Hyper-V machine and we are going to install some application servers, that need SQL Server as backend: SharePoint, System Center Essentials, Data Protection Manager. At least one, DPM, says it is to be designed to run on a dedicated server controlling its own SQL Server.
Now we think of giving each of this servers its own SQL Server. Is this a way to go? Or is it absolute nonsense? Should we try to force all the servers to use named instances on a single SQL Server? Sometimes i have the feeling that SQL Server becomes a part of the OS, so just install it and let the application (SharePoint, DPM, you name it) take over control.

Any advice or opinion is highly appreciated.

Thank you,


Query the names and number of instances on a different server



I was wondering is it possible to use a query on one instance that (perhaps using linked servers) quieries another server to ask what instances are installed on it. 

Is this possible in SQL Server or do I need to use an external method?


reusable classes for multiple server instances


Hi All:
I have a requirement to create a Reusable Database Class which supports multiple server instances of a replicated databse.  The pool of databases should be managed in a config file or wherever you think is best and the class should simply rotate through the list of servers. Also, A Resuable Error Handling class which is used by the database class. 
Please note that this a web application so all errors need to be raised back up to the caller and eventually redirect to a page which displays the error number and error message.  The error class should also support custom error numbers and descriptions which are managed internally in the .net app in a config file.

SQL 2008 Server SP1 Updating to SQL 2008 SP2 - No Instances Found


Currently Running Specs

OS: Windows 2008 R2 Standard Server 64bit
SQL: SQL 2008 Server Service Pack 1 64bit
SQL Query:SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Returns:  10.0.2531    SP1    Standard Edition

Logged in as Administrator

1. I downloaded SQL 2008 SP2 64bit - SQLServer2008SP2-KB2285068-x-64-ENU
2. Ran the setup
3. Passes the System Configuration Check
4. Accept License
5. Select Features - PROBLEM - Greyed Out - Only Shared Features shows up with SQL Server Books Online and SQL Client Connectivity SDK
6. If i click Next - i get the following message
There are NO SQL Server instances or shared features that can be updated on this computer

I looked in the C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\summary.txt

and this is a section of the results

I noticed that the Full Text Search is of a value less than sp1 like the other engines

could this be why the update isn't working?

If so how can i get around it -

Product features discovered:
  Product              Instance             Instance ID   &nb

How to find SQL Server instances installed?


Hi there.

I want to connect to database from my application.

I dont't know what's the name of installed instance of sql server 2005.

I tried pcname and (local) and local host ...

How can I aquire the name?

SQL Server Express 2005 Installation Fails when No Instances of Express Qualify


Windows update wants to install KB 2463332 for SQL Server Express 2005, however I have no instances of Express 2005 that qualify for the update. Please see summary of installation that follows.  I have manually installed KB 2463332 for the SQL Server 2005 instances and the update finished successfully - all instances of SQL Server 2005 have been updated, but KB 2463332 will not update the SQL Server 2005 Express instances. Why do my SQL Server Express instances not qualify? How do I get rid of this annoyance? Is there a registry entry that needs to be modified to keep this from recurring? Why is Windows Update trying to apply an update for a product with no qualifying instances? Can anybody please point me in the right direction.

Time: 03/31/2011 16:04:13.171
KB Number: KB2463332
Machine: CRAY-6Q344J1
OS Version: Microsoft Windows XP Professional Service Pack 3 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 4
Package Version: 5000
Command-line parameters specified:
Cluster Installation: No

Prerequisites Check & Status
SQLSupport: Passed

Products Detected  &n

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend