4,707 questions
Maybe you should change this line, inserting apostrophes:
'EXEC [USP_Delta_Test] ''ADS'', ''ADS'''
Insert results of a stored procedure into a temporary table
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 33%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETZ%3C/text%3E%3C/svg%3E)
T.Zacks
3,996
Reputation points
I tried this code but got error
https://stackoverflow.com/a/29040625/9359783
SELECT *
INTO #temp
FROM OPENROWSET('SQLNCLI',
'Server=192.17.11.18;Trusted_Connection=yes;',
'EXEC [USP_Delta_Test] ADS,ADS')
select * from #temp
drop table #temp
Normally when executing SP like this way then getting data EXEC [USP_Delta_Test] 'ADS','ADS'
this is my server IP 192.17.11.18
please tell me what i need to change in my above code ?
Developer technologies | Transact-SQL
{count} votes
-
MelissaMa-MSFT 24,221 Reputation points2021-02-24T01:55:27.34+00:00 Hi @T.Zacks ,
Could you please validate all the answers so far and provide any update?
Best regards
Melissa
Sign in to comment
2 answers
Sort by: Most helpful
-
Viorel 122.6K Reputation points2021-02-19T20:10:37.39+00:00 -
T.Zacks 3,996 Reputation points
2021-02-20T07:51:23.25+00:00 after change I got this error message when execute rectified sql.
OLE DB provider "SQLNCLI11" for linked server "(null)" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "(null)" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].
Completion time: 2021-02-20T01:49:30.7154920-06:00 -
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2021-02-20T10:08:51.707+00:00 This is the standard error message for that you are not able to reach the instance you are trying to connect to, and has absolutely nothing to do with what you are trying to achieve.
Apparently there is no SQL Server instance running on the machine at 192.17.11.18, or at least not listening on port 1433. Or there is a firewall in the way. You need to conduct the standard troubleshooting for this situation.
Sign in to comment -
-
MelissaMa-MSFT 24,221 Reputation points
2021-02-22T02:37:05.337+00:00 Hi @T.Zacks ,
Please refer a thorough list of troubleshooting methods that can be used to connect to the SQL server from below:
- Make sure SQL Server Service is running( run services.msc).
- If a named instance, make sure SQL Server browser service is running.
- Make sure SQL Server is configured to allow remote connections.
- Check the SQL Server error log and confirm SQL is listening on the expected network interfaces and ports.
- Test server connectivity with PING from the client machine.
- Test port connectivity using TELNET(TELNET <server-name> 1433).
- Check firewall settings or reate a Firewall exception.
- Check Local connection.
You could also refer more detailed steps in this article.
Best regards
Melissa
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.