more quick actions
minimize quick actions
Topic starter
Hello guys,
I have a HDS issue that PcVue cannot create Database of SQL Server when finishing Database configuration and restarting PcVue.
I tried with PcVue 10.0SP2,11.0 and 11.1, and repaired SQL Server installation, All failed. My SQL Server is x64 2012 Express.
HDS log file is attached below. Do you know what happened to my PC?
2016/03/08,15:23:37.000,MARK-PC,Mark,HDS,I,0,0,Project loading
2016/03/08,15:23:37.047,MARK-PC,Mark,HDS,I,0,0,Project loaded
2016/03/08,15:23:37.125,MARK-PC,Mark,HDS,I,0,0,Setup loading
2016/03/08,15:23:37.156,MARK-PC,Mark,HDS,I,0,0,Loading configuration directory = D:PcVue 11.1USRsqlserverCTEMP
2016/03/08,15:23:37.172,MARK-PC,Mark,HDS,I,0,0,General configuration directory = D:PcVue 11.1USRsqlserverC
2016/03/08,15:23:37.188,MARK-PC,Mark,HDS,I,0,0,General configuration file name = HDSConf.dat
2016/03/08,15:23:37.203,MARK-PC,Mark,HDS,I,0,0,Trends configuration file name = HDSTrend.dat
2016/03/08,15:23:37.484,MARK-PC,Mark,HDS,I,0,0,Setup loaded
2016/03/08,15:23:37.656,MARK-PC,Mark,HDS,E,0,0,CSchDatabase::Connect __ Call TreatComError ID = 'DATABASE1'
2016/03/08,15:23:37.703,MARK-PC,Mark,HDS,E,0,0,TreatComError __ ComError Source : 'Microsoft OLE DB Provider for SQL Server' Description : 'Cannot open database "sqlserver_DATABASE1" requested by the login. The login failed.' (80004005=E_FAIL)
2016/03/08,15:23:37.719,MARK-PC,Mark,HDS,E,0,0,TreatComError __ ProviderError '80004005' : Description : 'Cannot open database "sqlserver_DATABASE1" requested by the login. The login failed.' SQLState : '42000' NativeError : 4060
2016/03/08,15:23:37.875,MARK-PC,Mark,HDS,E,0,0,CSchDatabase::Connect __ Call TreatComError ID = 'DATABASE1'
2016/03/08,15:23:37.906,MARK-PC,Mark,HDS,E,0,0,TreatComError __ ComError Source : 'Microsoft OLE DB Provider for SQL Server' Description : 'Cannot open database "sqlserver_DATABASE1" requested by the login. The login failed.' (80004005=E_FAIL)
2016/03/08,15:23:37.938,MARK-PC,Mark,HDS,E,0,0,TreatComError __ ProviderError '80004005' : Description : 'Cannot open database "sqlserver_DATABASE1" requested by the login. The login failed.' SQLState : '42000' NativeError : 4060
2016/03/08,15:23:42.128,MARK-PC,Mark,HDS,I,0,0,Project unloading
2016/03/08,15:23:43.175,MARK-PC,Mark,HDS,I,0,0,Setup unloading
2016/03/08,15:23:43.206,MARK-PC,Mark,HDS,I,0,0,Setup unloaded
2016/03/08,15:23:43.222,MARK-PC,Mark,HDS,I,0,0,Project unloaded
Thanks in advance.
BRs,
Mark
Posted : 08/03/2016 1:38 pm
Hi Mark,
In my experience, Description : 'Cannot open database "sqlserver_DATABASE1" requested by the login. The login failed.' normally refers to wrong login used by the DB creation wizard. Can you try to open SQL server Mgmt Studio and try to login using the same login used by the DB creation wizard in PcVue
rgds
Posted : 08/03/2016 2:06 pm
Topic starter
Yes,SQL server Mgmt Studio can login with both Windows Authentication and SQL Server Authentication(sa).
Posted : 08/03/2016 2:18 pm
Hi Mark,
Strange but I've never encountered this but I googled on the web for SQLState=42000 and found some information https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2c22ee89-faf8-4118-b5e9-048e7f7e7fbe/connection-failed?forum=sqldatabaseengine . Read it but not sure whether it is helpful. I will let others to give their advice 🙁 . But before that can you try to re-register the PcVue Component Registration and try again the db creation with sa password?
rgds
Posted : 08/03/2016 2:56 pm
Your SQL server is local or distant ?
Posted : 08/03/2016 2:58 pm
Hello,
These errors mean that the HDS is unable to reach the database, obviously it has not been created.
In traces, database creation should be found before the line "Setup loaded". There is nothing here !
What to do now:
- Check that within SSMSE you can create a databse with the user you are using for the HDS
- Check the permissions of the Databases folder (see KB484)
- Add the traces ADOX, ADO and ADO Events, and post the result here (don't forget to remove them once the issue is solved)
Posted : 08/03/2016 9:25 pm
Topic starter
Thank you all.
The issue is solved by giving the permission of Authenticated Users to PcVue installation folder.
My OS is Win10. This issue may caused by updating Win7 to Win10.
BRs,
Mark
Posted : 09/03/2016 8:45 am