ANSWERED Error Opening Database! (80004005) (Openqueue)

[rick 0]

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 

[Tom Wellige 61]

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 ?

[Tom Wellige 61]

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"

[rick 0]

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

[Tom Wellige 61]

Are you sure you have the correct sql server name and the correct database name in the connect string?

[rick 0]

i pretty sure that i use the right server and database name in the connect string

[Tom Wellige 61]

Please post your connect string here (without the password included).

[rick 0]

Const oConn.Open    "Provider              =sqloledb;" & _

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

                                   "Initial Catalog     =OpenQueue;" & _

                                   "User Id               =openqueue;" & _

                                   "Password           =Rick123;"

[Tom Wellige 61]

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?

[rick 0]

i have solved the connection string, but now if i connect the page is just white 

[Tom Wellige 61]

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.

[rick 0]

thanks for the help it work just fine

[Tom Wellige 61]

Hi Rick,

 

I am glad to read that