rick 0 Report post Posted September 7, 2015 Error opening Database! (80004005)[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. did somebody else did get this problem with open Queue. please answer me in the forum gr rick 0 Quote Share this post Link to post Share on other sites
Tom Wellige 60 Report post Posted September 7, 2015 Have you configured a login within the SQL server which grants read/write access to the OpenQueue database and is connected with the "SwyxWare Server Account" windows account ? 0 Quote Share this post Link to post Share on other sites
Tom Wellige 60 Report post Posted September 7, 2015 Sorry, I just figured, that you are talking about the little demo website. If you can't connect via integrated security just create another login to the SQL server which grants read/write access to the OpenQueue database and which uses SQL Authentication (username/password). In this case you have to modify the connect string according this scheme: oConn.Open "Provider=sqloledb;" & _ "Data Source=myServerName;" & _ "Initial Catalog=myDatabaseName;" & _ "User Id=myUsername;" & _ "Password=myPassword" 0 Quote Share this post Link to post Share on other sites
rick 0 Report post Posted September 7, 2015 i have made a new user for sql with authentication, reader and write and changed the connect string but it still not working 0 Quote Share this post Link to post Share on other sites
Tom Wellige 60 Report post Posted September 7, 2015 Are you sure you have the correct sql server name and the correct database name in the connect string? 0 Quote Share this post Link to post Share on other sites
rick 0 Report post Posted September 7, 2015 i pretty sure that i use the right server and database name in the connect string 0 Quote Share this post Link to post Share on other sites
Tom Wellige 60 Report post Posted September 7, 2015 Please post your connect string here (without the password included). 0 Quote Share this post Link to post Share on other sites
rick 0 Report post Posted September 8, 2015 Const oConn.Open "Provider =sqloledb;" & _ "Data Source =WIN-4NLA0S4DFT0;" & _ "Initial Catalog =OpenQueue;" & _ "User Id =openqueue;" & _ "Password =Rick123;" 0 Quote Share this post Link to post Share on other sites
Tom Wellige 60 Report post Posted September 8, 2015 If you say that all information in this connect string is correct, then the problem must be somewhere else. Is the SQL server on the same machine as the IIS? Is there some firewall in between blocking SQL ports? 0 Quote Share this post Link to post Share on other sites
rick 0 Report post Posted September 8, 2015 i have solved the connection string, but now if i connect the page is just white 0 Quote Share this post Link to post Share on other sites
Tom Wellige 60 Report post Posted September 8, 2015 Have you had already a call in the call queue? If not your queue is simply not yet created in the database and therefore the webpage has nothing to display. So please do at least one call into your queue script so everything will be created properly within the database. 0 Quote Share this post Link to post Share on other sites
rick 0 Report post Posted September 9, 2015 thanks for the help it work just fine 0 Quote Share this post Link to post Share on other sites
Tom Wellige 60 Report post Posted September 9, 2015 Hi Rick, I am glad to read that 0 Quote Share this post Link to post Share on other sites