Stack Overflow
Stack Overflow

Questions tagged [named-instance]

28 questions
154
votes
7 answers

SQL Server, convert a named instance to default instance?

I need to convert a named instance of SQL server 2005, to a default instance. Is there a way to do this without a reinstall? The problem is, 2 out of 6 of the developers, installed with a named instance. So its becoming a pain changing connection…
DevelopingChris
  • 39,797
  • 30
  • 87
  • 118
11
votes
2 answers

Use named instances for other instances

I'm trying to make a Semigroup and VerifiedSemigroup instance on my custom Bool datatype both on operator && and operator ||: %case data Lógico = Cierto | Falso (&&) : Lógico -> Lógico -> Lógico (&&) Cierto Cierto = Cierto (&&) _ _ = Falso (||) :…
chamini2
  • 2,820
  • 2
  • 24
  • 37
6
votes
1 answer

How can I create named-instance of Microsoft SQL Server on Ubuntu

I used the official tutorial to create a default instance https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ubuntu but now I want to create a named-instance and can't find how to do that
arielorvits
  • 5,235
  • 8
  • 36
  • 61
3
votes
3 answers

SQL - Connect to Linked Server with Named Instance

How do I connect to a named instance of a linked SQL server. If its not linked, I would do the following: ServerName.DatabaseName.dbo.TableName If it is linked, I would assume the following: ServerName\InstanceName.DatabaseName.dbo.TableName but…
Miles
  • 5,646
  • 18
  • 62
  • 86
3
votes
1 answer

structuremap does return named instance instead of default one

As the title says, structuremap does not return the default instance when i have also configured named instances. Here is my type registration: /// /// Initializes a new instance of the class. …
leozilla
  • 1,296
  • 2
  • 19
  • 29
3
votes
1 answer

SQL Server instance name with IP address

I have a very strange situation happening and I'm hoping someone here knows why. I have TCP/IP enabled for all ports on the default port 1433. All tests are consistent with SQL Server Management Studio and my program. This…
Net Citizen
  • 5,174
  • 8
  • 38
  • 50
3
votes
2 answers

Connecting to SQL Server Named Instance from Windows 64bit

I have both java and .net applications running on an app server using Microsoft Windows Server 2003, Enterprise Edition. These are being migrated to another app server Windows 2008 64-bit machine. All applications connect to the same SQL Server…
Lost In Code
  • 494
  • 1
  • 5
  • 18
2
votes
2 answers

How to retrieve the names of all the named instances in StructureMap

In my application I have the IPolicy interface and a number of concrete implementations. Let's say BasicPolicy and AdvancedPolicy. I configure the StructureMap container by adding named instances like so: class MyRegistry : Registry { public…
Pavel Bastov
  • 6,911
  • 7
  • 39
  • 48
2
votes
1 answer

Cannot connect to a SQL Server 2008 named instance hosted in a azure virtual machine

When I try to connect to a named instance in a SQL Server hosted in a Azure VM, I get this message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not…
Eduardo Mardini
  • 21
  • 1
  • 3
1
vote
1 answer

Redirect all connections to new SQL Server instance

I need to migrate a SQL database to a new server. All applications access the old SQL Server with a named instance SQLA\InstOld. Now the new SQL instance is at SQLB\InstNew. I don´t like to change all applications/clients, as in the past the…
KKRohr
  • 11
  • 1
1
vote
0 answers

Structure map automatically resolve instance by name

My problems is that I want to register two types for one interface: I've checked this…
mihkov
  • 1,171
  • 13
  • 37
1
vote
2 answers

how connect to mssql named instance

I connected remote mssql default instance like jdbc.url=jdbc:jtds:sqlserver://ip:port;databaseName=name it succeed to connect and proceed in java source I connected remote mssql named instance…
LimSangWon
  • 11
  • 2
1
vote
1 answer

Autofac Named Instance - Define Default Instance if Not Found

I'm using Autofac to register named instances. I have to translate xml transactions into objects. First, I have an enum. public enum TransactionType { Unknown = 0, [XmlNode("MyNodeA")] TypeA = 1, [XmlNode("MyNodeA")] TypeB =…
Josh
  • 16,286
  • 25
  • 113
  • 158
1
vote
1 answer

Structuremap Open Generic named instances

I must do the following: var someType = ObjectFactory.GetNamedInstance("myNamedInstance"); where someType can be any implementation of ICommand. so I registered some of…
Luka
  • 4,075
  • 3
  • 35
  • 61
1
vote
0 answers

Create default instance of SQL Server 2008 while already having named instance

I want to setup default instance of SQL Server while I already have setup named SQLServer instance while installing SQL Server 2008 and SQL Server Management Studio. How do I do that?
WAQ
  • 2,556
  • 6
  • 45
  • 86
1
2