I am attempting to add a database to the AppData folder. It seems to only want to use SQL Express, which I have read is not a good idea for a live website for the purposes of memberships. How do I change the default Express to SQL2008.
View 6 RepliesI been trying to attach a database in sql 2008 express created in VS 2008 Professional. I have been getting error message and codes which there is no support for once you click the link in the message whats up with that? to my most recent memory it had something to do with permissions... but I was logged in as adminstrator so that confuses me.
View 2 RepliesUsing the Web Platform installer, in installed both the Visual Web Developer Express 2008 and SQL Server Management Studio Express 2008. Next, I connected to my local SQL Server Express 2008 and created a simple database and table using Visual Web Developer Express 2008 where the database file resided in the app data folder of my website. I can connect and explore the table from both Visual
Web Developer 2008 as well as the full blown version of Visual Studio 2008.
I have incorporated the asp.net membership and roles feature in my web app on my local dev setup that uses SQL 2008 Developer edition, all works as it should.
My remote system uses SQL 2005 express and I went through the process of creating the ASPNET membership tables via the "aspnet_regsql" command to my remote target database. I then created a few users, adjusted my app connection strings accordingly and uploaded.
My login page uses the "login" server control and when I try and login using credentials from one of the previously created users I get a "Your login attempt was not successful. try again." error. I know the users are in the DB as I can see then via the SQL Management studio on the remote DB. I have triple checked the username/passwords and I am definately entering the correct info. The connection strings are correct as the initial page renders content from another table in the DB. I am getting no errors.
My best guess at the moment is that SQL Express handles Membership/Roles connections differently to the full versions of SQL?
I am building an internal wep site for my team. I have installed visual web developer express to start with and connected it to an oracle database. I want to use Oraclemembershipprovider option for user login and control. On the Web Site Administration Tool page under Membership Provider, I am getting only one option "AspNetSqlMembershipProvider". However I want to use Oraclemembershipprovider. Can you please help. I am very new to asp.net and visual web developer express.
View 3 RepliesI am trying to access an SQL server2008 database from a VWD 2008 express GridView. I create the SqlDataSource and connect it to the gridview and thenn run the page and it is not rendered on the page. Visible is set to true.
View 8 RepliesI have written a website in ASP.NET with a back-end database using SQL Express 2008. My database is created and put in the App_Data folder. It is ok when it runs on my local machine. However, when I upload to the web server, I got the error: An attempt to attach an auto-named database for file C:Documents and ettingsDesktopProject2_ISAM5337App_DataEvent.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. By the way, I notice a same probelm : When I move my project to a location which is different from specific path for my database, I got the same error message .
View 1 RepliesAfter reinstalling Visual Web Developer 2008 express a few times I still don,t have design view just source view.
View 3 RepliesUsing Visual Web Developer 2008 Express with what I'm assuming is Sql 2008 Express. Using SqlDataSource, when I try to configure a data source, I'm able to input a server name: (local)sqlexpress and the "Test Connection" button shows that it was successful. However, if I type in a new database table name and VWD 2008 asks if I would like to create it, I keep getting the message: "OBJECT REFERENCE NOT SET TO AN INSTANCE OF AN OBJECT." No idea what that means or how to fix it. I can't open theDatabase Explorer View.
View 2 RepliesI jsut installed SQL server and management studio on my PC. For management studio, I created a database with tables. However, When I have data connection for SQL server in visual studio express, I couldn' t see the database I created.
View 1 RepliesIt works perfectly the first time I install SSMS 2008 Express and I can access my remote database. But, after I restart my machine and open an instance of SSMS the database node is missing.
Before:
After: [:(]
I tried refreshing the database folder but still nothing. I even uninstall but it's still the same.
I'm stumped. I have a client site on a virtual private server - Windows Web Server 2008 SP2, IIS7, SQL Server 2008 Express.I'm trying to setup a second web application, to allow him to review updates prior to their going live. I've created the web application in IIS7, and I have added a second database to SQL Server. The second db is essentially a copy of the production db, with 'DEV' prefixed to the database name and a few new fields in a few tables.My production site works fine. However, the test site comes back with an SqlException: "Invalid column name 'version'." This is one of the new fields - which leads me to believe that my dev site is referring to the production database, and not the dev database. Connection strings, however, do point to different databases (although the login is the same for both):
[code]...
This is my third site that I use role management, but the first time this happens. I have two roles: Member and Admin. If Admin user login, Admin node on sitemap shows. It works very well on my local machine in Visual Studio Express 2008 and in Visual Studio Team 2008. But once I deploy files to live site, even admin login, the Admin node doesn't show. I have a Member management page from which I may see member's role, and I can see that user name is in the role Admin. What could be wrong?
I used ASP.Net Configuration manager to create roles, users, and access roles. Here is the code:
in general site.config
<siteMap enabled="true " defaultProvider="XmlSiteMapProvider">
<providers>
<add name="XmlSiteMapProvider" description="Default SiteMap provider." type="System.Web.XmlSiteMapProvider"
siteMapFile="Web.sitemap" securityTrimmingEnabled="true"/>
[Code]....
When i add asp.net membership provider it uses some default database to add those records?How to change the default database to my own sql database?
View 1 RepliesI'm trying to access an SQL Server Express database out of an ASP.NET HTTP request handler. The handler is run under ASPNET account and uses "integrated security" in the SQL connection string and so I get an error message saying that login for ASPNET account failed and so I can't access the database. This seems to be a very common problem and most answers say "grant access to you database to user ASPNET".
I only have Visual Studio 2008 and I can't find how to change access permisssions for a database. Specifically I use Tools->Server Explorer and I can see all the tables in the database but can't find how to change access permissions. How do I change access permissions to my database using tools shipped within Visual Studio 2008?
I would like to use the Role Membership and User Security database as my application database too. That is, just add the tables and relationships required by my application's data access layer to the Membership and Roles Database to save on hosting fees, (I have to pay extra for having two databases instead of one). Of course, the connection string would have to be adjusted, but I don't see a downside considering the application's database is actually an Access database. What can I say, it was a requirement at the time.
Basically, I would like to do the opposite of this:
http://forums.asp.net/p/1162485/1925262.aspx#1925262
I have been using VWD2010 Express for a website that I am working on. Due to a delay in implementing the 4.0 framework at the hosting service that I use, I need to finish up with VWD2008 Express. Is there a simple way to save my project so that it is compatible with 2008?
View 2 RepliesI installed sql server express 2008 R2, no problems.
I created a database and added a table, no problems.
I'm using the entity framework, I created and am using the .edmx file, no problems.
I created a form that reads from and submits to the table, no problems.
I added the membership tables to the database, now I have problems.
I can still read from and update my table fine, so clearly the connection string in my web.config still works. But I can't add a new user or do anything with the website administration tool. It can't find any providers, and under security, it tells me it can't login into the database. When I try to register a new user, I get a failed login error, again for my database user. Yet I can login fine through Server Management Studio with the same credentials.
This code is OK: [URL]
I wonder how to incorporate the view of my table?
Example:
I have a table:
- Products
- Customers
I have multiple users, each one to see what Products and the parties if the request with your username and password.
How does this connect to the Membership table?
Is it possible to use the Membership API with an already exisiting database? I have a database that is built around my own fields for the User and breaks down users into half a dozen different groups that determine their access to different parts of the site and exactly what they can do and see on different pages.
View 8 RepliesASPNETDB Problem - Unable to connect to SQL Server database
now, after some real soul searching, i managed to get it working, however i want to do the following:
I have a table in a database I created called "Students". Now, I have a studentId and a password in that table. What I want to do is allow users to login using their accounts.
However, I am having real trouble doing this. I want to create a custom membership provider, etc.
I have been crawling through the net looking for ways to do it but some of the sites I visited had too much complicated code.
What is the best and easiest way to do this?
I am facing a very unique situation and need help. My problem is as follows:1. I have a basic ASP.NET website (3.5 is it helps on IIS 7) where I have implemented Membership for Authentication.2. The site caters to multiple companies (Say Company A, Company B etc.).3. For each company I need to have different database (SQL 2008). This is mandatory as i can use multiple Application in there.Now as far as the flow is concern its pretty simple:1. The user comes to this site with a QueryString like cid=123 (in actual there is a HttpModule for this, cid=123 is just for this forum purpose).2. The site using the cid=123 gets to know this user is for Company A (i have a WCF service for this, how it works is not a problem.), along with that I also get the connectionstring for the database this user should use.3. For Business implementation i have handled this nicely in my DAL Layer.4. The problem comes with Membership.5. In Membership I have writtent a custom provider, that assigns the connection on teh fly.6. But this happens only once for the application. i.e. the connectio string gets cached at application level.7. The connection string does not change untill I reset my IISwhere i can have a single WebSite, catering to different companies, using seperated databases and using Membership for Authorization.
public class CustomMembershipProvider : SqlMembershipProvider
{
public override void Initialize(string name, System.Collections.Specialized.NameValueCollection config)
[code]...
I am using aspnet_regsql.exe to add membership tables to my database.
when I click the exe file it just opens up an XML file in visual web developer and does not start the wizard to merge the databases.
the run command where file is located is below
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727
I just get the file below opening instead
[Code]...
I've just finished my database design and now i'm going to start implementing it in SQL Server 2008. Since i'm creating an ASP.NET Web Application i would like to use Membership Provider to manage user access to the application. In other projects (more simpler) i used Membership but always with its default parameters.
In this recent application i need to use custom user data for it to work properly.
So, what i would like to know is, how can i use my 'Users' table in my DB with .NET Membership Provider?
I would like to collect all the emails from all users in a certain role. How would I do this ?
View 1 Replies