This is my first time creating a multi-tier server farm for our company and I am trying to add our Web Server to our SharePoint server farm.
When I try to run the product configuration from our Web Server - I receive an error message that it fails to connect to the server. We check the logs and it looks like we are getting an access denied. I clicked on the "Help" button and I believe it's because the database has already been created so we have to use PSConfig from the CMD line?
I'm on the Farm Account on our Farm server. I enter in the script and it is successful but I cannot see our web server added. I know this is incorrect because the server we are trying to add is our web server and nowhere on that script has our web server mentioned.
Our farm account does not have an account/access with our web server and I try entering the same script from our webserver and it's telling me I don't have the permissions but the account I logged in with has DBO access to the Farm Server.
I've been trying to find information online and I have been working on this portion for about 2 weeks but nothing seems to work. Can anyone help lead me towards the right direction?
Another Note: Settings wise - We previously had this portion working and our web server was linked to our farm server but our farm server crashed and we had to get it replaced. The employee who was working on this project left so I have been assigned to work on this now.
Both my user name and shptAdmin are dbo on the Config server - It says dbo on default scheme but the db_owner is not checked and when I try to change that I receive the 15151 error : cannot alter the role 'db_owner', because it does not exist or you do not have permission.