rick

Error Opening Database! (80004005) (Openqueue)

Recommended Posts

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 

post-711-0-02886800-1441617699_thumb.png

Share this post


Link to post
Share on other sites

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 ?

Share this post


Link to post
Share on other sites

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"

Share this post


Link to post
Share on other sites

i have made a new user for sql with authentication, reader and write and changed the connect string but it still not working 


Share this post


Link to post
Share on other sites
Const oConn.Open    "Provider              =sqloledb;" & _

                                   "Data Source       =WIN-4NLA0S4DFT0;" & _

                                   "Initial Catalog     =OpenQueue;" & _

                                   "User Id               =openqueue;" & _

                                   "Password           =Rick123;"

Share this post


Link to post
Share on other sites

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?


Share this post


Link to post
Share on other sites

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.


Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now