June 9, 2008 at 4:54 am
I've followed the instructions contained in the link, made a substitution of oslq command into sqlcmd in the scritp (I use sql server 2005) and executed the job that was created. The sql file generated by the process contains the following error message:
HResult 0x35, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [53].
Sqlcmd: Error: Microsoft SQL Native Client : 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..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
I have verified that remote connections are allowed on the server.
Also, what problem should there be?
June 9, 2008 at 9:36 am
Can you connect via SSMS?
June 9, 2008 at 12:15 pm
Hey,
Only thing I could imagine of this problem is make sure TCP/IP is turned on.
June 10, 2008 at 7:01 am
I didn't specify the real server name instead of generic 'server1' in the sql. Now it works!
Now I woul like to gather informations from all my ssql servers, and put them into the same table on a separate server which I use for tests. I have created linked servers, but what is the correct syntax to use to refer to their objects? e.g. select * from linkedServer1.master.systables?
Thanks for your replies.
June 10, 2008 at 11:27 am
Hi,
I am expecting you connected linked server to your server succesfully.
Query will be like this select * from openquery ([linkedserver1],'select * from db_name.master.dbo.table_name')
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply