Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error "Login timeout expired" Expand / Collapse
Author
Message
Posted Thursday, November 20, 2008 1:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 3, 2008 12:54 AM
Points: 8, Visits: 28
have problem with distributes queries . Can I help me?

Problem : I have a distributes database. I want connect client with server to get data .

I used SQLSEVER 2005 connect to SQLSEVER 2005.

Above is my query :

EXEC EZV2.dbo.sp_addlinkedserver @server = N'REMOTE_DISTRIBUTEDDB2', @provider='SQLNCLI', @srvproduct=N'', @datasrc='remote_site_dns_or_ip', @provstr='server=ipaddress;database = DistributedDB;uid = sa;pwd=sa223;'



EXEC EZV2.dbo.sp_serveroption @server=N'REMOTE_DISTRIBUTEDDB2', @optname=N'collation compatible', @optvalue=N'false'



EXEC EZV2.dbo.sp_serveroption @server=N'REMOTE_DISTRIBUTEDDB2', @optname=N'data access', @optvalue=N'true'



EXEC EZV2.dbo.sp_serveroption @server=N'REMOTE_DISTRIBUTEDDB2', @optname=N'rpc', @optvalue=N'false'



EXEC EZV2.dbo.sp_serveroption @server=N'REMOTE_DISTRIBUTEDDB2', @optname=N'rpc out', @optvalue=N'false'



EXEC EZV2.dbo.sp_serveroption @server=N'REMOTE_DISTRIBUTEDDB2', @optname=N'connect timeout', @optvalue=N'0'



EXEC EZV2.dbo.sp_serveroption @server=N'REMOTE_DISTRIBUTEDDB2', @optname=N'collation name', @optvalue=null



EXEC EZV2.dbo.sp_serveroption @server=N'REMOTE_DISTRIBUTEDDB2', @optname=N'query timeout', @optvalue=N'0'



EXEC EZV2.dbo.sp_serveroption @server=N'REMOTE_DISTRIBUTEDDB2', @optname=N'use remote collation', @optvalue=N'true'



EXEC EZV2.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'REMOTE_DISTRIBUTEDDB2', @locallogin = NULL , @useself = N'true'



EXEC EZV2.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'REMOTE_DISTRIBUTEDDB2', @useself = N'true',@locallogin = null,@rmtuser ='sa',@rmtpassword = 'sa223'





select * from REMOTE_DISTRIBUTEDDB2.DistributedDB.dbo.Number



create synonym dbo.remote_northwind_categories2 for REMOTE_DISTRIBUTEDDB2.DistributedDB.dbo.Number;



select * from dbo.remote_northwind_categories2



This here is error :

OLE DB provider "SQLNCLI" for linked server "REMOTE_DISTRIBUTEDDB2" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked server "REMOTE_DISTRIBUTEDDB2" 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.".

Msg 53, Level 16, State 1, Line 0

Named Pipes Provider: Could not open a connection to SQL Server [53].

OLE DB provider "SQLNCLI" for linked server "REMOTE_DISTRIBUTEDDB2" returned message "Invalid connection string attribute".



Please help me! Thank you verry much !
Post #605630
Posted Thursday, November 20, 2008 1:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
Are the network protocols enabled in the target server.

"Keep Trying"
Post #605633
Posted Thursday, November 20, 2008 2:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 3, 2008 12:54 AM
Points: 8, Visits: 28
I enable Names pipes in SqlServer Configuration Manager.But then execute this query -> error.
If connect by Login Form of Sqlserver 2005 -> BDEnger on server ok
But can not excute query :
"select * from dbo.remote_northwind_categories2"
Post #605637
Posted Thursday, November 20, 2008 2:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:49 AM
Points: 1,391, Visits: 608
both server are in same domain or different domain ?

check the remote server settings thro' SQL server Surface area configuration (in that enable Remote Connections...)



Post #605655
Posted Thursday, November 20, 2008 3:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 3, 2008 12:54 AM
Points: 8, Visits: 28
Hi,
both server same domain . I Configure Surface Area for ... is Remote Compute. Then Configure Surface Area for Service and Connection ->
Service Connection -> Local and Remote Connection - > TCP/IP and Named Pipes but can not.
Thank very much for these reply!
Please hepl me!
Post #605668
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse