Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'B47\Kola'.

Posted on 2008-06-25
Last Modified: 2013-11-26
Please i cant seem to find out what i and doing wrong, i am getting the error "Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'B47\Kola'."

i am using a stored procedure to add data from form to SQL SERVER 2005, i have attached below the snippets stored procedure, Addevent.aspx.cs, and web config respectively

Please can some help


ALTER PROCEDURE dbo.StoredProcedure1 
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	@EventId varchar(50),
	@UserId varchar(50),
	@CatId varchar(50),
	@EventName varchar(50),
	@Organiser varchar(50),
	@ContactEmail varchar(50),
	@ShortText varchar(50),
	@LongText varchar(50),
	@Address varchar(50),
	@City char(30),
	@Price Money,
	@Thumbnail varchar(20),
	@eImage varchar(20),
	@eDate datetime,
	@eTime varchar(10),
	@Venue varchar(50),
	@Tickets varchar(50),
	@Age char(10)
(EventId, UserId, CatId, EventName, Organiser, ContactEmail, ShortText, LongText, Address, City, Price, Thumbnail, eImage, eDate, eTime, Venue, Tickets, Age)
	VALUES(@EventId, @UserId, @CatId, @EventName, @Organiser, @ContactEmail, @ShortText, @LongText, @Address, @City, @Price, @Thumbnail, @eImage, @eDate, @eTime, @Venue, @Tickets, @Age)
public partial class AddEvent : System.Web.UI.Page
    protected void Page_Load(object sender, EventArgs e)
           if (!IsPostBack)
               MembershipUser myObject = Membership.GetUser();
               string UserID = myObject.ProviderUserKey.ToString();
               Label6.Text = UserID;
    protected void Button1_Click(object sender, EventArgs e)
        SqlCommand cmd = new SqlCommand("StoredProcedure1 ", new SqlConnection(ConfigurationManager.AppSettings["ConnString"]));
        cmd.CommandType = CommandType.StoredProcedure;
        /*cmd.Parameters.AddWithValue("@UserID", UserID);*/
        cmd.Parameters.AddWithValue("@EventName", eName.Text);
        cmd.Parameters.AddWithValue("@city", Organiser.Text);
        cmd.Parameters.AddWithValue("@ContactEmail", ContactEmail.Text);
        cmd.Parameters.AddWithValue("ShortText", Short.Text);
        cmd.Parameters.AddWithValue("@LongText", Long.Text);
        cmd.Parameters.AddWithValue("@Address", Address.Text);
        cmd.Parameters.AddWithValue("@City", City.Text);
        cmd.Parameters.AddWithValue("@Price", Price.Text);
        cmd.Parameters.AddWithValue("@eDate", Date.Text);
        cmd.Parameters.AddWithValue("@eTime", Time.Text);
        cmd.Parameters.AddWithValue("@Venue", Venue.Text);
        cmd.Parameters.AddWithValue("@Tickets", Tickets.Text);
        /*cmd.Parameters.AddWithValue("@Age", Age.SelectedIndex.ToString);*/
        /*cmd.Parameters.AddWithValue("@name", txtName.Text);
        cmd.Parameters.AddWithValue("@city", txtCity.Text);
        cmd.Parameters.AddWithValue("@name", txtName.Text);
        cmd.Parameters.AddWithValue("@city", txtCity.Text);*/
		<add name ="ASPNETDBConnectionString1" connectionString ="Data Source= .\SQLEXPRESS; Integrated Security = True;  Initial Catalog= ASPNETDB"  providerName ="System.Data.SqlClient"/>		
				<network host="localhost"/>
    <validation validateIntegratedModeConfiguration="false"/>
      <add name="ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
      <remove name="WebServiceHandlerFactory-Integrated" />
      <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode"
           type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
      <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode"
           type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
      <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
		<add key="ConnString" value="Data Source=.\SQLEXPRESS;Initial Catalog=ASPNETDB;Integrated Security=True"/>

Open in new window

Question by:kladtek
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 21

Accepted Solution

naspinski earned 500 total points
ID: 21864700
look in your SQL Server Management Studio.

Under Security->Logins, make sure that that user is there and has sufficient rights.

Author Comment

ID: 21865175
thanks for your reply

having a look at the logins as u mentioned her is what i found


i guess the user is not there

what do i do next

thanks again
LVL 21

Expert Comment

ID: 21865207
you can add the user by right clicking 'Logins' and select 'New Login' now browse for the user and give them proper permissions in the 'server roles' tab.

Author Comment

ID: 21865620
hello thanks again

i successfully did that,

however, when i ran the script again it still gave me the same error message
LVL 21

Expert Comment

ID: 21871227
Is this on the same machine?
Do you have remote connections enabled?

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question ( here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question