Questions tagged [named-instance]

28 questions
1
vote
1 answer

How to configure StructureMap to provide two separate instances of the same type for two arguments?

I have a situation, where the constructor of a class requires two instances of the same concrete type implementing an interface. This is to enable use of "Tasks" to run them in parallel to reduce time. The constructor code is like this: public…
1
vote
2 answers

Can I modify package.xml file in SQL bootstrapper to install a named SQL server instance

I want to use the SqlExpress2008 Bootstrapper for a new installation on Windows7, I do not want to use the default SQLEXPRESS Instance. I have attempted to edit the package.xml file located in: C:\Program Files\Microsoft…
jonmiddleton
  • 1,122
  • 14
  • 16
0
votes
1 answer

Autofac Named Services and Dynamic Instantiation not working

I have an object graph as, Client -> Handler -> HandlerSettings and my app has multiple Clients with different HandlerSettingss. // instances Client1 -> Handler1 -> HandlerSettings1 Client2 -> Handler2 -> HandlerSettings2 ... Autofac's dynamic…
hIpPy
  • 4,649
  • 6
  • 51
  • 65
0
votes
1 answer

Get SQL named instance name via PowerShell

I have a SQL Job that (among other things) manipulates some files in folders that are named after SQL Named Instances. Here's the relevant code within the SQL Job: EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Do Stuff',…
coinbird
  • 1,202
  • 4
  • 24
  • 44
0
votes
0 answers

Connecting to SQL Server Named Instance

I have a default instance of sqlserver running on my server. I installed a additional name instance. I can remote into the default instance from SSMS just fine but I cant connect to the named instance. When I try ti enable TCP/IP for the named…
Dblock247
  • 6,167
  • 10
  • 44
  • 66
0
votes
0 answers

Cant connect to named instance Sql Server(12.0.4457.0) from netcoreapp1.1

So I am having trouble connecting to sql server from ubuntu 14.0.4 with dotnetcore 1.1. It is one of those sql instances where it is like ipaddress\nameofinstance where leaving out nameofinstance leads you to a different instance of sql server.…
BillHaggerty
  • 6,157
  • 10
  • 35
  • 68
0
votes
0 answers

convert autofac to simple injector : named instance - WithParameter

I Want to convert from Autofac to Simple Injector... My problem is set Named instance and set WithParameter in Simple Injector.. this is the autofac code : //cache managers if (config.RedisCachingEnabled) { …
0
votes
0 answers

Powershell Script Issue with SQL Server 2012/2014

I have a PowerShell script which works well when I run it on server with SQL Server default instance (MSSQLSERVER) but the same script fails on a server with a named instance (MSSQL$instance) For the default instance…
Viral
  • 21
  • 5
0
votes
3 answers

JDBC conncetion string using WindowsAuth to SQLS2014 named instance

How should I write my connection string in jdbc when I want to connect to a SQL server where windows authentication is needed and I am connecting to a named instance? So I have my connection string like…
Yantes
  • 251
  • 3
  • 18
0
votes
1 answer

How to swap StructureMap named instance?

Sample code: public interface IMyClass { string Name { get; set; } } public class MyClass : IMyClass { public string Name { get; set; } } public static class Program { public static void Main() { var container = new…
0
votes
1 answer

Can Not connect to Remote SQL server named instance with port

Hi All We have a server where we have sql server 2008 as well as SQL server 2005 hosted on port 1444. Using SSMS, I am able to connect to 2008 instance without any problem. But when I try to connect to 2005 instance using following connection…
Mahesh
  • 982
  • 8
  • 20
0
votes
2 answers

How to configure SQL Server named instance in IBM Websphere application server

Can anyone help me in configuring SQL Server named instance in IBM Websphere Application server? With Regards Gopinathan K. Munappy
Gopinathan K M
  • 335
  • 2
  • 6
  • 15
-1
votes
1 answer

Login failed for user 'sa' in ASP.NET with SQL Server 2019

I am trying to connect my .NET project to SQL Server developer edition 2019 (named instance), but it always throw the error: Login failed for user 'sa'. It however connects perfectly through SSMS without any issues. I tried all possible things as…
Abbas
  • 4,948
  • 31
  • 95
  • 161
1
2