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


ADVERTISEMENT

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

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

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

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 View Related

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

Reporting Service-Dynamic Connection String &&amp; Multiple Instances

Oct 1, 2007

I am facing a reporting service issue.

System information:
1. Our Reporting Server installed on a DB server.
2. We have one windows application which executes on the same server, which generates the reports snapshots.
3. One set of reports with single Shared data source

Scenario:
We have many countries for which report history snapshots needs to be generated. The report information is stored in different databases named as database_CountryCode on the same DB server.

Questions:
1. We need to dynamically change the shared data source connection string to point to the respective country database, when generating the report for that particular country. --> We found out this can be accomplised by using parameterized connection string in report specific data sources in SQL 2005. Can we achive something similar in SQL 2003 Reports as well?
2. We also need to instantiate the reporting service web service in multiple threads, one for each country, where in each thread picks up the corresponding country code, changes the connection string and generates reports snapshots. Can this be accomplished? I know this goes against the entire idea of licensing, but my question is just about feasibility of this idea.

Addnl Info
The CreateReportHistorySnapshot method of reportingservice.asmx returns a snapshotID, which is the timestamp of report snapshot creation. We tried creating the same report snapshot for the same country in 2 threads. Whenever the timestamp for both snapshots was same, only one report snapshot actually got created. Can this be overcome?

View 1 Replies View Related

Running Instances.?

Apr 30, 2007

A small question which may be stupid.



In Management Studio Express, one instance of Sql Express is running, with User Instances. This in indicated by a green circle with a white arrow head.



At the same time I'm connected to an instance of Sql Express on a Small Business Server. This server instance just has a white circle, but is also running. Is this normal.?



Tailor

View 3 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

Running SQL 6.5 And SQL 2000 As 2 Instances

Feb 9, 2001

Hi all

We are planning to upgrade vom SQL 6.5 to SQL 2000 and SMS 1.2 to SMS 2.0. We want to first migrate SMS 1.2 to 2.0 with the SQL 6.5 database. Afterwards we want to install SQL 2000 as a second instance on the sql 6.5 server and migrate from there our databases. Is this the best way to do this? Does anybody have experience with running two instances of different SQL-Versions on one server? and what kind of trouble can I expect to run into?

Any tips & tricks are welcome

Thanx
Aragorn

View 1 Replies View Related

Enum The Running SQL Instances Using DMO

Feb 12, 2008

Hello,

I want to enumerate all the RUNNING SQL instances[in a mixed env where SQL 2000 and SQL2005 are deployed] using SQL DMO.
But any of the following methods would not help

ListAvailableSQLServers Method
ListInstalledInstances Method

because they list all the installed instances and while my intent is getting only the running instances.

Is there any other direct API ? Pls advise.

Regards,
Velu

View 1 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

Multiple Sql Instances

Dec 1, 2007

i have sql server 2005 express running. during install, i had issues with a system dll that i found answers online and resolved. i am still very green, but i know much more now than i did at the time. i believe that as a result of the partial then failed installs i have multiple instances either fully or partially installed.  when i am in the sql server mgmt express environment, it lists two sql engines.  i only ever use one, and would like to safely remove the second without damaging or corrupting anything done with the other instance.
my reasons for wanting to do this are twofold. first, i would like to free up the drive space taken up by the second instance. (i am a stickler for clean harddrive mgmt and maintenance). second, now that i have used the software and am somewhat more familiar with it, i would consider installing a second, intentional instance so that i may attempt to better customize some of the install-time settings and configurations.
can anybody give me any pointers/ guide me in the direction of information on how to SAFELY go about this?
thank you in advance for any help.

View 5 Replies View Related

Multiple Instances

Mar 6, 2003

I created a second SQL2000 instance on a Windows 2000 server. The strange thing is that I can create an ODBC connection to the default instance but cannot for the new named instance. If I try from a client that has SQL installed on it, I can see both instances. Any idea why this is happening?

Thanks,
Ken Nicholson

View 3 Replies View Related

Multiple Instances On A VM

Jun 9, 2014

We're trying to decide if we should use a single large instance of SQL Server or multiple instances on the same server. This is for a dev environment.Have to limit max RAM per instance so no instance grabs it all.There will be I/O contention and CPU contention between instances since the different instances won't coordinate with each other.It limits the available RAM for In-Memory tables..It sets lower limits to the amount of RAM available for any given query, causing artificial "contention" even when there's nothing else running at the time.

View 2 Replies View Related

Multiple Instances Of SQL

Mar 26, 2007

According to the Task Manager, on my SBS 2003 Server, I'm running multiple instances of SQL. How do I determine which instance(s) are required to maintain server stability, and which are not. My Server resource use continues to be a perennial problem. Please advise.

View 3 Replies View Related

Multiple Instances, One DB

Nov 9, 2007

SQL Server 2005 Enterprise


Is it possible to have multiple instances attach the same database?

I have a scenario where I want to have on one node, a clustered instance and a non clustered instance and both instances attach the same singular DB on a filer.

Is this possible?

View 1 Replies View Related

SSL With Multiple Instances

Dec 11, 2006

Can SQL Server be setup such that one instance on a server is using SSL and another instance is not? Or is SSL a server-wide all-or-nothing issue?




Dave

View 5 Replies View Related

Multiple Instances

Apr 6, 2006

Does SQL Server express support running multiple instances of database ?

View 1 Replies View Related

Multiple SQL2000 Instances

Dec 6, 2001

If I want to install 2 instances of SQL2000, will it install the SQL2K executable files (inn folder) onto 2 different folders, or all instances in one folder but the databases are in different folders.

Thanks

View 1 Replies View Related

SQL Server2000 Multiple Instances

Mar 2, 2001

Please Help me on this.
I installed the two instances SQL on one box. ONe is default instance called ACSQL1(actually machine name) and the other one is called ACSQL1/DEVELOPMENT. THrought the my client site of SQL 2000 I can access both instances. When I try to get connection from VB. I can access the default instance but I can not access the second instance. Any ideas about this???
Qun Lu

View 2 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

Creating Multiple Instances

Feb 18, 2004

Currently, I am running SQL Server 2000 with the default instance. I know SQL2K can run up to 16 instances simultaneously. I would like to add another instance but am unable to find documentation on how to add it. Books online tells me "about" multiple instances, but not how to set it up. I've obviously missed something somewhere. Can someone please direct me to a document that will help explain "how" to add another instance?

Thanks for your time and your help.

View 3 Replies View Related

Multiple Instances Of Sql On A Cluster

May 7, 2008

I have a need to add a second Sql instance to an existing cluster. However I read in this article http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx

that this is not recommended. Does anyone know why this is or what problems I may encounter?


Its is running Sql 2005 on a 64 bit windows Server 2003.

View 2 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 2005 Multiple Instances 2.8 GB RAM

Dec 12, 2007

Has anyone run SQL 2005 Standard Edition, 2 or more instances on one server... where you got the extended memory up to 2.8 GB on EACH instance of SQL Server? I've done the 2.8GB game on boxes with ONE instance, but don't think I tried it on a multi-instance box, to get the 2.8GB RAM each. Thanks, Bruce

View 2 Replies View Related

Multiple Sql Instances In A Cluster

May 7, 2008

I have a need to add a second Sql instance to an existing cluster. However I read in this article http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx

that this is not recommended. Does anyone know why this is or what problems I may encounter?


Its is running Sql 2005 on a 64 bit windows Server 2003.

View 18 Replies View Related

Using One Single-application Connection Vs. One Connection For Every Operation To SQL-Server Via ADO.NET

Aug 11, 2005

Dear members,I'am thinking about the "best" way to connect to my sql-server viaADO.Net (if there is a best way).My application uses the sql-server very intensively. At the momentevery database-operation opens a connection, executes and then closesthe connection.Another way would be to use only a single connection to the database,which is opened when the application starts.What do you think is the better way to get a high performing sqlserver: using one single application connection vs. using oneconnection for every operation?Cheers, Sebastian

View 2 Replies View Related

Upgrading Multiple Msde Instances

Nov 4, 2005

Himy first post in the data access forums, I really hope, someone can enlighten me here...I have a windows server 2003 running with 15 MSDE instances. No I would like to upgrade to SQL Server 2000 without crashing the existing instances... My perfect scenario woudl be- install sql server as new instance- move existing databases via detach / attach to the new instanceWill that work?

View 2 Replies View Related

Sql 2000 Enterprise And Sql 7- Multiple Instances

Jan 5, 2001

I need to put sql server 2000 enterprise and sql server 7 on the same box. For multiple instancing is it better to run with Win 2k Pro Server or Advanced Server. Please Elaborate.

Thanks in advance

Gunnar

View 1 Replies View Related

Multiple Instances Is It Safe And Secure ?

Feb 6, 2002

Hi everybody.
One of department want to place db application from one server somewhere else on corparation network for 3 month period.
Problem is they want to keep it with max security.
Company does not want set up another server , so we want to create another
Instance and place database on it.
1. Is safe to keep 2 instances on same server ?
2. How remove access to this instance from members of local and domain admin role(If we deny acces to BuildInAdministrators how it is going to affect security?)
Thank you

View 1 Replies View Related







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