CodingGorilla Posted May 13, 2014 Report Share Posted May 13, 2014 So I've had to reinstall my system from scratch, but like a good boy I had everything backed up including all of my plastic databases. I've restored all of the databases to the SQL server instance on my machine, and I'm trying to set up the plastic server again. But I keep getting this error (from the logs): 2014-05-13 10:16:39,745 960f4b5a-75aa-4f45-88c7-8614938259ad NT AUTHORITY\SYSTEM at Server:MARK-PC INFO Transaction - Transaction timeout -> 120000ms2014-05-13 10:16:39,770 960f4b5a-75aa-4f45-88c7-8614938259ad NT AUTHORITY\SYSTEM at Server:MARK-PC ERROR DataConnection - There was a problem in OpenConnection. Cannot open database "pscmrepositories" requested by the login. The login failed.Login failed for user 'pscm'. [pscmrepositories]2014-05-13 10:16:39,770 960f4b5a-75aa-4f45-88c7-8614938259ad NT AUTHORITY\SYSTEM at Server:MARK-PC ERROR Trigger - There was an error loading the triggers. Error: Plastic SCM server MARK-PC:8087 wasn't able to open a connection to the database. Check the server log (plastic.server.log). Error: Cannot open database "pscmrepositories" requested by the login. The login failed.Login failed for user 'pscm'.2014-05-13 10:16:39,785 e5c90819-da8c-4349-9be6-bb77d8d9ab45 NT AUTHORITY\SYSTEM at Server:MARK-PC ERROR DataConnection - There was a problem in OpenConnection. Cannot open database "pscmrepositories" requested by the login. The login failed.Login failed for user 'pscm'. [pscmrepositories]2014-05-13 10:16:39,785 e5c90819-da8c-4349-9be6-bb77d8d9ab45 NT AUTHORITY\SYSTEM at Server:MARK-PC ERROR Trigger - There was an error loading the triggers. Error: Plastic SCM server MARK-PC:8087 wasn't able to open a connection to the database. Check the server log (plastic.server.log). Error: Cannot open database "pscmrepositories" requested by the login. The login failed.Login failed for user 'pscm'. I've confirmed using SSMS that I can log into the SQL server as the specified user (pscm) and access all the databases, but for the life of me I can't get the plastic server to connect. Any ideas? Link to comment Share on other sites More sharing options...
manu Posted May 14, 2014 Report Share Posted May 14, 2014 Do you have the SQLServer remote connections enabled? Link to comment Share on other sites More sharing options...
CodingGorilla Posted May 14, 2014 Author Report Share Posted May 14, 2014 Manu, thanks for the reply - I figured out the problem. Apparently if you don't tell Plastic (5.4) where to put the SQL Server database files, it will attempt to put the files into the plastic server folder. Since the SQL server normally runs as a low privilege user (NETWORK_USER), it doesn't have access to the plastic server folder and so SQL Server can't create the database files. Once I told plastic to put my database files in my default data folder (as configured in SSMS), it seemed to notice all the databases and work normally. Link to comment Share on other sites More sharing options...
manu Posted May 14, 2014 Report Share Posted May 14, 2014 Ops, yes. That's right. You can also use the <DatabasePath> tag inside the db.conf file to select your custom location. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.