Error On Link Servere

Jul 23, 2005

HI,
I am getting below error on link server. And the performance between
link server is really pathatic.

Executed as user: NT AUTHORITYSYSTEM. OLE DB provider 'SQLOLEDB'
reported an error. Execution terminated by the provider because a
resource limit was reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE
01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ICommandText::Execute returned 0x80040e31: Execution terminated by the
provider because a resource limit was reached.]. [SQLSTATE 01000]
(Error 7300).

View 1 Replies


ADVERTISEMENT

Download The SQL Servere Date To Excel File Using ASP.net

Feb 13, 2007

Hi EveryOne
I would like to download the SQL server databse to excel file using ASP.Net
I need to download the one table to excel file. If anyone knows please help me.
With Regards
 
Nibu Abraham 
 

View 3 Replies View Related

Need Help - Database Has Been Moved To SQL Server 2000 From SQL Servere 6.5

May 20, 2005

Hi there,
    I am not sure if this is the right place to seek help for the problem i have but as i don't see any other link to discuss the situation i have i am just posting it here.  To explain a little bit about the project i am on..... Originally the  appication(developed in asp.net and vb) i am assigned to was developed by a different team and most of the databases  were on  SQL server 6.5 servers. So they have used oledb connections where ever they had to connect SQL server 6.5 data sources. Lately the client has moved all of the sql server 6.5 data bases to SQL server 2000 and now the application is kinda not working as it is suppose to as it was before. So i am hired to fix the problem.
So as a first step what i am doing is finding out all of the .net oledb proivder part of the database connections code to SQL server 6.5 data sources and changing them to .NET provider for SQL server.
Say for example in the below GetConnection function i am commenting out OledbConnection and defining a SqlConnection instead.
Private Function GetConnection() As IDbConnection
'Dim conn As IDbConnection = New System.Data.OleDb.OleDbConnection
Dim conn As IDbConnection = New System.Data.SqlClient.SqlConnection
conn.ConnectionString = Helpers.DBHelpers.GetConnectionString(Helpers.DBHelpers.COMMON)
Return conn
End Function
and also commenting out OledbDataAdapter line of code and defining a SqlDataAdapter instead. You can see it below
'Dim adapter As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(CType(cmd, OleDb.OleDbCommand))
Dim adapter As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter(CType(cmd, SqlClient.SqlCommand))
And connection strings are defined in web.config file and also i am changing those as well . See below.
 
<!--<add key="Common" value="User ID=Test;pwd=*****;Data Source=ESMALLDB2K;Initial Catalog=cj_common;Auto Translate=True;Persist Security Info=False;Provider=&quot;SQLOLEDB.1&quot;;" />-->
<add key="Common" value="User ID=Test;pwd=*****;Data Source=ESMALLDB2K;Initial Catalog=cj_common;" />
So i hope i am in the right direction as far as the first step. But please throw in any kind of suggestions on this.
 
One more thing. I have a search screen and T-sql query thats built for this purpose searches 4,5 tables and brings the data back.
When i make a search from the web browser it doesn't return the data for the first couple of times but it brings the data 3rd time but even its taking as long as 60 seconds to bring the data back.  when i close the browser and debug and paste the SQL query in the query analyzer it returns the data in the query analyzer and when i complete the remaining part of debugging and bind the data to the gird i also see the data on the broswer for the first time itself.
Question : Why i don't get the data for the first time when i search it from the front(web browser)?
But like i said the executing time to the query in the query analyzer itself takes considerably long time( i would say around 60 seconds just to return 3,4 records)) in the query analyzer. When i talked to the database guys why sql queries are a little slow they say they have a lot of datat out there around 180 thousand records in it and thats why its taking that much time to search agains all of the rows.
Question - Do you think it could be some thing to do with dropping and recreating the indexes should solve our problem? May be its some thing to do with the indexes but i am sure they have not dropped out the indexes of all of the table objects and recreated yet after the databases are moved to SQL servere 2000.
Hope i am able to explaing what i am looking for and what i am doing.
Please help me understand in solving these problems. Thanks in advance
-D

View 1 Replies View Related

Access2003 Cannot Link (but Excel2003 Can Link) To Tables In Access97 Database

Feb 20, 2008

I have created an Access2003 project (existing data) that links to external data. First I connected to a SQL Server 2000 database. Success. Then I tried to set up a Transact SQL data connection to a legacy MDW-secured Access97 database. (A third-party VB6 application goes against it, and we don't have the source code, so we cannot upgrade it.)

The Transact SQL link tests OK but I cannot select any of the tables or queries from the list presented. However, with the same credentials, I can use these same objects in Excel 2003.

When setting up the link in Access2003, I specify JET 4.0 OLE DB Provider, I enter the MDW file on the All tab, a username and a password on the Connection tab where I browse to the MDB file, and specify Shared Deny None on the Advanced tab. When I test the connection, it tests OK ("Test connection succeeded"). Yet on the "Select the Database and Table/Cube which contains the data you want" dialog, "(Default)" appears in the grayed-out dropdown. Then, beneath that dropdown, there is a grid with Name and Description columns. The grid contains query names but the grid is not enabled. The list of queries is this table is grayed out. Neither of the scrollbars works.

BUT... if I use the SAME username and password in Excel2003, and specify the same MDW, there is no problem working with these same database objects in the legacy Access97 database. WHAT IS DIFFERENT ABOUT THE WIZARD IN EXCEL THAT ALLOWS IT TO SUCCEED AND THE WIZARD IN ACCESS THAT CAUSES IT TO FAIL HERE? In Excel, the list of available providers says Microsoft Access Driver, not JET 4.0 OLE DB Provider.

Thanks
TR

View 1 Replies View Related

Cannot Link To SQL Tables Using ODBC Link Table In Access 2003

Feb 3, 2006

When trying to link to an SQL table in Access 2003, the software appears to be malfunctioning. 

The sequence of events is File - Get External Data - Link Tables - Files of Type: ODBC Databases().

The Problem: On two of my computers, the select data source window does not pop up, preventing me from linking to any ODBC data source. 

Observations:  This function has worked normally in the recent past and works on other computers running Access 2003.  One difference between the computers working and non-working computers is Norton Antivirus 2006 (recent upgrade).

Has anyone experienced anything like this?  What's going on?

View 8 Replies View Related

Link Server Error: Login Failed For User 'Domainuser'. (Microsoft SQL Server, Error: 18456)

Oct 18, 2007


Hi,

I am trying to create a linked server between 2 SQL Server 2005 boxes.
When I create the linked server I specify a login for the connection.
The strange part is that I get the following error when it goes to test the connection:

The test connection to the linked server failed
Login failed for user 'Domainuser'. (Microsoft SQL Server, Error: 18456)


I can use the SQL mangement studio to conenct to the database using this same login.
The login has all the server roles assigned to it also.

Can anyone shed some light as to what may be the problem?


Thanks,

View 5 Replies View Related

Communication Link Failure Error

Jun 14, 2007

Hi Y'all,
 When i alter 1 single value in my sql server 2000 sometimes i get following error:
1) [MICROSOFT][ODBC SQL SERVER DRIVER] Communication link failure
After clicking away:
2)CANNOT START MORE TRANSACTION ON THIS SESSION
Maybe someone can help me out on this?
Thanks!

View 1 Replies View Related

Microsoft Data Link Error

Nov 27, 2006

A test installation script I ran on my dev rig seems to have broken the OLE DB Provider for Sql Server. The uninstall must have deleted a DLL or unregistered a lib. When I try to connect to a SQL database from this machine now get the following error:

==

Microsoft Data Link Error

Test connection failed because of an error in initializing provider. Unspecified error.

==

It is not the connection string because this was working fine prior to me running the test installation script.

Can you give advice on how to repair the SQL Server data provider for WinXP SP2?

I have tried to re-install MDAC 2.8 with no success due SP2 diallowing this. I uninstalled SP2 and re-installed MDAC 2.8 but the problem remains.

I'm all out of ideas, so any help would be appreciated.

Thanks!



View 2 Replies View Related

Communication Link Failure Error

Oct 12, 2006

Hi,

I am using ADO in my application to connect and retrieve data from Microsoft SQL Server 2000 SP4. When I start my application, it establishes connection to the server successfully and I am able to retrieve data from the server. here is my test scenario:

1. unplug the network cable from the client machine and put the cable back in after some time. I disconnect from the database in my code when the client machine disconnects from the network

2. Once the client machine comes back on the network, I try to reconnect and retrieve data from the sql server but I get the following error message when I try to execute a sql command:

[Microsoft][ODBC SQL Server Driver]Communication Link failure

This problem occurs only with Window XP SP2. With XP SP1 it works fine. It seems to be problem on the client side as with Windows XP SP1 I do not get this error message at all.

Here are the various details:

1. The firewall is off on the client workstation.

2. the connection string is:

driver={SQL Server};server=AA;uid=BB;pwd=CC;database=DD

where AA = DNS name of server machine where sql server is running.

BB = user name

CC = password

DD= database name

3. The client is remote to the server.

4. I can ping the server machine when the client machine reconnects to the network.

5. I can still telnet the server when the client machine reconnects to the network.

6. client database provider is MDAC odbc.

7. the client and server machines are in the same domain.

8. Shared memory and TCPIP protocols are enabled and TCP is at the top of the list.

9. No alias is being used.

10. Viris scan is not installed.

11. force encriptioned is NOT checked.

Please reply.

View 12 Replies View Related

Error: The Size Specified For The Link Is Too Small

May 29, 2008

Hi All!

I've got some data in a table called Dim.Sources that I generated by a program to generate data, so the characters are wierd, but it is in the database.

When I process the dimension, I get an error like: the size specified for the link is too small, and it will truncate one or more values of the column...

It is only for the name column, but not for the id column (I guess because in this column there are only numbers).

I'm getting nuts! please, any help will be much appreciated! No way to find any information on the internet about it!

I don't remember defining any link size!! Where can I change it?? What is it??? : )


Thank you all in advance!

View 1 Replies View Related

Error When I Try The Link Http://localhost/reportserver

Jul 30, 2007

Dear All,
i face a problem when i try the link http://localhost/reportserver
an error message appear as the following

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config' is denied

and i check the server log file and it is as the following ( i hope anyone help to solve that problem)


<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Egypt Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerService__07_30_2007_16_46_58.log</Path>
<SystemName>KKHALIFA-XP-588</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!7/30/2007-16:46:59:: w WARN: WebServiceAccount is not specified in the config file. Using default: KKHALIFA-XP-588ASPNET
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!7/30/2007-16:46:59:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!4!7/30/2007-16:46:59:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 33180 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: SQM timer timer enabled: Next Event: 36780 seconds. Cycle: 86400 seconds
ReportingServicesService!library!8!7/30/2007-16:47:00:: i INFO: Catalog SQL Server Edition = Developer
ReportingServicesService!library!8!7/30/2007-16:47:00:: e ERROR: Sql errorystem.Data.SqlClient.SqlException: Could not find stored procedure 'GetDBVersion'.
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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
ReportingServicesService!library!8!7/30/2007-16:47:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.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 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.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 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights.
ReportingServicesService!library!8!7/30/2007-16:47:00:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.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 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights.
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!8!7/30/2007-16:47:00:: Attempting to start service again...

View 2 Replies View Related

Communication Link Failure + General Network Error

Nov 22, 2007



Hi Folks,

This is regarding the intermittent failure of communication between the application server and database server in one of our customer environment. Application error as well as SQL error log shows "General Network Error","Communication Link Failure". Please find below the server configuration

Application Server OS: Win 2003 server + Service Pack1, Standard Edition
Database Server OS: Win 2003 server + Service Pack1, MS SQL Server 2000 + SP4

We have checked the Client/Server Network utility associated with SQL Server and found TCP/IP protocol is used in communication neither than Named Pipes. DSN is used. We have also followed and implemented as per one KB article which mentioned Win 2003 server's feature of preventing Denial of Service attacks (Chance may be there to prevent the valid login packets).We made the registry changes and disabled this feature. A scheduled job which updates the database happens every morning. Also backup was done using a backup utility which needs the exclusive access to DB. So we have asked the customer to use enterprise manager for back up the DB instead of using the other utility to backup. If any one have experienced the same issue, please let me know.

Thanks,
Pranav.

View 2 Replies View Related

Microsoft Data Link Error - Connection Failure

Apr 21, 2008

Hi!

I've a computer with W2K SP4 installed. Previously SQL Express 2005 worked but according to the user it "just stopped working".

When selecting database on the server in the "Data Link Properties"-window he is given the following error message:

"Microsoft Data Link" "Login failed. Catalog information cannot be retrieved"
followed by
"Microsoft Data Link Error" "Connection failure"
Note: He is not given the error message "Server does not exist or access denied!"

- The SQL service is started (can be stopped and restarted without problem)
- I've re-installed SQL Express.
- I've checked and is certain the server name is correct (i.e. computernameSQLEXPRESS)

Any ideas here because I'm getting desperate?

Thanks in advance,

Peter Hartlén

View 7 Replies View Related

Transact SQL :: Error To Insert Data From Link Server

Jul 30, 2015

Msg 7314, Level 16, State 1, Line 42

The OLE DB provider "SQLNCLI10" for linked server "192.168.0.40" does not contain the table ""CP_DW"."dbo"."StgDimSalesTargetSetup"". The table either does not exist or the current user does not have
permissions on that table.

Insert into [192.168.0.40].CP_DW.dbo.StgDimSalesTargetSetup

Select t.SalesTargetCode,t.SalesTargetId,t.TargetDefination,
--LEFT(DATENAME(MM, t.PeriodFrom), 3) + '-' + CONVERT(VARCHAR(4),DATEPART(YY, t.PeriodFrom)) AS MonthYear
--CONVERT (char(8),PeriodFrom,112) [Datkey],
Left(CONVERT (char(8),PeriodFrom,112),6) [Monthkey],t.PeriodFrom,t.PeriodTo,t.TargetAmount
FROM [SO_SalesTargetSetup] t

View 5 Replies View Related

Communication Link Failure Error When Running A Distributed Query

Apr 12, 2007

Hello

TestMachine1 runs SQL2005 SP2 and has as linked server myRemoteServer (SQL2000) server. I run an stored procedure in TestMachine1 which inserts about 20,000 rows to a table in myRemoteServer and brings back a similar quantity of rows. This stored procedures take about 1.5min to complete, but no error appears.

When running the same stored procedure in TestMachine2 (also SQL2005SP2), the following error appears after about 1 minute of execution (not the exact text):

SQLNCli. TCP Provider: network name is no longer available - communication link failure.

Please note that this stored procedure worked before on TestMachine2 (but with less than 10,000 rows) and that connectivity is proven among TestMachine1 and myRemoteServer, since I can execute "select * from synonym_MyRemoteTable" with no problems at all in the TestMachine2's Management Studio.

TestMachine1 and TestMachine2 have Windows XP Professional SP2; myRemoteServer has Windows 2003 and SQL Server 2000 SP4.

Can you please help me to avoid this error?

View 1 Replies View Related

Error: Communication Link Failure When Executin Stored Procedure In SSIS

May 19, 2008

Hi all,

I am wondering if you guys have any experience with failing Stored Procedures running inside a SSIS package with the following error:

=====================================================
Message
Executed as user: GAALPSVR034FSYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:51:22 AM Error: 2008-05-19 09:06:55.15 Code: 0x00000000 Source: usp_SLIM_Site_PreProcess Description: TCP Provider: The specified network name is no longer available. End Error Error: 2008-05-19 09:06:55.18 Code: 0xC002F210 Source: usp_SLIM_Site_PreProcess Execute SQL Task Description: Executing the query "Exec usp_SLIM_Site_PreProcess" failed with the following error: "Communication link failure". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:51:22 AM Finished: 9:06:55 AM Elapsed: 932.203 seconds. The package execution failed. The step failed.
======================================================

Sometime it fails when gets called through a job and sometimes even when a package is open in a design mode. The actual Stored Procedure NEVER fails if called in SQL Server Management Studio.

Any ideas or suggestions will be very helpful and appreciated
Thanks for your help!

Jacob

View 3 Replies View Related

Integration Services :: Shared Memory Provider - Timeout Error 258 / Communication Link Failure

Apr 1, 2014

When running the etl I'm getting the error: <SSIS Task>: Shared Memory Provider: Timeout error [258] ; followed by the message "Communication link failure".

What is special about this message that it happens on a SQL Execute task (random task) and the Timeout is after 2 minutes.

When executing the packages separatly it is working fine. The SQL Tasks that are failing are also quit heavy, but reasonable and takes between >2min and 10 - 15 min. Statements are stored procedures that puts an index on 3 mil. records or update statements,...

I had a look to all my (SSIS-etl) timeouts and they have the default value 0, the "remote query timeout" of the server is set to 10 minutes. According to me, these are the only one that exists?

There are 2instances on the server each instance has 24GB allocated, the server has 64 in total. Also when the etl runs (that results in an error) no other etl is running on the 2 instances. I'm working with the oledb sql server native client11.0 provider : SQLNCLI11.1.

View 7 Replies View Related

SQL Server Admin 2014 :: SSAS Cube Processing Fail With Communication Link Failure Error

Feb 4, 2015

we have our cubes in Server A and SQL DB resides on Server B (we are on SQL 2014), from last couple of days are cube started failing due to below error:

OLE DB or ODBC error: Protocol error in TDS stream; HY000; Protocol error in TDS stream; HY000; Protocol error in TDS stream; HY000; Communication link failure; 08S01; TCP Provider: An existing connection was forcibly closed by the remote host.
; 08S01

I have been going through some blogs to understand the error but don't find any specific yet.

View 0 Replies View Related

SQL Server 2000 SP4 - Link Server Problem - Error 7302

Oct 17, 2007

Error 7302: Could not create an instance of OLE DB provider 'SQLOLEDB'. OLE DB error trace [Non-interface error: CoCreate of DSO for SQLOLEDB returned x8007007f].










CASE:
I created a link server from SQL Server 2000 to FoxPro database using vfpoledb driver. SQL server and FoxPro database are NOT being run on the same machine.

Server1 - SQL Server 2000 (I created the link server which connects to Server2)
Server2 - FoxPro database

TROUBLESHOOT
When I test the link server on the machine which has FoxPro database , It is working with no problem.

PROBLEM STATEMENT:
When a user machine sends a query to Server1/Link Server, it is getting Error:7302

Please help me.

View 2 Replies View Related

Link For SQL BOL Anyone?

Jun 11, 2001

and does BOL store the system error messages? if not where would i find those?
Im getting error 3700.

Thank You
Matthew Nye

View 2 Replies View Related

Link To DB2

Jan 21, 2006

Hi all,I'd like to know what the best means available is to enable distributedqueries from a SQL Server 2000, on tables in BOTH SQL Server 2000 and aremote DB2 server (the latter is not yet available for testing).So, I would be wanting to write queries or SP's like:select t1.field1, t1.field5, t1.field6, t2.field55, t2.field22from MySQLServer.mydb.dbowner.tableXXX as t1inner join ThatDB2Server.thatdb.thatowner.tableYYY as t2 on t2.field11= t1.field99where t1.field44 = @foobarI'm aware of at least two ways to go here:1) in SQL Server 2000, create a linked server to the remote DB2server, either using the wizard or sp_addlinkedserver, and using eitheran OLEDB or ODBC connection;2) using MS Host Integration Server (HIS).Since I've only just today learnt about HIS, I don't know very muchabout it.Questions:(a) are options (1) and (2) mutually exclusive, or does one depend onthe other?(b) can I do (1) without having to bother with (2)? If this, wherewould I get hold of the required OLEDB/ODBC Provider?(c) Is there another way(s) to go about this task?HYCH,Rob

View 1 Replies View Related

Is This The Right Link To SP2

Mar 18, 2008



Is this the right link to Microsoft Sql server 2005
http://technet.microsoft.com/en-us/sqlserver/bb426877.aspx

and what is latest Versions thats around.. I have 9.00.3054.00 installed..

Is this the latest version??

View 4 Replies View Related

Link To A Table

Jun 21, 2006

There is a way to create a link from a SQL Server database to a table located on a MSAccess database? I mean like creating links from MSAccess to other databases. The requested table is updated many times/day, and I dont want to import the table each time an update happens.
Thanks,
Richard

View 2 Replies View Related

Can I Have Link Between Several Servers

Sep 5, 2007

hello all
I have a web application(asp.net) and Database(sql server 2005) .
we have installed them on several servers.
now we want to  have a  connection between apllication on one server to a database on another  server .
for example we have Server(A) and Server(B) the DataBases and Web apllications on two server are the same.
sometimes the Apllication on server(A) must connect to database on server(B). 
whats the solution plz?
note that the number of servers can be inceased in the future this mean the number of servers are not fixed.
thanks

View 3 Replies View Related

Link Servers

Mar 22, 2001

Is there a good article somewhere on sql link server I can find and be able
to get a good understanding ??

Thanks very much.

Rick

View 2 Replies View Related

Link Server

May 4, 2000

Can any one tell me what I did wrong? Tried to set up link server from SQL 7.0 to Oracle.I did it as it was instruct in BOL. When I tried to click on the table, I got this message "error 7399: OLE DB provider "MSDAORA" reported error. Thanks.

View 1 Replies View Related

Link To MySQL

Jan 24, 2006

Can anyone tell me how to link to a MySQL database please?

i want to DTS some data from one and i cant see how to link....

TIA

FatherJack

View 1 Replies View Related

Link Server

Sep 18, 2001

I have created a linked server using an userid that have access to 2 different databases. The linked
was created successfully but I am only able to see tables in 1 database but not both.
The tables of the databases that I can access is the default database of that userid. Is there a way to see all the
tables from more than 1 database that the user is authorized to? Thanks.

View 2 Replies View Related

SQL 7 Link To MS Access

Aug 30, 2004

I am working from within an SQL database trying to get data from an MS Access Database as a linked server. I can "successfully" add the linked server, but when I try to open it from SQL EM I get "Error 7399. . . " from Microsoft Jet. When I try to query it from QA I get "Could not initialize data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. [OLE/DB provider returned message: Not a valid account name or password.]"

I tried both Access 2000 databases and '97. Same results for each. Big project pending . . . any help is appreciated!

JB

View 3 Replies View Related

Remedy Link For SQL

Nov 2, 2004

Hi,

Does anyone know how to configure a Remedy Link for SQL.

let me know
CHRIS

View 3 Replies View Related

Database Link

Feb 9, 2004

Hi!

Is it possible to use database links on MS SQL-Server 2000, like on Oracle? If its possibe, what is the syntax and can i create a database link from Microsoft SQL Server 2000 to Oracle?

Nick

View 1 Replies View Related

Link To Mysql

Mar 8, 2004

I tired to create a link 'MYSQL' in a SQL Server using the following code :

EXEC sp_addlinkedserver
@server = ‘mysql’,
@provider = 'MSDASQL',
@provstr = 'DRIVER={MySQL ODBC 3.51 Driver};SERVER=MySQLServer;UID=root;PWD=;'

NB: I have a DB by the name of : MYSQL

There is no errors during creation ...

The link creation is OK but I am not able to see tables from SQL Server…

Any Idea ?

View 6 Replies View Related

Link - Other Servers

May 22, 2008

Hi
I have a scenario please help

I have 2 servers A and B
DB1 is the database in A and DB2 is the database in B

want to fetch the records from the server B in DB2. My query is

select * from B.DB2.dbo.table1

when i issued this statement in server A from database DB1 got the following error...
OLE DB provider "SQLNCLI" for linked server "B" returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18456, Level 14, State 1, Line 0
Login failed for user 'sa'.

How to solve this issue.

(Note - login for SERVER A - sa/<nopassword>
login for SERVER B - sa/master)

View 4 Replies View Related







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