Jump to content
rick

ANSWERED 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

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
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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and have taken note of our Privacy Policy.
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.