So I installed everything but I keep getting the error message "Could not connect to database using 'DSN=ApodoraDSN;uid=ApodoraUser;pwd=d3fault'.
I have tried re-installing the database portion and a cmd window flashes which says:
"SQLCMD.exe" …Cannot open database "ApodoraDB" requested by the login. The login failed.
Is there any way I can delete the database and try to reinstall everything? I think the database exists but Apodora is unable to login and the reinstall isnt fixing things.
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I had similar problem with access to database:
I was fighting with servie configuration and firewall.
But I did a thing which I think solved the problem.
1. control Panel\Administrative Tools\Data Sources(ODBC)
2 User Data Sources Tab \ add
3 Select SQL server
4. any name any description server (point your local server - i used 127.0.0.1\SQLEXPRESS
5. in next window (DNS service configuration) select
* With SQL Server authentication using Loginid and password entered by the user
mark/thick ON checkbox with :Connect SQL server to obtain default settings for the additional configuration options
LoginID: ApodoraUser
password (i left that empty - but could be a password: d3fault"
click next and finish that wizard.. and everything strat to work.
PS it may be a good idea to ACCEPT (UNBLOCK) incoming traffic on port 1941 (TCP should be enough)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
So I installed everything but I keep getting the error message "Could not connect to database using 'DSN=ApodoraDSN;uid=ApodoraUser;pwd=d3fault'.
I have tried re-installing the database portion and a cmd window flashes which says:
"SQLCMD.exe" …Cannot open database "ApodoraDB" requested by the login. The login failed.
Is there any way I can delete the database and try to reinstall everything? I think the database exists but Apodora is unable to login and the reinstall isnt fixing things.
Thanks
Ahh.. I figured it out. I deleted the database in the SQL Server MSSQL directory then reinstalled. Looks like everything installed correctly.
Thanks
hi kevinrees7,
i am getting the same error as yours… what and how exactly did you delete and reinstall the sql server mssql?
thanks in advance.
I had similar problem with access to database:
I was fighting with servie configuration and firewall.
But I did a thing which I think solved the problem.
1. control Panel\Administrative Tools\Data Sources(ODBC)
2 User Data Sources Tab \ add
3 Select SQL server
4. any name any description server (point your local server - i used 127.0.0.1\SQLEXPRESS
5. in next window (DNS service configuration) select
* With SQL Server authentication using Loginid and password entered by the user
mark/thick ON checkbox with :Connect SQL server to obtain default settings for the additional configuration options
LoginID: ApodoraUser
password (i left that empty - but could be a password: d3fault"
click next and finish that wizard.. and everything strat to work.
PS it may be a good idea to ACCEPT (UNBLOCK) incoming traffic on port 1941 (TCP should be enough)