Remote Connections
Mar 26, 2008Hello community
I have the following problem = /
http://img101.imageshack.us/my.php?image=asdfzv7.jpg
ADVERTISEMENT
Remote Connections Enabled, But I Still Get Error That Remote Is Not Configured - Sql 2005
Aug 23, 2006Fellow 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?
SQL Remote Connection Not Being Seen, Though Remote Connections Allowed
Oct 11, 2007HiI'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 RelatedRemote Connections
Oct 27, 2007Does 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!
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
Remote Connections Error
Jun 2, 2007While 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
Server Does Not Allow Remote Connections
Jul 12, 2007Hi 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 RelatedRemote Connections Error
Feb 10, 2008I 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.
Remote Database Connections With 6.5
Apr 11, 2001I 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.
Allowing Remote Connections
Apr 18, 2008Hi 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
How To Enable Remote Connections?
Jul 11, 2006Hello 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 !
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
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.
Trying To Set Up SS 5 Express For Remote Connections
May 9, 2008I 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
.
SQL Server Does Not Allow Remote Connections
Apr 7, 2008I 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??
Not Allowing Remote Connections
Mar 3, 2007TITLE: 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.
Error 53, Remote Connections
Dec 18, 2007Hi 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
SQL Server Does Not Allow Remote Connections
Sep 21, 2006I 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
Securing Remote Connections
Dec 5, 2006Hi,
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.
SQL Server Does Not Allow Remote Connections. (
Dec 8, 2006Hi,
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
Ql Server Does Not Allow Remote Connections
Jul 2, 2007hi,
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?
Not Allowing Remote Connections
Mar 3, 2007TITLE: 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.
Trouble With Remote Connections
Jan 25, 2007when 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.
SQL Server Does Not Allow Remote Connections
Dec 18, 2007I'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.
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
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
SQL Server Remote Connections With Web Service
Feb 8, 2007Hello,
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.
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?
SQL Server 2005 Does Not Allow Remote Connections
Sep 8, 2007got 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
Setting Up An Sql Server To Allow Remote Connections To It
May 5, 2008I 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)
MSDE Doubt About Remote Connections
Oct 24, 2006Hi 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
Sql Server Remote Connections Error
Jun 2, 2008Guys,
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
Remote Connections In Sql Server 2005
Feb 6, 2007Snehalata writes "i have one database at sql server 2000 and i have one database at sql server 2005. now i have added linked server to sql server 2005. i wish to access database located at sql server 2000 from sql server 2005 by creating a view in database located at sql server 2005. but when i access database located at sql server 2000 from sql server 2005 i get error message
OLE DB provider "SQLNCLI" for linked server "OLDPARTNER" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "OLDPARTNER" returned 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.".
wat should be done?
its urgent"