rick Posted September 7, 2015 #1 Share 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 Link to comment Share on other sites More sharing options...
Tom Wellige Posted September 7, 2015 #2 Share 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 ? Link to comment Share on other sites More sharing options...
Tom Wellige Posted September 7, 2015 #3 Share 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" Link to comment Share on other sites More sharing options...
rick Posted September 7, 2015 Author #4 Share 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 Link to comment Share on other sites More sharing options...
Tom Wellige Posted September 7, 2015 #5 Share Posted September 7, 2015 Are you sure you have the correct sql server name and the correct database name in the connect string? Link to comment Share on other sites More sharing options...
rick Posted September 7, 2015 Author #6 Share Posted September 7, 2015 i pretty sure that i use the right server and database name in the connect string Link to comment Share on other sites More sharing options...
Tom Wellige Posted September 7, 2015 #7 Share Posted September 7, 2015 Please post your connect string here (without the password included). Link to comment Share on other sites More sharing options...
rick Posted September 8, 2015 Author #8 Share Posted September 8, 2015 Const oConn.Open "Provider =sqloledb;" & _ "Data Source =WIN-4NLA0S4DFT0;" & _ "Initial Catalog =OpenQueue;" & _ "User Id =openqueue;" & _ "Password =Rick123;" Link to comment Share on other sites More sharing options...
Tom Wellige Posted September 8, 2015 #9 Share 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? Link to comment Share on other sites More sharing options...
rick Posted September 8, 2015 Author #10 Share Posted September 8, 2015 i have solved the connection string, but now if i connect the page is just white Link to comment Share on other sites More sharing options...
Tom Wellige Posted September 8, 2015 #11 Share 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. Link to comment Share on other sites More sharing options...
rick Posted September 9, 2015 Author #12 Share Posted September 9, 2015 thanks for the help it work just fine Link to comment Share on other sites More sharing options...
Tom Wellige Posted September 9, 2015 #13 Share Posted September 9, 2015 Hi Rick, I am glad to read that Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.