ASPNETDB.MDF - need to use SQL Server 2000

Hi,

I'm building an intranet app for a client using ASP.NET 2. The client is running SQL Server 2000 - and does not have plans to upgrade to 2005 anytime soon.

Is there a script that I can use to create the objects in the ASPNETDB database so that I can do this in SQL Server 2000?

Also, what additional changes would I have to make in order for the application to point to a SQL Server 2000 database with these objects?

Thanks in advance, Al

MDF(Microsoft data file) is only one half of a SQL Server database, the other half is the LDF(Log data file). That said the Personnal and Club starter kits comes with the membership database and Microsoft created a SQL Server 2000 version of both so I think you can install both take the membership related tables, triggers and stored procs. You know it is all manual so you just right click on the object in Object browser in Query Analyzer and click on create to generate the scripts. Hope this helps.

http://www.microsoft.com/downloads/details.aspx?FamilyId=0DD83A11-6980-4951-A192-DA6EACC6A19E&displaylang=en

http://www.microsoft.com/downloads/details.aspx?FamilyId=2EE85ED4-7613-47E2-8375-17222B150E4F&displaylang=en

|||Hi luckydog,

as alternative in clean way, you can run aspnet_regsql in command prompt and choose any database instance that you want to have membership tables inside it.

Run it in .Net Framework SDK Command Prompt

aspnetdb is on a "network path that is not supported for database files"

I have two, probably related, problems:

I have a very simple site. It will be used on the local intranet only. I want to use the windows authentication so users do not have to log on. The aspnetdb has been created using the configuration tool. If I use Server Explorer in vs to work on the site on my local machine, I can open aspnetdb, look at its tables, etc. If I use Server Explorer in vs to work on the site on the server, aspnetdb will not open and gives this error message:

..."network path that is not supported for database files"...

Other sites on the same server give the same message, but the sites work. I think this is because they can read the file but not write it; but that is a guess. We have tried everything; my head is ready to explode. We are using SQLServerExpress. It resides on the server's C drive (as does our data database). The web site, and hence the aspnetdb are on the F: drive of the same machine. Does SQLServerExpress treat the F: drive as a UNC drive? If so, are we in deep doo doo? I'm at a loss.

As far as logging in: If I debug from vs, the login works beautifully both on my local machine and running from the server using vs. Login does not work when accessing the site from iexplorer. Mystified by that one, too. I tried to implement profiles and they crash, too; that led me to consider a write problem.

Don't know what to do; any help is appreciated.

This is a common connection exception, which may be misleading in some cases. You may take a look at this article:

http://www.aspspider.net/resources/Resource170.aspx

ASP.NET cube administration?

Hi all!

We would like to create an Intranet based cube administration tool.

Power users should be able to process cubes and dimensions. This works

and all the cubes, dimensions and even databases from the SSAS can be

displayed in the web! ASP.NET@.C# combined with

Microsoft.AnalysisServices offer a lot of very good possibilities!

But we still have a problem:

How ist it possible to show some kind of progress bar (maybe in a self refreshing iframe or a new window?)?

When a cube/dimension is processed the user does not get ANY feedback

(of course the webserver waits to finish the process() method.

I tried to start a different thread an this even works!

I want to show our powerusers at least some kind of progress (%, events, what ever).

can someone help? we are totally lost with that topic!

I already had a look at the example from:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=75148&SiteID=1

But it did not lead me to a propper solution :)

TIA and regards

JohnnyR

Hi Johnny,

i have tried to configure the display of my dimensions and cube on the Web but I have totally failed, could you please outline for me the proper steps of how togo about this.

You can reach me on REjalu@.cit.mak.ac.ug. or within the forums

Thanx in advance.

Ronald

|||

Hi,

maybe you should have an eye on http://www.lennybacon.com/Default.aspx#a0eaaccb3-4c0c-405f-9bde-ced4b95a1222?

cheers,
Markus

|||Hi Ronald!

This is how I manage it:

string olapserver = @."SERVER\DATABASE";

private bool getDBs()

{

Server olapsrv = new Server();

this.DropDownDatabase.Items.Clear();

try

{

olapsrv.Connect(olapserver);

foreach (Database mydb in olapsrv.Databases)

{

ListItem myitem = new ListItem();

myitem.Text = mydb.ToString();

myitem.Value = mydb.ToString();

this.DropDownDatabase.Items.Add(myitem);

}

olapsrv.Disconnect();

return true;

}

catch

{

olapsrv.Disconnect();

return false;

}

}

private bool getCubes(string server)

{

Server olapsrv = new Server();

this.ListBoxCubes.Items.Clear();

try

{

olapsrv.Connect(olapserver);

foreach (Cube mycube in olapsrv.Databases[server].Cubes)

{

ListItem myitem = new ListItem();

myitem.Text = mycube.ToString();

myitem.Value = mycube.ToString();

this.ListBoxCubes.Items.Add(myitem);

}

olapsrv.Disconnect();

return true;

}

catch

{

olapsrv.Disconnect();

return false;

}

}

private bool getDimensions(string server)

{

Server olapsrv = new Server();

this.ListBoxDimensions.Items.Clear();

try

{

olapsrv.Connect(olapserver);

foreach (Dimension mydimension in olapsrv.Databases[server].Dimensions)

{

ListItem myitem = new ListItem();

myitem.Text = mydimension.ToString();

myitem.Value = mydimension.ToString();

this.ListBoxDimensions.Items.Add(myitem);

}

olapsrv.Disconnect();

return true;

}

catch

{

olapsrv.Disconnect();

return false;

}

}

.

.

.

<asp:DropDownList ID="DropDownDatabase" runat="server" AutoPostBack="true" />

<asp:ListBox ID="ListBoxCubes" runat="server" SelectionMode="Multiple" />

<asp:ListBox ID="ListBoxDimensions" runat="server" SelectionMode="Multiple" />
good luck!

I finally managed to get the admin page working:

My solution was the following:

I created a Windows Command Line Application that processes either

cubes or dimensions. The Application get an XMLA File Path as a command

line argument.

The XMLA file is created by my Administrator Web Page, which also launches the Command Line Tool!

The Command Line tool traces the server output and writes it into a log file!

The log file is display in an iframe (reload every 5seconds).

It works great and really fast using XMLA.

maybe somebody want to do the same!

regards

JohnnyR|||

Johnny,

if you are going to share this app with the community somewhere I would be glad if you notify me and send me a download link...

cheers;
Markus

|||Hi Markus!

Give me some time to clean up the code an to design the whole stuff a bit more understandable :)

But i will definitely post it in here or post a downloadable link!

We concidered to write a dynamic MDX query generator for the web (like

you know from the pivot table drag and drop plug in @. Excel), too! So

give me some time to design the prog a bit better ;)

regards from Vienna

JohnnyR|||

from Vienna?
Then we could do it in german also...
:-)

Glad to hear that you think of posting it!

Have you thought of getting in touch with some other projects regarding SSAS and web-"things"?
PASS Germany is currently doing a project in the SIG BI which will be a AJAX Client for SSAS.

If you would like to get in contact please just send me a mail to m.fischer [at] sqlpass.de

cheers,
Markus