Export Pops Login Screen
May 14, 2008
Just reporting a quirky thing here... not sure if it is a config issue for our site, or a bug or what. Just want to put it on the radar screen.
We're running AD here. Have Report Services up and have been running about 6 months now.
People on the domain log into the report site just fine.
Recently I rec'd what I thought would be a security problem, but now I'm not so sure. Our COO tried to export an inventory turns report to excel. About half way through the process after he selects 'Open' a login pops.
The problem is that even if the user puts in valid login credentials, the login just pops again, as if there is something incorrect in the values being typed in.
I was able to replicate this on my machine, even logging in as Administrator.
But, I was also, as a regular user on the domain, able to export several other reports. Only the Inventory turns report pops the login on export.
Then it dawned on me, the inventory report uses a group by table that is expandable by product line.
The reality that is shielded from us when all the groups are collapsed is that as of this morning, the total rows in the table exceed 183,000 lines, way more than what one worksheet can hold.
I'm assuming this has something to do with it, but why I wouldn't just see the standard excel error about this and get a login pop instead perplexes me.
Can anyone confirm that this is indeed what happens if you try to export to excel more rows than a worksheet can hold?
I'm trying to figure out if we have a problem or if it is a 'bug' type of thing.
View 3 Replies
ADVERTISEMENT
May 1, 2008
HI all
Currently we have a report manager up and running (SQL Standard 2000), and every one can access to this report, since this report has been abused by some users. So I need to restrict only manager(s) user can have access to it and it should prompt a login screen for username and password as it happens only when I try to open http:\server
eports locally then I got a login screen for username and password, however when I try to open the report on different workstation remotely I don't have login screen and I am able to connect/ open the report.
Any help would be much appreciated.
Cheers
View 6 Replies
View Related
Jul 3, 2004
Well im trying to install some software on someone's cpu. I dont know his password, and he has forgotten. How do I get pass the login screen? and assign a new name and password. :confused:
View 2 Replies
View Related
Jan 17, 2007
Hi guys,
I recently installed SQL 2005 SP2 on my Vista x64 system. However, when I launch the SQL Server Management Studio, I don't see any server names available, even though I have one called SQL2005 listed as running in the Configuration Manager.
Any idea what I did wrong?
When I type in the correct SQL Server name "SQL2005" and click connect I get this error:
TITLE: Connect to Server
------------------------------
Cannot connect to SQL2005.
------------------------------
ADDITIONAL INFORMATION:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
Thanks in advance guys!!!
View 4 Replies
View Related
Sep 13, 2007
I am trying to access a report via url
http://69.23.3.112/reportserver?/rptProject/rptStatus&eStatus=All&eUser=2
it always asks for username and password.
All my users login to my project which is asp.net 1.1(vs2003) based project, now from inside the project, if they try to access any report from (which is on framework 2.0), they have to go through a autentication screen which is related to sql server reporting services.
can you please help, how to override this login screen.
Thank you very much for the information.
View 3 Replies
View Related
Oct 25, 2007
get the following error when I click on prview.
Build complete -- 0 errors, 0 warnings
[rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access.
[rsInvalidMIMEType] The value of the MIMEType property for the image €˜image1€™ is €œtext/html; charset=utf-8€?, which is not a valid MIMEType.
Preview complete -- 0 errors, 2 warnings
This is the URL:
http://air101/airmaps/amsexpress.aspx?sym=bigdot&mlat=42.2446&mlon=-71.1649&lat=42.2446&lon=-71.1649&wid=0.012500&ht=0.012500&mpanv=0&mpanh=0
I've been told that image is a gif how should I set the mimeType?Or is this a security issue of some sort?
View 5 Replies
View Related
May 9, 2007
Hi All,
When I start executing my package a SQLDumper.exe pops up and Stops the package execution.
In addition,SQLDumper.exe creates a SQLDUMPER_ERRORLOG.log file at my Desktop with the following content
05/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied05/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 255205/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 005/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x005/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x005/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0100C5D005/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>05/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000005/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000005/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>05/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>05/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>05/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used05/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used05/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used05/09/07 14:09:55, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL Server90SharedErrorDumpsSQLDmpr0032.mdmp05/09/07 14:09:55, ACTION, DtsDebugHost.exe, Watson Invoke: No
Thanks in advance
View 4 Replies
View Related
Feb 25, 2008
I am trying to export a SQL Server 2005 database from one machine (A) to another machine (B) using SQL Native Client but the export wizard displays an error related to login credentials for the destination server, similar to: "Login error for user ". Not associated with a trusted SQL Server connection (Microsoft SQL Native Client)", when using Windows Authentication and "Login error for user 'user_name'. (Microsoft SQL Native CLient)" when using SQL Server Authentication.
Both database servers are enabled for WIndows and SQL Server Authentication.
Both machines have the same user names.
A ping to the (export) database server returns a valid response.
Even user "sa" returns a SQL authentication error.
Any suggestions??
View 1 Replies
View Related
Oct 27, 2004
Hi,
Im getting this error when attempting to retrieve data from an sql database.
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: Cannot open database requested in login 'projectAllocations'. Login fails. Login failed for user 'sa'.
Source Error:
Line 13: objConn = New SqlConnection( "Server=LAB303-066NETSDK; Database=projectAllocations; User ID=sa;Password=mypassword")
Line 14: objCmd = New SqlCommand("SELECT * FROM project_descriptions", objConn)
Line 15: objConn.Open()
Line 16: objRdr = objCmd.ExecuteReader()
Line 17: While objRdr.Read()
Source File: C:finalyearproject2sample.aspx Line: 15
Please Help!! Im a beginner to this, so if anyone knows the answer, take baby steps when explaining. Thanks
View 3 Replies
View Related
Jul 27, 2005
Been looking through the forums for a solution to this problem.I already tried granting access through statements such as:exec sp_grantloginaccess N1'machineNameASPNET'But they don't seem to work.. i vaguely remember seeing somewhere a DOS command line statement that grants access to the ASPNET_WP and that fixed my problem before on another computer.. but this is a new computer and i forgot to write down the command.Can anyone help explain and propose a solution to my problem. Many thanxs.
View 9 Replies
View Related
Dec 19, 2003
I am using the MSDE to connect to my ASP.NET application. I get this error after clicking the login button of my login page. Anyone know why this would happen?
Thanks for any help,
Cannot open database requested in login 'DataSQL'. Login fails. Login failed for user 'serverASPNET'.
View 5 Replies
View Related
Sep 4, 1999
if you encountera problem of blue screen and then you reinstall NT server, what is the quickest way to restore sql back. after installation of windows nt sql will not start, please advice anyone who knows
View 1 Replies
View Related
Jul 20, 2005
Hello,I am looking for help with the following situation.I have created a simple call tracking system that is integratedwith our accounting / warehousing program in the company. The calltracking system uses ASP 3.0 and MSSQL 2000 sitting on an Intranet webserver. All appears to be working well with the software. I amtrying to create a search screen to search through the calls based ondifferent criteria.I have an ASP script that generates a SELECT statement based onthe selected criteria but this is sent off to the SQL server as thestatement. I want to use a stored procedure to speed up the process.Is it possible to create a stored procedure for this search even whenthe WHERE clause and criteria keeps changing?TIA
View 3 Replies
View Related
May 4, 2007
Hi all,
I have a simple question about RS.
I need to show all my reports in full screen mode but I don't find any properties in report.
I read in some threads to use ToolBar options but toolbar show or hide print, refresh, etc. but I want to hide the top bar because I don't want show search box or navigation bar!!!
Thanks for all your help.
View 3 Replies
View Related
Jul 20, 2005
HaiIs it possiable to close the current connection screen in the queryanalyser , not to close the query analyser.With ThanksRaghu
View 3 Replies
View Related
Sep 4, 2007
I have created a report, and want to now deploy it to the Report Server. Each time I try to do that, I get a Reporting Services Log In screen. I have no idea what to input, having tried my windows authentication and sa account without sucess. Is there something else that I need to set up so I can deploy my reports? Thanks in advance!
View 1 Replies
View Related
Feb 7, 2008
Technical information:
***STOP: 0X0000008E (0XC0000005, 0X8062C26B, 0XA84E5A58, 0X00000000)
Beginning dump of physical memory
Physical memory dump complete.
Contact your system administrator or technical support goup for further assistance.
What can i do to fix this problemHelp please, don't want to reinstall XP because i am running AutoCad on my PC.
This Blue screen of death is the worst!!!
Keron
View 1 Replies
View Related
Dec 27, 2006
everything is ok.. the connection is on..the page can be loaded... no error....
BUT the data from the database cannot be retrieved... as in.. it just didnt load on screen...
i dont know whats wrong... i have follow all the steps show on a book.. can anyone pls help me?? thks
View 3 Replies
View Related
Sep 14, 2000
does anyone know of easy to use tools to design input screens to access sql version 7 databases
View 1 Replies
View Related
Aug 9, 2006
I have a screen set up in another software package which accepts
2 values on a form -
'Number1' and 'Number2'
I need to check that at least a value is entered in one or both ...
If both values are 0 (set on dispaly of the form )then I need
to throw an error message to that effect on screen ....
(The Sql script is triggered after the form data has been entered)
Can anyone help me with the SQL script please to check the values ???
View 5 Replies
View Related
Oct 21, 2005
SQL 2000 SP3================================================In reviewing this screen, I have SPIDS > 100 that have a status ofsleeping, command = AWAITING COMMAND and login/batch dates that areweeks old ... Shouldn't this list be more recent activity only ?Thanks,Craig
View 1 Replies
View Related
Jul 18, 2007
Just trying to find out what this error code is, and how to solve this. I have the infamous "blue screen of death" but I cannot get XP to load or even to load in "safe mode". I am hoping to save my files on this laptop.
Here is the error:
A problem has been detected and windows has been shut down to prevent damage to your computer.
If this is the first time you've seen this Stop error screen, restart your computer. If this screen appears again, follow these steps:
Check to be sure you have adequate disk space. If a driver is identified in the Stop message, disable the driver or check with the manufacurer for driver updates. Try changing the video adapters.
Check with your harware vendor for any BIOS updates. Disable BIOS memory options such as caching or shadowing. If you need to use Safe Mode to remove or disable components, restart your computer, press F8 to select Advanced Startup Options, and then select Safe Mode.
Technical information:
***STOP: 0X0000008E (0XC0000005, 0X8062C26B, 0XA84E5A58, 0X00000000)
Beginning dump of physical memory
Physical memory dump complete.
Contact your system administrator or technical support goup for further assistance.
I have tried to change my memory but that didn't seem to help. Any ideas?
Thanks for a reply,
Shan
View 1 Replies
View Related
Apr 25, 2007
So in order for print preview to work, one has to change the background of all items on the page to white?
Is that a bug that is going to be fixed soon (along with running out of memory when you print a big report)?
View 1 Replies
View Related
Feb 27, 2008
The "View Report" button is relatively positioned so when the report content is wider than the screen size, it pushes it to the right such that the users have to scrool right to click on it again. Is there a way of setting the "View Report" button to a fixed position to eliminate this?
View 1 Replies
View Related
Jul 28, 2006
Hi again.
I have been deploying the first few test SQL 2005 machines recently, from what I was told is the full-feature edition DVD received from the https://licensing.microsoft.com website.
We have purchased a mixture of per-processor and per-user licenses to use for this software. However, I am never asked what licensing mode to use during the install.
Can anyone confirm or deny that a setup screen appears asking what licensing version you want to use (per-user or per-processor)?
I cannot confirm what was downloaded from the licensing-website because I don't have access through the company.
I have the same symptoms as seen on this postings:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=360181&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=510279&SiteID=1
However, I don't see such a Control Panel utility to change the licensing type.
Thanks to anyone who can assist.
View 4 Replies
View Related
Jul 20, 2007
Can the results screen on the data tab be permanently hidden?
Thanks
BobP
View 2 Replies
View Related
May 29, 2014
However when I start SQL 2012 it loads the Management Studio but does not load the smaller splash screen that usally appears asking me to connect to a server. When I try to click any of the menu items at the top of the screen the system just hangs.
I also have 2012 Service pack 1 installed too.My installations of 2005 and 2008r2 still work fine.I also tried loading SQL2014 and had the same issues as with 2012.
View 0 Replies
View Related
Feb 28, 2008
I am hoping someone can guide me through this error. It appears SQL Server 2005 Management Studio might have a bug. What I am accomplishing deleting several rows from several tables inside SSMS. However, after about 4 or five deletions, I get the BLUE SCREEN of DEATH.
I can repeat this pattern.
Thanks for taking the time to read my post.
View 20 Replies
View Related
Apr 17, 2007
Hi, anybody help me how to develop Today Screen plug in for WM5 pocket pc.
View 1 Replies
View Related
May 21, 2007
Hi,
I am trying to use the report wizard and I get to the last screen where it asks for a name for the report file. The 'Next' button is not unprotected although the 'Finish' button is.
As far as I can tell I have setup the Matrix style report up correctly. If I use the 'Finish' button, Visual Studio just crashes.
The help does not give any clue and I have not found any answers in the forum.
Any ideas what the problem might be?
View 3 Replies
View Related
Jan 14, 2008
Hi
I have the following problem (on 2 PC's now)
On 1 pc i installed VS2008 besides VS2005 and SQL 2005 (before i installed VS2008 everything was fine)
On the other is a fresh installed XP machine with only VS2008 SQL2550 and Office2007
Latets service packs are installed
On both machines when i open a table in SQL 2005 with the 'open table' command the show of the table is very slow.
Every row is updated file by field, the grid is not showing, the row and column headers are not 'grey' as normal.
Scrollign is impossible as the screen updates start again that slow.
Even a small table with 10 rows and 15 field behaves this slow. Its not workable.
What can be done to resove this???
Peter
View 11 Replies
View Related
Jun 2, 2015
How can I resize a bitmap to fit the screen? I have inserted a bitmap using an external source.
View 4 Replies
View Related
Nov 30, 2007
Hi,
I have a MS Reporting Services Report which I display in a ASPX page inside a iFrame (i.e. an other ASPX page displayed inside the main ASPX page).
The report is rendered to the screen using the normal ReportViewer control.
Everything works fine, except when I click on the Print Button on the ReportViewer control, I get a Blue Screen of Death (BSOD) and my computer restarts.
This is something that happens every single time I click on that Print button
Has this happenend to anyone else?
Regards,
Thysie
View 4 Replies
View Related