Error: Could not connect to database

The following error is encountered while trying to Host the site from IIS ..
" The Assembly Version ([ASSEMBLY VERSION]) does not match the Database Version ([DATABASE VERSION]).
"Error: Could not connect to the database specified in the connection string for SqlDataProvider. "

We have 2 different machines, over which we have 2 different SQL Server.
In Web.Config, if we give server=server1 it works well and there is no problem at all...
if we give server=server2, and executehttp://localhost/application, the above mentioned error occurs..

and yes the application is hosted on 3rd machine......

Can anyone throw some light on this regard.
Its urgent.

You're using DotNetNuke, right? Try this search on the Forums to see other threads on this topic:
http://forums.asp.net/search/SearchResults.aspx?q=ASSEMBLY+VERSION+match+DATABASE+VERSION&o=Relevance

error: 40 - Could not open a connection

I am developing a web service that uses a sql data connection.

The sql database is on a server, and the development version of my web service is on my pc.

I can connect/access the data accross my network when I run the service on my PC, but as soon as I put the web service onto the server(with the sql) it displays, the service wont function - error: 40 - could not open a connection....

I presume that sql is configured correctly as I am recieving data back when I request it accross the network. I dont understand why it wont work when I have the service on the server with the sql?

Any help will be appreciated.

Do you mean your web service and SQL server are on the same machine? Can you post your connection string here? On which account your web service is running?|||

Yes they are both on the same server

"Data Source=SV1;Initial Catalog=SiteVisitSQL;Integrated security=sspi"

My web service is running on IUSR_SV1, I have created an account for the database/user in Microsoft SQL Server Management Studio Express

Ive never configured anything like this before so any help is much appreciated.

|||

Thanks for all your help

I solved this by adding a user for NT AUTHORITY\NETWORK SERVICE in SQL Management studio

Error: 17883 - The scheduler 0 appears to be hung...

Environment:
Clustered SQL Server 2K sp3a (single instance)
Product version: 8.00.760
Problem:
I end up in error 17883.
I am aware that the solution is to apply this patch:
821277 MS03-031:Security Patch for SQL Server 2000 Service
Pack 3.
I am also aware that after you install this cumulative
patch you will end up in this problem:
826161 FIX: You are prompted for password after you change
a standard SQL Server login.
After reading this one I found that there are 2
possibility to solve this problem, one if you have already
installed the security patch from MS03-031 and another one
if you do NOT have installed this patch.
Question:
Do I only need to apply this last one (is it also
cumulative?) or do I need to first apply MS03-031 and then
later the FIX 826161?
Please advise.
Kind regards.
You will need to follow the instructions in the section "If you have not
installed the security patch for Microsoft Security Bulletin
MS03-031,Q826161..." . This will include the
fix for the Enterprise Manager issue.
Additionally, this will not fix the cause of the 17883. This will only
provide additional diagnostic information for Microsoft Support should a
17883 occur which was not available in previous builds. If you believe you
are seeing performance issues at the time the 17883's are being recorded, I
urge you to open a case with Microsoft Support for assistance.
Regards,
Farooq Mahmud [MS SQL Support]
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
|||Thank you so much for your answer.
I still don't understand why, when you read MS KB article
810885,under resolution, you find the reference for MS03-
031 Cumulative Security Patch for SQL Server.
What does this cumulative patch solve?
I was sure that it will solve many problems, most of them
security related, but also the 17883 problem.
If this cumulative patch does not solve the 17883 problem
so I don't need to install any patch, right?
Am I wrong?
Please advise.

Error while Installing SQL Server evaluation version - sqlunirl.dll not found

Hi

When I attempt to install MS SQL Server evaluation copy (downloaded
from Microsoft site) on Windows 2K Professional getting following
error.

Setup initialization error.
The system cannot find the path specified.

Source file or directory missing or cannot be read:
'C:\SQLEVAL\x86\setup..\System\sqlunirl.dll'

Please help.

Regards,
AGajay_gupta@.consultant.com (ag) wrote in message news:<8125681d.0312112140.4b69e1bd@.posting.google.com>...
> Hi
> When I attempt to install MS SQL Server evaluation copy (downloaded
> from Microsoft site) on Windows 2K Professional getting following
> error.
> Setup initialization error.
> The system cannot find the path specified.
> Source file or directory missing or cannot be read:
> 'C:\SQLEVAL\x86\setup..\System\sqlunirl.dll'
> Please help.
> Regards,
> AG

I will download the missing dll and give it another try

Michael Tubuo Ngong