No Connection Could Be Made Because The Target Machine Actively Refused It

Nov 17, 2006

Hello,

 I am not sure if this is the right forum.

This is the first time that I have seen this error,
No connection could be made because the target machine actively refused it

I have a web app that when some one inserts text in a text box and clicks a button it creates a new web page and a new table in the database.  Up until this point it has always worked.  A datalist returns the data.  In the datalist there is a hyperlink that when clicked takes the client to the new webpage.  But for some reason it is not working now and that is the error above.

I am lost.  Any help appreciated.

Thanks Matt

View 1 Replies


ADVERTISEMENT

OLE DB Error - TCP Provider: No Connection Could Be Made Because The Target Machine Actively Refused It.

Apr 26, 2006

All,

-> SQL Server 2005 Standard set as a named instance, runs as a local system
-> SQL Server protocol enabled: TCPIP (configured to listen on port 1433 with use of dynamic ports disabled)
-> Remote connections through the SQL Server Surface Area Configuration.

Server starts successfully.

But, I received the following error on trying to process a cube from BI studio is -

OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.; 08001; TCP Provider: No connection could be made because the target machine actively refused it.
; 08001.

Any hints on how to resolve this problem?

Thanks,
Sanchet

View 8 Replies View Related

Service Broker Getting Error '10061(No Connection Could Be Made Because The Target Machine Actively Refused It.)'.

Jul 17, 2007

Hi All,

I have created an application using service broker.i have a source database which in a particular server say server A and want to send message to target database which is in another server say server B.



i have configured all the service broker objects and advanced service broker objects in correct way by reffering the site --http://www.sqlservercentral.com/columnists/sindukuri/2797.asp



but when i am trying to send message from my source server to target server , i am getting the following error in sys.transmission_queue.

Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'.

I have enabled the tcp port in both the server.

Note-My source server is an XP and Target Server is an windows server 2003.



can anybody please tell do i need to set any extra configuration in windows server 2003 or any thing do l need to do which i have left.

please do help!!!!!!!!!!!!!!!!!!



Thanks a lot in advance.....................................

View 6 Replies View Related

Connection Attempt Failed With Error: '10061(No Connection Could Be Made Because The Target Machine Actively Refused It.)'.

Sep 7, 2007

I am working in a distributed environment, I verified msgs have been successfully send from server1 db1 to server2 db2, but I still get the following error msg from the sender server through SQL profile:


Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'.

Does anyone experienced the samething?
Thanks!

View 5 Replies View Related

Connection To Target Machine Could Not Be Made In A Timely Fasion

Apr 28, 2008

I installed SQL 2005 Developer Edition on a Small Business Server 2003. It worked properly for a period of time. However, I cannot open the Management Studio today and it shows a message "Connection to target machine could not be made in a timely fasion.".
Initially, I installed the SQL 2005 Evaluation Edition. After passing the evaluation period, I un-install the Evaluation Edition and then install the current Developer Edition.
What's thing can I do?

Thanks,
Joe.

View 4 Replies View Related

SQL Server Configuration Manager: Connection To Target Machine Could Not Be Made In A Timely Fashion

Dec 5, 2007

I have a SQL Server 2005 box that was moved from a domain environment to a non-domain environment and was never dropped from its original domain before moving over. Subsequently a new domain was created at the data center this SQL Server box now resides in. The machine was dropped from its old domain and joined to the new one.

All the while the service accounts were set to the local admin account. When I tried to start the Configuration Manager I got the message "Connection to target machine could not be made in a timely fashion.". I read some blog entries and tried changing all the service accounts to Local System and the error message still came up.

All of the SQL Server services run fine. It is just this management console that I cannot open. I wasn't with this employer when this box was moved to the data center so I do not know if it worked prior and there isn't anyone here that could give me its history.

Any help would be appreciated.

View 4 Replies View Related

Remote Connection Refused When Creating ODBC Connection To SQL Server 2005

Aug 30, 2006

When I create a new odbc connection to a SQL server 2005 Db I get a failure telling me dat de SQL server does not allow remote connections.

How can I allow the server to allow this.



Any help appreciated



regards

View 1 Replies View Related

Connection Refused

Oct 5, 2007

I have a new server SQL 2005 im setting up a linked server to my 2000 box, however the connection is being refused: Error 10061.

The strange part of it is.
I have other SQL 2000 machines that can connect to this box over the linked server, and I have one linked server from 2005 to a different 2000 box working.

From remote desktop on my new 2005 box I can ping and connect via object explorer to the machine in question. One difference that exists between the 2000 server I can link to and the one that I can not is the port.

The box I can not connect to is on 2433 with the hide server option turned on.

Yes I have tried both the IP and Named pipe with port information when connecting.

Your assistance is appreciated.

Thank you.

You can do anything at www.zombo.com

View 1 Replies View Related

SQL Native: Connection Refused By Using IP

Feb 14, 2006

Hi!!!

I got a problem, if i try to connect with SQL Native client by IP (exemple: 192.168.1.2MYDATABASE) it doesn't work. But I use: HOMEMYDATABASE it works. But in the 2nd case i cannot connect to SQL Server from another computer.



Thanks fr your help.



fred

View 7 Replies View Related

Coredll.lib(COREDLL.dll) : Fatal Error LNK1112: Module Machine Type 'THUMB' Conflicts With Target Machine Type 'ARM'

Jun 30, 2006

Dear All:

When i try to debug the northwindoledb example with VS2005 i get the foolwing error message.

Is there a way to configure the solution to run witn WM5 emulator.

The application run with wm5 emulator when i set the plataform to Windows Mobile 2003, but i want to use the wm5 platform to debug my application with wm5 emulator.

------ Rebuild All started: Project: northwindoledb, Configuration: Debug Windows Mobile 5.0 Pocket PC SDK (ARMV4I) ------

Deleting intermediate and output files for project 'northwindoledb', configuration 'Debug|Windows Mobile 5.0 Pocket PC SDK (ARMV4I)'

Compiling...

Employees.cpp

northwindoledb.cpp

stdafx.cpp

Generating Code...

Compiling resources...

Linking...

coredll.lib(COREDLL.dll) : fatal error LNK1112: module machine type 'THUMB' conflicts with target machine type 'ARM'

Build log was saved at "file://d:Proyectos_VS2005Northwindoledb_WM2003_SQLEW_Windows Mobile 5.0 Pocket PC SDK (ARMV4I)DebugBuildLog.htm"

northwindoledb - 1 error(s), 0 warning(s)

========== Rebuild All: 0 succeeded, 1 failed, 0 skipped ==========

View 1 Replies View Related

What Do I Need To Use SSIS API On A Target Machine?!

Aug 30, 2006

Hi,

I've created an SSIS package to be loaded using my ASP .NET app. This package is kept within the application and loaded via Microsoft.SqlServer.Dts.Runtime.LoadPackage method.

My target machine does not have MS SQL Server 2005 installed. So what do I need at minimum to get this up and running? What components do I've to install or copy over?

I tried to copy just the class libraries across. I copied Microsoft.SQLServer.ManagedDTS.dll and Microsoft.SQLServer.DTSRuntimeWrap.dll into my bin directory but I got this error:

[COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.]
Microsoft.SqlServer.Dts.Runtime.Application..ctor() +25

[DtsPipelineException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.]
Microsoft.SqlServer.Dts.Runtime.Application..ctor() +87


I can't find any information online so any insight or advice will be very much appreciated!

View 8 Replies View Related

How Deploying A Local Database To Target Machine?

May 9, 2005

how deploying a local database to target machine?

View 1 Replies View Related

CLR Integration In 64bit Machine In SQL 2005 With X86 Platform Target

Aug 3, 2006

Hi,

I have following problem:

My production problem enviornment is:

Windows Server 2003 Standard x64 edition with Service Pack 1

SQL Server 2005 with .Net Framework 2.0 for 64bit machines.

I have a .Net application that uses assemlies that use COM references, so I have my application compiled with target platform x86 so that it can use COM Interop and can run in WOW64. All of my assemblies are compiled for x86 target platform.

We are using the same set of assemblies on 32bit machines and SQL server 2005 with 2.0 framework for 32 bit machines.

Now, I have one of my assemblies target platform x86, being used in SQL server 2005 on 64 bit machines using CLR. The assembly gets installed fine, but when I call the function I get following error on 64 bit machines only. 32 bit machines do not have any problem:

Msg 10314, Level 16, State 11, Line 1

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65548. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:

System.IO.FileLoadException: Could not load file or assembly 'echalk.common, Version=7.0.0.0, Culture=neutral, PublicKeyToken=77f22df29f1a5e39' or one of its dependencies. The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)

System.IO.FileLoadException:

at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)

at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

at System.Reflection.Assembly.Load(String assemblyString)

We are using the same exact steps but I get the above error in 64bit machines. I know if I had the asseblies compiled with AnyCPU, it works on both sql servers but then my application fails in 64 bit machines. If I compiled all my assemblies with x86 platform then application works but sql server functions stop working on 64 bit machines. Is there a work arount that I could use so that I don't have to create 2 sets of assemblies for application and sql server seperate.

Any help would be appreciated. Also thanks in advance.









View 4 Replies View Related

Connection Pool Leak In Production Machine (in Other Machine It Runs Well)

Nov 16, 2006

Hi to everyone,
I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.   

View 2 Replies View Related

Connection Could Not Be Made, Login Failed For Use

Mar 18, 2006

I have sql server 2000 Personal Edition with service pack 4 loaded on a laptop running Windows XP and I'm trying to install a program that automatically loads all the tables and files to the SQL Server.

I keep getting the following error:

Your connection could not be created. Check your settings. The error was: Login failed for user "FileArch"

The program had been previously loaded on this laptop and I had to rebuild the hard drive. When I check Enterprise manager I see in Databases that the FileArch database is in Master as opposed to its own database.

The database missing is called FileArch.

If anyone can provide me with help to solve this I'd be grateful as a new member.

Bob

View 7 Replies View Related

A Connection Could Not Be Made To The Report Server

Apr 1, 2007

While attempting to deploy from within VS2005 running on 2003 server we get the following error:



TITLE: Microsoft Semantic Model Designer
------------------------------

A connection could not be made to the report server http://xxxxx:90/ReportServer.



Running sql2005 sp2 integrated w Sharepoint 2007



Thanks..


View 12 Replies View Related

A Connection Could Not Be Made To The Report Server

Feb 23, 2008



hi,

I got this error when I was trying to deploy the reporting into IIS..


TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/reportserver.

------------------------------
ADDITIONAL INFORMATION:

The server committed a protocol violation. Section=ResponseStatusLine (System.Web.Services)

------------------------------
BUTTONS:

OK
------------------------------

I am not able to solve it please help.

Thanks.

View 1 Replies View Related

A Connection Cannot Be Made To The Database. Timeout Expired.

Feb 19, 2008

Looks like I'm up to no good as usual.

Basically due to a client spec, I had to create 115 datasets (one for each of my 115 tables).

After I created the 111th, I am getting the following error:

A connection cannot be made to the database. Timeout Expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.


How do I clear the pooled connections or increase the max pool size?

I suppose what happened is each time I create a dataset it opens a connection to the database and these connections aren't being terminated...

View 3 Replies View Related

Connection Cannot Be Made To Http://localhost/ReportServer

Jun 14, 2007

I have developed a reports in Business Intelligence Development studio and when I am tring to deploy it.
It says that
Connection cannot be made to http://localhost/ReportServer
What does it really mean.

View 6 Replies View Related

Problem - A Connection Cannot Be Made. Ensure That The Server Is Running

May 22, 2007

Hi ,



I installed Ms As 2005 and visual studio 2005 in the machine but i can see visual studio 2005 is working fine.but the problem is with analysis studio when i try to connecting to Analysis studio am getting error like - A connection cannot be made.Ensure that the server is running.





Please help me on this.

View 3 Replies View Related

A Connection Could Not Be Made To The Report Server Http://localhost/ReportServer.

Jan 19, 2007

Hello Guys,

Please take me out from this hell. I created report using VS2005 Business Intelligence Project. It builds fine. I can also see data in the design time. But when I am trying to deploy it gives me this error.

TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/ReportServer.

------------------------------
ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Configuration Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>

<b> Parser Error Message: </b>An error occurred loading a configuration file: Failed to start monitoring changes to 'c:inetpubwwwroot' because access is denied.<br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

[No relevant source lines]</pre></code>

</td>
</tr>
</table>

<br>

<b> Source File: </b> c:inetpubwwwrootweb.config<b> Line: </b> 0
<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

</font>

</body>
</html>
<!--
[HttpException]: Failed to start monitoring changes to 'c:inetpubwwwroot' because access is denied.
at System.Web.FileChangesMonitor.FindDirectoryMonitor(String dir, Boolean addIfNotFound, Boolean throwOnError)
at System.Web.FileChangesMonitor.StartMonitoringFile(String alias, FileChangeEventHandler callback)
at System.Web.Configuration.WebConfigurationHost.StartMonitoringStreamForChanges(String streamName, StreamChangeCallback callback)
at System.Configuration.BaseConfigurationRecord.MonitorStream(String configKey, String configSource, String streamname)
at System.Configuration.BaseConfigurationRecord.InitConfigFromFile()
[ConfigurationErrorsException]: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:inetpubwwwroot' because access is denied. (c:inetpubwwwrootweb.config)
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName)
at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index)
at System.Web.Configuration.RuntimeConfig.get_HealthMonitoring()
at System.Web.Configuration.HealthMonitoringSectionHelper..ctor()
at System.Web.Management.HealthMonitoringManager..ctor()
at System.Web.Management.HealthMonitoringManager.Manager()
at System.Web.Management.WebBaseEvent.RaiseRuntimeError(Exception e, Object source)
at System.Web.HttpResponse.ReportRuntimeError(Exception e, Boolean canThrow, Boolean localExecute)
at System.Web.HttpRuntime.FinishRequest(HttpWorkerRequest wr, HttpContext context, Exception e)
-->
--. (Microsoft.ReportingServices.Designer)

------------------------------
BUTTONS:

OK
------------------------------




View 8 Replies View Related

A Connection Could Not Be Made To The Report Server Http://localhost/reportServer..

Sep 18, 2006

hi,

I got this error when I was trying to deploy the reporting into IIS..

A connection could not be made to the report server http://localhost/reportServer.

------------------------------
ADDITIONAL INFORMATION:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

------------------------------

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)


I am not able to solve it please help.

Thanks.

View 12 Replies View Related

Error Connection Could Not Be Made To The Report Server When Attempting Deployment

Apr 5, 2006

I'm working through the SQL2005 Reporting Services Tutorial. When I try to deploy, I get the error "Connection could not be made to the report server." It appears that I do not have permissions to get to localhost/reportserver (I get a permissions error when just trying to get there directly from "run"). In another forum I saw several people having the same issue. One contributor said that the problem was solved for him by uninstalling SQL2005 and reinstalling using the local system account rather than a windows domain account. I tried that, but am getting the same error. Anyone know how to fix this?

View 18 Replies View Related

A Connection Could Not Be Made To The Reporting Server Http://localhost/reportserver

Jul 21, 2006

Hi all,

When I build a simple project using the report wizard project.

When i deploy the report i get the following error.





TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/ReportServer.

------------------------------
ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Server Unavailable
</title>
</head>
<body>
<h1><span style="font-family:Verdana;color: #ff3300">Server Application Unavailable
</span></h1>
<p>
<span style="font-family:Verdana;">
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
</span></p>
<p>
<b>Administrator Note:
</b> An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
</p>
</body>
</html>

--. (Microsoft.ReportingServices.Designer)

------------------------------
BUTTONS:

OK
------------------------------


Could some one come to my rescue.

Thanx in advance.

Ronald

View 4 Replies View Related

A Connection Could Not Be Made To The Report Server Http://[IP Address]/ReportServer

Dec 6, 2006

Hi

I have sql server 2005 Business Intelligent studio on my machine and Report server on some other machine. I created one rdl file and tried to deploy it on the report server. I have checked the report folder name and everything. But the error mentioned in the subject is being thrown. Additional information is

The request failed with HTTP status 407: Proxy Authentication Required. (Microsoft.ReportingServices.Designer)

Please let me know what all I need to do to resolve the problem.

Regards

Rajesh





View 1 Replies View Related

Errors In The High-level Relational Engine. A Connection Could Not Be Made To The Data Source With The DataSourceID Of '

Feb 7, 2006

When I deploy the cube which is sitting on my PC (local) the following 4 errors come up:

Error 1 The datasource , 'AdventureWorksDW', contains an ImpersonationMode that that is not supported for processing operations. 0 0
Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW', Name of 'AdventureWorksDW'. 0 0
Error 3 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Customer', Name of 'Customer' was being processed. 0 0
Error 4 Errors in the OLAP storage engine: An error occurred while the 'Customer Alternate Key' attribute of the 'Customer' dimension from the 'Analysis Services Tutorial' database was being processed. 0 0

View 25 Replies View Related

Deploying A Report Services Application To The Local Host; Error:A Connection Could Not Be Made To The Report Server

Feb 23, 2007

I installed SQL reporting services 2005 and successfully configured reporting services.After designing the report using Bussiness Intelligence Studio, i tried to deploy my reporting services application to the localhost , I got the below mentioned error :

TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/ReportServer.

------------------------------
ADDITIONAL INFORMATION:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

------------------------------

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

Can anybody provide a solution for this issue....

Thanks in advance

Nirupa

View 4 Replies View Related

Why Isn&#39;t Microsoft Actively Marketing SQL Server 2000 OLAP?

Apr 9, 2001

I recently wrote a white paper on OLAP and was having a hard time finding any information about what was new in SQL Server 2000 OLAP on the web. I didn't really find much until I downloaded a trial copy of SQL Server 2000 (which didn't have OLAP, but had links to information on it). We use Hyperion Essbase, and I was wondering if Microsoft OLAP 2000 would be a viable competitor.

View 2 Replies View Related

SQL Server 7 On Win 98 Machine Will Not Let Me Make A Connection.

Jun 24, 2001

Installed SQL Server 7 on Win 98 machine, keep getting errors:Unable to connect to server servername:

Server: msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

Did the troubleshooter on M$ Knowledgebase, still did not work.
Still get the above and this error:
General network error. Check your network documentation.
ConnectionOpen (connect())

Went to install SP3, and now It won't let me continue without an sa password.
I never had a password to begin with.

Oh, the fun of it all! :)

Any and all help will be greatly appreciated.

Thank You.

CZ

View 1 Replies View Related

Provider: TCP Provider, Error: 0 - No Connection Could Be Made (Need Help)

May 14, 2008


I try to connect to a SQL Server 2005 Express Edition via IP address. But anytime the application tries to connect to the database here is th error message I receive:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

There is the connection String code:


"Data Source=192.168.1.109,1433;Network Library=DBMSSOCN;" & _

"Initial Catalog=myDataBase;" & _

"UserID=Username; Password=Password;"


Already checked

I have enabled the TCP/IP under SQL Server,
Under SQL Server Configuration Area, I have chosen the option Local and remote connection: TCP/IP only
I have verified that my firewall allows SQL remote and a Local Connection.


Now I don't know where to look or what I have to fix to continue. I will really appreciate if somebody can help me.

Thank you in advance.

AA

View 12 Replies View Related

Connection Problem MSSQL SERVER && PWS Same Machine

Jun 14, 2004

Im getting an error when i try to connect to my MS SQL database

0x80040e21 .... multiple-step ole db operation generated errors ....check each ole db status value

this code works connecting to database via web hosting, only things i changed was to replace the server with "(local)" [also tried ip no joy there either] and add integrated security to the connection string

ms sql server and IIS, personal web server all on same laptop, i can access the same database with same details no problem to login it gives up on the subsequent login

code (generally)

Set objconn=Server.CreateObject("ADODB.Connection")
objconn.ConnectionString="SERVER=(local);Database=blah;uid=blah1;pwd=blah2;Integrated Security=true;"

objconn.open


can anybody help

ta, b

View 5 Replies View Related

Connection Problems SQL2000 On Local Machine

Jun 19, 2006

This may be a stupid newbie question, but being that I'm not a DBA I'm going to ask it anyway.

We discovered a problem with a clients server (Windows 2003 SBS) when we tried to install Veritas Backup Exec. Backup Exec requires an instance of either SQLMSDE or full SQL. This server has full SQL 2000 sp3a installed on it with a working account application. When backup exec trys to create it's instance it fails.

Investigating further...when I go into Enterprise Manager (logged in as Domain Admin) I get an error when I select the local server.

I.E.
"A connection could not be established to (LOCAL).
Reason: Data source name not found and no default driver specified.
Please verify SQL Server is running and check your SQL Server registration properties. blah blah blah.

Okay the server is running. The accounting application (client/server) is still working. I right click on the server and select "New Server Registration" for the field "server" I click the browse button and the "Active Servers" box is empty..:shocked:

I went to check the "Data Sources" under drivers, that field is blank. (no drivers installed). I downloaded MS's component checker and it says "MDAC 2.8 on Windows server 2003 sp1" is installed.

At this point I have exhausted my knowledge of MS-SQL server. My goal is to get BackupExec installed and NOT break the existing accounting application.

Any help is greatly appreciated.

Thanks
rogerb

View 3 Replies View Related

ADO Connection String Not Working When SQL On Local Machine

Apr 3, 2007

Here is the connect tring from table properties:ODBC;DRIVER=SQL Server;SERVER=VICRAUCHSRVRVGSMISC;APP=Microsoft Data Access Components;WSID=VICRAUCH;DATABASE=vgs_prod;TABLE=d bo.USysCandidatesHere is the connect string from the ADO .Open connect string:"ODBC;DRIVER=SQL Server;SERVER=VICRAUCHSRVRVGSMISC;APP=Microsoft Data Access Components;UID=sa;PWD=xxxXX99X;WSID=VICRAUCH;DATAB ASE=vgs_prod"Here is the ADO .Open code. Set CNN = New ADODB.ConnectionDim strDEFConn As StringstrDEFConn = FixConnStr(DEFCONN)CNN.Open strDEFConn The last line fails with the CNN.Open strDEFConn with this message:Run-time error '-2147467259 (80004005)';[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified This code works when the SQL Server is on it's own server, but for testing at my own office, I have SQL Server on the same machine as the Access application. I'm getting the above error where SQL Server and the Access app are on the same machine. I can open a linked SQL table from the user interface, and VBA code that deals with the tables as Access tables works. It is the ADO .Open statement where the error happens. Thanks for any help you can give me on getting this to work.

View 5 Replies View Related







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