Issues connecting to localhost with windows authentication for mssql
I am trying to connect to my localhost database.
This is a screenshot from MSSQL Mangement Studio with the basic credentials:
This is my application.properties file:
spring.datasource.url=jdbc:sqlserver://DESKTOP-HF5N51H\SQLEXPRESS;databaseName=ETA
spring.datasource.username=DESKTOP-HF5N51H\Zafir Stojanovski
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect
spring.jpa.hibernate.ddl-auto = create-drop
When I run my application, I get the following error:
Login failed for user 'DESKTOP-HF5N51HZafir Stojanovski'. ClientConnectionId:948051cf-bfe3-4cba-ad57-8a05d01afeab
I don't understand. Should there be a different application.properties configuration for windows authentication?
Thank you for your time.
spring spring-boot spring-data-jpa
asked Dec 30 '18 at 13:28
Zafir StojanovskiZafir Stojanovski
10711
add a comment |
I am trying to connect to my localhost database.
This is a screenshot from MSSQL Mangement Studio with the basic credentials:
This is my application.properties file:
spring.datasource.url=jdbc:sqlserver://DESKTOP-HF5N51H\SQLEXPRESS;databaseName=ETA
spring.datasource.username=DESKTOP-HF5N51H\Zafir Stojanovski
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect
spring.jpa.hibernate.ddl-auto = create-drop
When I run my application, I get the following error:
Login failed for user 'DESKTOP-HF5N51HZafir Stojanovski'. ClientConnectionId:948051cf-bfe3-4cba-ad57-8a05d01afeab
I don't understand. Should there be a different application.properties configuration for windows authentication?
Thank you for your time.
spring spring-boot spring-data-jpa
asked Dec 30 '18 at 13:28
Zafir StojanovskiZafir Stojanovski
10711
Maybe this topic will be helpful...
– Cepr0
Dec 30 '18 at 17:03
Could you connect to SqlServer via Sql Server Authentication rather than Windows Authentication ?
– TinyOS
Dec 31 '18 at 2:34
add a comment |
I am trying to connect to my localhost database.
This is a screenshot from MSSQL Mangement Studio with the basic credentials:
This is my application.properties file:
spring.datasource.url=jdbc:sqlserver://DESKTOP-HF5N51H\SQLEXPRESS;databaseName=ETA
spring.datasource.username=DESKTOP-HF5N51H\Zafir Stojanovski
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect
spring.jpa.hibernate.ddl-auto = create-drop
When I run my application, I get the following error:
Login failed for user 'DESKTOP-HF5N51HZafir Stojanovski'. ClientConnectionId:948051cf-bfe3-4cba-ad57-8a05d01afeab
I don't understand. Should there be a different application.properties configuration for windows authentication?
Thank you for your time.
spring spring-boot spring-data-jpa
asked Dec 30 '18 at 13:28
Zafir StojanovskiZafir Stojanovski
10711
I am trying to connect to my localhost database.
This is a screenshot from MSSQL Mangement Studio with the basic credentials:
This is my application.properties file:
spring.datasource.url=jdbc:sqlserver://DESKTOP-HF5N51H\SQLEXPRESS;databaseName=ETA
spring.datasource.username=DESKTOP-HF5N51H\Zafir Stojanovski
spring.datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.jpa.show-sql=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.SQLServer2012Dialect
spring.jpa.hibernate.ddl-auto = create-drop
When I run my application, I get the following error:
Login failed for user 'DESKTOP-HF5N51HZafir Stojanovski'. ClientConnectionId:948051cf-bfe3-4cba-ad57-8a05d01afeab
I don't understand. Should there be a different application.properties configuration for windows authentication?
Thank you for your time.
spring spring-boot spring-data-jpa
spring spring-boot spring-data-jpa
asked Dec 30 '18 at 13:28
Zafir StojanovskiZafir Stojanovski
10711
asked Dec 30 '18 at 13:28
Zafir StojanovskiZafir Stojanovski
10711
asked Dec 30 '18 at 13:28
Zafir StojanovskiZafir Stojanovski
10711
asked Dec 30 '18 at 13:28
Zafir StojanovskiZafir Stojanovski
10711
asked Dec 30 '18 at 13:28
Zafir StojanovskiZafir Stojanovski
10711
10711
Maybe this topic will be helpful...
– Cepr0
Dec 30 '18 at 17:03
Could you connect to SqlServer via Sql Server Authentication rather than Windows Authentication ?
– TinyOS
Dec 31 '18 at 2:34
add a comment |
Maybe this topic will be helpful...
– Cepr0
Dec 30 '18 at 17:03
Could you connect to SqlServer via Sql Server Authentication rather than Windows Authentication ?
– TinyOS
Dec 31 '18 at 2:34
Maybe this topic will be helpful...
– Cepr0
Dec 30 '18 at 17:03
Maybe this topic will be helpful...
– Cepr0
Dec 30 '18 at 17:03
Could you connect to SqlServer via Sql Server Authentication rather than Windows Authentication ?
– TinyOS
Dec 31 '18 at 2:34
Could you connect to SqlServer via Sql Server Authentication rather than Windows Authentication ?
– TinyOS
Dec 31 '18 at 2:34
add a comment |
0
active
oldest
votes
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%2f53978001%2fissues-connecting-to-localhost-with-windows-authentication-for-mssql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53978001%2fissues-connecting-to-localhost-with-windows-authentication-for-mssql%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
Maybe this topic will be helpful...
– Cepr0
Dec 30 '18 at 17:03
Could you connect to SqlServer via Sql Server Authentication rather than Windows Authentication ?
– TinyOS
Dec 31 '18 at 2:34