I have created a new SharePoint farm and am getting an error message when I create sub-sites. The sub-site appears to be created fine (links appear to it in menus) but I also get an error when I attempt to visit it.
The error message says
An unexpected error has occurred
And, from the log files I'm getting the following error messages:
ConnectionString: 'Data Source=XXXXXXXX;Initial Catalog="User Profile Service Application_ProfileDB_c9b5d1154dc648bb82d8394371e0a902";Integrated Security=True;Enlist=False;Asynchronous Processing=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 Failure checking user access permissions for User Profile Application Proxy 'User Profile Service Application'. Exception: System.Data.SqlClient.SqlException: Cannot open database "User Profile Service Application_ProfileDB_c9b5d1154dc648bb82d8394371e0a902" requested by the login. The login failed. Login failed for user 'XXXX\XXXX$'.
This server has just been joined to the domain too.
How can I check which service account this will be running under? It should be a domain account, I imagine, if it's attempting to connect to my database server.
Just wondering what else I can check?