LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
John A Grandy
 
Posts: n/a
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why are the help files now remote? Sean Excel Discussion (Misc queries) 2 April 1st 06 10:11 PM
Remote References Lfp Excel Discussion (Misc queries) 0 March 29th 06 05:46 AM
dynamic connections in excel? dennism Excel Worksheet Functions 1 September 16th 05 10:35 AM
Sumif function with remote cell references hennis Excel Worksheet Functions 1 August 12th 05 01:54 AM
Remote access to excel terance311 Excel Discussion (Misc queries) 1 July 20th 05 08:18 AM


All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"