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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Issue with contacting named instance

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
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.

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.

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

Issue Adding a new Lookup Field to an existing List Instance

I have a code base that houses all of the column, content types, template, and list instance definitions. Am using the Update functionlaity a lot from version to version. Has been working well to this point. I just added two new columns (fields), one a Lookup and the other a Multi-Lookup. The fields are added fine on the update, columns look correct and the content type to which these were added also look fine. I can create a new List instance from the content type, and the new lookup columns are fine. The problem is this. Any existing list instances that were created from this same content type, now blow up when I try and access list items via the SP GUI. Something about a valid GUID, I dont't have the exect error anymore, but will repost it when I recreate the issue for the tenth time. I tried deleting the new lookup fields from this new list instance, thinking that I might be able to re-add them to fix the problem, but I get a new stack trace when I try and re-add them. Any hints on where I can start digging would be appreciated. I think I'll start with comparing the list instance schemas between an existing list and a newly created one.  

OWC11 Nightmare!!! Can't Install Named Instance

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

[.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" };


Issue with Named Set


Hey guys,

     I have an issue that I am experiencing with named sets. I have the following query for a report. We are trying to replace the filter with the named set Commented, which includes the exact same information at the calc level as the query without the cross join. However, the information returns 2 different data sets. The named set returns 2 records that do not meet the filter criteria.We believe it has something to do with the date dimension because the named set does not include it.

WITH MEMBER [Measures].[Prior Year Revenue] AS ([Measures].[True Cost Revenue], [Time Calculations].[Comparison].&[1])
                MEMBER [Measures].[VarianceToPriorYear] AS [Measures].[True Cost Revenue] - [Measures].[Prior Year Revenue]
                MEMBER [Measures].[VarianceToPriorYearPercent] AS [Measures].[VarianceToPriorYear] / [Measures].[Prior Year Revenue]
SELECT NON EMPTY { [Measures].[Forecast], [Measures].[True Cost Revenue vs Forecast], [Measures].[True Cost Revenue vs Forecast %], [Measures].[True Cost Revenue], [Measures].[Prior Year Revenue], [Measures].[VarianceToPriorYear], [Measures].[VarianceToPriorYearPercent] } ON COLUMNS,

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.

SQl Server Express 2008 connecting to instance issue


Hi all,

First time user here.

Need some advice on connecting to a database or instance. Keep getting error message when i try to connect to instance.

Error message when I try to connect to instance refers to veryfying that the instance name is correct and to also check that remote connections are enabled.

I just cant connect at all.

I have enabled TCP/IP in config manager tool for sql server.

I am trying to do this locally.

TCP/IP and shared name pipes is enabled.

How do I verify that the instance name is correct?

And one silly question I think, why dont I have sql browser service in Services?

Any help would be greatly appreciated.

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?



Issue to install a new instance SQL Server 2008 SP1



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



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\ABC, but this time I could access !


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

connectivity issue with local instance of sql server


hi everbody,

well for the last couple of days i have almost taken my head out to get this issue resolved.

but still i am no where. i have already referred to so many tips available online but still can't fix the prob.

i am trying to connect a C# ( .net 2005) program to connect to the  integrated sql server 2005 instance on my local computer.

i have got windows 7 home basic on my pc with .net frame work 2.0 sp2 and have also upgraded to sql server 2005 sp3 as per some online study.

i have also tried all these steps but still getting the error 40.

1. Check Whether the SQL Server is running or not.
Because the trial to connect to the stopped server may also cause this problem.

2. Check the name of the SQl Server.
For example, if we try to connect to SQL server using .NET application, for some SQL Server, the name of the server "localhost" works, but for some server, we may need to mention "(local)".

3. Check Whether the SQL Browser Service is running

4. Check Whether the TCP/IP is enabled for SQL Server Configuration

* Expand SQL Server Configuration Manager
* Enable TCP/IP

5. Firewall Settings

You may need to add the port of Sql server to the Firewall if it is other than the default port(1433).

Go to Control Panel | Win

SQLCF 3.5 SP2 Replication Issue: An instance of the SQL Server Reconciler error object cannot be cre

Hi, we have a desktop application synchronizing with our SQL server using merge replication via IIS6.

Previously we used SQL2005 Ent database server, SQLCF 3.5SP1 tools and runtime library were installed on IIS machine, the desktop application was compiled with SQLCF 3.5 SP1 runtime as well.

Last week we upgraded our server to SQL 2008 R2, the application has been broken since then.

We tried to upgrade to SQLCF 3.5 SP2 tools and runtime on IIS ==> didn't help
We tried to install SQLCF 3.5 SP2 on the desktop where the application running (but left the application unchanged) ==> didn't help

Could anybody here help me with this? Do I need to re-compile my application?

Here are some debug information:
SQLCESALOG.TXT: Thread=1284 RSCB=1 Command=SYNC Hr=00000000 Failed to use 10.0 error components. Exiting... 0

Impersonation and Access Tests Action Status ErrorCode
Impersonate User SUCCESS 0x0
ReadWriteDeleteMessageFile SUCCESS 0x0

SQL Server Compact Modules Test Module Status ErrorCode Version
sqlcerp35.dll SUCCESS 0x0 3.5.8080.0
sqlcesa35.dll SUCCESS 0x0 3.5.8080.0

Reconciler Test Reconciler Status ErrorCode
10.0 Database Reconciler SUCCESS 0x0
9.0 Database Reconciler SUCCESS 0x0

Any help would be appreci

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!




A better way to reference your wizard steps using named steps

Note: this article uses the plain vanilla but the concepts apply equally well to its popular counterpart .

By far the most common way that I see wizard steps reference in code snippets is by their index.
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