How Could I Know The Version Of Reporting Services In My Machine?
Aug 15, 2007How could I know the version of Reporting Services in my machine?
thanks
ADVERTISEMENT
Installing Full Version Of 2005 Server On A Machine That Already Has Reporting Services On It
Jan 7, 2008Hi there,
I'm trying to install the common components for SQL 2005 on a server that already has Reporting Services 2005 installed on it. It keeps comng up with an error:
"To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter."
The Reporting Services install has had SP2 applied to it, would that be what is messing up the install?
I have very little experience with SQL so any info would be helpful.
Thanks!
To Access Reporting Sevices (Report Manager, Reporting Web Services), Does One Has To Be An Admin On The Machine
Mar 12, 2007Hi There,
Our DBA has installed reporting services on a server and now in order to access the report manager, one has to be an Admin on that Server. I am guessing that there is a mistake in the configuration of Reporting Services. Usually it should allow anybody who was added to the roles in the properties section of the Report Manager, right? I have also added the users to the DB..
Also I am using Windows Authentication to access Report Catalog items (Reporting Services is installed on Server2) from a web Application(deployed on Server1) and displaying the report using report viewer. For some reason, server1 has to be in an Admin role on Server2 to access the report catalog/report. This is kinda strange for me as I don't want everybody to be an Admin on Server2. Can anybody please point in the right direction?
Thanks.
How To Know The Reporting Services Version At Runtime
Apr 2, 2007HI, can anybody help me?
I have a problem. With the sqlserver 2005 sp2 some behavieur are differt from previous versions.
For example with service pack 1 there isn't the "select all" option for multi value parameters, so i add MY select all, but with service pack 2 there is the "select all" option for multivalue paramteres, so when my reports are running under a server with service pack 2 in the list of multivalue parameter I'm going to find "Select all" and "MY select all"
It is possible to know at runtime under which version my repors will be running? so I can use or not MY select all. (i cannot force client with a particular version)
Thank in advance
Reporting Services Toolbar && Version
Aug 9, 2007Hi All,
1. Whether I'm working on in Layout, Data or Preview (Reporting Services 2005) for any report
the toolbars I select disappear when I click on close. In Tools, Customize, I have check marks by: Formatting, Query designer, Layou,Build and Standard among a few others. I tried the reset button but no help as well.
What am I missing? Should they be visible and not grayed out?
2. Also, Is there an easy way to tell what verion/service pack level SQl server 2005 and of MSSRS 2005 I am running?
Thanks in Advance !
>Scott
Reporting Services 2000 && 2005 On Same Machine
Aug 3, 2006How can I get the 2000 and 2005 versions of SQL Server Reporting Servicesboth working on my development laptop ?????I have ASP.NET 1.1 and 2.0 installed on my laptop.I have Visual Studio 2003 and 2005 installed on my laptop.I have my default website configured for ASP.NET 2.0.I have the developer edition of SQL Server 2000 installed on my laptop asinstance RMK006 in the MSSQL folder. I have the developer edition of SQLServer installed on my laptop as instance RMK0062005 in the MSSQL.1 folder.I have the corresponding versions of SQL Server Reporting Services installedon my laptop.I have the Reports web site and the Reports web site and ReportServer website configured to ASP.NET 1.1I have the Report$RMK0062005 web site and the ReportsServer$RMK0052006configured to ASP.NET 2.0Entering http://localhost/reports$rmk0062005 in my web browser works fine.Entering http://localhost/reportserver in my web browser generates thefollowing error:Reporting Services Error--------------------------------------------------------------------------------The report server cannot decrypt the symmetric key used to access sensitiveor encrypted data in a report server database. You must either restore abackup key or delete all encrypted content and then restart the service.Check the documentation for more information. (rsReportServerDisabled) GetOnline HelpBad Data.--------------------------------------------------------------------------------Microsoft Reporting ServicesEntering http://localhost/Reports in my web browser generates the followingerror:The report server cannot decrypt the symmetric key used to access sensitiveor encrypted data in a report server database. You must either restore abackup key or delete all encrypted content and then restart the service.Check the documentation for more information. (rsReportServerDisabled) GetOnline Help Bad Data.The only way I can seem to get 2000 Reporting Services working is to do thefollowing:- run C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspn et_regiis.exe -u- uninstall 2000 Reporting Services- run C:WINDOWSMicrosoft.NETFrameworkv1.1.4322aspne t_regiis.exe -i- install 2000 Reporting ServicesBut once I've done that Visual Studio 2005 etc no longer work.The utlimate goal is an ASP.NET 2.0 application developed in Visual Studio2005; the application is based on a SQL Server 2000 database and needs toinvoke SQL Server 2000 Reporting Services to run reports.What am I doing wrong?ANY HELP WOULD BE GREATLY APPRECIATED - I'M DIEING HERE AND MY CLIENT ISLOSING PATIENCE !!!!!
View 1 Replies View RelatedVersion Error When Connecting To SQL Reporting Services
Oct 12, 2007Hello,
Does anyone know the steps I need to take to update the version of reporting services from C.0.8.40 to C.0.8.43?
My connection error occurred during my attempt to move a database from one server to another using detach and attach. After successfully attaching the databases to the new server I got the following error:
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.43'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) (Report Services SOAP Proxy Source)
Thanks for any help you can provide!
How Can I Check The Version Of Reporting Services Installed?
Jun 2, 2006Hi, all here,
Would anyone here please guide me how can I check the version of reporting services installed? My problem is in my virtual machine, both SQL Server and SQL Server 2005 are installed, but I can create report in the vistual studio 2005 IDE, but cant deploy it to the reporting server database, in addition, I cant connect to reporting services database in SQL Server 2005 management studio.
Is it possible to install two different versions of reporting services in the same virtual machine? Please anyone here give me some advice for that. Thanks a lot.
With best regards,
Yours sincerely,
Unable To Start Reporting Services On Local Machine
Apr 6, 2008I am new to SQL Server 2005 Reporting Services and I€™m having problems starting the service. I am running a Windows XP SP2 with SQL Server 2005 and reporting services but the service will not start. My SQL Server instance logs on using €˜Windows Authentication€™ using a username sysadm with no password
I have installed IIS and made sure that ASP.net is running.
I have opened up the Report Services Configuration Manager and amended the settings but I€™m unable to get the service started!!!
Theses are my settings
i) Report Server Virtual Directory OK
Name: ReportServer1
Website: Default Web Site
ii) Report Manager Virtual Directory
Name: Reports1
Website: Default Web Site
iii) Windows Service Identity
Service name: ReportServer
Service Account: NT AuthorityLocal Service
Iv Web Service Identity (NOT WORKING)
v) Database Setup
Servername €“ Nameofmyserver
Database name - ReportServer1
Credential Type Server Credentials
When I click on start no error message appears, it just seems to time out.
Reporting Services :: Why SSRS Is Looking For Using Machine Configuration File
Aug 6, 2014I am using BIDS 2012.I am getting this error: Unable to load assembly U2.
Data.Client, Version=2.1.0.0, Culture=neutral , PublicKeyToken=9ab9148678f4f448, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.Â
---> System.IO.FileNotFoundException: Could not load file or assembly 'U2.Data.Client, Version=2.1.0.0, Culture=neutral, PublicKeyToken=9ab9148678f4f448' or one of its dependencies. The system cannot find the file specified.
[code]....
I am expecting
C:WindowsMicrosoft.NETFramework64v4.0.30319configmachine.config
how can I force SSRS to use "C:WindowsMicrosoft.NETFramework64v4.0.30319configmachine.config".
Trial Version Of SQL SERVER REPORTING SERVICES 2005
Apr 24, 2007Where can I get a trial/evaluation version of Sql Server 2005 Reporting Services?
I dont have SQL SERVER 2005 Installed on my Pc.
Reporting Services 2005 - Showing Wrong Version
Jun 15, 2006Hi
I installed RS 2005, SP1 and then the rollup fix 2153 however; if I run http://server/reportserver or view the reportserver log file, it shows version 2047 which is the SP1 version. I have added the tail end of the rollup hotfix log file which shows I have installed it.
Is this a known issue?
06/14/2006 16:03:57.153 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1Reporting ServicesReportServerCatalog.sql
06/14/2006 16:03:57.169 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1Reporting ServicesReportServerStylesHtmlViewer.css
06/14/2006 16:03:58.216 Attempting to install file: sqlrun_rs.msp
06/14/2006 16:03:58.263 Attempting to install file: \NLDN9577DWWd$89a527f93aa2bb044103hotfixrsFilessqlrun_rs.msp
06/14/2006 16:03:58.278 Creating MSP install log file at: C:WINDOWSHotfixRS9LogsRS9_Hotfix_KB918222_sqlrun_rs.msp.log
06/14/2006 16:03:58.294 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
06/14/2006 16:03:58.294 Failed to read registry key: Debug
06/14/2006 16:04:44.826 MSP returned 0: The action completed successfully.
06/14/2006 16:04:45.092 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
06/14/2006 16:04:45.107 Failed to read registry key: Debug
06/14/2006 16:04:45.123 Successfully installed file: \NLDN9577DWWd$89a527f93aa2bb044103hotfixrsFilessqlrun_rs.msp
06/14/2006 16:04:45.139 Restarting RS Service ReportServer since it was previously running
06/14/2006 16:04:45.154 Attempting to start service: ReportServer
06/14/2006 16:04:51.936 Successfully started service: ReportServer
06/14/2006 16:04:51.983 Successfully installed target: NLDN9577DWW
06/14/2006 16:04:51.998 Successfully installed instance: MSSQLSERVER
06/14/2006 16:04:52.014 Successfully opened registry key: SoftwareMicrosoftWindowsCurrentVersionUninstall
06/14/2006 16:04:52.608
06/14/2006 16:04:52.623 Product Status Summary:
06/14/2006 16:04:52.639 Product: SQL Server Reporting Services 2005
06/14/2006 16:04:52.701 MSSQLSERVER - Success
06/14/2006 16:04:52.717
06/14/2006 16:06:05.500 Hotfix package closed
Cheers
Steve
Reporting Services Configuration Fails In Windows 2003 SP2 ,64-bit Machine
May 14, 2008
Hi all,
i am tring to install and configure reporting services in Windows 2003 SP2- 64 bit machine as part of installing SCE 2007, and i followed the procedure for confiurng all the options in reportingservices config tool,
all the options show green flag and still could not proceed further as the following error is coming
"The Selected Sql server reportin service instance is not configured , please configure to continue" which halts the further process,
I have installed SQL Server 2005 edition and installed Sql server 2005 SP2 also,
any inputs on this issue , i would welcome them,
Reporting Services :: How To Get Add-in For SharePoint Version To Sync With SSRS Engine
Oct 23, 2015I have installed SQL 2012 on my DB Server. The SSRS database version table(s) list the current version as 163. The Version number that's displayed in the Programs and Features for SSRS Add-in for SharePoint (yes, on the db server) is 11.2.5623.0.
On my two SharePoint servers the version number for SSRS Add-in for SharePoint shows 11.2.2058. I have installed SQL Server 2012 Service Pack 2 on all three machines. When the SharePoint box calls into SSRS to render a report I get this error:
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '163'. The expected version is '162'. --->
Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException:
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '163'. The expected version is '162'.
what else I need to install - and where - to correct this error. What is expecting version '162' and why?
Trying To Install A Local Version Of Reporting Services, Got Error Message
Jan 31, 2008Where do I look to fix this?
Server status is red.
I think I might have left the domain name blank when I installed this. Is there anyway to enter one later. I have tried to change this through add/remove programs and do not get a chance to change this field
Thanks!
Terry Beckman
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerService__main_01_31_2008_08_18_22.log</Path>
<SystemName>JPADESKTOP1</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!1/31/2008-08:18:22:: w WARN: WebServiceAccount is not specified in the config file. Using default: JPADESKTOP1ASPNET
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/31/2008-08:18:22:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!servicecontroller!9!1/31/2008-08:18:23:: Total Physical memory: 1055309824
ReportingServicesService!library!4!1/31/2008-08:18:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'JPADESKTOP1ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'JPADESKTOP1ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!1/31/2008-08:18:23:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'JPADESKTOP1ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
Reporting Services :: Version Of Report Server Database Is Either In Format That Is Not Valid
Jun 3, 2015When i try to restore the encrypt key to reporting service getting the below error.The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '147'. The expected version is 'C.0.9.45'I found the table in Database  called DBUpgrdaeHistory
UpgradeID DBVersion
Datetime
31 147 Â Â Â Â Â
[code]...
Error:no Report Server Found On The Specified Machine While Setting Up Reporting Services Configuraion Manager
Feb 19, 2007Hello,
I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace... the installation is local ...
Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server...
Can somebody please help me on this...
Thanks in advance...
Nirupa
Can We Install Reporting Services 2005 In A Machine In Which Is Not Installed SQL Server 2005
Nov 19, 2007Hi,
Can we install reporting services 2005 in a machine in which is not installed SQL server 2005.?
Thanks
Integration Services :: Package Migration From Version 8 To Version 6 Failed
Sep 22, 2015I have received the error message "Package migration from version 8 to version 6 failed".I have developed a SSIS package with Visual Studio 2013 which gives me PackageFormatVersion of 8. I then deploy my package to the ssisdb catalog that is running on a SQL Server 2012, this works fine but when I try to execute the package the error arises…due to SQL Server 2012 has a PackageFormatVersion of 6 and it can’t run something that has a greater version.I haven’t seen any good solution for this but one that would work for me would be to upgrade the Integration Services Server from 2012 to 2014, leaving everything else in 2012 (database, ssms, ssas, ssrs).Would this solve the package format problem? Would I then be able to execute my packages in the ssisdb catalog?
View 3 Replies View RelatedConversion Of Oracle Version 0-1 From DEC Machine
Jul 20, 2005Hi... Have a customer who's running version 1 of oracle on a DECmachine.. is there a driver out there for that stuff? How might oneget the data from the DEC machine to Sql Server 2000???? All I havenow are fdl/sfl files.thanks in advance.Steve
View 2 Replies View Related911 Help! Why Can't I Get A Functional Version Of SQL Installed On My Machine?
Mar 5, 2007Hello Everyone, I am trying to install SQL 2005 on my machine. All I want is the functionality that I enjoyed with SQL 2000- Query Analyzer and Enterprise Manager. For some reason, the version of SQL 2005 that I am installing is only giving me an option for the Configuration Manger which does not provide access to the Management Console. It is my understanding that I need the Management Console to create databases, look at tables in my databases, etc., etc. just like I did in Enterprise Manager. Is there anyone who can tell me what I'm doing wrong? Currently, the cd that I have says SQL Developer Edition. Thanks.
View 8 Replies View RelatedVista 64 Bit Machine With 64 Bit Version Of SQL Server Express 2005
May 28, 2008Hi
I have a PC running the 64 bit version of vista home premium (will be soon upgrading to ultimate).
On the download page http://msdn.microsoft.com/en-au/express/bb410792.aspx for SQL Server Express under the section entitled SQL Server 2005 Express Edition SP2 it mentions at the bottom of the page (referred by * & **) that there is a 64 bit install version available for both SQL Server & management Studio.
However, under the section entitled SQL Server 2005 Express Edition with Advanced Services SP2, there is no * or **. As far as I can tell, the Advanced services has Reporting Services as well.
So, what I am wondering is, can I specifically download the 64 bit versions of SQL server express & management studio and as well, download just the reporting services part of Advanced Services?
Kind regards
Ross
Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services
Mar 22, 2008
Hello,
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?
Any help is appreciated
Compatibility Of SQL Express Reporting Services With SQL 2000 Reporting Services
Dec 6, 2006I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.
One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows:
Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets?
Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?
Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.
Thanks to anyone who can help.
-- Mark
SQL Reporting With Sage Line 500 Version 6
Jul 19, 2007HI all,
I'm a newbie to all this so if I ask soem stupid questions then I appologise.
I was given a project on getting the reports within sage to work, You may be asking why then post in the SQL forum.
Ah well that is because Sage is as helpfull as a chocolate teapot to write reports with!!
I have try and found the limitation way to fast for my liking. So in my desperation to have a happy boss, I have turned away from the internal reporting and tryed to work on the SQL reporting.
I have found the \severname
eports function and I am nowtrying to find my way around.
Do any of you know a good place to pick up any information on the getting started. I konw that its going to be an uphil fight with sage cross referancing more times than i have hot dinners! but Sages and Crystal reports are not working for me, in the respect I can not get the look and functionality that I want.
Well i think that that sould cover it?!
I fyou know of any resource or step by step howto's then that would be great.
many Thanks
Michael
Where Can I Download A Non-trial Version Of SQL Reporting Service?
Apr 16, 2004we're Microsoft partner, but I find no link to download (non-trial version) it from Microsoft site (partner/MSDN subscriber area).
View 1 Replies View RelatedEnterprise Manager Reporting Wrong Server Version
Dec 3, 2006I am running MS SQL 2000.I recently ran a procedure in Query Analyzer from the Master db toclear out all replication information so I could start/recreate itagain.After I ran this procedure Enterprise Manager no longer showed theregistered server in the tree. When I tried to re-register it gave methe following message:"A connection could not be established to ([Database Name])""Reason: [SQL-DMO]Sql Server ([Database Name]) must be upgraded toversion 7.0 or later to be administered by this version of SQL-DMO""Please verify that sql is running and check your SQL serverregistration properties (by right click on the ([Database Name]) node)and try again."I ran the following procedure:<code>exec sp_configure N'allow updates', 1goreconfigure with overridegoDECLARE @name varchar(129)DECLARE @username varchar(129)DECLARE @insname varchar(129)DECLARE @delname varchar(129)DECLARE @updname varchar(129)set @insname=''set @updname=''set @delname=''DECLARE list_triggers CURSOR FORselect distinct replace(artid,'-',''), sysusers.name fromsysmergearticles,sysobjects, sysusers wheresysmergearticles.objid=sysobjects.idand sysusers.uid=sysobjects.uidOPEN list_triggersFETCH NEXT FROM list_triggers INTO @name, @usernameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping trigger ins_' +@nameselect @insname='drop trigger ' +@username+'.ins_'+@nameexec (@insname)PRINT 'dropping trigger upd_' +@nameselect @updname='drop trigger ' +@username+'.upd_'+@nameexec (@delname)PRINT 'dropping trigger del_' +@nameselect @delname='drop trigger ' +@username+'.del_'+@nameexec (@updname)FETCH NEXT FROM list_triggers INTO @name, @usernameENDCLOSE list_triggersDEALLOCATE list_triggersgoif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[syspublications]') and OBJECTPROPERTY(id,N'IsUserTable')= 1) begin DECLARE @name varchar(129)DECLARE list_pubs CURSOR FORSELECT name FROM syspublicationsOPEN list_pubsFETCH NEXT FROM list_pubs INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping publication ' +@nameEXEC sp_dropsubscription @publication=@name, @article='all',@subscriber='all'EXEC sp_droppublication @nameFETCH NEXT FROM list_pubs INTO @nameENDCLOSE list_pubsDEALLOCATE list_pubsendGODECLARE @name varchar(129)DECLARE list_replicated_tables CURSOR FORSELECT name FROM sysobjects WHERE replinfo <>0UNIONSELECT name FROM sysmergearticlesOPEN list_replicated_tablesFETCH NEXT FROM list_replicated_tables INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'unmarking replicated table ' +@name--select @name='drop Table ' + @nameEXEC sp_msunmarkreplinfo @nameFETCH NEXT FROM list_replicated_tables INTO @nameENDCLOSE list_replicated_tablesDEALLOCATE list_replicated_tablesGOUPDATE syscolumns set colstat = colstat & ~4096 WHERE colstat &4096<>0GOUPDATE sysobjects set replinfo=0GODECLARE @name nvarchar(129)DECLARE list_views CURSOR FORSELECT name FROM sysobjects WHERE type='V' and (name like 'syncobj_%'ornamelike 'ctsv_%' or name like 'tsvw_%' or name like 'ms_bi%')OPEN list_viewsFETCH NEXT FROM list_views INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping View ' +@nameselect @name='drop View ' + @nameEXEC sp_executesql @nameFETCH NEXT FROM list_views INTO @nameENDCLOSE list_viewsDEALLOCATE list_viewsGODECLARE @name nvarchar(129)DECLARE list_procs CURSOR FORSELECT name FROM sysobjects WHERE type='p' and (name like 'sp_ins_%'ornamelike 'sp_MSdel_%' or name like 'sp_MSins_%'or name like 'sp_MSupd_%' ornamelike 'sp_sel_%' or name like 'sp_upd_%')OPEN list_procsFETCH NEXT FROM list_procs INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping procs ' +@nameselect @name='drop procedure ' + @nameEXEC sp_executesql @nameFETCH NEXT FROM list_procs INTO @nameENDCLOSE list_procsDEALLOCATE list_procsGODECLARE @name nvarchar(129)DECLARE list_conflict_tables CURSOR FORSELECT name From sysobjects WHERE type='u' and name like '_onflict%'OPEN list_conflict_tablesFETCH NEXT FROM list_conflict_tables INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping conflict_tables ' +@nameselect @name='drop Table ' + @nameEXEC sp_executesql @nameFETCH NEXT FROM list_conflict_tables INTO @nameENDCLOSE list_conflict_tablesDEALLOCATE list_conflict_tablesGOUPDATE syscolumns set colstat=2 WHERE name='rowguid'GODeclare @name nvarchar(200), @constraint nvarchar(200)DECLARE list_rowguid_constraints CURSOR FORselect sysusers.name+'.'+object_name(sysobjects.parent_ob j),sysobjects.namefrom sysobjects, syscolumns,sysusers where sysobjects.type ='d' andsyscolumns.id=sysobjects.parent_objand sysusers.uid=sysobjects.uidand syscolumns.name='rowguid'OPEN list_rowguid_constraintsFETCH NEXT FROM list_rowguid_constraints INTO @name, @constraint WHILE@@FETCH_STATUS = 0 BEGINPRINT 'dropping rowguid constraints ' +@nameselect @name='ALTER TABLE ' + rtrim(@name) + ' DROP CONSTRAINT '+@constraintprint @nameEXEC sp_executesql @nameFETCH NEXT FROM list_rowguid_constraints INTO @name, @constraint ENDCLOSE list_rowguid_constraintsDEALLOCATE list_rowguid_constraintsGODeclare @name nvarchar(129), @constraint nvarchar(129)DECLARE list_rowguid_indexes CURSOR FORselect sysusers.name+'.'+object_name(sysindexes.id), sysindexes.namefromsysindexes, sysobjects,sysusers where sysindexes.name like 'index%' andsysobjects.id=sysindexes.id and sysusers.uid=sysobjects.uidOPEN list_rowguid_indexesFETCH NEXT FROM list_rowguid_indexes INTO @name, @constraint WHILE@@FETCH_STATUS = 0 BEGINPRINT 'dropping rowguid indexes ' +@nameselect @name='drop index ' + rtrim(@name ) + '.' +@constraintEXEC sp_executesql @nameFETCH NEXT FROM list_rowguid_indexes INTO @name, @constraint ENDCLOSE list_rowguid_indexesDEALLOCATE list_rowguid_indexesGODeclare @name nvarchar(129), @constraint nvarchar(129)DECLARE list_ms_bidi_tables CURSOR FORselect sysusers.name+'.'+sysobjects.name fromsysobjects,sysusers where sysobjects.name like 'ms_bi%'and sysusers.uid=sysobjects.uidand sysobjects.type='u'OPEN list_ms_bidi_tablesFETCH NEXT FROM list_ms_bidi_tables INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping ms_bidi ' +@nameselect @name='drop table ' + rtrim(@name )EXEC sp_executesql @nameFETCH NEXT FROM list_ms_bidi_tables INTO @nameENDCLOSE list_ms_bidi_tablesDEALLOCATE list_ms_bidi_tablesGODeclare @name nvarchar(129)DECLARE list_rowguid_columns CURSOR FORselect sysusers.name+'.'+object_name(syscolumns.id) from syscolumns,sysobjects,sysusers where syscolumns.name like 'rowguid' andobject_Name(sysobjects.id) not like 'msmerge%'and sysobjects.id=syscolumns.idand sysusers.uid=sysobjects.uidand sysobjects.type='u' order by 1OPEN list_rowguid_columnsFETCH NEXT FROM list_rowguid_columns INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping rowguid columns ' +@nameselect @name='Alter Table ' + rtrim(@name ) + ' drop column rowguid'print @nameEXEC sp_executesql @nameFETCH NEXT FROM list_rowguid_columns INTO @nameENDCLOSE list_rowguid_columnsDEALLOCATE list_rowguid_columnsgoDeclare @name nvarchar(129)DECLARE list_views CURSOR FORselect name From sysobjects where type ='v' and status =-1073741824 andname<>'sysmergeextendedarticlesview'OPEN list_viewsFETCH NEXT FROM list_views INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping replication views ' +@nameselect @name='drop view ' + rtrim(@name )print @nameEXEC sp_executesql @nameFETCH NEXT FROM list_views INTO @nameENDCLOSE list_viewsDEALLOCATE list_viewsgoDeclare @name nvarchar(129)DECLARE list_procs CURSOR FORselect name From sysobjects where type ='p' and status = -536870912OPEN list_procsFETCH NEXT FROM list_procs INTO @nameWHILE @@FETCH_STATUS = 0BEGINPRINT 'dropping replication procedure ' +@nameselect @name='drop procedure ' + rtrim(@name )print @nameEXEC sp_executesql @nameFETCH NEXT FROM list_procs INTO @nameENDCLOSE list_procsDEALLOCATE list_procsgoif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergepublications]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergepublicationsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergesubscriptions]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergesubscriptionsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[syssubscriptions]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM syssubscriptionsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysarticleupdates]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysarticleupdatesGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[systranschemas]') and OBJECTPROPERTY(id,N'IsUserTable')= 1)DELETE FROM systranschemasGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergearticles]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergearticlesGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergeschemaarticles]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergeschemaarticlesGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergesubscriptions]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergesubscriptionsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysarticles]') and OBJECTPROPERTY(id,N'IsUserTable') =1)DELETE FROM sysarticlesGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysschemaarticles]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysschemaarticlesGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[syspublications]') and OBJECTPROPERTY(id,N'IsUserTable')= 1)DELETE FROM syspublicationsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergeschemachange]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergeschemachangeGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysmergesubsetfilters]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM sysmergesubsetfiltersGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSdynamicsnapshotjobs]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSdynamicsnapshotjobsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSdynamicsnapshotviews]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSdynamicsnapshotviewsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_altsyncpartners]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_altsyncpartnersGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_contents]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_contentsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_delete_conflicts]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_delete_conflictsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_errorlineage]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_errorlineageGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_genhistory]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_genhistoryGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_replinfo]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_replinfoGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSmerge_tombstone]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSmerge_tombstoneGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSpub_identity_range]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSpub_identity_rangeGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSrepl_identity_range]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSrepl_identity_rangeGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSreplication_subscriptions]') andOBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSreplication_subscriptionsGOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[MSsubscription_agents]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)DELETE FROM MSsubscription_agentsGOif not exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[syssubscriptions]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)create table syssubscriptions (artid int, srvid smallint, dest_dbsysname,status tinyint, sync_type tinyint, login_name sysname,subscription_typeint, distribution_jobid binary, timestamp timestamp,update_modetinyint,loopback_detection tinyint, queued_reinit bit)CREATE TABLE [dbo].[syspublications] ([description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_ASNULL ,[name] [sysname] NOT NULL ,[pubid] [int] IDENTITY (1, 1) NOT NULL ,[repl_freq] [tinyint] NOT NULL ,[status] [tinyint] NOT NULL ,[sync_method] [tinyint] NOT NULL ,[snapshot_jobid] [binary] (16) NULL ,[independent_agent] [bit] NOT NULL ,[immediate_sync] [bit] NOT NULL ,[enabled_for_internet] [bit] NOT NULL ,[allow_push] [bit] NOT NULL ,[allow_pull] [bit] NOT NULL ,[allow_anonymous] [bit] NOT NULL ,[immediate_sync_ready] [bit] NOT NULL ,[allow_sync_tran] [bit] NOT NULL ,[autogen_sync_procs] [bit] NOT NULL ,[retention] [int] NULL ,[allow_queued_tran] [bit] NOT NULL ,[snapshot_in_defaultfolder] [bit] NOT NULL ,[alt_snapshot_folder] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CI_ASNULL ,[pre_snapshot_script] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CI_ASNULL ,[post_snapshot_script] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CI_ASNULL ,[compress_snapshot] [bit] NOT NULL ,[ftp_address] [sysname] NULL ,[ftp_port] [int] NOT NULL ,[ftp_subdirectory] [nvarchar] (255) COLLATESQL_Latin1_General_CP1_CI_ASNULL ,[ftp_login] [sysname] NULL ,[ftp_password] [nvarchar] (524) COLLATE SQL_Latin1_General_CP1_CI_ASNULL ,[allow_dts] [bit] NOT NULL ,[allow_subscription_copy] [bit] NOT NULL ,[centralized_conflicts] [bit] NULL ,[conflict_retention] [int] NULL ,[conflict_policy] [int] NULL ,[queue_type] [int] NULL ,[ad_guidname] [sysname] NULL ,[backward_comp_level] [int] NOT NULL) ON [PRIMARY]GOcreate view sysextendedarticlesviewasSELECT *FROM sysarticlesUNION ALLSELECT artid, NULL, creation_script, NULL, description,dest_object,NULL, NULL, NULL, name, objid, pubid, pre_creation_cmd, status, NULL,type,NULL,schema_option, dest_ownerFROM sysschemaarticlesgoif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysarticles]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [dbo].[sysarticles]GOCREATE TABLE [dbo].[sysarticles] ([artid] [int] IDENTITY (1, 1) NOT NULL ,[columns] [varbinary] (32) NULL ,[creation_script] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_ASNULL,[del_cmd] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_ASNULL ,[dest_table] [sysname] NOT NULL ,[filter] [int] NOT NULL ,[filter_clause] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[ins_cmd] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[name] [sysname] NOT NULL ,[objid] [int] NOT NULL ,[pubid] [int] NOT NULL ,[pre_creation_cmd] [tinyint] NOT NULL ,[status] [tinyint] NOT NULL ,[sync_objid] [int] NOT NULL ,[type] [tinyint] NOT NULL ,[upd_cmd] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,[schema_option] [binary] (8) NULL ,[dest_owner] [sysname] NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOif exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[sysschemaarticles]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)drop table [dbo].[sysschemaarticles]GOCREATE TABLE [dbo].[sysschemaarticles] ([artid] [int] NOT NULL ,[creation_script] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_ASNULL,[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_ASNULL ,[dest_object] [sysname] NOT NULL ,[name] [sysname] NOT NULL ,[objid] [int] NOT NULL ,[pubid] [int] NOT NULL ,[pre_creation_cmd] [tinyint] NOT NULL ,[status] [int] NOT NULL ,[type] [tinyint] NOT NULL ,[schema_option] [binary] (8) NULL ,[dest_owner] [sysname] NULL) ON [PRIMARY]GOdeclare @dbname varchar(130)select @dbname ='sp_replicationdboption'+char(39)+db_name()+char(39)+',''merge publish'',''false'''exec (@dbname)select @dbname ='sp_replicationdboption'+char(39)+db_name()+char(39)+',''publish'',''fals e'''exec (@dbname)reconfigure with overridegoselect db_name()</code>Can any one please help me as this is a production machine and needsfixing ASAP.Regards,Ben
View 2 Replies View RelatedReporting Services :: Localization Data In Reporting Services?
Jul 27, 2015I work in a big project and we will begin in using reporting services as the base technique for reports and I will be responsible for this part. but I have a problem I will discuss in the following:
Currently: We use currently devexpress reports and we have 2 languages(Arabic and English). the data in tables saved in two ways (Arabic and English). when the end user change the language of the web site the report data language changed when run it.
Example:
we have table with (ID, NAME_AR, NAME_EN, JobTitle_AR, JobTitle_EN). designed report will display(ID, NAME_EN, JobTitle_EN) . but the end user change the language of the system the report will
dispaly(ID, NAME_AR, JobTitle_AR)Â
Hint:this done pragmatically
how to do this in reporting services.
SQL 2012 :: Set Up Web Services Locally On Machine
Apr 6, 2014I need to set up web services locally on my machine.I am working in a team. They gave project that I mapped to my local drive and take the latest version and build the solution. Some of them are configured to use IIS. So before build the solution, in the IIS manager I created the self certificate and added https binding.
I am not sure after that what I have to do? How to test my web services are running locally or not?Do I need to do anything else to set up web services locally?
SQL 2012 :: How To Deploy Web Services On Local Machine
Apr 10, 2014how to deploy web services on local machine. I created self certificate in IIS and then build the solution in the visual studio. After I build the solution, I found that automatically it created the virtual directories for the web services under the default website in the IIS Manager. When I click and select the browse it is not working.
View 9 Replies View RelatedSql Integration Services Edition And Version
Jan 29, 2008
how to find the edition and the version of microsoft integration services?
I appreciate the help.
cheers,
Ariel
X64 Version Of SharePoint Integration Services
Jun 20, 2007I see on the download page that the SharePoint Integration component only runs on x86. Are then any plans or timetable to release an x64 version? We run both the x64 version of SharePoint 2007 and SQL 2005.
This is the second SQL Server component (the first being the IIS Merge Replication agent) that has been released only for x86. What gives?
Server 2005 Express Vs Advanced SErvices Version
Sep 7, 2007
Our new version of a VB.net 2005 program uses
Install Microsoft SQL Server 2005 Express Edition
While upgrading a client over PCAnywhere in another state, I inadvertantly installed
Microsoft SQL Server 2005 Express Edition with Advanced Services
I have had an absolute nightmare with SQL 2005 uninstalling it from a laptop on my desk, so you can understand why I don't want to try uninstalling the Advanced Services version on a computer over PCAnywhere.
However, the remote computer does not have IIS on it, which prompts a warning form Microsoft SQL Server 2005 Express Edition with Advanced Services.
So, the simple question is, if the program works Microsoft SQL Server 2005 Express Edition then I assume it will work with Microsoft SQL Server 2005 Express Edition with Advanced Services, since it doesn't use any advance services.
Please advise.
Bob