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


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

OWC11 Nightmare!!! Can't Install Named Instance

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server
 
I'm being driven demented by OWC11! Please help before they take me away! I'm trying to install a new named instance of SQL 2005 Enterprise 64 bit on a box which already has a default instance patched to SP3.

Setup barfs at the OWC11 stage and it complains about missing files I can't even find in the installation media. I have absolutely no idea what to do now. I tried uninstalling / reinstalling OWC11 but to no avail.

My boss thinks installing a new instance is simple and he'll think I'm an idiot if I can't resolve this. He may be right of course but I'm stuck.

Is this a bug? Sure smells like one. Will this go away at SQL 2008?

Sorry to dump a lot of text but here's the OWC setup log -

=== Verbose logging started: 22/09/2010 19:32:47 Build type: SHIP UNICODE 3.01.4000.4042 Calling process: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe ===
MSI (c) (0C:B4) [19:32:47:199]: Resetting cached policy values
MSI (c) (0C:B4) [19:32:47:199]: Machine policy value 'Debug' is 0
MSI (c) (0C:B4) [19:32:47:199]: ******* RunEngine:
******* Product: ******* Action:
******* CommandLine: **********
MSI (c) (0C:B4) [19:32:47:215]: Client-side and UI is none or basic: Running entire install on the serv


View Complete Post


More Related Resource Links

named instance sql server 2008 install on cluster

  
I have a production two-node cluster with sql server 2008 sp1 cu7 running over windows server 2008 sp2. If I were to install a new named instance on this live environment, would it impair the default sql server instance functionality? I'm not referring to processor/io while the install is in progress. My question specifically is would the install process by its nature bring down the default instance. I'm pretty sure it won't, but don't see any documentation that would confirm this. thanks.

Issue with contacting named instance

  
Hi. I'm having problem with connecting to the named instance of SQL Server. The machine runs Windows 2008 x64 and SQL Server 2008 Std SP1+CU7. It holds 3 instances of service: default, and 2 named ones. We have 2 networks in our company. All instances can be contacted from the 1st localization (the one, which is local to the SQL), but the named instance cannot be contacted form the remote localization. What's amazing, users can connect to the default instance, but when they try to reach the named one, they receive message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "Remote" users have permissions to the named instance - I've given them sysadmins to test, they can ping the SQL box and all works fine from the "local" network. Client is Win7+SSMS 2008. Please help.

Specify Instance Port Number on Command Line Install

  
Is there a way to specify which port we want our named SQL Express instance to run on during a command line install with no interaction from the user?  If not, is there a way we can change the dynamic port selected after the install without any user interaction?Nick's Programming Tips

Best Practices for WPF Single Instance with named pipes?

  
Hi, I've developed a WPF server-hub-typed application, and a bunch of client-typed applications. The hub app is always a single instance (using mutex), and implements named pipes.   However, I'm having problem with the clients. The clients are applications that send data to the hub. They need to start the hub if it is not already running.   The problem with these clients is, they are optional and portable. Hence, the user might store them in different locations on their system. I really do not wish to deploy the Hub application with every client. What's the best way for me to implement this?   Another thing, do I *have* to use Process.Start(path, args) to start my hub application?    I've attached a sample project that I've done. But there are several problems with it, which I've not figured out how to fix. http://www.sendspace.com/file/ykhdg0   Thanks Min Chew   [References I've used:] http://blogs.microsoft.co.il/blogs/maxim/archive/2010/02/13/single-instance-application-manager.aspx <-- This is the one that seems the most promising (single instance + IPC), but I want a bare-minimum example so I can get a better hang on things. Besides, it crashes when I click on any of the 3 Run buttons http://www.switchonthecode.com/tutorials/wcf-tutorial-basic-interprocess-communication <-- Named pipe IPC using wcf http://www.switchonthec

SQL Server 2005 Standard edition install fails; An instance with the same name.../

  

Good Morning

I am trying to install SQL Server 2005 onto Windows Server 2003 Small Business Edition. Previously SQL Server 2000 from the SBE disk was installed, automatic updates are enabled.

I have selected the default instance and everything I try results in the error:

An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

Log file says;

--------------------------------------------------------------------------------
Machine         : ISAINTERNET
Product         : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_ISAINTERNET_SQL.log
Last Action     : DetectInstanceClash
Error String    : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Error Number    : 28086
--------------------------------------------------------------------------------

Ian Smith


[.Net 4, Named Pipes, Single-instance app] Critique the code, please

  

The code below is a prototype of single-instance component. Of course there's a lot of work to get it done: separate into an component, add different names per user session, run server in background thread and so on and so on.

Currently, I'm interested in finding wrong options supplied, invalid usages, security holes or anything I missed. E.g. I'm almost sure there's a bug: the code allows for remote connections. I'll prove it on monday, as I've no access to local network for now.

using System;
using System.IO;
using System.IO.Pipes;
using System.Security.AccessControl;
using System.Security.Principal;

namespace ProcessSingleInstance
{
 class Program
 {
  static void Main(string[] args)
  {
   string[] data = new[] { "a", "aaaaa", "qweqeqweqeqweqwert" };

   

How to Install MSDTC on a multi Instance SQL Server Fail OverCluster (SQL 2005 & Windows 2003 R2 x64

  

I am installing 2 SQL instances on a fail over cluster.

Currently I have my Quorum and DTC resources on the default Group and the 2 sql instances on 2 other groups.

In this way would the DTC resource  be available for both the SQL groups or is there any other way i should go about doing this ?


Can't install SP1 on SQL 2008 express default instance

  

I have SQL Express instaled as the machine default instance name MSSQLSERVER.  When I run Express SP1 setup and choose that instance, it won't let me select any features to install.  Presumably this is because it thinks my instance is not express because of the instance name.  Is there a workaround for this behavior?

TIA,
Josh


Install Requirement - The instance name is arbitrary and was created when Microsoft SQL Server was i

  

On this Technet Article http://technet.microsoft.com/en-us/library/ee662513.aspx related to service account permissions during install there is this requirement mentioned: "The instance name is arbitrary and was created when Microsoft SQL Server was installed."

Does anyone know why the instance needs to be created when SQL Server is installed as opposed to later after SQL Server is already installed?


Where can I find my named instance inside SQL server 2008?

  
I am looking for the connection string on my Visual Basic Program. My problem is I forgot what named instance I gave my SQL server 2008 when I loaded it. Where can I find the NAMED INSTANCE inside my SQL server?

Adding named instance of SQL Server 2005 failed - "Error Locating Server/Instance Specified"

  

We are trying to add a named instance to our Windows 2003 R2 x64 SP1/SQL Server 2005 SP3 server.  It has been running for about 3 years now with a single (default) instance.  When trying to add a named instance, it fails when it gets to the point where it is Updating System Databases - "SQL Server Setup could not connect to the database service for server configuration.  The error was:[Microsoft][SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Refer to server error logs..."  We are using the local service account for both the default and new named instance.  Allow Remote Connections to This Server is enabled on the default instance. 

In Services, the new SQL Server service has started, but I cannot start the SQL Server Agent - it says it started and then stopped.  I cannot access the instance with SMS.  I rebooted the server and tried the process again with identical results.  I have successfully added a new instance to my test SQL Server using the same install files. Can anyone shed some light in this issue?  Thanks.


Feature Install/Activation not creating List Instance

  

I have created a feature that includes a form template, two list templates (one for a doc library that uses the form and another for a custom task list template), and two list instances.  The idea is that I want installation/activation of the feature to create and register the form template, to set up the two list templates, and then to create an instance of each list template (i.e. a Doc Library and a Task List based on my templates).

The feature installs fine, and all templates are created.  However, no instances are created.  Best I can tell I have the required XML files set up as required.  There are no errors that I've been able to isolate in the SharePoint logs.

Anyone have any ideas why I might not be getting the list instances?  Below are my XMLs...

FEATURE.XML:

<?xml version="1.0" encoding="utf-8" 

How to access named instance

  

I have a SQL 2008R2 server with a default instance. I just installed a 2nd instance - named API02. I log into the SQL server with Management Studio but don't see the 2nd instance. How can I access this?

Thanks,

Scott


Issue to install a new instance SQL Server 2008 SP1

  

Hi,

I have an issue when I want to install a new instance SQL Server 2008 on server which already contains 2 instances.

My screen is blocked on the step "Feature Selection". So I noticed when I compared both logs one of a correct installation and my installation log some differences (below the log of the file detail.txt)

"

Log of my installation KO
--------------------------
2010-11-12 18:36:43 Slp: Package ID sql_tools_Cpu64: match result for Discovery - Version: True, Cpu: False, Language: True
2010-11-12 18:36:43 Slp: Package ID sql_tools_Cpu64: match result for Discovery - Version: True, Cpu: False, Language: True
2010-11-12 18:36:43 Slp: Package ID sql_tools_Cpu64: match result for Discovery - Version: True, Cpu: False, Language: True
2010-11-12 18:36:43 Slp: Package ID sql_tools_Cpu64: match result for Discovery - Version: True, Cpu: False, Language: True
2010-11-12 18:36:43 Slp: Package ID sql_tools_Cpu64: NotInstalled - Package was found but determined as NotInstalled because at least one of C


Log of an installation OK
--------------------------
2010-08-26 15:19:09 Slp: Package ID sql_tools_Cpu64: Installed - Version: 10.1.2531.0

*********

Log of my installation KO
--------------------------
2010-11-12 18:36:43 Slp: Package ID sql_tools_loc_Cpu

Replication over VPN to a named instance

  

hello,

I'm trying to make a replication between to sql servers on vpn, and the following are what I tried:
- first I created aliases on two sql servers, lets say XXX and YYY ... the aliases are the same as the servers machine name
- I created the publication on XXX and the subscribers would be on YYY
- on YYY there are two instances ... the default is sql server 2005 and the named one (lets say ABC) is 2008
- when I made the replication between XXX and the default instance on  YYY, it worked fine and everything is ok
- but when I tried to make the replication to YYY\ABC,   I got the following error: 

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)"

- so I tried to just connect to YYY\ABC from Microsoft SQL Server Management Studio on XXX, and I got the same error
- I tried again using the IP address of YYY ... as for example 192.168.100.5\ABC, but this time I could access !

 

can anybody tell me what is the problem when I use the server name wi

install another instance of sql 2005 express

  

how do i create another instance (for WSUS) using sql 2005 express onto my server that already has an existing instance setup and running (for Acronis backups)

 


mining model will not process on a named instance of SS 2005

  

What should be done if the error message is received:

OLE DB connection error

"make sure SQL Browser service is running on localhost"

?

My Browser service is running but it's on a named instance, not localhost.

My cube won't process (although I can browse it), neither will the mining model I've developed.

I've searched throughout the code but can't find any explicit reference to browser service. Where is the localhost specification appearing in the processing (either of the cube or the mining model)?

Are there any known fixes for this problem?

Thanks so much!
Laura

 


Categories: 
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