Connection Between SQL Server 6.5 Database And ASP Pages
Oct 28, 1999I cannot connect my ASP pages to my SQL Server 6.5 Database. I've got a login error.
Any idea?
ADVERTISEMENT
ASP.Net Pages And SQL Server Not In The Same Machine. Login Failed For The User, Not A Trusted Sql Connection
Jun 16, 2008I am having an asp.net web site hosted in my machine's IIS (5.1). This aspx files are accessing data from an sql server 2000 database located in another machine. While i am trying to open a connection from the aspx files to the database, an error showing login failed for that user. Not a trusted sql server connection. so i unchecked the "allow anonymous access" in the directory security. But now its working from my machine (the web server, localhost). but when i try to access the aspx files from another machine with my system ip, the same error exists-Login failed for the user and not a trusted sql server connection.
View 3 Replies View RelatedCalling My Connection From Pages
Aug 25, 2006I have been looking everywhere and cant seem to find out how to do this using 2.0I would like to have my connection strign in my web.config file being decralred publicly in my pages so that I dont have to repeat lines of code throughout pages.In my web.config I have this.<connectionStrings> <add name="myconn" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings>then in my pages I haveImports System.DataImports System.Data.SqlClientPublic sqlconnection As New SqlConnection(ConfigurationSettings.AppSettings("myconn"))Public sqlcommand As New SqlCommandPublic sqldataAdapter As New SqlDataAdapterPublic sSQL as StringFunction getdata()sSQL = "INSERT INTO tbl_Idea (Status) value (@Status)Dim dbcommand As New System.Data.SqlClient.SqlCommand(sSQL, sqlconnection)Dim statusparam As New SqlParameter("@Status", SqlDbType.NVarChar)statusparam.Value = "PENDING"dbcommand.Parameters.Add(statusparam)sqlconnection.Open()dbcommand.ExecuteNonQuery()sqlconnection.Close()for some reason this code does not seem to work. It keeps telling me The ConnectionString Property has not been initialized.I do the same thing in my asp.net 1.1 pages using vs 2003. Can some one help or atleast point in the right direction.thanks
View 2 Replies View RelatedMaintaing A Connection Across Pages (Persistent)
Nov 8, 2005I've only been workign with Database programming for 6 months or so, specfically SQL Server. I've setup a site through a hosting company that is pretty reputable and allows me plent of space/bandwidth etc. However, they've recently been having problems with one of their servers (the one I'm co hosted on) as an "abornamlly" large amount of connections are being opened up on their server.
I realize that SQL Server is designed to handle large amounts of traffic and my humble little site probably isn't killing it with shear traffic, but I'm wondering if my programming practicies are sub par and causing problems.
I'm coding in ASP (work hasn't given us the chance to migrate to .net). Anyway my site is getting some 30 - 40k hits a day on the actual web portion and probably another 10-20k on backed stuff - all which open up database connections to do their work.
I've had locks and blocks routinely because of this and I'm afraid I'm just going about this all wrong.
So I'm wondering if there is a way to maintain an established connection in ASP across multiple pages and/or sessions so I don't have to constantly drop and reconnect to the db?
Any help would be great!
Why Clean Data Pages Written To L2 Cache To Make Space For Other Not Modified Pages
Oct 2, 2014in microsoft doc there is written on the topic of BP Extensions with SSD's in SQL Server 2014: only clean pages are written to disk... does this mean data pages that have not been modified yet? or also those data pages that have already been modified, and where log has finished writing and the transaction has been marked as commited??
why are there clean data pages being written to L2 cache to make space for other not modified pages? I mean, shoudnt they be modified first, before letting other unmodified data pages into the Cache? I mean they have still to be modified..that makes no sense to me to page them out and page them in again just for other data pages...
Backup SQL Database From ASP.NET Pages
Jun 9, 2007Is there possibility to make backup of MS SQL database directly from ASP.NET pages?
View 2 Replies View RelatedConnecting Database To Asp.net Pages!
Jun 3, 2008Hello,
Iam a new developer to asp.net, I have been trying to connect a database to a asp.net page but many times i failed. actually i dont want to connect just directly by dragging and dropping controls rather i wanted to bind controls like textboxes and comboboxes but at first i think i have to make querystrings to and sqlconnection to connect to the database. I mean i have to manually code all these items to get my pages connected. but most of the time i face the bug which is:
Server Error in '/WebSite2' Application.
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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
is that because of the fact that i dont sql server management studio installed actually i tried the same process with some other pcs that does not have sql server insatlled but it was working pretty well, but now i dont have a sql server installed and the problem still insists.
hope i have clarified my problem, sorry if it is a bit lenghty
thanks and regards
How To Reallocate PAGES Used By Database
Dec 2, 1998Hello,
I have two identical databases DB1 and DB2. And each have 4 tables
In DB1 i will insert the data in the following order
For Every set of 4 records
Insert into Table1 Values ..
Insert into Table2 Values ..
Insert into Table3 Values ..
Insert into Table4 Values ..
In DB2, i will insert the data as
Insert into Db2..table1 select * from db1..table1
Insert into Db2..table2 select * from db1..table2
Insert into Db2..table3 select * from db1..table3
Insert into Db2..table4 select * from db1..table4
i.e. a bulk copy.
What is hapening is if i run DBCC SHOWCONTIG on both the database tables, it shows avg Space used for DB2 tables as more than 90% but for DB1 it is 4 - 5 %.
And if we check the device stace used by db1, it will be 10 times more by the DB2 for the same set of data. Both databases have different devices to store the log.
1. Can we have any command/procedure to reasllocate all the data so that minimum pages are used to store the data.
2. One more thing, is there any diff in SQL server 6.5 installed on Dell6100 ( Pentium Microprocessor ) and winNT 4.0 ? Because what is hapening is, if the log space is full, and if we Stop and start the SQL server on Dell system, it is not at all clearing the log space occupied. But in NT it is clearing the LOG.
3. Does any SQL server service Packs affect this..? If any let me know
4. If we create saperate LOG devices, what othere information is stored in the Data devices othere that data. Because in my case, DB1 is occupying more space than the actual data inserted.
ThanX
__Vijay VM
Design Help – Access SQL Database Behind A Firewall From ASP .NET Pages.
Feb 26, 2004Hi,
I am new to internet development and would like some advice on the technology used to access a SQL database that sits on a network behind a firewall.
** ASP .NET Page ** -> ** Web Server ** -> ** FIREWALL ** -> ** SQL **
So to give an example; from an ASP .NET page on the internet, I would like to populate a DataGrid with the contents of a single table from a SQL database. The SQL database is sitting on our company network behind a firewall.
Could someone please explain / point me in the right direction in how the ASP .NET page / Web Server can securely access the SQL database.
Thanking you in advance
Scott
Cannot Set Connection Property Of Backup Database Task If Connection String Is Customized In Connection Object
Aug 23, 2006I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.
Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.
Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.
Is this an intrinsic issue?
ODBC Connection From Access 2007 Database To SQL Server 2005 Database
Feb 29, 2008I need detailed instructions on how to connect to a database from a Microsoft Access 2007 database to a Microsft Office Accounting 2007 database. The accounting database is an SQL 2005 datbase. It has an instance name of "MSSMLBIZ".
When I try I get an SQL error 53. Do not have permissions or database does not exist.
Thanks in advance for any help.,
SQL Server CODE Pages
Jul 6, 1999Does anyone know a workaround for the code page translation that occurs if you use bcp to
transfer data in and out of SQL Server. I have a table that I am losing certain characters in the
transfers.
SQL Server 7.0 has the -C code page specifier added to BCP to address this but I am running 6.5 currently.
Any ideas on how to deal with this?
Thanks,
Phil
Connecting To Sql Server From Asp.net Pages
May 27, 2008Dear guys
I need to connect to a database from my asp.net page through internet. I encrypt sensitive data before sending them on the net. but I think about a more basic problem: what happens to login data when transfered on the net? I mean, if user name and password are captured by hackers, they can make more serious problems than they find some sensitive data. what shall we do? is there any way for securing sql server login itself?
Regards
Data Access Pages And SQL-Server
Jul 20, 2005Dear All,I have developed a Data Access Page with Access as a project. It isconnected to a SQL-Server database. I try to edit the data in the table andam not able to do so. I might be missing some permissions. I have changeda number. What am I missing?Thanks in advance.Jeff Magouirk
View 1 Replies View RelatedDesign Pages On Report Server
Aug 1, 2007
Hi every body
I have developed an reporting solution for a customer with reporting services and using report builder.
When he connect to http://localhost/reports , he see the page like
http://img215.imageshack.us/img215/583/folderhl1.jpg
But i would to custom design of my default page, and other maybe. Where i can do it ?
Thanks all
Regards
Erwan Sarcelet, France
Deploying ASP.net Pages With Sql Server 2005 (ASPNETDB)
Jun 15, 2008hi,i'm new to deploying asp.net pages with built in asp.net login controls over the web server. i've uploaded my asp.net pages with web.config and placed my ASPNETDB in App_Data folder on the webserver as it was placed in local machine. but it dint work and displayed the following error
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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): 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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735123
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
i also enabled the TCP/IP connection on my local machine to accept remote connections.. Can any1 please provide me a step to step guide on how to deploy the webiste?
Thanking u in advance.
Regards
DB Engine :: Why Does Server Group Pages Into Extents
Jul 24, 2015I am reading the official documentation on pages and extents. I've also read an article on the official SQL Server Blog (sadly, I can't link as a new member). These articles do a good job explaining what an extent is.Why use extents at all?I can't find a good example anywhere of how grouping pages into extents make SQL Server work more efficiently. Any good example of what SQL Server would be missing if it didn't have extents at all, and how extents fix this?
View 6 Replies View RelatedConnection To SQL Server Database
Sep 16, 2004I keep on getting an error when I try to connect to my database throuh my ASP.NET WEb application. The error says login failed for user...
Initially I was using Windows Authentication with Impersonation turned on. This let me connect to the database no problem.
However, I decided to change my method of connecting to the database for performance reasons but now I get this error.
I store my connection string in web.config and it looks like this:
<appSettings>
<add key="ConnectionString" value="server=server;
Database=dbname;Connect Timeout=15;Network Library=dbmssocn;uid=username;password=userpassword"/>
</appSettings>
Further down in the web.config file I still have this:
<authentication mode="Windows" />
<authorization>
<allow users="nameofusergroup" />
<deny users="?" />
</authorization>
<identity impersonate="true" />
Any ideas why I would be able to connect to the database using impersonation and not when I explicity give the crudentials in the connection string?
Regards
Wallace
???VPN Connection To An SQL Server And/or Database
Jul 20, 2005Hi AllCan we connect remotely using SQL Server Enterprise Manager from ourhome PCs using a VPN connection, across the Internet, to an instanceof SQL Server(or a database on it) that resides on an ISP's Server?Can this be done using a VPN IP connection? I believe a static IP isrequired for this?Thanks in Advance, Michael
View 4 Replies View RelatedDatabase Server Connection
Jul 20, 2005I am trying to using sqlserver as back-end for an application(web) runningon the window 2X, one thing I am not sure is that once I establish theconnection between database server and application, should I keep thisconnection open while application is running, or only open it whenthere is a requet to qury records from database?Thanks for your help.
View 2 Replies View RelatedProblems Connection The SQL Server Database
Apr 24, 2007I build a small application using VS 2005. The application just builds a report using basic Select statement from SQL Server db. Here is my problem:
When I tried to run the application using VS 2005 by pressing F5 . The applicaiton launches using VS webserver and everything test fine. But when I put the site in IIS created website . I get an error "Login failed for user '<serverName><userName>
In my connection string I have Integrated Security = SSPI
Please suggest.
Thanks
Connection To Database On A Remote Server
Nov 29, 2007Here is my environment and problem:
I have VWD 2005 and SSE 2005 installed on my local machine. I also have these installed on my Windows 2003 Server. I developed my database using SSE on my local machine but pointing to directory on my server. I have been developing the web app using VWD on my server. I now want to use VWD on my local machine and point to the project on my server. I am able to open the project. In order to access the database in the "Database Explorer" I use as my "Data Source", "MS SQL Server (SQL Client) and it attaches fine and I can see my tables and data.
Now for my problem:
When I try to run the application "VIew in Browser", which login.aspx page is my first page, I get the page, but it doesn't inherit my master page which has the basic navigation and layout. Then after I try to login I get this message.
The file "W:BBAppApp_DataTimeTracker.mdf" is on a network path that is not supported for database files.An attempt to attach an auto-named database for file W:BBAppApp_DataTimeTracker.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Here is a portion of my web.config file for the connection string.<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=true;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />
My website I started with the source code for the TimeTracker start kit and have added more pages and changed the sitemap.
In general I guess I need to know how to handle using VWD on my local machine, but accessing the project on the server. The reason I'm doing this is because my colleague needs to be able to access the web app too to add pages to the site.
Thank you for any help.
Remote Database Connection --SQL Server
Apr 4, 2008HI I have installed VS 2005 with that SQL express edition came default and i then installde SQL server Enterprise Edition .....There i created database and tables and other my colleagues are not able to connect to the Database from there System...........I am using This on XP.......Is it possible to access databse from other remote systems .....IF yes What is the procedure to connect from my other computer to my database which is on XP not any Server OS..
View 7 Replies View RelatedCreating Connection To SQL Server Database
Mar 29, 2004Hi,
platform window xp, SQL Server
I have created a new server registration called 'MASTECH'
with this registration I have created a database called 'youngerNow'
As far as I am aware, no username nor password have been created.
I wish to access the database through asp.
I attempt to create connection with below code
strConn = "Provider=SQLOLEDB; Data Source=mastech; Initial Catalog=youngerNow"
Set Conn=Server.createObject("ADODB.Connection")
Conn.Open strConn
Conn.Close
however I am getting the below error.
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'IUSR_MASTECH'. Reason: Not associated with a trusted SQL Server connection.
/younger now/books.asp, line 199
Anyway help would be appreciated.
regards
steve
SQl Server CE Database Connection Issue
Jun 27, 2006Hi,
I have created my sql mobile database in c drive ( c:SQlMobilesqlmobile.sdf).now when i try to connect it with following code, it gives "The path is not valid. Check the directory for the database" error. i have tried all path options but no one is working.please help me. ( i am using visual studio 2005 and SQl server mobile)
code:
SqlCeConnection ssceconn = new SqlCeConnection("Data Source=c:\SQlMobile\sqlmobile.sdf;Password=XYZ11!@#");
ssceconn.Open();
MessageBox.Show("Ok");
ssceconn.Close();
Recovery :: Pages On A Full Recovery Model Database Corrupted
Sep 17, 2015Pages on a full recovery model database corrupted, need to ensure data loss is minimal for restore operation am thinking about restoring the latest full backup.
View 4 Replies View RelatedReports Are When Printed SQL Server Report Is Printing Extra Pages
Apr 5, 2008
Hi ,
I have developed some report in Sql Server Reporting services my Page orientation is portrait that is report height and width are 8.5 and 11 respectively and margins are set to 0.3 in when it is printed the pages are printed more that actually viewed Pages.
I need help from someone.
Thanks,
Nikhil
response2nikhil@hotmail.com
How To Establish Connection Between SQL Server Database && VWD 2005
Mar 24, 2007I just got a shared hosting plan with godaddy (economy plan) ...
I wrote a simple application with a database. it works fine on my local PC.
I tried to upload my files to the server, but i couldn't get database file on godaddy's server. I did a little research and found out they dont allow uploading database files to their server nor they allow remote access either.
so I logged in to my account and found a database links and I created one (SQL Server)
Host Name
whsql-v44.prod.mesa4.secureserver.net
Database Name
DB_43434
Database Version
2000
Description
maindb
I then logged in to the database and created a new table .. but now I dont know how to make a connection between this database and my application on my pc.
I later found that I must modify my web.config file for the database to work. http://help.godaddy.com/article.php?article_id=689&topic_id=216&prog_id=GoDaddy&isc=
<connectionStrings><add name="Personal" connectionString="Server=whsql-v04.prod.mesa1.secureserver.net;Database=DB_675;User ID=user_id;Password=password;Trusted_Connection=False" providerName="System.Data.SqlClient" /><remove name="LocalSqlServer"/><add name="LocalSqlServer" connectionString="Server=whsql-v04.prod.mesa1.secureserver.net;Database=DB_675;User ID=user_id;Password=password;Trusted_Connection=False" providerName="System.Data.SqlClient" /></connectionStrings>
Now- I am new to web developing, but I do understand that this code is not enough to create the connection to the database. I researched alot but I cant get further.
What code/ settings/ steps do I need to do to get my gridview and other database items connect to the database on godaddy's server ?
any help would be greatly appreciated...
How We Can Drop Connection To SQL Server 2005 Database ?
Aug 6, 2007Hi,
We can see current connections while trying to detach the database through SQL server 2005 Management studio.
Is there any way to drop all existing connections to an SQL server 2005 database with out detaching it.
Thanks
How To Change From SQL Server Express To Database.mdf Connection
Apr 29, 2006Hi,
I've created a SQL Server Express Database that is used by an ASP.NET 2.0 application (developed using VWD Express).
I would like to be able to:
Make changes to stored procedures, views and table structures while developing/testing ASP.NET application - which, ideally, needs a SQL Server Manager Studio Express connection and
Upload my application and data to a database on a network - which, ideally, needs a direct Database.mdf connection.
I know that I need to change my connection string - and am able to achieve that with ease - but I'm not sure what the best way of switching between the two ways of attaching on the database side. I keep getting logon type problems etc.
Thanks very much.
Regards
Gary
Windows Application With Connection To Database On A Server
Apr 21, 2008
Hi all,
I think I can do this, just want to check
Can I have an sql server database (mdf file) on a server and allow windows applications at different site manipulate the database.
As far as I am concerned the only thing that needs to be configued is the connection string..is this correct.
[i would rather use windows applications rather than asp pages]
If I can, the best way to manipulate the database is to use stored procedures. How would I do the following to create and execute the following proposed procedure:
Insert data into a table
Update another table as a result
Execute the store procedure on a form to execute these two statements
Thanks in advance
Peter
Dynamic Database Connection - EXCEL To SQL Server
Feb 5, 2007Hi *, is there a way to connect Excel to SQL Server so that Excel serves as a frontend to SQL Server? I heard rumors that this is possible with the 2007 release.
I'm looking for a product that helps me storing massive data outside an Excel file. Right now, I'm using Palo (open source multidimensional database).
Regards,
Steve
Slow Performance When Rendering Pages In SQL Server 2005 Reporting Services
Jul 3, 2007I have designed a fairly simple report in report designer that uses an analysis services cube as its input, and a basic matrix object as the primary design component. Cube performance either via object browser in Analysis Services or via connection from Excel is great. It does exactly what you build a cube for, i.e. it builds aggregations you can get to quickly. However rendering from a report designer report within Report Manager is a different story.
Even though this report is being rendered from an execution snapshot, it is painfully slow at opening and closing different levels of drill down. The report does have six levels of drill down, which I am sure is a factor. If I use a smaller dataset, performance does become more acceptable. However, I don't consider the requirements of my report to be all that extraordinary.
My conclusion thus far is that larger data sets with many possible page renderings are not the best candidates for HTML rendered reports. In this case Microsoft's cube analysis add-in to Excel might be a better choice. Thoughts and feedback on either how to improve the rendering speed or other presentation alternatives that would perform better would all be welcome.