Can You Have Multiple RS2005 Instances Running On Server 2003?

May 9, 2006

I have a website running under Windows Server 2003 which I am trying to deploy Reportin Services to using a custom security extension using Forms authentication. There is also another website which is just a Report Server running on this IIS 6.

On my development machine, XP with IIS 5.1, the Website with Reporting Services using forms authentication works fine, shares cookies for authentication and all that jazz. but trying to configure a second instance of Reporting Services on Server 2003 is not behaving.

Is there some trickery or details involved with running two instances of Reporting Services?

Also in the Configure Report Server tool it is failing and so not initializing on the last step of the Database Setup

Setting Connection Info for Reporting Server


ReportServicesConfigUI.WMIProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.

---> System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
--- End of inner exception stack trace ---
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)

View 1 Replies


ADVERTISEMENT

SQL Server Admin 2014 :: Running Multiple Instances On 2 Nodes

Apr 12, 2015

I'm looking at installing 2008R2 and 2014 side by side, then using Mirroring to provide HA for the 2008R2 instance and AoHA for the 2014 instance. I'd be using the same two physical servers for both the Mirroring pair and the AoHA pair.

View 2 Replies View Related

Installing / Running Multiple Instances Of SQL Server Express 2005

Jan 3, 2008

My client has a server running MS 2003 Server for Smal Business Server, and it has SQL Server Express 2005 installed (I believe it is installed 3 times, as part of SharePoint, Veritas Backup Exec and ACT! applications).

I am trying to implement an application that uses SQL Server 2000, but the Server 2003 SBS does not support that version. So I need to launch an additional instance of SQL Server Exp 2005.

To do so, do I need to download and install SQL Server Express 2005 software again? Or can I just run SQLSVR.exe from an existing instance, but with a different instance name (sqlservr.exe -s<InstanceName>?

The reason I need another instance is that these existing instances limit DDL statements.

I am new to this and compare it to launching MS Word multiple times - you don't need to reinstall Word to run it multiple times.

Is launching from the command line a bad idea - and if it is, what is the better way to ensure that it launches under the local system context a service?

Thanks in advance for any help and insights. It is much appreciated.

View 9 Replies View Related

Multiple Instances Of Job Running

Jun 20, 2002

We have a DTS package that is submitted every minute by a SQL Agent job (2000). We see instances where before the first job is completed, the second one starts running.

Has anyone encountered this type of behavior before?

View 3 Replies View Related

Running Multiple Instances Of The Same Package In Parallel

Feb 13, 2006

In my application code I am trying to invoke multiple threads in which each thread is loading an instance of the same SSIS package and would initialize the package variables with different values and execute the different instances in parallel. In each thread - after the package execution has completed successfully - I read that instance's SSIS package variables to get result information from that Instance run.

When I load the same package in different thread using LoadFromSqlServer() method
- does the code create multiple instances of the SSIS package and load the distinct instances in each of the thread
- Will the Package Execution ID be different for the different instances?
- Are the package level variables instance safe?

View 2 Replies View Related

Connection Issues When Running Multiple Instances Of Same Application

Sep 19, 2007

I am running multiple instance of the same application. This application is connecting to the database and running stored procedures using ADODB (all code examples are taken from msado15).

The problem is that somehow these two applications are sharing something either with the connection or commands.

For instance if the two instances are in the following function at the same time then they both thow an SEH exception:




Code Snippet
inline _RecordsetPtr Command15::Execute ( VARIANT * RecordsAffected, VARIANT * Parameters, long Options ) {


struct _Recordset * _result = 0;
HRESULT _hr = raw_Execute(RecordsAffected, Parameters, Options, &_result);
if (FAILED(_hr)) _com_issue_errorex(_hr, this, __uuidof(this));
return _RecordsetPtr(_result, false);
}






The exception that occurs is: "First-chance exception ...: 0xC0000005: Access violation reading location 0x00000068."

And afterwords when they go to release the command an error occurs on
First-chance exception at 0x4de4120c in IpsEngine.exe: 0xC0000005: Access violation reading location 0xcccccccc.



Code Snippet

inline void _bstr_t::Data_t::_Free() throw()
{

if (m_wstr != NULL) {
::SysFreeString(m_wstr);
}
if (m_str != NULL) {

delete [] m_str;
}
}





This is being called from.



Code Snippet

inline void Command15::PutRefActiveConnection ( struct _Connection * ppvObject ) {

HRESULT _hr = putref_ActiveConnection(ppvObject);
if (FAILED(_hr)) _com_issue_errorex(_hr, this, __uuidof(this));
}





The exception that occurs: First-chance exception at ...: 0xC0000005: Access violation reading location 0xcccccccc.

Similarly when one instance releases a command using





Code Snippet
inline void Command15::PutRefActiveConnection ( struct _Connection * ppvObject ) {


HRESULT _hr = putref_ActiveConnection(ppvObject);
if (FAILED(_hr)) _com_issue_errorex(_hr, this, __uuidof(this));
}







The second instance of the application fails when running the command at the exact same time.



Code Snippet

inline _RecordsetPtr Command15::Execute ( VARIANT * RecordsAffected, VARIANT * Parameters, long Options ) {


struct _Recordset * _result = 0;
HRESULT _hr = raw_Execute(RecordsAffected, Parameters, Options, &_result);
if (FAILED(_hr)) _com_issue_errorex(_hr, this, __uuidof(this));
return _RecordsetPtr(_result, false);
}







The command and connections are not static and there should be completely seperate instances of these for each instance of the application. Does anybody know why this may be happening. Any help would be appreciated. Thanks in advance.

View 2 Replies View Related

SQL Server 2000 + 2005 Working On Same Windows 2003 Server As Seperate Instances

Nov 20, 2006

Hi all,I just asked some people to help me out and phone microsoft with thefollowing information, kindly they refused unless we setup a supportcontract with them first, for pre-sales information. (That really doesnot sound like good business sense to me - anyway here is our problem,if anyone could help thanks)."To tell and ask microsoft:We will be setting up a microsoft sql server 2000 instance running on awindows 2003 server.1) We need to check this can run alongside a microsoft 2003 sql server(either workgroup or standard edition), on the same machine. Are thereany .dll clashes if we do this? If there are can we run SQL Server2000, in a virtual machine running windows 2000 professional. (I have alicenced copy we can use for this).2) If we run one instance of 2000, and one of 2003 of the sql servers,can one use the processor licence model, and one use the CAL licencemodel."Thanks for any help, and any idea why they actually force you to usenews groups for pre-sales information?David

View 4 Replies View Related

Multiple Customers (with Multiple Sql Instances) On 1 Reporting Server

Dec 3, 2007



Hi,

I think this is a question for the specialists among us.

Can I use one general reporting server (installed on instance MAINREPORTING)
for multiple customers who all have their own sql instance (CUST1, CUST2, CUST3, ..)
I would use UserAuthenciation on the reportserver url to display the specific reports customers can use.


Is this possible, and what do i have to take care off concerning installation and/or configuration (especially on
the reporting side) ?

Greetings
Vinnie

View 3 Replies View Related

List Of SQL Server 7.0/2000 Instances Running

Jun 28, 2004

How to get the list of instance of SQL Server 7.0/2000 running on the local machine inside my domain...
I need to prepare the list of all sql instances.. pls help if possible to find details using sql query.

View 1 Replies View Related

DB Engine :: How To Check Names Of Running Instances Without Connecting To Server

Jul 3, 2015

When i have multiple sql server instances running on one server, how to check the names of that instances with out connecting to sql server management studio.

View 12 Replies View Related

Sql 2000 32 Bit Running On 64 Bit 2003 Server With AWE Set!!!

May 23, 2008


I€™m having a few issues with a server that keeps grinding to a halt and having frequent system issues requiring a reboor. It is Sql 2000 32 bit enterprise edition running 64 bit 2003 server. Im not sure of the impact of having the AWE switch set for this server because even though it has 8Gb of RAM it is only using 262Mb and is used extensively. It is set to dynamically configure sql server memory with a minuimum memory of 3075 and maximum of 6144

Is it worth me removing the AWE option or are there any more tweaks I can make to make this system run more effectively?

View 18 Replies View Related

Multiple Instances Of SQL Server 7 & 2K

May 22, 2001

I am running SQL 7.0 as the default instance and SQL 2K as a named instance. Each is using a different port....7.0 is using port 1433 and 2K is using 1024. Everything appears to be up and running fine on the server. However, I am not able to access the 2K instance from a client. I have tried to use both TCP IP and named pipes setting them up using the server network utility and the client network utility. No luck anywhere. I continue to get connection errors...check network documentation...

ANY IDEAS??????

View 3 Replies View Related

SQL Server Multiple Instances

May 8, 2008

Is there any limit on SQL server Multiple Instances? if we require to run 60+ Instances on single machine what will be the minimum hardware requirements.

View 3 Replies View Related

SQL Server Express 2005 Running On Windows 2003 Sp2?

Mar 27, 2007



Is this supported on Windows 2003 sp2 and does anyone know how to do a silent install of this using Altiris?



Thanks!

View 1 Replies View Related

Send Mail From SQL Server 2000 Running On Small Business Server 2003

Nov 5, 2007

I'm trying to configure SQL server 2000 (standard edition) to send e-mail on a Small Business Server 2003. There's a great article on how to do this on a SBS 2000 server (KB304967), but it does not apply to SBS 2003. Can anyone point me to a article or white paper on how to configure SQL on a SBS 2003 server to send e-mail. Thanks.

David Neahusan

View 1 Replies View Related

Server 2003 Running Sql Server 2005. Regional Settings Are Different From All Others We Have; Can We Safely Change It?

Oct 18, 2007

Hi
We have a bunch of servers running server 2000 & 2003 along with many sql server (versions 2000 & 2005) databases in a production environment pulling transactions then doing warehousing & reporting.

An audit has shown up 1 production server using English_US 'mmddyyyy' system date formats, all others being English_Australian 'ddmmyyyy'.

Is it safe to simply change the regional settings on this English_US server to English_Australian or will it mess up the data in our SQL 2005 databases? I've not been able to get a definitive answer from anyone yet!

many thanks in advance; GaryP

View 1 Replies View Related

SQL Server 2005 Stored Procedures Running On Server 2003 Machines

Jan 20, 2006

Stupid question but please be gentle and answer anyway please....

Background: We have SQL Server 2003 (32bit) running on our servers. Our .Net applications (from old release of VS) are still running on them and using the old databases. From what I understand there is no immediate plans to upgrade the servers. However the developers were just given this new upgrade (2005) SQL Server and VS (and fixing depreciated code etc in the .net apps).

Question: Can the applications and new stored procedures written via the 2005 environment be deployed successfully on the 2003 Servers? Same goes with Reporting Services?

View 1 Replies View Related

Install AS On Multiple SQL Server Instances?

May 12, 2002

Dear Listers,

1.) Is it possible to install Analysis Services on multiple SQL Server 2000 instances? If it is, then can you instruct me as to how to perform the install. If it is not possible, then does one restrict access to cube data via the Database Role Manager?

ie. The host box is - DOILAB30 with Analysis Services & SP2
Instance - DOILAB30/DOILAB30_FIN (Can AS be installed here?)

Do I severely restrict the membership of OLAP Admins?

2). Re. AS maintenance. - How do I backup and restore OLAP dbs/cubes etc. Following a restore, what issues, such as cube users/permissions should I be aware of? (if any).

TIA

John

View 1 Replies View Related

RDA Access To Multiple SQL Server Instances

May 31, 2007

Hello,



There are several instances in SQL Server. I use RDA method to access SQL Server from mobile devices. But RDA method only gets the server IP,not the instance name. So, how can I define RDA to access to the instance that I need?

View 3 Replies View Related

Multiple Reporting Instances On One Server

Dec 17, 2007



Hello all,

I am trying to built a general demo machine for our multiple resellers.

Is it possible to have multiple database instances (one per reseller) with each of them their own reporting instance, running on the same server (also same IIS). In our DNS and in the IIS settings i will reroute the specific reseller to his specific reporting url (eg: http://www.demosite.reseller1.com/reports (this is not a real url), will be rerouted via dns to the
specific reporting url for reseller one ... and so on.)

Each reseller must be able to has it own reports, subscriptions, models and access to reportbuilder.

Can this be accomplished ?

I have tried already a few times but get stuck when i want to upload reports/datasources to the specific websites. Also i have encountered the fact that if i succeed in uploading data to one reporting site and i want to upload different data to
another site, the initial site is also changed with the data of the second upload.

Can anyone point me into the right direction how to solve this problem .

Greetings
Vinnie

View 7 Replies View Related

Secruity Question, Putting SQL Server 2000 Or 2005 On Windows Server 2003 Running A Website

Jan 31, 2006

Where can I further educate myself on this subject?

Right off from the start I would assume that installing SQL Server 2000 or 2005 on Windows Server 2003 that is set up as a web server hosting a website would be against "best practices." Is my assumption right?

Common sense tells me to not to host a website on a pc that is also hosting my database.

View 4 Replies View Related

Can You Mirror To Multiple Instances On Same Server Via One Endpoint?

Oct 29, 2007



Hi all,

Can a MIRROR server have mirrored databases on many instances or must all of the mirrored databases on a server reside on one instance?

This initial implementation worked fine:

PRINCIPAL ServerPROD1instance01 endpoint1430
MIRROR ServerDRinstance01 endpoint1440
WITNESS ServerZ endpoint1450


This second implementation (different PRINCIPAL server to same MIRROR but to a different instance)

PRINCIPAL ServerPROD2instance5 endpoint1430
MIRROR ServerDRinstance02 endpoint1440 <<same mirror server but different instance
WITNESS ServerZ endpoint1450


I know that you can only install one endpoint on each server. Does that mean that the endpoint can only resolve to one instance though?

The second implementation looks fine until the final step (start mirroring). I get the following error:


An error occured while starting mirroring
Alter failed for database 'test'
An exception occurred while executing transaction-sql statement or batch
The remote copy of database 'test' does not exist. Check the database name and resissue the command

I have created the test database in instance02 and rolled a log onto it. It is currently in recovery mode - waiting patiently for another log.....

I have read books online and 2k5 unleashed but can't see anything that relates to an implementation across mutliple instances on the DRmirrored servers.

Has anyone tried to do this? Can you confirm its possible?

Many thanks in advance...

View 3 Replies View Related

Recovery :: Multiple Instances Of Server On A Cluster

Aug 18, 2015

Is it possible to have more than one instance of SQL Server on a failover Active/Passive cluster? What are the concerns/ramifications if that indeed is possible?

View 4 Replies View Related

Merging Multiple Report Server Instances Into One

Sep 18, 2007

Greetings... I'm working at consolidating several Reporting Services installations into one so we can decommission some old servers. We have two Report Servers that are in SQL Server 2000 and three that are in SQL Server 2005 (none are in a web farm configuration). I can upgrade the 2000 databases to 2005 format just fine, but now how do I merge these five ReportServer/ReportServerTempDB databases into one? I'm reluctant to redeploy reports to the "official" Report Server because we lose security, subscription, and scheduling information by doing that. So redeploy would cost us time and data loss over hundreds of reports, thus my hope to merge the databases at a data level. Is there a tool to automate this process, or has anyone tried this before? Thanks in advance.

Austin

View 8 Replies View Related

SQL 2012 :: Mirroring Endpoint Multiple Instances On Same Server

Jun 18, 2014

I was told that if I wanted to setup mirroring between multiple instance on the same server that each endpoint had to be different number. Is that true? Or can I use the default 5022 for each instance?

Ex.

Server1Instance1
Use endpoint 5022

Server1Instance2
Use endpoint 5022

VS

Server1Instance1
Use endpoint 5022

Server1Instance2
Use endpoint 5023

View 4 Replies View Related

SQL 2012 :: How To Run Transaction Across Multiple Instances Without Linked Server

May 18, 2015

i want to run a transaction across mulitpule instences of sqlserver with out linked server.

distributed trnasaction can do it with link server , can it do it with out linked server.

View 9 Replies View Related

Distributed Transactions With Multiple Instances Of Microsoft SQL Server

Jul 23, 2005

Hi,I'm having a problem running a distributed transaction between twolinked servers that both have multiple instances of SQL Serverinstalled on them. This is the error message that I receive:"The operation could not be performed because the OLE DB provider'SQLOLEDB' was unable to begin a distributed transaction.[OLE/DB provider returned message: New transaction cannot enlist in thespecified transaction coordinator. ]OLE DB error trace [OLE/DB Provider 'SQLOLEDB'ITransactionJoin::JoinTransaction returned 0x8004d00a]."The query follows the format:"BEGIN DISTRIBUTED TRANUPDATE [LINKEDSERVER1INSTANCE_NAME].DB.OWNER.TABLENAMESET fieldname = alias2.fieldnameFROM tablename alias2JOIN [LINKEDSERVER1INSTANCE_NAME].DB.OWNER.TABLENAME alias1on alias2.urn=alias1,urn"[color=blue]>From what I can gather from various sources the SQL Server must be[/color]named the same as the computer which it is installed on. However, if Ihave two instances of SQL Server, they cannot both be named the same asthe computer. Does anyone know of a way around this or whether I'mbarking up the wrong tree completely?Many thanks.

View 2 Replies View Related

SQL Server Configuration Manager: SSL And Multiple Instances Problem

Mar 31, 2008

Hi

We are trying to setup a number of SQL Server 2005 database instances on a single server. The server has multiple IP addresses bound to its network interface (card). Each instance is configured to listen on a specific (unique) port on 127.0.0.1 and port 1433 on a specific (unique) IP address configured on the network interface. Finally, there is another instance of SQL Server (which also has the Reporting Services, Analysis Services and Integration Services installed) that does not allow remote connections and has TCP/IP disabled.

SSL is configured for all instances, apart from the non-remote connections instance, as follows: The same self-signed certificate is specified for every instance. This certificate has been configured for all 127.0.0.1 ports and port 1433 on all IPs in use for any of the instances using httpcfg as documented. The Force Encryption option is enabled and the Hide Instance option is disabled.

All appears to work correctly, and the "The certificate was successfully loaded for encryption" message appears when sp_readerrorlog is run, for the instances it is supposed to. However, at some point a problem occurs. The Force Encryption and Hide Instance labels _disappear_ (leaving blank spaces in the grid) from the interface, with the drop-down settings still visible. This seems to happen after installing an additional instance, although on one occasion it was after the 3rd was installed and on another occasion the 4th. Uninstalling the instances (even all of them) does not seem to help - only removing SQL Server 2005 completely and re-installing allowed the labels to re-appear.

Another concern is that after problem occurs, it appears that the settings are not being interpreted correctly. Even if the certificate is disabled for an instance, the message "The certificate was successfully loaded for encryption" appears, instead of the instance using a self-signed certificate. Additionally, on some occasions, the values for the Force Encryption and Hide Instance are swapped (or at least the values in the positions that used to be inline with the labels for these options).

As an additional note, various IIS Web Sites are configured on each of the IPs on the network interface. These are also using the same self-signed certification for SSL and are all using port 443, which none of the SQL server instances are configured to use.

Any feedback or suggestions on this would be appreciated. Thanks.

View 1 Replies View Related

Replication :: Multiple Instances On Same Instance Of Server 2012 SE

Jul 13, 2015

I am currently having publisher(database A), subscriber (database B) and distributor on the same instance for a test environment that is using a uni directional transactional replication. Now I need to setup another unidirectional transactional replication in the same test instance but for a different database. Publisher database is D and subcsirber database is E.

View 4 Replies View Related

Sharing Hard Disk On Multiple SQL Server Instances

Jan 31, 2008



I have a situation where I would like to set up one DB server instance for US and anther one for AUStralia. The Instance should share the same data base/hardsisk. One of the instances will be running in using US time zone and anothe one in Australia time zone.
There will be 2 Application instaces one poinint to each SQL Server instance. This applications does write into the database

So the underlying requirment is to have 2 database server running in differnet time zones but accessing the same disk/set of data
What is the best way to do this? Is it linked servers?Girish

View 3 Replies View Related

Installing Multiple Instances Of ASP.NET Application Services On ONE SQL Server Database

Aug 3, 2006

Hi,
I am trying to install multiple application services on 1 sql server database. Is this possible? I do not know how to install anything but the default application services settings for the membership, roles, etc.
 
Please help if you can.
 
Thanks,
Ezeibe

View 1 Replies View Related

SQL Server Admin 2014 :: Multiple SSRS Instances On Same Server

Jun 23, 2015

I am playing around in a test environment with SQL Server 2014. I have a question about the default location of the report server databases when you have multiple report server instances installed on one server.

I did a very simple install of SQL Server 2014 with the database and Reporting Services in Native Mode (install only) features selected. Accepting the default locations, I ended up with the following locations as you would expect:

C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVER
C:Program FilesMicrosoft SQL ServerMSRS12.MSSQLSERVER

Running the Reporting Services Configuration Manager, I created the Report Server database. After creating the Report Server database, the related files will be located below in the SQL folder as I would expect.

C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATA

Next I installed another instance, which I called Test, of SQL Server 2014 like I did above. I now have the following folder structure the Test instance as I expect.

C:Program FilesMicrosoft SQL ServerMSSQL12.TEST
C:Program FilesMicrosoft SQL ServerMSRS12.TEST

Running the Reporting Services Configuration Manager, I select the Test instance and create the Report Server Test instance database.

My first thought would be that the Test instance Report Server database would be in the following location:

C:Program FilesMicrosoft SQL ServerMSSQL12.TESTMSSQLDATA

Instead this database is located with the default instance Report Server database:

C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATA

View 2 Replies View Related

SQL Server 2012 :: Query To Find Distinct Multiple Instances Of A Pattern In A String?

Apr 30, 2015

One of my varchar columns in a table has multiple key words enclosed in a pattern of special characters.

Eg: William Shakespeare was an English [##poet##], [##playwright##], and [##actor##], widely regarded as the greatest [##writer##] in the English language and the world's pre-eminent [##dramatist##]. He is often called England's national [##poet##] and the "Bard of Avon". His extant works, including some collaborations, consist of about 38 plays, 154 [##sonnets##], two long narrative [##poems##], and a few other [##verses##], of which the authorship of some is uncertain. His plays have been translated into every major living language and are performed more often than those of any other [##playwright##].

I need to write to query to find all distinct key words that are enclosed within [## and ##]. My query should yield the following results from the string in the example above

[##actor##]
[##dramatist##]
[##playwright##] -- 2 occurrances, but I need it only once in my result set
[##poems##]
[##poet##] -- 2 occurrances, but I need it only once in my result set
[##sonnets##]
[##verses##]
[##writer##]

I need to run this on a large table, so I am looking for the best possible way to minimize any performance issues.

Just give you sample code, I have provided below 2 separate snippets, one with table variable and another with temp table.

DECLARE @MyTable TABLE (MyString VARCHAR (8000))
INSERT @MyTable VALUES ('William Shakespeare was an English [##poet##], [##playwright##], and [##actor##], widely regarded as the greatest [##writer##] in the English language and the world''s pre-eminent [##dramatist##]. He is often called England''s national [##poet##] and the "Bard of Avon". His extant works, including some collaborations, consist of about 38 plays, 154 [##sonnets##], two long narrative [##poems##], and a few other [##verses##], of which the authorship of some is uncertain.

[code].....

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved