Accessing ASPNETDB From Outside Web Application
Mar 6, 2007
Hi there,
I have a slight problem. I have a web service running on my server. In this, I need to access values in User's profiles. The problem is of course, that Profile, ProfileCommon, ProfileBase, etc... are not available to me here.
What can I do?
Is using an SQL command best? If so, could someone post an example SQL command - I am getting confused by how to structure the command, since I need Membership data like UserName, and Profile data (an object serialized as binary in the Profile).
Kind regards,
kreid
View 3 Replies
ADVERTISEMENT
Sep 19, 2006
I have tried to find all the threads related to this topic. At this point I would like to find out what the best practices are for doing this. I plan to use Membership, Roles, and the login controls to handle my authentication and permissions issues. I want to use the same database for my application data as for Application Services, using a standard SQL Server. So far, the easiest way to set this up that I can think of is to:1. Use aspnet_regsql.exe to create the Application Services Database schema2. Edit the "LocalSqlServer" entry in <connectionStrings> to point to the above database3. Add the tables, views, stored procedures, etc., that I need for my application into the database created in step 1Is there any more configuration I need to do to get Membership and Roles working? When I did the Walkthrough, step 2 seemed to be the only requirement for getting Membership and Roles to work.Will I run into any trouble using LocalSqlServer for my application data updates?I would be interested in any other approaches to setting up a combined database, including opinions why and why not to do it.
View 1 Replies
View Related
Nov 17, 2005
I have an asp.net application. This application provide consolidated information to the user using Analysis Services 2005. Within it, one aspx page uses MDX query to retrieve the information from the cube. However, we are unable to access AS 2005 because of authentication issues. What would be the easier to implement and deploy scenario?
How can I access AS 2005 from an ASP.NET application? Is there any feature to use?
View 1 Replies
View Related
Oct 28, 2005
In SQL Server 2005, you must have the VIEW SERVER STATE permission in order to access sys.syslockinfo (http://msdn2.microsoft.com/en-us/library/ms189497).
View 7 Replies
View Related
Apr 18, 2007
I have a C# program that access SQL Server 2005. The program have 4 threads that performs the same method and are used only to improve performance of the system
The C# accesses the SQL Server using OleDbConnection and
OleDbCommand classes. Sometimes (very rare) I get exception to method ExecuteNonQuery() with message: "Table does not exist.".
The command text for the query is a constant string in the format: "insert into my_table€¦".
Can any one tell me what could be the problem?
View 6 Replies
View Related
Nov 22, 2007
Hello,
My next project(in VB.NET 2005) would involve accessing different DBs and tables in remote SQL servers
What are the steps that need to consider first? Are there any settings that needs to be done in the servers?
k
View 1 Replies
View Related
Jun 11, 2008
Geekz,
My problem is that , I had setup blog on server say, blog.xyz.com [I am using blogengine.net, which is in ASP.Net]. It is using sql server2005 as a backend for storing its blog's posts. After settingup blog, i tried to access its database through my windows application. But while development I was getting error that
"An error has occured while establishing a onnection to the server. When connecting to SQL server 2005, this failure may be caused by the fact that under the defaukt settings SQL server doesnot allow remote connections.(Provider Named Pipes, error :40 - Could not open a connection to SQL Server)"
I am using [String ConnectionString = "Data Source=sql-v123.mesa11.1Server.net; Initial Catalog=abc; User ID=xyz; Password=xyz123";]
Then I decided to created a webservice that will access the data from databse blog and store it somewhere in datatable and using windows application i will retrieve those data for end user. So I want to to know that whether i can access the datatable of webservice holding the blog data from windows application or not. if answer is Yes, then please provide me with source or some great links. Or if There is any other option so that I can access my database directly from windows application, then it would be better. Looking for your answers.
Thanks and regards
View 3 Replies
View Related
Dec 13, 2007
SQL Database in my application with windows authentication rejects accessing after deploying and remote access
1- My web applications databese access is windows authentication
2- In developing area there is no problem for accessing database
3- After deploying to another server there is problem accessing database:
Cannot open user default database. Login failed.Login failed for user 'BRCK231ASPNET'.
How can I solve this problem?
Thanks.
View 1 Replies
View Related
May 12, 2008
I am getting the error:
Cannot open database "aspnetdb" requested by the login. The login failed.
When I browse to my ASP.NET 3.5 LINQ web application on the IIS 6.0 server on Server 2003.
I imagine this is because while I granted SQL Server 2005 login and permissions to my database that the application stores its data in, I did NOT grant any rights to the service account the IIS Application Pool uses for its identity to the aspnetdb database on SQL Server which is where all my roles information is stored at.
My question is what are the MINIMUM permissions needed for this database so it can perform its roles related functions?
I'm using Windows Authentications with the SQL Role provider for authorization.
Thank you.
EDIT: I think I only need to open the aspnetdb database and add my login to the aspnet_Roles_FullAccess role. Is that correct?
View 2 Replies
View Related
Dec 6, 2007
Hi,
I am developing a windows application that needs to communicate with a remote SQL server 2005 database. Server allows remote connections and MSDTC service also running. Do I need to run MSDTC service on the client machine where I use desktop application ? any ideas ? It's throwing some error like
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote connections.
But my SQL Server allows remote connection, and I am able to do a select statement.
But when I insert/update anything, it's throwing this error. I guess some problem with MSDCT. Anybody have any idea ?
View 1 Replies
View Related
Apr 13, 2008
have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.)
Replication past two months working fine, Now
1.Distrib.exe application err is coming.
Due to which my job is failing (Distributor to Subscriber).
Iam attaching thw file.
Thanks
Sandeep
View 1 Replies
View Related
Mar 13, 2007
Using VS2005, VB backend and javascript,
I have developed a relatively simple site - its got a few (12) simple aspx pages but its mostly client side javascript. Keeping disk storage costs down is a big concern with this my site. The disk usage for the site is ~24M. Since this was larger than I expected I started inspecting the files comprising my site and found that the "ASPNETDB.MDF" in my "App_data" folder is consuming 10.2M by itself. The thing is that site only has a few pages with calls to SQL Server - but I never did anything (that I know of) with ASPNETDB.MDF. Through VS2005, I opened up the MDF file and poked around, everything that I looked at was empty (NULL).
So my questions are:
What is causing the ASPNETDB.MDF to consume 10.2M even thought I can't see any data stored in it?
Is there anyway for my to reduce the size of this file? If so, how?
Your input appreciated.
View 2 Replies
View Related
Nov 14, 2007
I'm creating a website in VWDexpress 2005 using a database, with string "SqlDataProvider". I have only one small-sized database. When I try to run my application in login mode (not using LoginView, I create it manually), the application cannot log me in, instead there's a weird error said some kind of "cannot use the ], [ or ) in database name". I don't configure the ASP.NET Configuration (which is opened in browser to make roles etc), I create all the controls manually. I don't have any other automatically-generated databases such as ASPNETDB.mdf because it cost lots memory! Oh, I used it before and the weird error I mentioned is occur when I excluded the ASPNETDB.mdf. I'm confused, why would the same error occur since I create everything manually? Any solutions? Thank you.
View 1 Replies
View Related
Jan 31, 2008
I am creating a new application and want to store the sql database. But i need the aspnetdb.mdf. I dont know where is the database located or do we have any scripts to create the database.
Any help would be useful
View 3 Replies
View Related
Apr 27, 2006
In response to a problem I have, my web hosting company asked me to rename aspnetdb.mdf. When I ask why, I was given this response
...it is because SQLexpless is developed for single database. If there is a same db name in the server, it cannot attach to the server. In order to prevent conflict, so that you need to change the SQLexpress's dbname into others to prevent conflict with others db name...
Does this make sense?
View 1 Replies
View Related
Aug 14, 2007
Hi,
I thought I had this corrected, but in fact don't. According to http://msdn2.microsoft.com/en-us/library/ms228037.aspx
SQL Express is supposed to automatically generate a copy of ASPNETDB.mdf in the App_Data folder of the Express edition development suites (I'm using Visual Web Developer 2005).
In my case, it doesn't, and I can't figure out how to trigger it manually. I've read every post I can find, especially http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1
However, that mainly applies to deploying a database that already exists. I have already tried deleting the files as suggested and they do reappear in the appropriate folder, but I'm still not getting the ASPNETDB.mdf file in my apps.
Any help on this would be greatly appreciated. I've had a post up on the Visual Web Developer forum, but folk are staying away in droves. Also tried uninstall and reinstall all the way down to IIS 5.1
biobot
View 4 Replies
View Related
Aug 1, 2006
I been all over this forum trying to find out how to get the aspnetdb.mdf running on my remote site and its driving me nuts.
i been using VWD 2005 express Edition and SQL Express
Error Server Error in '/' Application.
An attempt to attach an auto-named database for file I:DataWebqsh.eumarker_93618920-db3b-4a04-a274-3fb613afc5dfwwwApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
over the last week it has been a nightmare trying to get anything working on the site but i have got all the other databases working but i can get the aspnetdb.mdf working. i am very new to ASP.net so please use the he kiss method "Keep It Simple, Stupid!" as im a newbe to this and it will just go over my head.
Thanks
View 3 Replies
View Related
Nov 29, 2006
I have downloaded and installed ASP.NET Ajax Sample applications from
http://ajax.asp.net/default.aspx?tabid=47&subtabid=471
I am trying to run the AJAX TaskList example under C:ProgramMicrosoft ASP.NETASP.NET AJAX Sample Applicationsv1.0.61025TaskList
First I moved the content of the TaskList folder to a virtual IIS directory, making it possible to debug the website on my local IIS server.
When I run the example I get prompted to Login or register as a new user. When I submit the registration form I receive the following error message:
Failed to update database "C:INETPUBWWWROOTTASKLISTAPP_DATAASPNETDB.MDF" because the database is read-only.
How can I modify the permissions for ASPNETDB.MDF in order to run the TaskList example.
Thanks
View 4 Replies
View Related
Mar 6, 2007
Hi there,
i wanted to embed ASPNETDB into my own db, so i scripted the ASPNETDB and executed it into my db. the problem is that App Manager of my website can not connect to it,(>i've corrected the connectionstring LocalSqlServer), the problem is that, it says its schema is not as expected, i understand this problem but, is there any way to solve it?
thanks in advance
View 2 Replies
View Related
Apr 19, 2007
Hi there readers of this post,
Do you know how to transfer the database (ASPNETDB.mdf) tables made by the ASP.NET admin tool into another database?
I want to run everything from 1 database.
regards
Sat
View 1 Replies
View Related
May 30, 2007
hello how is created asnetdb,mdf?...from where it`s get that structure?... i want some link where is explained structure and how asnetdb.mdf works. can you help me? thx
View 9 Replies
View Related
Jun 4, 2007
Hello,I have a shared hosting plan which already has aspnetdb.mdf on the server so of course I cannot use that db name for my site...I have renamed the db and now I get an error Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion My question is, how can I make this thing work? All help is greatly appreciated!
View 12 Replies
View Related
Jul 6, 2007
When I first sign up with Visual Web Developer, Do I continue to use this database ASPNETDB.MDF or do I need to connect to the Microsoft SQL Server Database? Does Visual Web Developer Express automaticaliyy connect to SQL Server Express Edition?
Thanks
Computergirl
View 1 Replies
View Related
Jul 12, 2007
I created a website using Visual web developer express edition (including SQL Express). No the user management section of the site (the login/logout database) was created automatically and SQL Server express was installed at my computer under the instance name of SQLExpress. I uploaded it to my web host and he hooked up the ASPNETDB for me. Now the problem is that ASPNETDB has an id password and I was given the MSSQL Server IP. How do I configure my website to accommodate that? Any help will be extremely useful!!!
View 3 Replies
View Related
Jan 29, 2008
I developed an ASP.NET 3.5 site in VWD 2008 Express (with SQL Server 2005 Express) on Vista Home Basic (no IIS). So I then moved my source over to an XP Pro machine with IIS 5.1 and installed .NET 3.5 and SQL Server 2005 Express. Brought up the site, but it failed when I attempted to login. What do I have to do to get this to work? Do I need to attach the ASPNETDB.MDF in my APP_DATA directory to my SQLServerExpress? Was this taken care of by the ASP.NET config tool when I set up users/roles on the Vista machine?Do I need to set some permissions? Like I said this was working only on through the built in webserver in VWD 2008 Express.ThanksEric
View 1 Replies
View Related
Apr 23, 2008
Hi I have a problem most of the hosting companies I have seen offer the hosting package I want offering 1 MS SQL Server database and if you want to then they charge twice the price. The problem is I have heard you can use your own database for the memberships, roles, etc and have other tables for your other stuff. It's just I don't know and can't find the steps to do this.
View 1 Replies
View Related
May 26, 2008
Hi all,
I`m a .NET desktop-app developer and i`m new to ASP.NET and web development, i start developping a web application with SQL Server database and i want to know if i can put all my tables in ASPNETDB?
is any restriction with that?
Regards
View 3 Replies
View Related
Apr 25, 2006
Hello everyone.
I am to create a sample site using the club site example. I had a problem with the IIS but now it is solved.
Now i copyied the site to the IIS and it is running. But i cannot access ASPNETDB.MDF. It keep saying that the database is read only... It is not read only!!!
Can any one help me??
System.Data.SqlClient.SqlException: Failed to update database "C:INETPUBWWWROOTNEOAPP_DATAASPNETDB.MDF" because the database is read-only.
Thank you in advance.
Iasonas
View 2 Replies
View Related
May 3, 2006
Hello!I have my own database file, but when I run my site in debug mode it creates aspnetdb.mdf again and stores all users in there ... question is - why? :((I've attached my own db to sql server express, ran "aspnet_regsql.exe -W" on it, so it got all the schema in there.Here's what I have in my web.config-----------<connectionStrings> <add name="SqlServices" connectionString="Data Source=MESQLEXPRESS;Initial Catalog=myOwnDB;Persist Security Info=True;User ID=user;PWD=password" providerName="System.Data.SqlClient"/> </connectionStrings><membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="20"> <providers> <remove name="AspNetSqlProvider" /> <add name="SqlProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="SqlServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" passwordFormat="Hashed" requiresUniqueEmail="true" maxInvalidPasswordAttempts="5" passwordAttemptWindow="10" minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0" applicationName="/" /> </providers> </membership>----------so i connect straight to sql server, not local file (so i dont have to attach / detach the db all the time)but when i create new user through ASP Config, it creates them in aspnetdb.mdb file :(can anyone explain me what im doing wrong here?thanks in advance!
View 1 Replies
View Related
May 15, 2008
Hi All,
I have a question.What is relationship between ASPNETDB.MDF in application and aspnetdb databasein SQL Server 2005?
Thanks,
Jack
View 1 Replies
View Related
Jan 25, 2006
Hi:
I am using the built in securty database from vs2005
I am trying to write an insert trigger that will add a role each time a user is added but I seem to be having difficulty I believe it's with the uniqueidentifier datatype. when I run this trigger via an insert statement I get the following error.
Can anyone set me straight?
========error==============
Cannot insert the value NULL into column 'RoleId', table 'R:AAAPROJECTSASPVS2005MERCERBUCKSAPP_DATAASPNETDB.MDF.dbo.aspnet_UsersInRoles'; column does not allow nulls. INSERT fails.
==================insert statement==========
Declare @NewUserID as uniqueIdentifier
set @NewUserID=newID()
print Cast(@NewUserID as varchar(50))
insert into dbo.aspnet_Users (ApplicationID,UserID,UserName,LoweredUserName,LastActivityDate)
Values('f23f01f0-7ad7-463b-87e2-f3e9141e6426',@NewUserID,'lrchase','lrchase','7/20/2005')
======trigger============================
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER TRIGGER [InsertRole]
ON [dbo].[aspnet_Users]
AFTER INSERT
AS
DECLARE @RoleID uniqueidentifier
DECLARE @UserID uniqueidentifier
Select @UserID=Userid from inserted
Print @UserID
SELECT @RoleID = RoleID
FROM dbo.aspnet_Roles where dbo.aspnet_Roles.LoweredRoleName='user'
Print @RoleID
SET NOCOUNT ON;
Insert Into dbo.aspnet_UsersInRoles
Values(@UserID,@RoleID)
Thanks Len
View 2 Replies
View Related
Mar 8, 2007
Hi, feel like i might be headed for peril
i changed the appplication name on a aspnetdb equipped mdf (SQL express) , but have another similar mdf (SQL express) in a different web application, this database has the same applicationID in the "aspnetdb" tables,
these are meant to be two different web applications running under IIS, the root folder name for each web application is also different. also the mdf (SQL express) names are different as well
but still feel like i might be headed for jeporadry, ie does IIS want a unique applicationID for each asnpnetdb equipped mdf, or is the applicationID only applicable to the mdf it is in and the web application the mdf is running under??
View 1 Replies
View Related
Jul 9, 2006
Hello, I'm getting up to speed with VS2005 and use SQL Server 2005. I'm using the login control in a test web app. When I run the app I get this error:
Cannot open database "aspnetdb" requested by the login. The login failed.Login failed for user 'UserIDASPNET'.
The connection string I'm using is:
data source=localhost;Integrated Security=SSPI;Initial Catalog=aspnetdb;
The AspNetSqlProvider in the web administration tool connects to the database.
My question is, Is this a connection string issue, and user ID issue, a rights issue or is it something else?
Thanks,
Gaikhe
View 1 Replies
View Related
