Remote Connections From Specified Ip Addresses

Oct 18, 2007



Hi,

Is there any way to ony allow remote access to an instance of SQL Server 2005 from a specific set of ip adresses? (and How To..)

My problem is i only want certain machines to access the server. Any other suggestions to achive this are most welcome.

Thanks for your time

Leroy

View 4 Replies


ADVERTISEMENT

Remote Connections Enabled, But I Still Get Error That Remote Is Not Configured - Sql 2005

Aug 23, 2006

Fellow Devs,
I have an instance of SQL Server Express 2005 running on another box and I have Remote Connections enabled over both TCP/IP and Named Pipes, but on my other box I keep getting the error that the server does not accept Remote Connections.
Any ideas why this might be happening? Is there some other configuration?
 
 

View 25 Replies View Related

SQL Remote Connection Not Being Seen, Though Remote Connections Allowed

Oct 11, 2007

HiI'm going insane.I have a club starter kit on my local server which is working fine.I have migrated the database to my remote host and seems to have transfered ok.For a brief period I was able to connect to the database remotely, but now I cannot I get the following, even though SQL Server Surface Area Config is set to accept remote connections.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 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)This is my connection string;<add name="ClubSiteDB" connectionString="Data Source=xx.xxx.xx.xx,xxxx; Network Library=DBMSSOCN; Initial Catalog=tets; User ID=sqladminbob;Password=sqlbob4398;" providerName="System.Data.SqlClient="/>I hav also tried to use  aspnet_regsql.exe to add the remote provider but I get the same message. Thanks 

View 3 Replies View Related

Load A Text File With Email Addresses And Compare Against A Database Table That Has Email Addresses And User_id

Jul 12, 2007

Hello ALL



what I want to achieve is to load a text file that has email addreses from disk and using the email addresses in the text file look it up against the email addresses in the database table then once matched delete all the users in the table whose email address were in the text file.



I also want to update some users using a different text file.



Please help me with the best way to do this



Thanks in advance

View 6 Replies View Related

Remote Connections

Oct 27, 2007

Does someone have a guide or a link to a guide to allow remote connections from a default install?

Just that I'm currently testing my setup on a work laptop but not having much success but thats probably down to the network admins limiting me far too much on here.

However I am getting a new DELL machine, which I'm gonna make sure the network admins get no where near. Once I have this machine I will be forwarding port 1433 to the machine, but need to know what other changes I need to make to allow my friend access to the machine as well.

So I'd need to know what server settings I need to change and also what my friend needs to do as a client.

thanks in advance!

View 4 Replies View Related

How Can I Allow Remote Connections Using SMO?

May 20, 2008



Hi all,

I would like to enable remote connection on SQL Express 2005 using SMO.
How can I do it?

Thanks,

Assaf

View 5 Replies View Related

Remote Connections

Mar 26, 2008

Hello community

I have the following problem = /


http://img101.imageshack.us/my.php?image=asdfzv7.jpg

View 1 Replies View Related

Remote Connections Error

Jun 2, 2007

While trying to transfer my website project to another computer I am encountering an error when tryng to run the solution.  It gives me a "Does not allow remote connections".  Why is this when on the original computer everything worked fine.
 
Walter

View 2 Replies View Related

Server Does Not Allow Remote Connections

Jul 12, 2007

 Hi folks,Perhaps every 100 calls to DB i get 1 error message like this:"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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" i am using SQL 2000 and am wondering why this happens.I appreciate your help.Leo. 

View 3 Replies View Related

Remote Connections Error

Feb 10, 2008

I am getting the following connection error: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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)When I run the page locally on my develepment environment, the page runs fine.  I'm using VS2005 and SQL Server Management Studio Express.When I upload the page to the remote server, I get the connection error indicated above.To further troubleshoot the issue, I created a simple test page with the connection string hardcoded in the code-behind and binded to a dropdownlist using the following code:SqlConnection conn = new SqlConnection("Data Source=xxx.xxx.xxx.xx;network=DBMSSOCN;Initial Catalog=TechCenter;Persist Security Info=True;User ID=xxxxx;Password=xxxxxrx;Asynchronous Processing=True;MultipleActiveResultSets=True");
        conn.Open();        SqlDataReader dr;        SqlCommand command = new SqlCommand("SELECT RecordID, customer_id FROM Customers WHERE recordtype <> 'F' ORDER BY customer_id ASC", conn);        dr = command.ExecuteReader();        while (dr.Read())        {            DropDownList1.Items.Add(new ListItem(dr["customer_id"].ToString(), dr["RecordID"].ToString()));        }        dr.Close();        conn.Close();When I run the test page, it works fine, so I know I'm using the correct connection string properties.When I move the connection string to the web.config file and using a dataset with a tableadapter, I get the error about the sql server not allowing remote connections?  I'm stumped.  I cannot isolate the cause of the error.The remote server is using sql server 2000 and error indicates it is trying to connect to SQL Server 2005??? Any help would be greatly appreciated.Thank you.

View 5 Replies View Related

Remote Database Connections With 6.5

Apr 11, 2001

I have a need to connect to a remote (i.e. database on the clients site) SQL Server database from a live application. It is relatively easy under Oracle, but I havent tried to do to an SQL Server. Has anyone done this? The remote SQL Server database in question is 6.5
You can set up odbc connections to remote clients (99% sure on this) so you could go this way. You can also connect directly to a sql box through an IP address in sql7, but I am not too sure how it is with 6.5.

View 1 Replies View Related

Allowing Remote Connections

Apr 18, 2008

Hi All,

I installed full version of SqlServer 2005. Iam able to Connect to all the systems that are in Intranet. But iam not able to Connect to the external systems (or) remote Connections. I followed all the steps that are in the following URL support.microsoft.com/kb/914277
Still iam getting the problem. Show me a way in this issue.


Thanks&Regards,
SrinivasReddy

View 3 Replies View Related

How To Enable Remote Connections?

Jul 11, 2006

Hello guys,

I would like to know how to enable remote connections to my SQLExpress installation? Thank you very much for any help!

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !

View 4 Replies View Related

SQL Server Does Not Allow Remote Connections

Oct 11, 2006


Hello ,

The problem is that we are having Problem while making the remote Connection to the Sql Server 2005

Basically We are having a problem connecting to SQL2005 through a package remotely. when we try to connect to a remote data base, we get the following error

[Connection manager "CRA LRRS Development DB"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "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.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ".


Although by running the configuration manager on the Remote DataBase System we have enable the Remote Connections through name and IP both but still it cant access it.

Please tell us the possible consequences and provide us the feedback.

I will be really obliged if any of you can provide us the feedback on it as soon as possible.

Thanking You,
Yours Sincerely,
Saima Salim

View 1 Replies View Related

How Do I Set Remote Connections And Using TCP/IP In Code

Apr 16, 2008



Hello,

In SQL Server 2005 configuration tools, is there a way to set SQL Server to remote connections and to set the TCP Port through c# code?

Thanks for your help.

View 1 Replies View Related

Trying To Set Up SS 5 Express For Remote Connections

May 9, 2008

I am running a standalone WinXP SP2 system with VS 8 and SS 5 Express on it. I have been working very nicely with VB and SSCE, but I want to learn to use Sql Server 5 Express, which I also have on my system from a prior install of VS 5. I am strictly doing this as a learning experience on my own.

I have been trying to install the NW sample database into SS 5 Ex, but it is obviously not configured properly, because I am getting errors stating that the scripts cannot install because they cannot establish a remote connection to SS. So I looked up the FAQ item here on setting up for remote connections (which I am not even sure applies for a standalone system like mine). Anyway, I followed the instructions in the FAQ, using the SAC util to configure for remote connections, but it does not work. Every time I try to start the DB engine, it fails with the following message:

When trying to start Database Engine when configuiriung for remote connections in SAC:

"TITLE: Surface Area Configuration
------------------------------
The service did not respond to the start or control request in a timely fashion, you need
administrator privileges to be able to start/stop this service. (SQLSAC)



Now, I am the admin user on the PC but OK, so I selected the SAC option to set myself as SSadmin, even though this option is supposedly only for Vista users according to the dialog. Anyway, it does not allow me to set myself as SSAdmin, it returns the following error:

When trying to add myself to SQLSAC, even though it is for Vista:

"TITLE: .Net SqlClient Data Provider
------------------------------
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: Named Pipes Provider, error: 40 - Could not open
a connection to SQL Server)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtI
D=2&LinkId=20476"

(which help link is no help BTW, because it is not valid). And the setting does not get set, because the next time I open that dialog, I am back to being a non-admin user.

So what is the solution here? Am I going to be able to use SS 5 Ex on my PC? No matter which connection option I select, either local only, or for any of the remote options, I cannot get it to work. Am I supposed to reboot my PC after changing a setting? Or is it just not possible to run SS 5 Ex on a standalone PC like mine?

Or worse, are there a bunch of other configuration settings I must change as well? I note that, when I look in the SS Config Manager at the properties for SS Express, I see that it shows the logon option that uses the built-in account "Network Service"rather than Local System or Local Service; is that correct? BTW the browser is always running in all this.

As you may gather, I know zip nada about SS, but I am an experienced VB/VBA/VC+/FP programmer of many years, did desktop Access databases w/VB6 frontends for a lot of customers, so I am familiar with DB design etc. I just know next to nothing about backend stuff like this, other than a little with BTrieve years ago.

Any help appreciated

Pete B
.

View 1 Replies View Related

SQL Server Does Not Allow Remote Connections

Apr 7, 2008

I am having trouble with Report Manager. It seems that every day or every other day we get this message:

"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 such host is known.) 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."

To fix this we open the Surface Area Configuration for the server that hosts the Reporting Database and stop and restart the database engine then open up the Surface Area Configuration for the server that hosts the Report Manger database and stop and restart that database engine along with the Reporting Services Browser.

This actually may not be the exact order that we do the stop/starts because we have tried so many different combinations (ie. stop one then start another then restart that one, etc.). Anyway, we usually keep on stoping and restarting until we can get back into Report Manager without getting the error message from above.

Does anyone have any insight as to what this could be??

View 4 Replies View Related

Not Allowing Remote Connections

Mar 3, 2007

TITLE: Connect to Database Engine
------------------------------

Cannot connect to FRI-0503SQLEXPRESS.

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

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.) (Microsoft SQL Server, Error: 10061)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476

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

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


I have recieved this error and i have changed the surface area configuration to allow remote connections but it still won't allow them after i start and restart the server service. is there any way to fix this i have reinstalled several times and that has not yet fixed the problem either.

View 5 Replies View Related

Error 53, Remote Connections

Dec 18, 2007

Hi all

This question has probably been asked a few times on the forum but none of the answers work for my situation.

I recently installed SQL Server 2005.
When trying to connect to my server, locally, using Management studio, I get the following error:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53).

I have already enabled remote connections in the Surface Area Configuration, using TCP/IP and pipes.
I created exceptions in the Firewall and started the Server Browser service.

Please help

Thanks

View 5 Replies View Related

SQL Server Does Not Allow Remote Connections

Sep 21, 2006

I downloaded VS studio express, and created a personal website using the wizard to test drive the thing. When I hit ctr + f5 to run the sample provided, then I get this message:

"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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "

I tried disabling the firewall (Norton's firewall because Windows is disable always). Any suggestions? This is a brand-new machine, running XP sp2, just downloaded the VS studio express.

I really appreciate your inputs.

Regards,

Carlos

info@paesano.com

View 4 Replies View Related

Securing Remote Connections

Dec 5, 2006

Hi,

I'm without a clue when it comes to SQL and how to secure it!

I've set up a SQLExpress running on a dedicated server on the web and I'm using TCP/IP remote connection to connect to the DB from a the web server running the ASP .

Would it be better using named pipes?

Also is there some way I can additionally authenticate a connection based on IP numbers?

I would really appreciate some advice thanks.

View 1 Replies View Related

SQL Server Does Not Allow Remote Connections. (

Dec 8, 2006

Hi,

Attempting to open a new database engine from a Windows 2003
R2 server (x64) which is

running SQL Server 2005 to my desktop PC (XP Pro) which is running SQL 2005 developer
edition.



I€™ve opened up TCP/IP and named pipes and enabled all protocols
within surface area configuration and server

configuration manager but get this€¦



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
- A connection attempt failed because the connected party did not properly
respond after a period of time, or established connection failed because
connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)



Is this a red-herring type message? I ask because the text
states €œthis failure may be caused€? and as far as I can see I€™ve open up my

PC to all connections.



Thanks in advance



Dave

View 10 Replies View Related

Ql Server Does Not Allow Remote Connections

Jul 2, 2007

hi,

sql server 2005 express is installed on comp1. my client application is installed on comp2 and comp3. all comps have win xp. when i run my application, it can't connect to sql server express. i got the following message:

an error has occured while establishing a connection to the server. when connecting to sql server 2005, the failure may be caused by the fact that under the default settings sql server does not allow remote connections. (provider: sql network interfaces, error 26 - error locating server/instance specified)


so, how can i solve this problem, to connect to the server?

View 4 Replies View Related

Not Allowing Remote Connections

Mar 3, 2007

TITLE: Connect to Database Engine
------------------------------

Cannot connect to FRI-0503SQLEXPRESS.

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

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.) (Microsoft SQL Server, Error: 10061)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476

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

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


this is the error message i get and i don't know how to correct it. i have tried going into surface area configuration and setting it allow remote connections but that hasn't changed anything. i am at a loss for how to correct this situation.

View 1 Replies View Related

Trouble With Remote Connections

Jan 25, 2007

when i try to add a new data connection from within Visual basic or C#, i get a 'provider: SQL Network Interfaces, error number 26 - error locating server/instance specified.

i have tried to allow remote connections through the sql configuration manager and the surface area configuration.

View 3 Replies View Related

SQL Server Does Not Allow Remote Connections

Dec 18, 2007

I've got the following error from running my aspx webpages, trying to communicate to the MSSQL 2005 database.

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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)


I've see and read a lot of chatter on the forum on the topic, but didn't find my solution. I have done a number of things, all of which didn't shake the error.
1) I went into SQL Server Surface Area Configuration for Services and Connections, and set Remote Connections to Local and Remote Connections, using TCP/IP only
2) Disabled Firewall
3) Made exceptions throught the Firewall for SQL Server and SQL Browser


Any other suggestions, thanks in advance.

View 4 Replies View Related

Allowing Remote Connections

Apr 18, 2008



Hi All,

I Installed full version of SqlServer 2005. Iam able to connect to all of our systems which are in intranet. But iam not able to connect to external system. I performed all the steps that are mentioned in the following URL support.microsoft.com/kb/914277 . Even then i was not able to connect to the remote systems. I request you to show me a solution to this issue.


Thanks&Regards,

SrinivasReddy.Tadi

View 1 Replies View Related

SQL Server Remote Connections With Web Service

Feb 8, 2007

Hello,
I am getting this error with a web service trying to fill a strongly-typed dataset stored in another project that the web service has connection to.  I keep getting this error:
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) 
I set it to allow TCP/IP only, TCP/IP and Named Pipes, and Named Pipes only remote connections allowed.  But it still doesn't work.  I don't understand what the problem may be.  I stopped and started the database engine service every time (this is a SQL Express database attached to the server, by the way).
Any insight would be helpful, Thanks.

View 2 Replies View Related

SQL Server 2005 Does Not Allow Remote Connections?

Sep 3, 2007

 Hello,

I have SQL Server 2005 express loaded on my webserver and I have loaded
SQL server studio manager on another terminal.  When I try to
connect to the SQL Server it tells me that i can't and because the SQL
server does not allow remote connections.  How do I fix that?

View 2 Replies View Related

SQL Server 2005 Does Not Allow Remote Connections

Sep 8, 2007

got the following error in my site. am using visual studio 2005 vb.net sql server 2005. my webhost (philhost.net) said that they support mssql server 2005. please help
Server Error in '/' Application.


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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error:



Line 16: Dim myConnection As New SqlConnection(strConnString)Line 17: Line 18: myConnection.Open()Line 19: Line 20: Dim myTrans=myConnection.BeginTransaction()Source File: E:inetpubvhosts\httpdocsDefault.aspx.vb    Line: 18 Stack Trace:



[SqlException (0x80131904): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +685966 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +109 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +383 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 _Default.Button1_Click(Object sender, EventArgs e) in E:inetpubvhostshttpdocsDefault.aspx.vb:18 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102


Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

View 11 Replies View Related

Setting Up An Sql Server To Allow Remote Connections To It

May 5, 2008

I have a database on my computer with a series of tables in it.
I have sql server management studio express 2005 handling them.
How would I make it so I can access the database remotely, over the internet (a non-local network)

View 6 Replies View Related

MSDE Doubt About Remote Connections

Oct 24, 2006

Hi all,

I have 2 pcs connected each other and one has the MSDE installed, i would like to access PC1 MSDE instance remotly is this possible or MSDE couldn't be used in network environment and just locally?

TIA
Tiago Teixeira

View 6 Replies View Related

Sql Server Remote Connections Error

Jun 2, 2008

Guys,

I can connect the sql server instance through management studio and I can also create a DSN to the same sql server instance. But when the application tries to establish the connection i get the following error

I have checked the following

SQL BROWSER is started
TCP/IP default port 1434 is enabled

At this point I am not sure how to proceed further to trouble shoot this issue.


System.Exception: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) ---> System.Data.SqlClient.SqlException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Any suggestions and inputs would help.

Thanks

View 2 Replies View Related







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