ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   remote connections (https://www.excelbanter.com/new-users-excel/90642-remote-connections.html)

John A Grandy

remote connections
 
In SS2K , how to enable remote connections ?

For example, from my machine, within SEM I'd like to create a "New SQL
Server Registration" connection to that machine. This has always worked for
me in the past, but today I've encountered an SS2K instance which gives me a
"SQL Server does not exist or access denied. ConnectionOpen (Connect())"
error.

Does it matter if the target instance is configured as "Windows
Authentication" vs "Mixed Mode" ?

I'm attempting the "New SQL Server Registration" via Windows Authentication.



Pete_UK

remote connections
 
I think you have posted to the wrong group - this is Excel.Newusers.

Pete



All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com