SQL Server Management Studio Logins Dialog missing
I am running SQL Server Management Studio v17.6.
The online tutorials for creating a new Login show a dialog that comes up when your right-click on Logins and select New Login.
I don't see this dialog; instead I get a script to CREATE LOGIN which is OK but I would prefer the dialog.
I don't see an option to switch from getting a script to getting the dialog. I don't know if this version does not have the dialog or if I am just not finding the option.
sql
sql-server 
azure-sql-database ssms login-script edited Aug 30 '18 at 10:29
Andrea
7,711144652
asked Aug 29 '18 at 17:38
RichardRichard
185
|
show 1 more comment
I am running SQL Server Management Studio v17.6.
The online tutorials for creating a new Login show a dialog that comes up when your right-click on Logins and select New Login.
I don't see this dialog; instead I get a script to CREATE LOGIN which is OK but I would prefer the dialog.
I don't see an option to switch from getting a script to getting the dialog. I don't know if this version does not have the dialog or if I am just not finding the option.
sql
sql-server azure-sql-database ssms login-script edited Aug 30 '18 at 10:29
Andrea
7,711144652
asked Aug 29 '18 at 17:38
RichardRichard
185
Are you selecting "New Login..." or "Script Login As>Create To>New Query Editor Window"?
– Jacob H
Aug 29 '18 at 18:14
I am selecting "New Login." This seems to be true for other actions such as adding a new user. I just get the script.
– Richard
Aug 29 '18 at 18:28
Do you have any addons in SSMS?
– Jacob H
Aug 29 '18 at 18:33
No addons. Does using Azure make a difference?
– Richard
Aug 29 '18 at 18:35
I have not used Azure in a few years, but I wouldn't doubt if that is a limitation.
– Jacob H
Aug 29 '18 at 18:49
|
show 1 more comment
I am running SQL Server Management Studio v17.6.
The online tutorials for creating a new Login show a dialog that comes up when your right-click on Logins and select New Login.
I don't see this dialog; instead I get a script to CREATE LOGIN which is OK but I would prefer the dialog.
I don't see an option to switch from getting a script to getting the dialog. I don't know if this version does not have the dialog or if I am just not finding the option.
sql
sql-server azure-sql-database ssms login-script edited Aug 30 '18 at 10:29
Andrea
7,711144652
asked Aug 29 '18 at 17:38
RichardRichard
185
I am running SQL Server Management Studio v17.6.
The online tutorials for creating a new Login show a dialog that comes up when your right-click on Logins and select New Login.
I don't see this dialog; instead I get a script to CREATE LOGIN which is OK but I would prefer the dialog.
I don't see an option to switch from getting a script to getting the dialog. I don't know if this version does not have the dialog or if I am just not finding the option.
sql
sql-server azure-sql-database ssms login-script sql
sql-server azure-sql-database ssms login-script edited Aug 30 '18 at 10:29
Andrea
7,711144652
asked Aug 29 '18 at 17:38
RichardRichard
185
edited Aug 30 '18 at 10:29
Andrea
7,711144652
asked Aug 29 '18 at 17:38
RichardRichard
185
edited Aug 30 '18 at 10:29
Andrea
7,711144652
edited Aug 30 '18 at 10:29
Andrea
7,711144652
edited Aug 30 '18 at 10:29
Andrea
7,711144652
7,711144652
asked Aug 29 '18 at 17:38
RichardRichard
185
asked Aug 29 '18 at 17:38
RichardRichard
185
asked Aug 29 '18 at 17:38
RichardRichard
185
185
Are you selecting "New Login..." or "Script Login As>Create To>New Query Editor Window"?
– Jacob H
Aug 29 '18 at 18:14
I am selecting "New Login." This seems to be true for other actions such as adding a new user. I just get the script.
– Richard
Aug 29 '18 at 18:28
Do you have any addons in SSMS?
– Jacob H
Aug 29 '18 at 18:33
No addons. Does using Azure make a difference?
– Richard
Aug 29 '18 at 18:35
I have not used Azure in a few years, but I wouldn't doubt if that is a limitation.
– Jacob H
Aug 29 '18 at 18:49
|
show 1 more comment
Are you selecting "New Login..." or "Script Login As>Create To>New Query Editor Window"?
– Jacob H
Aug 29 '18 at 18:14
I am selecting "New Login." This seems to be true for other actions such as adding a new user. I just get the script.
– Richard
Aug 29 '18 at 18:28
Do you have any addons in SSMS?
– Jacob H
Aug 29 '18 at 18:33
No addons. Does using Azure make a difference?
– Richard
Aug 29 '18 at 18:35
I have not used Azure in a few years, but I wouldn't doubt if that is a limitation.
– Jacob H
Aug 29 '18 at 18:49
Are you selecting "New Login..." or "Script Login As>Create To>New Query Editor Window"?
– Jacob H
Aug 29 '18 at 18:14
Are you selecting "New Login..." or "Script Login As>Create To>New Query Editor Window"?
– Jacob H
Aug 29 '18 at 18:14
I am selecting "New Login." This seems to be true for other actions such as adding a new user. I just get the script.
– Richard
Aug 29 '18 at 18:28
I am selecting "New Login." This seems to be true for other actions such as adding a new user. I just get the script.
– Richard
Aug 29 '18 at 18:28
Do you have any addons in SSMS?
– Jacob H
Aug 29 '18 at 18:33
Do you have any addons in SSMS?
– Jacob H
Aug 29 '18 at 18:33
No addons. Does using Azure make a difference?
– Richard
Aug 29 '18 at 18:35
No addons. Does using Azure make a difference?
– Richard
Aug 29 '18 at 18:35
I have not used Azure in a few years, but I wouldn't doubt if that is a limitation.
– Jacob H
Aug 29 '18 at 18:49
I have not used Azure in a few years, but I wouldn't doubt if that is a limitation.
– Jacob H
Aug 29 '18 at 18:49
|
show 1 more comment
1 Answer
1
active
oldest
votes
Currently this is an Azure SQL limitation.
More information can be found here on azure.microsoft.com or here on Microsoft docs.
When creating a new login with the following SSMS menu item:
this is what appears with an Azure SQL database:
instead a dialog window appears when using a local database:
answered Aug 30 '18 at 10:27
AndreaAndrea
7,711144652
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
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f52083296%2fsql-server-management-studio-logins-dialog-missing%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Currently this is an Azure SQL limitation.
More information can be found here on azure.microsoft.com or here on Microsoft docs.
When creating a new login with the following SSMS menu item:
this is what appears with an Azure SQL database:
instead a dialog window appears when using a local database:
answered Aug 30 '18 at 10:27
AndreaAndrea
7,711144652
add a comment |
Currently this is an Azure SQL limitation.
More information can be found here on azure.microsoft.com or here on Microsoft docs.
When creating a new login with the following SSMS menu item:
this is what appears with an Azure SQL database:
instead a dialog window appears when using a local database:
answered Aug 30 '18 at 10:27
AndreaAndrea
7,711144652
add a comment |
Currently this is an Azure SQL limitation.
More information can be found here on azure.microsoft.com or here on Microsoft docs.
When creating a new login with the following SSMS menu item:
this is what appears with an Azure SQL database:
instead a dialog window appears when using a local database:
answered Aug 30 '18 at 10:27
AndreaAndrea
7,711144652
Currently this is an Azure SQL limitation.
More information can be found here on azure.microsoft.com or here on Microsoft docs.
When creating a new login with the following SSMS menu item:
this is what appears with an Azure SQL database:
instead a dialog window appears when using a local database:
answered Aug 30 '18 at 10:27
AndreaAndrea
7,711144652
edited Nov 20 '18 at 10:17
answered Aug 30 '18 at 10:27
AndreaAndrea
7,711144652
answered Aug 30 '18 at 10:27
AndreaAndrea
7,711144652
answered Aug 30 '18 at 10:27
AndreaAndrea
7,711144652
7,711144652
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f52083296%2fsql-server-management-studio-logins-dialog-missing%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Are you selecting "New Login..." or "Script Login As>Create To>New Query Editor Window"?
– Jacob H
Aug 29 '18 at 18:14
I am selecting "New Login." This seems to be true for other actions such as adding a new user. I just get the script.
– Richard
Aug 29 '18 at 18:28
Do you have any addons in SSMS?
– Jacob H
Aug 29 '18 at 18:33
No addons. Does using Azure make a difference?
– Richard
Aug 29 '18 at 18:35
I have not used Azure in a few years, but I wouldn't doubt if that is a limitation.
– Jacob H
Aug 29 '18 at 18:49