Small disclaimer: I am a n00b at Sharepoint. I am actually a developer and have just been given Sharepoint platform saying that I have to get it running properly =/ Have had no training, all my knowledge comes from reading extensively on this site as well as other blogs and sites.
A bit of history before I give details on the error. We currently have a Production environment for Sharepoint with 2 websites running (different ports). One as production and the other as UAT. This environment did not suit our UAT requirements and so steps were taken to essentially create a replica of the environment on separate virtual machines etc.
And so the App and Db servers have been separated for UAT and they needed to be renamed etc. So in effect we didnt install anything and just placed a "copy" of both servers in new machines.
DB is up and running, allowing connection via SQL Studio. On the new App server I tried to reconfigure Sharepoint to start pointing to the SPDB-UAT as all the content and Central Admin database is residing there.
This brings me to the error I am facing when running Sharepoint 2010 products configuration wizard and trying to use existing farm :
Cannot connect to database master at SQL server SPDB-UAT. The database might not exist, or the current user does not have permission to connect to it.
Looking into the logs:
An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information: Cannot connect to database master at SQL server at SPDB-UAT. The database might not exist, or the current user does not have permission to connect to it. Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException: Exception of type 'Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException' was thrown. at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureDatabase(Parameter parameterDatabase, Boolean validateVersion) at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureConfigurationDatabaseConnection() at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Validate(Int32 nextExecutionOrder) at Microsoft.SharePoint.PostSetupConfiguration.TasksQueue.Validate(Boolean useDefaultExecutionOrder) at Microsoft.SharePoint.PostSetupConfiguration.PsconfigBaseForm.ValidateConfigurationData() at Microsoft.SharePoint.PostSetupConfiguration.PsconfigBaseForm.TryValidateConfigurationData()
Points to note:
- I ran the Wizard as an Administrator
- The user as permissions to DB itself, to the DB server as well as App server as an admin
- Master DB exists on SPDB-UAT
I thought of running wizard and trying to set a new server farm and I still got the same errors.
I hope I do not have to reinstall Sharepoint and start from scratch on the APP server and am hoping someone can help me out, because reinstalling Sharepoint would pose a whole different set of issues for me!