Advertisement

06.25.2008 at 05:13AM PDT, ID: 23514115
[x]
Attachment Details

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

Asked by kladtek in Visual Studio .NET 2005, SQL Server 2005

Tags: Microsoft, SQL Server, 2005, C#, Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'B47\Kola'

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

thanks
Start Free Trial
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
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)
	
AS
 
INSERT INTO Events
(EventId, UserId, CatId, EventName, Organiser, ContactEmail, ShortText, LongText, Address, City, Price, Thumbnail, eImage, eDate, eTime, Venue, Tickets, Age)
	/* SET NOCOUNT ON */ 
	
	VALUES(@EventId, @UserId, @CatId, @EventName, @Organiser, @ContactEmail, @ShortText, @LongText, @Address, @City, @Price, @Thumbnail, @eImage, @eDate, @eTime, @Venue, @Tickets, @Age)
	RETURN
 
 
/////////////////////////////////////////////////
 
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);*/
 
        cmd.Connection.Open();
        cmd.ExecuteNonQuery();
        cmd.Connection.Close();
    
     
    }
}
 
 
////////////////////////////////////////////////////
 
</system.web.extensions>
	<connectionStrings>
		<add name ="ASPNETDBConnectionString1" connectionString ="Data Source= .\SQLEXPRESS; Integrated Security = True;  Initial Catalog= ASPNETDB"  providerName ="System.Data.SqlClient"/>		
		
	</connectionStrings>
	<system.net>
		<mailSettings>
			<smtp>
				<network host="localhost"/>
				
			</smtp>
			
		</mailSettings>
		
	</system.net>
	
 
  <system.webServer>
    <validation validateIntegratedModeConfiguration="false"/>
    <modules>
      <add name="ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
    </modules>
    <handlers>
      <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" />
    </handlers>
  </system.webServer>
 
	<appSettings>
		<add key="ConnString" value="Data Source=.\SQLEXPRESS;Initial Catalog=ASPNETDB;Integrated Security=True"/>
	</appSettings>
</configuration>
[+][-]06.25.2008 at 05:25AM PDT, ID: 21864700

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Visual Studio .NET 2005, SQL Server 2005
Tags: Microsoft, SQL Server, 2005, C#, Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'B47\Kola'
Sign Up Now!
Solution Provided By: naspinski
Participating Experts: 1
Solution Grade: B
 
 
[+][-]06.25.2008 at 06:16AM PDT, ID: 21865175

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.25.2008 at 06:19AM PDT, ID: 21865207

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.25.2008 at 06:55AM PDT, ID: 21865620

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.25.2008 at 06:52PM PDT, ID: 21871227

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628