.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Eminent IT
Post New Web Links

can't open the database

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :ASP.Net

Hi Experts,

i have created a small app wit VWDE 2008 Express.

Now i have dublicate  this app and the sql database for a second project.

I renamed the databe and added to the sql express server.

My problem now is by clicking F11 i recieve this error message: can't logon with the user XPV1\user

Im allready trying to solve it for several hours but without any success.

I hope somebody here can help me

View Complete Post

More Related Resource Links

Cannot open database "ReportServer$SQLEXPRESS" requested by the login. The login failed. (App Log Ev

I have SQL'08r2x64 freshly installed on a WS'03r2x64sp2 box and WS is also a DC (sorry).  Previously, there was a SQL'05sp3 installation on this box and it worked splendito.  I used the SQL'05 for some minor devel and to host a Backup Exec 11D db/installation; it all was splendito.   Then, i removed SQL'05&BE11D to prepare for an upgrade of this arrangement.  Next, i installed said SQL'08 to be the foundation for a planned Backup Exec 12.5 install.  To date, I can't get to a clean install of SQL'08 and thus have not progressed to installing BE12.5.  I now have this painfully annoying situation (as i've been beating on it for 2 days) where a series of errors occur during boot: 1st: srmSvc; Event ID 12317; File Server Resource Manager failed to enumerate share paths or DFS paths.  Mappings from local file paths to share and DFS paths may be incomplete or temporarily unavailable.  FSRM will retry the operation at a later time. 2nd & 3rd (occurs twice): MsSQL$buExpressSQL; Event ID 18456; Login failed for user 'BOWMAN\ExecSQL'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>] 4th: Report Server Windows; Event ID 107; Report Server Windows Service (SQLEXPRESS) cannot connect to the report server database. I couldn't find anything to sink my teeth into for the 12317 error; i

Use Database.Open for ConnectionString from web.config

This is an FYI - I am not looking for a solution:As mentioned in this tutorial (http://www.asp.net/webmatrix/tutorials/5-working-with-data), I tried using my own connectionstring from web.config. I got this error: "Format of the initialization string does not conform to specification starting at index 0."The tutorial suggests to use: Database.OpenConnectionString("SmallBakeryConnectionString") method Instead you should use Database.Open("ConnectionStringName").Ref: http://cytanium.com/forums/yaf_postsm18_Connection-string-problem.aspxThe API Document is missing Database.Open method and also Database.OpenConnectionString info needs to be modified.

Cannot open database " " requested by the login. The login failed.

Hi, I am trying to take the backup of the sitecolletion using stsadm -o command, getting the following error. Cannot open database "dbName " requested by the login. The login failed. Login failed for user  'User'. Any help appriciated. Thanks Srikanth Reddy

Can I have an SQL Express database open in VS2010E along with the website? "Login failed for user ..

Hi, as the topic says..Whenever I have my database open in Visual Studio 2010 Express, I get this error:Cannot open user default database. Login failed.Login failed for user 'IIS APPPOOL\DefaultAppPool'.Cannot open user default database. Login failed.Login failed for user 'IIS APPPOOL\DefaultAppPool'.

Cannot open database "dbTest" requested by the login. The login failed.

Hi,All Hi, all      I meet a problem and an error: Cannot open database "dbTest" requested by the login. The login failed.Login failed for user 'machinename'. The condition is like this: 1 I make my website connect to a remote sql server. 2 This sql server makes only access to a count, such as 'sa' and its password is 'sapw' 3 I write the connect string in web.config like this : <add name="ConnectionString" connectionString="Data Source=dbTestSource;Initial Catalog=dbTest;Integrated Security=True;    User ID=sa;Password=sapw;"    providerName="System.Data.SqlClient" />   But the error says "Login failed for user 'machinename'". How could I make my website access to the sql server with the account of "sa"?  

claims authenticated (FBA) user cannot open a connection to our custom application database

We have designed a custom sharepoint site. This site uses a membership provider that I implemented, and the users are stored in our custom application database. These are the steps I follow to reproduce the error: 1. Browse to our site. Select Forms Authentication from the default.aspx selection. 2. Enter in a username from our DB table. This user I have configured as a site collection administrator. 3. Login to the site. The user is authenticated by our membership provider and allowed access (ValidateUser returns true) 4. Browse to a page that attempts to connect to the custom app DB. 5. I get the following error when the page attempts to open a connection to our DB: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server NOTES: The code that opens the DB connection is running with SPSecurity.RunWithElevatedPrivileges. Our application pool account has access to the database. My user can connect to the database fine as well as the user that our  application pool is running as. I have validated the connection string that is being used in the debugger, and that is correct.

Failed upgrade from wss 3.0 to moss 2007. Cannot open database "ProjectServer-live_Published" reques


While trying to upgrade from WSS 3.0 to MOSS 2007 the process finished, but it stated that it completed with errors. Those errors seem to be causing problems within the Central Administration site. I will try outline the errors the best I can from the upgrade.log file and with the actions I've been attempting. THANK YOU in advance for any and all assistance.

[SharedResourceProviderSequence] [ERROR] [9/23/2010 11:15:03 AM]: Unable to locate SearchDatabase for the SharedResourceProvider Hyperion_SSP
[SharedResourceProviderSequence] [ERROR] [9/23/2010 11:15:03 AM]: Exception thrown was: System.ArgumentNullException: Value cannot be null.
Parameter name: No search database is associated with the search shared application, Hyperion_SSP
   at Microsoft.Office.Server.Search.Upgrade.SharedResourceProviderSequence.get_SearchDatabase()
   at Microsoft.Office.Server.Search.Upgrade.SharedResourceProviderSequence.AddNextLevelObjects()
[SharedResourceProviderSequence] [INFO] [9/23/2010 11:15:03 AM]: Re-run upgrade using stsadm -o upgrade to ensure the search database gets upgraded appropriately
[SharedResourceProviderSequence] [DEBUG] [9/23/2010 11:15:03 AM]: No search database was found, so skip upgrading it

As advised in the info section for this error I re-ran the upgrade

create and open global database connection object


Hi to everyone:

I`m trying to install the allinta cms software www.allinta.com, I have already create a MySQL Data Base, but when I try to launch my cmsadmin I t appears an error

Microsoft VBScript runtime error '800a01f4'

Variable is undefined: 'dbConnectionStr'

/cmsadmin/inc/db_connection.asp, line 75

IT  seems to be the Object Connection, could somebody help me to give the right code instruction please, I don´t have an idea on how to make it.

At this moment I opened in dreamweaver and it´s

Set objConn = Server.CreateObject("ADODB.Connection")

SqlException Cannot Open Database WSS_Content_INTRANET


Hi, I'm getting

SqlException: Cannot open database "WSS_Content_INTRANET" requested by login. The login failed.
Login failed for user "SQLSERV\Administrator".

The farm is running fine.  The problem only happens when my Windows service makes a call to SPWeb.GetFile(String strUrl).

Does anyone know how I could be getting this error?  Two things seem weird here, 1) the service account is DOMAIN\Administrator, so why is it showing login failed for the local SQL Server machine user SQLSERV\Administrator?  And 2) why am I getting this message at all?  Shouldn't I be getting some sort of SharePoint security exception instead of an SqlException if there's a problem like this?

If you need anymore detail, just let me know.


my blog - Tea Time with Meowkins

Cannot open database on Locally Host


i have developed fees management system for school in asp.net , sql server 2005 as database , it was working fine before i host locally but when i host it locally it shows error on every dynamic page Error Server Error in '/fms' Application. Cannot open database "fees_system" requested by the login. The login failed. Login failed for user 'COMPUTER6\ASPNET'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot open database "fees_system" requested by the login. The login failed. Login failed for user 'COMPUTER6\ASPNET'. Source Error: Line 17: cn = New SqlConnection Line 18: cn.ConnectionString = ConfigurationManager.ConnectionStrings("fees_systemConnectionString").ToString Line 19: cn.Open() Line 20: cmd = New SqlClient.SqlCommand("select * from login", cn) Line 21: dr = cmd.ExecuteReader Source File: F:\software\FeesManagementSystem\fees_system\homepage.aspx.vb Line: 19 Stack Trace: [SqlException (0x80131904): Cannot open database "fees_system" requested by the login. The login failed. Login failed for user 'COMPUTER6\ASPNET'.] System

Cannot open database "db" requested by the login. The login failed. Login failed for user 'NT AUTHO


I am working with visual studio 2010, ms sql server 08 R2, IIS 7.5, I am trying to connect to the database the following error appear every time I try to open the connection with the server:

Cannot open database "db" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "db" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Source Error: 

Line 47:             //    "','&qu

Database.Open("wishlist"); in MVC3 controller not working


I am unable to reference the WebMatrix.Data dll with this using statement in my controller:

using WebMatrix.Data;

Therefore I can't use this statement:


Anythought on how to add the dll to my project?  I can't seem to find it in the Programs/Webmatrix folder.




Open .MDF Database


When I try to open a .MDF file with SQL Server Management Studio Express last version I get an error :

There is no editor available for "DATABASE.MDF"

Make sure the application for the file type (.MDF) is installed.

How can I open the MDF file.I tried to use also the database NORTHWIND.MDF provided with

MSSQL 2000  sample but the same error.

What can I do ?

I am using Microsoft SQL Server 2005 Express.

I want to open the .MDF file to create a index for Full Text Search.

Thank You !

How do I open database version 661? I have verion 612


I am using a Gridview in Visual Studio 2008 and have imported a database to use as the datasource. When I try to link the database to the datasource I get this message:

The Database 'xxxxx' cannot be opened because it is version 661. This server supports 612 and earlier....

What do I need to install to get it to open? I have windows server 2008 R2 installed.


This is my discovery report:

Discovery Report for Microsoft SQL Server 2008 R2 Setup

Microsoft SQL Server 2008 R2 Setup Discovery Report

Cannot open database "ProjectServer_Draft" requested by the login.


I have a Project Web App installed that is attached to ProjectServer_Draft2 database. In the past however I have had it point to 'ProjectServer_Draft'. This database is now deleted however in the event logs i can still the follwing error message.

Cannot open database "ProjectServer_Draft" requested by the login.

Please advise how can i get rid of this error.



how to open a database in a webmatrix C# file?


In the webMatrix examples, which I have working, it's very easy to access a database. Only three lines are necessary to get up and going:

    var db = Database.Open("LOS");  
    var selectQueryString = "SELECT * FROM wknTest"; 

and a little later,

 @foreach(var row in db.Query(selectQueryString)){  

There's no using's, no connection strings, all that happens behind the scenes. But now I have enough complicated c# code that I want to separate it into a separate C# file. How would I do the above, but in a C# file residing in the app_code folder in a webMatrix project? 

WebMatrix must be creating the Database object behind the scenes.  So I'm really asking how do I have access to that.

cannot open adventureworks database do not have sufficient permissions


i can open adventureworks on one computer but not the other i am using visual web developer


Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2005 SQLEXPRESS MSSQL.1 Database Engine Services 1033 Express Edition 9.2.3042 No
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend