Asp.net / sql help: tool

Showing posts with label tool. Show all posts

Thursday, March 22, 2012

atabase Tuning ADvisor and index recommendations

Hi there. I love this tool from what I've read, will it also tell me what indexes I DON'T need (I think that would be helpful - especially when I'm not the one creating indexes all the time). Thanks!Moving to tools forum.|||

More or less it does as per my experience, but in this case you might need to run thru full analysis using the profiler trace.

Refer to http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx for more information.

at a time more than 8 users executing sp_xml_preparedocument what

we r using xmlconcept , sp_xml_preparedocument taking 1/8 of the total memor
y
but our front end tool is PB .often our application close cause of locking
at a time more than 8 users executing sp_xml_preparedocument what will
happen , i need urgent soultionMake sure you are using sp_xml_removedocument
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Subramaniyan Ramesh" <SubramaniyanRamesh@.discussions.microsoft.com> wrote
in message news:29D5FD50-CA2B-4090-B589-0749BC460200@.microsoft.com...
> we r using xmlconcept , sp_xml_preparedocument taking 1/8 of the total
> memory
> but our front end tool is PB .often our application close cause of locking
> at a time more than 8 users executing sp_xml_preparedocument what will
> happen , i need urgent soultion

Friday, February 24, 2012

ASPNETDB to another database

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

What you can do is

Go to folder

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

in the above folder there is a file named "aspnet_regsql" run this file

it will ask you whether a default database or a partucular database in which you would like

to keep this. if you set it as default then it creates a new database"aspnetDB"

if you point to another databse[ say northwind] then all the tables necessary for member ship

do come in to northwind.

Try this if you still find issues let me know

With regards

Sridhar

ASPNETDB - Unable to connect to SQL Server database

Hi Eevryone:

I seem to have corrupted my ASP.netWeb Site Administration Tool some how. It worked fine a few days ago, but reloaded SQL Server 2005 Express Edition W Adv Services SP1 yesterday I can not get past the "Unable to connect to SQL Server database" error. I have run the aspnetdb.exe and created both a aspnetdb.mdf and loaded the tables to into a existing mdf. I have checked all the permissions.

So any ideas on what I am doing wrong, or can you point me to some documentation on the 'AspNetSqlProvider'

Thanks in advance, Gene

You could erase the file in the appdata directory and it should recreate one fromscratch for you. actually, all you need is

to get it to make the appdata express file

|||Exactly were do I am this entry?|||

Here is a very simple web.config with rolemanager enabled.

<?xml version="1.0"?>

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
<connectionStrings>
<add name="FetchEmailConnectionString" connectionString="Data Source=TM8200;Initial Catalog=FetchEmail;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<roleManager enabled="true"></roleManager>

<compilation debug="true"/>

<authentication mode="Windows"/>
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.

|||

Thanks again for the help.

Your sample web.config helped prove what I was beginning to suspect yesterday. It is the creation of user instances under .SQLExpress that is causing my problems. This makes sense considering that it was after I switched to .SQLExpress from SQL 2000 that my problems started. Any suggestions on where to find good user instance documenation? So far I have not found any good trouble shooting articles.

Cheers, Gene

aspnet_regsqlcache tool not found in my system

hi i am going to install the aspnet_regsqlcache tool in my system to create the notification tables for my database. while i am istalling in the .net framework command prompt, it tells like this,

"'aspnet_regsqlcache' is not recognized as an internal or external command"

what is the problem in my system...please any one help to solve this issues..

thanks in advance

The utility is now called aspnet_regsql.exe. It can be found here C:\WINDOWS\Microsoft.Net\Framework\v2.0.50727.

This was also discussed on the Wrox forum (in case you read about this in a book). http://p2p.wrox.com/TopicIndex/21996.htm

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

aspnet_regiis on remote system

Sure, the subject line seems easy enough. But is there a way that I can run this tool against my local SQL 2k5 server and script out the objects it creates to try and set up the tables and what-not on a remote server that doesn't accept remote connections? Or is there maybe a pre-built script somewhere that you can point me to?

I've tried to grab the stored procs and tables under the aspnet schema and script them out but it's not working correctly. Still can't run my login form against it.

Thanks

Hello,

I think you mean aspnet_regsql.exe? If you run it on your own computer like this: aspnet_regsql.exe /? you will see all available options. In it you will read that it's possible to generate an SQL script file. You can then use this script file to create the tables.

|||

Yes, I did mean the aspnet_regsql.exe. I gen'ed the script. THanks...

Thursday, February 16, 2012

ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe)

I just ran the utility without any commands ant the wizard has come up. This is all independent of my web application.

I am guessing this is going to install the database tables to my existing database.UPDATE: They have been created

Will I then connect my web app to this database schema that is created?

How do I change the membership/roles users in my web app to point to the database tables?

To connect you app to the membership database you define the membership provider in web.config
main setting are connectionstring and application name.

Here a link with more info about the settings for you

http://weblogs.asp.net/scottgu/archive/2006/04/22/Always-set-the-_2200_applicationName_2200_-property-when-configuring-ASP.NET-2.0-Membership-and-other-Providers.aspx

To manage the membership role and user you can use ASP.NET Configuration tool you will
find it on the website menu in visual web developer.

Hope that helps you.

|||

Weird, there is only 1 thing in my applications web config that references the roles and memberships..

What should I be doing to connect the current roles and membership to the new SQL Server 2000 tables that the utility created?
In the ASP.NET Configuration tool, there is a provider tab, in this area there is a AspNetSqlProvider and a radio button, there is also a test link.

When I click the test link it eventually fails, even though I have created all the necessary tables in the 2000 database.

|||

Ok you will need to setup a connection string to you database and define the membership provider.

Here is example for you

<connectionStrings><remove name="LocalSqlServer"/><!-- Connection for SQL 2000 --><add name="LocalSqlServer" connectionString="Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;" providerName="System.Data.SqlClient"/></connectionStrings> <membership> <providers> <clear/> <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true"requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" applicationName="/" /> </providers></membership>

You then can setup the users and roles using the asp.net confrigation tool you will find it in the website menu in visual web developer express

I hope this helps

|||

Ok, I will try to get farther. I am suprised none of this was added to the Web.config file as I have a working membership login ability... anyone know why?

Also, for the record, I am using Visual Studio 2005Standard Edition, will that change anything?

What is the situation with <remove name="...">

Are you just clearing the existing pair/key value? Is that needed?

|||

I think the logic around why it is not added is to allow you to define the setting ie because you are using SQL 2000 or 2005.

No problem with a higher version just lots of people here are using express.

Yes you are right about the remove name, it just to make sure you are overriding the system defaults.

Hope it helps

ASP.Net SQL Provider

Hello,
I am using the Visual Web Developer and would like to use the Web Site
Administration Tool to connect to a remote SQL server (it defaults to SQL
Express).
I have already run the regsql tool. My tables on my remote SQL server are
installed.
How do I add a provider in the code since I cannot do it in the GUI?
Thank you,
Exchange2003See if this helps you
www.ConnectionStrings.com
Madhivanan

Monday, February 13, 2012

Asp.net session has expired

I have designed reports using SQL Server Business Intelligence Development Studio tool (Sql Server reporting service). I have uploaded these reports to report manager.

I am displaying list of reports in tree view control, in my application. I am viewing report in Report Viewer control as per the report selection in tree view control, in same page. I am getting

Server Error in '/Application_name' Application or

ASP.NET session has expired error frequently while switching between various reports. Kindly provide me solution

Regards

Sagayaraj Rayappan

Are you reseting the Report Path each time they click on an item or are you saving the ExecutionID off? You will need to set the report path each time and not try and use the existed execution ID unless you can keep the session alive yourself.|||

Thanks for the information. I am resetting Report Path each time when we clicked on an item. How to keep the session alive myself?. What is ExecutionID and how to use it?. Kindly give more details on this.

|||

You do not want to use the ExecutionID, I just wanted to rule that out first.

Is the error occuring from within the report viewer or the entire page?

|||This error occurs for entire page.|||Since the error occurs on the entire page, this points to an issue in your app. If it was the report server session that had the timeout, the error would occur within the viewer (you would still see the toolbar. Try removing the viewer control and replacing it with a simple control and see if the problem persists.|||

Hi i am also getting the same error.In my web page i refer the reportviewer and showing different reports.While navigate to different reports randomly i am getting this error.

Can anyone suggest how to solve this?

Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

[AspNetSessionExpiredException: ASP.NET session has expired]
Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +683
Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +553
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +10
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Thanks in advance,Tom

|||

Daniel Reib wrote:
Since the error occurs on the entire page, this points to an issue in your app. If it was the report server session that had the timeout, the error would occur within the viewer (you would still see the toolbar. Try removing the viewer control and replacing it with a simple control and see if the problem persists.

Hi I'm getting this error from with the ReportViewer control... I've tried to change the session timeout with the following code but it still times out earlier then the timeout value stated...? Is there some other attribute that needs to be changed also?

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"

Many thanks in advance,

Rob.

|||

Did you get a solution to this? The setting you have changed is on the reportserver, your problem is on the app that contains the reportviewer. Look at my post here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=371287&SiteID=1&PageID=2

|||

Hi Mark,

My issue was slightly different. Because of the nature of our reporting system, users may leave a report open for a long period of time (maybe hours) and then come back to it and attempt to run a drillthrouhgh report from where they left off.

My solution to this was to increase the session timeout in the application pool which has worked well. I'm lucky I guess that the user base for the system is very small, i.e. no more than twenty users, so we should run into any resource issues (finger crossed).

Regards,

Rob.

Asp.net session has expired

I have designed reports using SQL Server Business Intelligence Development Studio tool (Sql Server reporting service). I have uploaded these reports to report manager.

I am displaying list of reports in tree view control, in my application. I am viewing report in Report Viewer control as per the report selection in tree view control, in same page. I am getting

Server Error in '/Application_name' Application or

ASP.NET session has expired error frequently while switching between various reports. Kindly provide me solution

Regards

Sagayaraj Rayappan

|||

You do not want to use the ExecutionID, I just wanted to rule that out first.

Is the error occuring from within the report viewer or the entire page?

Hi i am also getting the same error.In my web page i refer the reportviewer and showing different reports.While navigate to different reports randomly i am getting this error.

Can anyone suggest how to solve this?

Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

Thanks in advance,Tom

|||

Daniel Reib wrote:
Since the error occurs on the entire page, this points to an issue in your app. If it was the report server session that had the timeout, the error would occur within the viewer (you would still see the toolbar. Try removing the viewer control and replacing it with a simple control and see if the problem persists.

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"

Many thanks in advance,

Rob.

|||

Hi Mark,

Regards,

Rob.

Asp.net session has expired

I have designed reports using SQL Server Business Intelligence Development Studio tool (Sql Server reporting service). I have uploaded these reports to report manager.

I am displaying list of reports in tree view control, in my application. I am viewing report in Report Viewer control as per the report selection in tree view control, in same page. I am getting

Server Error in '/Application_name' Application or

ASP.NET session has expired error frequently while switching between various reports. Kindly provide me solution

Regards

Sagayaraj Rayappan

|||

You do not want to use the ExecutionID, I just wanted to rule that out first.

Is the error occuring from within the report viewer or the entire page?

Hi i am also getting the same error.In my web page i refer the reportviewer and showing different reports.While navigate to different reports randomly i am getting this error.

Can anyone suggest how to solve this?

Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

Thanks in advance,Tom

|||

Daniel Reib wrote:
Since the error occurs on the entire page, this points to an issue in your app. If it was the report server session that had the timeout, the error would occur within the viewer (you would still see the toolbar. Try removing the viewer control and replacing it with a simple control and see if the problem persists.

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"

Many thanks in advance,

Rob.

|||

Hi Mark,

Regards,

Rob.

ASP.Net service account gray out

I am installing RS2005 on Windows server 2000 with IIS 5.0. Everything is fine in configuration tool except service account. It is empty. I have added ASPNET account in reportservice user group and tried to add <machinename>\ASPNET to <WebServiceAccount>. It is still empty. Any idea?

Thanks.

Hello,

I believe this is pulled from the Identity of your application pool. Go to IIS and set the identity there and it should be reflected in the RS Configuration Manager.

Hope this helps.

Jarret

|||

Hi,

It seems that application pool is only for IIS6.0. I am using IIS5.0. How can I set the identity in this case

thanks

Ken

|||Therer's no direct way (from RS tools at least) to set IIS5 app pool identities. In fact, there's no way in IIS to set IIS5 app pool identities. I've heard that you can modify a .config file and change the IIS5 app pool identity, but I've not tried this myself.|||Yes, I have changed <WebServiceAccount> tag in RSReportServer.config but it doesn't work. I think Jarret is right. The identity is from somewhere in IIS setting.

I also installed report service in XP pro. I don't need to set anything to let it work. I am not sure if there is something special in Windows 2000 Server.
|||

Has anyone installed Report service 2005 on Windows 2000 server successfully? Please give comment. I appreciate it.

Ken

|||Did anybody solve this issue?

Sunday, February 12, 2012

asp.net enterprise manager

has anyone used this tool to upload sql databases to a web host

i'm struggling

cheers!!!

Adrian

Use the Copy Database Wizard

|||This post shows detailed steps to move database to?shared host:
HOW-TO: Database from VWD to Shared Host

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

asp.net configuration tool

I deployed a web site, and converted SQL Server Express to a single SQL Server 2005 database. I created all of the tables required for memberships and roles with aspnet_regsql.exe.

Real simple question - how can I populate the membership and role tables out on the server? When I attach VWD to it, the ASP.NET Configuration tool is gone. How do you maintain memberships and roles without the tool?

Thanks for any help you will share :)

It's been a long journey but I am finally here!

Hi CK,

I'm going to punt on this one.

The ASP.net forums is a better place to ask questions about ASP.net and Visual Web Developer. You can find all the forums at http://forums.asp.net/ and the forum that is specifically about SQL Express in VWD at http://forums.asp.net/54/ShowForum.aspx.

I can't redirect outside of MSDN, so you'll need to repost the question in the new forum.

Mike

|||

Hi mike,

You helped me SO MUCH already on other questions -- xoxo

I'll buy you a beer if you are in redmond and when I get this one figured out.

Are you in?

|||

It's beer time Mike.

VWD asp.net configuration tool successfully allowed me to update roles and memberships.

My web site is up and running.

For future reference, this article was of help: 4guysfromrolla.com article 040506-1

thanks again for helping me - let's go!

asp.net confgiguration tool. tool keeps timing out

is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible?

I suggest you ask this on the ASP.Net forums

http://forums.asp.net/

Thursday, March 22, 2012

atabase Tuning ADvisor and index recommendations

at a time more than 8 users executing sp_xml_preparedocument what

Friday, February 24, 2012

ASPNETDB to another database

ASPNETDB - Unable to connect to SQL Server database

aspnet_regsqlcache tool not found in my system

aspnet_regiis on remote system

Thursday, February 16, 2012

ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe)

ASP.Net SQL Provider

Monday, February 13, 2012

Asp.net session has expired

Asp.net session has expired

Asp.net session has expired

ASP.Net service account gray out

Sunday, February 12, 2012

asp.net enterprise manager

ASP.NET cube administration?

asp.net configuration tool

asp.net confgiguration tool. tool keeps timing out

Asp.net / sql help

Blog Archive

About Me