D
D
Denis Kuznetsov2019-12-14 21:23:26
Java
Denis Kuznetsov, 2019-12-14 21:23:26

Where to find properties from ms sql for config?

hello, I need to configure a Spring Boot application so that it can communicate with a database with such fields
spring.datasource.driver-class-name=
spring.datasource.url=
spring.datasource.username=
spring.datasource.password=
spring.jpa. properties.hibernate.dialect=
url seems to need a server, and if I understand correctly, then I have this DESKTOP-UI0E77E\SQLEXPRESS
name DESKTOP-UI0E77E\DennisKingsman
and there is no password
, where can I find the rest of the fields and how to compose the url?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vladimir Korotenko, 2019-12-14
@DennisKingsman

Use built-in authentication, no password is needed there.
https://github.com/bhochhi/howto-guide/wiki/How-to...

<bean id="dataSource"	class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
    <property name="url" value="jdbc:sqlserver://host:port;DatabaseName=dbName;integratedSecurity=true" />
 </bean>

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question