jamie Posted August 16, 2019 Share Posted August 16, 2019 I have installed the product but cant connect to the sqlexpress. When using the server (same server for both) ip address Resolving host name of database server... Executing creation of temporary database... Login timeout expired A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. When using the server name Resolving host name of database server... Executing creation of temporary database... Login failed for user 'Root'. I can connect to the database with ssms what do I need to do? Link to comment Share on other sites More sharing options...
jamie Posted August 16, 2019 Author Share Posted August 16, 2019 I can create a DB without any issue but I cant get anywhere using the setup software Link to comment Share on other sites More sharing options...
support Posted August 16, 2019 Share Posted August 16, 2019 Hi Jamie, When you say you can create a DB, do you mean outside of Passwordstate? In the information above, you seem to be using the account called root - this is not standard in SQL Server, and have you specifically created this account - and does it have permissions to create databases? The default admin account in SQL Server is called sa. If everything is okay with the 'root' account, can you provide a screenshot of what values you are specifying on this setup screen? Thanks Click Studios Link to comment Share on other sites More sharing options...
jamie Posted August 19, 2019 Author Share Posted August 19, 2019 I have enables sa, and created user 'root' both can create db in visual studio but neither work in the setup software Link to comment Share on other sites More sharing options...
support Posted August 19, 2019 Share Posted August 19, 2019 Hi Jamie, There must be some sort of configuration issue here, as the 'sa' account has the privileges to do this. Can you please log a support call via the following page https://www.clickstudios.com.au/support.aspx and provide screenshots of the details you are entering into the setup screen? If you need to re-initialize the installer for any reason, you can follow this article for that. https://www.clickstudios.com.au/community/index.php?/topic/1663-resetting-the-passwordstate-setup-process/ Regards Click Studios Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now