Having connecting issue with Local SQL server

Get Help
1

I have been using the Metabase jar file of the local instance.
I have been trying to connect with the local SQL server installed on my machine but it is failing.

I have given all the details like the server name which is my machine name by default,
port of 1433, database name, and username which is my username of the machine there is no password due to it being Windows authentication.

I don't know how to resolve this issue. can someone help me how to connect the Metabase and SQL server of both local instances in the Windows machine?

Diagnostic info of metabase.

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:131.0) Gecko/20100101 Firefox/131.0",
"vendor": ""
},
"metabase-info": {
"databases": [
"h2"
],
"run-mode": "prod",
"plan-alias": "",
"version": {
"date": "2024-09-10",
"tag": "v0.50.25",
"hash": "473a7ca"
},
"settings": {
"report-timezone": null
},
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "2.1.214 (2022-06-13)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "2.1.214 (2022-06-13)"
}
}
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "23+37-2369",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "https://java.oracle.com/",
"java.version": "23",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "23+37-2369",
"os.name": "Windows 11",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "Asia/Calcutta"
}
}

2

Windows auth doesn't mean no password. It won't work unless you muck about with Kerberos. Much easier to just use a SQL password.

3

Can we connect Local Metabase jar with Local SQLs server If there is SQL password is added?
I can add the SQL password if required as well.

4

Yes, it can be done. However, if you need to ask the question, the chances are you won't be able to make it work!
Kerberos is horrible to configure at the best of times. Add in SSO and it's worse.
Make you life easier and just add SQL authentication.

5

Okay sure.
I will check and if I am facing any issues I will get back to you.

Thanks for your help.