Sfrgttk

PTIJ: At the Passover Seder, is one allowed to speak more than once during Maggid?

Do I need an EFI partition for each 18.04 ubuntu I have on my HD?

Have the tides ever turned twice on any open problem?

How can an organ that provides biological immortality be unable to regenerate?

Which partition to make active?

Air travel with refrigerated insulin

What are the rules for concealing thieves' tools (or items in general)?

Recursively updating the MLE as new observations stream in

Knife as defense against stray dogs

Imaginary part of expression too difficult to calculate

Print last inputted byte

Animating wave motion in water

is this saw blade faulty?

Turning a hard to access nut?

Why do I have a large white artefact on the rendered image?

Gauss brackets with double vertical lines

What (if any) is the reason to buy in small local stores?

Symbolism of 18 Journeyers

Print a physical multiplication table

Exposing a company lying about themselves in a tightly knit industry: Is my career at risk on the long run?

How to find the largest number(s) in a list of elements, possibly non-unique?

Hot air balloons as primitive bombers

Could any one tell what PN is this Chip? Thanks~

Asserting that Atheism and Theism are both faith based positions

SQL Server Error while creating User

Unable to delete SQL Server 2008 R2 loginCannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management StudioSQL Server logs errorError in attaching mdf file from a crashed server to a new serverError configuring SQL Server as DistributorBackup throws permission errorprofile name not valid when creating SQL server 2014 availability groupLinked server to remote sql server failedSQL Server could not retrieve the list of publications for 'DB'SSMS 17.8.1 Error: Accessing SQL Server logs

2

I tried creating a user with all privileges but I am getting this error:

Microsoft SQL Server Management Studio

Create failed for User 'Hru'. (Microsoft.SqlServer.Smo)

Additional information:

An exception occurred while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.ConnectionInfo)

'Hru' is not a valid login or you do not have permission. (Microsoft SQL Server, Error: 15007)

Can anybody help me solve this?

sql-server permissions connectivity logins

share|improve this question

edited Aug 8 '18 at 15:22

Paul White♦

53.2k14284457

asked Aug 8 '18 at 13:56

HiralHiral

111

add a comment | 

2

I tried creating a user with all privileges but I am getting this error:

Microsoft SQL Server Management Studio

Create failed for User 'Hru'. (Microsoft.SqlServer.Smo)

Additional information:

An exception occurred while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.ConnectionInfo)

'Hru' is not a valid login or you do not have permission. (Microsoft SQL Server, Error: 15007)

Can anybody help me solve this?

sql-server permissions connectivity logins

share|improve this question

edited Aug 8 '18 at 15:22

Paul White♦

53.2k14284457

asked Aug 8 '18 at 13:56

HiralHiral

111

add a comment | 

I tried creating a user with all privileges but I am getting this error:

Microsoft SQL Server Management Studio

Create failed for User 'Hru'. (Microsoft.SqlServer.Smo)

Additional information:

An exception occurred while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.ConnectionInfo)

'Hru' is not a valid login or you do not have permission. (Microsoft SQL Server, Error: 15007)

Can anybody help me solve this?

sql-server permissions connectivity logins

share|improve this question

edited Aug 8 '18 at 15:22

Paul White♦

53.2k14284457

asked Aug 8 '18 at 13:56

HiralHiral

111

share|improve this question

edited Aug 8 '18 at 15:22

Paul White♦

53.2k14284457

asked Aug 8 '18 at 13:56

HiralHiral

111

share|improve this question

edited Aug 8 '18 at 15:22

Paul White♦

53.2k14284457

asked Aug 8 '18 at 13:56

HiralHiral

111

edited Aug 8 '18 at 15:22

Paul White♦

53.2k14284457

edited Aug 8 '18 at 15:22

Paul White♦

53.2k14284457

asked Aug 8 '18 at 13:56

HiralHiral

111

asked Aug 8 '18 at 13:56

HiralHiral

111

2 Answers
2

active

oldest

votes

3

The error message is stating that SQL Server cannot locate a login named Hiru, or you do not have the privilege required to create a user.

The SQL Server security model consists¹ of a server-level login that provides access at the instance level. Logins are then associated to a user inside each database. The user typically has the same name as the login, although that is not required.

Creating a login and user is easy to do with T-SQL, as in:

USE master;

CREATE LOGIN [Hiru] WITH PASSWORD = 'pwd';

USE mydb;

CREATE USER [Hiru] FOR LOGIN [Hiru];

Using a T-SQL script provides more direct control over the process, and allows better troubleshooting.

---

^{1 - unless you're using the contained database security model}

share|improve this answer

answered Aug 8 '18 at 14:46

Max VernonMax Vernon

51.6k13114229

add a comment | 

0

First create a global login under Security -> Logins

Then add the user in Databases -> Database -> Security -> Users

share|improve this answer

answered 11 mins ago

CharithJCharithJ

1012

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f214400%2fsql-server-error-while-creating-user%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

3

The error message is stating that SQL Server cannot locate a login named Hiru, or you do not have the privilege required to create a user.

The SQL Server security model consists¹ of a server-level login that provides access at the instance level. Logins are then associated to a user inside each database. The user typically has the same name as the login, although that is not required.

Creating a login and user is easy to do with T-SQL, as in:

USE master;

CREATE LOGIN [Hiru] WITH PASSWORD = 'pwd';

USE mydb;

CREATE USER [Hiru] FOR LOGIN [Hiru];

Using a T-SQL script provides more direct control over the process, and allows better troubleshooting.

---

^{1 - unless you're using the contained database security model}

share|improve this answer

answered Aug 8 '18 at 14:46

Max VernonMax Vernon

51.6k13114229

add a comment | 

3

The error message is stating that SQL Server cannot locate a login named Hiru, or you do not have the privilege required to create a user.

The SQL Server security model consists¹ of a server-level login that provides access at the instance level. Logins are then associated to a user inside each database. The user typically has the same name as the login, although that is not required.

Creating a login and user is easy to do with T-SQL, as in:

USE master;

CREATE LOGIN [Hiru] WITH PASSWORD = 'pwd';

USE mydb;

CREATE USER [Hiru] FOR LOGIN [Hiru];

Using a T-SQL script provides more direct control over the process, and allows better troubleshooting.

---

^{1 - unless you're using the contained database security model}

share|improve this answer

answered Aug 8 '18 at 14:46

Max VernonMax Vernon

51.6k13114229

add a comment | 

The error message is stating that SQL Server cannot locate a login named Hiru, or you do not have the privilege required to create a user.

The SQL Server security model consists¹ of a server-level login that provides access at the instance level. Logins are then associated to a user inside each database. The user typically has the same name as the login, although that is not required.

Creating a login and user is easy to do with T-SQL, as in:

USE master;

CREATE LOGIN [Hiru] WITH PASSWORD = 'pwd';

USE mydb;

CREATE USER [Hiru] FOR LOGIN [Hiru];

Using a T-SQL script provides more direct control over the process, and allows better troubleshooting.

---

^{1 - unless you're using the contained database security model}

share|improve this answer

answered Aug 8 '18 at 14:46

Max VernonMax Vernon

51.6k13114229

USE master;

CREATE LOGIN [Hiru] WITH PASSWORD = 'pwd';

USE mydb;

CREATE USER [Hiru] FOR LOGIN [Hiru];

share|improve this answer

answered Aug 8 '18 at 14:46

Max VernonMax Vernon

51.6k13114229

answered Aug 8 '18 at 14:46

Max VernonMax Vernon

51.6k13114229

answered Aug 8 '18 at 14:46

Max VernonMax Vernon

51.6k13114229

0

First create a global login under Security -> Logins

Then add the user in Databases -> Database -> Security -> Users

share|improve this answer

answered 11 mins ago

CharithJCharithJ

1012

add a comment | 

0

First create a global login under Security -> Logins

Then add the user in Databases -> Database -> Security -> Users

share|improve this answer

answered 11 mins ago

CharithJCharithJ

1012

add a comment | 

First create a global login under Security -> Logins

Then add the user in Databases -> Database -> Security -> Users

share|improve this answer

answered 11 mins ago

CharithJCharithJ

1012

share|improve this answer

answered 11 mins ago

CharithJCharithJ

1012

answered 11 mins ago

CharithJCharithJ

1012

answered 11 mins ago

CharithJCharithJ

1012