Styjun

Do I care if the housing market has gone up or down, if I'm moving from one house to another?

Killing a star safely

Could Europeans in Europe demand protection under UN Declaration on the Rights of Indigenous Peoples?

Super Regeneration Detector

Do we have to introduce the character's name before using their names in a dialogue tag?

Why do we need an estimator to be consistent?

Project Euler # 25 The 1000 digit Fibonacci index

How to tell readers that I know my story is factually incorrect?

What's so great about Shalantha's Delicate Disk?

Manager is asking me to eat breakfast from now on

What is the minimum wait before I may I re-enter the USA after a 90 day visit on the Visa B-2 Program?

Grease/lubricate rubber stabilizer bar bushings?

How much did all the space agencies spent on rockets launching and space exploration? What are the benefits for me and you?

Does the Bracer of Flying Daggers really let a thief make 4 attacks per round?

Do gauntlets count as armor?

What does Windows' "Tuning up Application Start" do?

Counting multiples of 3 up to a given number

How was Luke's prosthetic hand in Episode V filmed?

I want light controlled by one switch, not two

P-adic functions on annuli

What is the difference between uniform velocity and constant velocity?

Aren't all schwa sounds literally /ø/?

How to hide your own body?

What does this chess proverb mean?

Unable to connect to master or target server “ServerName”

Add a column with a default value to an existing table in SQL ServerHow to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?How to concatenate text from multiple rows into a single text string in SQL server?LEFT JOIN vs. LEFT OUTER JOIN in SQL ServerSQL Server 2008 can't login with newly created userHow do I UPDATE from a SELECT in SQL Server?Unable to connect to the Local Server with Integrated Seurity = TrueError - Unable to access the IIS metabaseNot able to read connection string from app config

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

Have some troubles with Unit Test and Dackpack. This is the full error name:

DeploymentFailedException: Unable to connect to master or target server 'DBTests'. You must have a user with the same password in the master or target server 'DBTests'.

I have 3 strange things :

1. I can publish my Database on Server (tests have the same connection string)


2. I can log in in my site and I don't have troubles with DB (using IIS)


3. Test logic: Test database created when I init my tests, and it is really created!!!!

But all tests have "Error".

I upgrade my SSDT. I reinstall MSSQL Twice. And I set compability level(130). And what is so funny this is my Connection Strings when I try to debug my tests:

"Data Source=ServerName;integrated security=false;Initial Catalog=DbTests;User ID=kek;Password=kek;Connection Timeout=60;MultipleActiveResultSets=True;Max Pool Size=1024"

That is TestDatabase connection string. And she is absolutely fine because I TESTED this connection string.

This is masterDatabase connection string:

Data Source=ServerName;integrated security=false;Initial Catalog=master;User ID=kek;Password=kek;Connection Timeout=60;MultipleActiveResultSets=True

And the main question what I have: Why Error say what 'DBTest' - this is a server ?? I mean, this is DB, not server.

Maybe someone knows about that, idk. That is so stupid and I can't understand what's wrong.

UPD: I solve my problem. Installed SQL Server 2016.

P.S. Ofc I can log in on the server with my "kek", "kek" credentials in Management Studio.

c# asp.net .net sql-server unit-testing

share|improve this question

edited Mar 29 at 16:04

Peter B

14.3k55 gold badges2020 silver badges4848 bronze badges

asked Mar 26 at 12:32

Tetsua KeitoTetsua Keito

955 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can you share publish.xml content in SSDT project
  
  – ElasticCode
  Mar 26 at 12:45
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i solved my problem , thank you
  
  – Tetsua Keito
  Mar 26 at 13:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  welcome, what was the issue?
  
  – ElasticCode
  Mar 26 at 13:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @ElasticCode well, my binaries files created for SQL 2016. And all my DackPack settings write for SQL Server 2016. My second day on my new work... and I'm junior, so sad...
  
  – Tetsua Keito
  Mar 26 at 13:17
  

  
  
  
  

add a comment | 

0

Have some troubles with Unit Test and Dackpack. This is the full error name:

DeploymentFailedException: Unable to connect to master or target server 'DBTests'. You must have a user with the same password in the master or target server 'DBTests'.

I have 3 strange things :

1. I can publish my Database on Server (tests have the same connection string)


2. I can log in in my site and I don't have troubles with DB (using IIS)


3. Test logic: Test database created when I init my tests, and it is really created!!!!

But all tests have "Error".

I upgrade my SSDT. I reinstall MSSQL Twice. And I set compability level(130). And what is so funny this is my Connection Strings when I try to debug my tests:

"Data Source=ServerName;integrated security=false;Initial Catalog=DbTests;User ID=kek;Password=kek;Connection Timeout=60;MultipleActiveResultSets=True;Max Pool Size=1024"

That is TestDatabase connection string. And she is absolutely fine because I TESTED this connection string.

This is masterDatabase connection string:

Data Source=ServerName;integrated security=false;Initial Catalog=master;User ID=kek;Password=kek;Connection Timeout=60;MultipleActiveResultSets=True

And the main question what I have: Why Error say what 'DBTest' - this is a server ?? I mean, this is DB, not server.

Maybe someone knows about that, idk. That is so stupid and I can't understand what's wrong.

UPD: I solve my problem. Installed SQL Server 2016.

P.S. Ofc I can log in on the server with my "kek", "kek" credentials in Management Studio.

c# asp.net .net sql-server unit-testing

share|improve this question

edited Mar 29 at 16:04

Peter B

14.3k55 gold badges2020 silver badges4848 bronze badges

asked Mar 26 at 12:32

Tetsua KeitoTetsua Keito

955 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can you share publish.xml content in SSDT project
  
  – ElasticCode
  Mar 26 at 12:45
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i solved my problem , thank you
  
  – Tetsua Keito
  Mar 26 at 13:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  welcome, what was the issue?
  
  – ElasticCode
  Mar 26 at 13:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @ElasticCode well, my binaries files created for SQL 2016. And all my DackPack settings write for SQL Server 2016. My second day on my new work... and I'm junior, so sad...
  
  – Tetsua Keito
  Mar 26 at 13:17
  

  
  
  
  

add a comment | 

Have some troubles with Unit Test and Dackpack. This is the full error name:

DeploymentFailedException: Unable to connect to master or target server 'DBTests'. You must have a user with the same password in the master or target server 'DBTests'.

I have 3 strange things :

1. I can publish my Database on Server (tests have the same connection string)


2. I can log in in my site and I don't have troubles with DB (using IIS)


3. Test logic: Test database created when I init my tests, and it is really created!!!!

But all tests have "Error".

I upgrade my SSDT. I reinstall MSSQL Twice. And I set compability level(130). And what is so funny this is my Connection Strings when I try to debug my tests:

"Data Source=ServerName;integrated security=false;Initial Catalog=DbTests;User ID=kek;Password=kek;Connection Timeout=60;MultipleActiveResultSets=True;Max Pool Size=1024"

That is TestDatabase connection string. And she is absolutely fine because I TESTED this connection string.

This is masterDatabase connection string:

Data Source=ServerName;integrated security=false;Initial Catalog=master;User ID=kek;Password=kek;Connection Timeout=60;MultipleActiveResultSets=True

And the main question what I have: Why Error say what 'DBTest' - this is a server ?? I mean, this is DB, not server.

Maybe someone knows about that, idk. That is so stupid and I can't understand what's wrong.

UPD: I solve my problem. Installed SQL Server 2016.

P.S. Ofc I can log in on the server with my "kek", "kek" credentials in Management Studio.

c# asp.net .net sql-server unit-testing

share|improve this question

edited Mar 29 at 16:04

Peter B

14.3k55 gold badges2020 silver badges4848 bronze badges

asked Mar 26 at 12:32

Tetsua KeitoTetsua Keito

955 bronze badges

"Data Source=ServerName;integrated security=false;Initial Catalog=DbTests;User ID=kek;Password=kek;Connection Timeout=60;MultipleActiveResultSets=True;Max Pool Size=1024"

Data Source=ServerName;integrated security=false;Initial Catalog=master;User ID=kek;Password=kek;Connection Timeout=60;MultipleActiveResultSets=True

c# asp.net .net sql-server unit-testing

c# asp.net .net sql-server unit-testing

share|improve this question

edited Mar 29 at 16:04

Peter B

14.3k55 gold badges2020 silver badges4848 bronze badges

asked Mar 26 at 12:32

Tetsua KeitoTetsua Keito

955 bronze badges

share|improve this question

edited Mar 29 at 16:04

Peter B

14.3k55 gold badges2020 silver badges4848 bronze badges

asked Mar 26 at 12:32

Tetsua KeitoTetsua Keito

955 bronze badges

edited Mar 29 at 16:04

Peter B

14.3k55 gold badges2020 silver badges4848 bronze badges

edited Mar 29 at 16:04

Peter B

14.3k55 gold badges2020 silver badges4848 bronze badges

asked Mar 26 at 12:32

Tetsua KeitoTetsua Keito

955 bronze badges

asked Mar 26 at 12:32

Tetsua KeitoTetsua Keito

955 bronze badges

1 Answer
1

active

oldest

votes

-1

Try this way, it worked for me:

<add name="YourContext" connectionString="Data Source=YourAddress,1433; Initial Catalog=database; Integrated Security=False; User ID=yourUser;Password=YourPass; Trusted_Connection=False;Encrypt=True;Connection Timeout=30; MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

share|improve this answer

answered Mar 26 at 12:49

Rogerio AzevedoRogerio Azevedo

32844 silver badges2020 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, that is not my work for me. But thank you. I just go to SQL 2016.
  
  – Tetsua Keito
  Mar 26 at 13:12
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55357293%2funable-to-connect-to-master-or-target-server-servername%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

-1

Try this way, it worked for me:

<add name="YourContext" connectionString="Data Source=YourAddress,1433; Initial Catalog=database; Integrated Security=False; User ID=yourUser;Password=YourPass; Trusted_Connection=False;Encrypt=True;Connection Timeout=30; MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

share|improve this answer

answered Mar 26 at 12:49

Rogerio AzevedoRogerio Azevedo

32844 silver badges2020 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, that is not my work for me. But thank you. I just go to SQL 2016.
  
  – Tetsua Keito
  Mar 26 at 13:12
  

  
  
  
  

add a comment | 

-1

Try this way, it worked for me:

<add name="YourContext" connectionString="Data Source=YourAddress,1433; Initial Catalog=database; Integrated Security=False; User ID=yourUser;Password=YourPass; Trusted_Connection=False;Encrypt=True;Connection Timeout=30; MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

share|improve this answer

answered Mar 26 at 12:49

Rogerio AzevedoRogerio Azevedo

32844 silver badges2020 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, that is not my work for me. But thank you. I just go to SQL 2016.
  
  – Tetsua Keito
  Mar 26 at 13:12
  

  
  
  
  

add a comment | 

Try this way, it worked for me:

<add name="YourContext" connectionString="Data Source=YourAddress,1433; Initial Catalog=database; Integrated Security=False; User ID=yourUser;Password=YourPass; Trusted_Connection=False;Encrypt=True;Connection Timeout=30; MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

share|improve this answer

answered Mar 26 at 12:49

Rogerio AzevedoRogerio Azevedo

32844 silver badges2020 bronze badges

<add name="YourContext" connectionString="Data Source=YourAddress,1433; Initial Catalog=database; Integrated Security=False; User ID=yourUser;Password=YourPass; Trusted_Connection=False;Encrypt=True;Connection Timeout=30; MultipleActiveResultSets=True" providerName="System.Data.SqlClient" />

share|improve this answer

answered Mar 26 at 12:49

Rogerio AzevedoRogerio Azevedo

32844 silver badges2020 bronze badges

answered Mar 26 at 12:49

Rogerio AzevedoRogerio Azevedo

32844 silver badges2020 bronze badges

answered Mar 26 at 12:49

Rogerio AzevedoRogerio Azevedo

32844 silver badges2020 bronze badges