Page 1 of 1

Project Server - Created a second DB and can't connect to it

PostPosted: Thu Jun 03, 2021 5:58 am
by Pete Berthet
SO I've added a second database because I wanted to firewall some projects from the team database.

That all went fine on the server end, but I can't connect to it on any of the edit suites.

Resolve returns the error "failed to connect to the database"

However all my machines can still connect to the main database.

Both of the db's are hosted on the same machine running project server 17

I'm totally lost here. Plz halp.

Project Server - Created a second DB and can't connect to it

PostPosted: Thu Jun 03, 2021 6:21 am
by iddos-l
Did you Authorize the new DB on the project server?

On the new project server (17) it’s called share database



Sent from my iPhone using Tapatalk

Re: Project Server - Created a second DB and can't connect t

PostPosted: Thu Jun 03, 2021 6:22 am
by Pete Berthet
iddos-l wrote:Did you Authorize the new DB on the project server?


Sent from my iPhone using Tapatalk


Yup.

Also chasing it up with newmagic here in Aus. Let u know how that goes.

Re: Project Server - Created a second DB and can't connect t

PostPosted: Fri Jun 04, 2021 7:08 am
by Pete Berthet
BMD Resolved it.

Project Server was connecting the database through the wrong NIC.

Thanks!