I am using SQL2008 SP1. I am frequently getting below errors.
Login failed for user 'xyz'. Reason: Failed to open the database configured in the login object while revalidating the login on the connection.
The error is automatically getting resolved. Do anyone have come across with the same error.
View Complete Post
We have to do a lot of restore from backups for a development on a production sql 2008 server.
This daily job or by request job will have 3 steps.
Step 1 kill the user that was using such @dbname
declare killprocess_cursor cursor for
select a.spid from sysprocesses a join
sysdatabases b on a.dbid=b.dbid where b.name=@dbname
Step 2 Restore database, from a fixed path using a T-Sql
RESTORE DATABASE db_abc FROM DISK = 'H:\RestoreDB\db_abc_FullBK.bak' with replace
Step 3 restore users
Sometimes the daily job will fail at 2. The by request job will fail at 1.
I am concern with daily job failure now. Error message:
Executed as user: myDomain\myISAgentAcct. Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] (Error 3101) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
When I use sp_who2, there is none using the db and rerun result with the same error. I have to take it offline, detach, attach again and rerun the job to finish it without error.
What bugs me... the job will run for in most days and fail in other. I already has a kill user step and no one works at the schedule night time.
My last suspicion... either Report service has a hold on
i am using create user wizard and capturing other information within content template when a new user
registers. Some of the textboxes are binded to required field validators.
there is a validation control on the page and ShowMessage box is True.
If they dont complete some of the text boxes then the message box pops Up with the error message.
It does not however include information errors like "User already exists" or Email address already exists
from the create user wizard membership UserName and Password Textboxes
is it possilbe to hook all of these up so I get one message box with all errors including membership ones?
Hi, there is an upgrade to my infimacs server and my web application encounter this error after the infimacs is upgraded.
Below is the information on the server before/after the upgrade.
Solaris 8 Solaris 10
IDS 9.40 IDS 11.50
The web server where the web application hosted is running IBM Informix Connect 2.81. There is no such error before the upgrade is done.
As a developer, i have IBM Informix Client-SDK 2.90 installed on my local pc and debug the page where the read is needed from infimacs but no such error found.
The error come out only when it is hosted on the web server where IBM Informix Connect 2.81 is installed.
I have gone through many articles and it suggest me to set the environement variable in the server : DB_LOCALE=en_us.819.
I haven't try this solution but i think that this might not be the best solution.
Is it possible to to to have this settin
Im using Enterprise library 5.0I have a scenario, where I have to access two
different databases in my application.Basically this application is a
webservice,delployed on my local for testing purpose.I'm trying to access
this web method from diffent windows application, default connection works fine
but the other database throw's exception.Problem is only my
defaultDatabase is works fine, if I change defaultDatabase="MYCON1" with
"MYCON2" it works fine, if I try to access the other database which is not
default, throws exception.<dataConfiguration defaultDatabase="MYCON1"
connectionString="Data Source=server1;Initial Catalog=dbName1;User
Has anyone deployed a website using the login database in the visual studio 2010 asp website template? I was wondering if I could look at someone's example to see how the integrated this into their website.
I followed the tutorial at http://www.asp.net/mvc/videos/creating-a-movie-database-application-in-15-minutes-with-aspnet-mvc At 12:04 in the video, the author, Stephen Walther. inclues the line
When I tried to compile this I get an error:
Error 1 'MovieApp.Controllers.MoviesDbEntities' does not contain a definition for 'MovieSet' and no extension method 'MovieSet' accepting a first argument of type 'MovieApp.Controllers.MoviesDbEntities' could be found (are you missing a using directive or an assembly reference?) P:\experiment\MovieApp\MovieApp\Controllers\HomeController.cs 18 35 MovieApp
If I just enter return View(_entities. then Intellisense offers Equals, GetHashCode, GetType, and TosString.Does this suggest that _entities is not being i
If I just enter return View(_entities. then Intellisense offers Equals, GetHashCode, GetType, and TosString.
Does this suggest that _entities is not being i