SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Error "Login timeout expired"


Error "Login timeout expired"

Author
Message
huuhieu004
huuhieu004
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 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 !
ChiragNS
ChiragNS
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3359 Visits: 1865
Are the network protocols enabled in the target server.

"Keep Trying"
huuhieu004
huuhieu004
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 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"
Kishore.P
Kishore.P
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1701 Visits: 619
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...)



huuhieu004
huuhieu004
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 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!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search