Answer Questions

• SVerhalle credentials type - service credentials missing

  Hi All, On my 64bit itanium cluster, how come when I open up my Reporting Services Configuration Manager and go to the "Database Setup", under "Credentials Type" I am missing the option "Service Credentials" This is how I have my dev server set up and would like it to be the same. This was due to us connecting to the individual node rather than to the cluster when opening up t ...Show All

• Randy_TS NOT build index while loading data into a DW

  Hi Champs I am importing huge amout of row into a DW, that I then want to build Cubes from. This process is slow, as SQL insists of concurrently building an index, whil loading. Is there a possebility to delay the build of Index to After the data is loaded into the DW /Many thanks If you are building an index then surely it is in your control as to when that happens P ...Show All

• Mgrondin345 Asp.Net not finding the SQLServer for setting up Security problem

  I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool. The error indicates it is looking for a file in the app_data directory. (empty), but everthing else points to  SQLServer (express) as being the issue. I have run aspnet_regsql.exe (both on my default instance of sql (a sql2kas) and the beta2 instance that shipped with ...Show All

• Andy En Native XML in SQL Express 2005 same as SQL 2005 standard, workgroup and enterprise?

  Is the native support of XML in SQL 2005 Express the same as native XML support in the other versions of SQL 2005 yes http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Thanks Thank you Zoya ...Show All

• BBBY Problem Connection and/or Deploying to ReportServer

  Hi, I know this is an issue that several people has posted, but I've yet to to get a resolution that works. I am unable to deploy reports to the report server and unable to view reporting services in SSMS. Here is the error I'm receiving from the when trying to deploy from BIDS. I'm thinking it may have something to do with IIS 6.0 security but I'm coming up empty at this point. Any help would be greatly appreciated. My current environment ...Show All

• khaaaalil Cannot Open User Default Database (error 4064)

  Hi, SQL Server 2005 installed on my computer. i was trying to make a login page with VS.2005 pro. But i got some errors on Website Administration Tool. Whatsoever, i registered a database (aspnetdb) . Then, i think i made my default database to aspnetdb. Something went wrong and i decided to delete aspnetdb and start whole procces from the begining and i did it. AAANDD WHOOOLA. I got this error: Cannot Open User Default Database, Login Failed M ...Show All

• BambooZelD Should this be an error rather than a warning?

  If you have a package that uses an environment variable for an indirect configuration and the environment variable is not present when the package runs you get the following warning: The configuration environment variable was not found.  The environment variable was: "Seer.ConnectionManager.CUECommonReference". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the confi ...Show All

• Marcin Kosieradzki Event ID: 107 MSSQLSERVER cannot connect to the report server database

  I only receive this error message when I reboot my server. I was wandering if there was a time limit I could set for SQL before it connects to the report server database. Event Viewer Log Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Windows Help and Support provided no further information o ...Show All

• basittanveer View sort order problems

  I am testing an upgrade of our databases to SQL Server 2005 (from 2000), and I apologize if this question seems a little simplistic.  I have a view that is based on a table where the primary key is Doctor #, and it even has an ORDER BY to sort by Doctor #.  This view has ALWAYS (in SQL 2000) returned the data in the proper sort order, but once I upgraded a copy of the database to SQL Server 2005 the view resultset is no longer in Docto ...Show All

• clugsta Log restore failure

  Hi, I'm getting error: An error occurred while processing the log for database ' ' when trying to restore first transaction log backup after successful restore of full backup on SQL 2000. Note that database name is blank. What's the cause and the solution Please help. Hi Kris, I'd recommend you not use EM to perform the restore, but rather issue a restore command from Query Analyser.  At ti ...Show All

• Ikky Attach Database problem

  I am trying to attach a database as part of my overall application distribution. After installing Express when my .NET app first starts it atempts to attach the database using EXEC sp_attach_db etc... This used to work fine with MSDE 2000 but now the database is being attached as read-only. If I then use Management Studio to manually detach and attach the database it is fine. Any ideas why this is happening please ...Show All

• m0 Extranet access to Report Manager

  I would like to make our reports available via Report Manager to customers external to our campus. Are you aware of any documentation to support this effort; i.e., White Paper(s), etc I think there will be some documents coming online soon. In the meanwhile, you can take a look here: http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx Hope that helps Tudor Thank you very much -- that w ...Show All

• paomeow Issue with launching Report Builder from client PC's

  Hi, I got a working installation of reporting services 2005 up and running, Im able to create models and launch the Report Builder on the machine on which the server is installed, however if I try and run it from another machine on the network I get an error and Im able to view the following exception. Following errors were detected during this operation.  * [04 Jul 2005 10:39:34 +01:00] System.Deployment.Application.DeploymentDownload ...Show All

• ThomasZecher Installation support for XP SP2

  When I try to install SQL Server 2005 on my computer (Windows XP with SP2) I get a warning from the installer telling me that my operating system is not supported, this is the warning I get. - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software R ...Show All

• Matt_343 visual studio running too slow

  Hi friends after working visual studio (on my report model project) few minutes it runs too slow. i mean clicking on entities ,attributes takes ages to finish. I opened task manager i see "devenv.exe" is taking more than 800,000 k !! am using sql server 2005 standard edition. have you seen similar problem. Thanks for your help. Jon am wondering if you found any solution regarding this. BTW i used "filemon" software fro ...Show All