I want to add a new server to my existing MOSS 2007 farm. I've followed some of the articles on how to do it. Installed it as complete. When the wizard started I gave the remote
server (Sql2005). Now curiously, it came back with 3 databases that seemed random. This is test environment so the db I chose was WSS_Content_Test, wich is what the current wss runs on. After picking that db the domain account was filed in the account field.
The account is a domain account called xxxxSharePoint. I used this account to installed the whole thing, it is an administrator account that has also db admin rights including db create, db read, etc.
So when the wizard started I gave it the database, this domain account and password, selected the option not to install the central admin page. Then the wizard continued to perform
10 steps only to fail on the 2nd with a message of denied access. The logs on both servers revealed that another domain account is trying to access the database and its credentials weren't adequate. I don't where this other acc
View Complete Post