cannot connect to database during install

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

André Lange 108 posts 410 karma points

Sep 08, 2017 @ 08:57
0

Cannot connect to database during install

Using Umbraco And Getting Started

Umbraco 7
I have a clean project, which i am trying to get started. I have also created a clean database.

Both are running locally on my pc.

I can connect to my database with linqpad, with no issues. But when i try to "customize" and set a microsoft SQL server, it says " Could not connect to database". And in console, i get a 500 internal server error, on :
```
:62164/install/api/PostValidateDatabaseConnection
```
What can i do ?
Copy Link
Alex Skrypnyk 6132 posts 23951 karma points MVP 7x admin c-trib

Sep 08, 2017 @ 09:40

0

Hi Andre

Can you check SQL server connection with MSSQL management studio?

Thanks,

Alex

Copy Link
André Lange 108 posts 410 karma points

Sep 11, 2017 @ 06:43

0

I can access the db, no problem in management studio, and i can access and view tables in linqpad, with no issue as well..

Copy Link
Paul Stephenson 19 posts 129 karma points

Sep 11, 2017 @ 07:29
1
In the Umbraco customize screen:
- Check you have typed "." (just a dot) or "(local)" as the server name
- Check you have typed the database name exactly
- Check that you have ticked Integrated Security (if you log into SQL Server with your Windows credentials) or have the correct SQL Server credentials
Copy Link
André Lange 108 posts 410 karma points

Sep 15, 2017 @ 07:13

100

I reinstalled umbraco, and then it worked...

Copy Link
Paul 1 post 72 karma points

Nov 26, 2023 @ 07:45

1

I had this same problem. Try selecting the "Trust Database Certificate" checkbox.

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?