>>>Is there a way to programmaticly determine the network address of the box hosting the sql server my app is connected to? ( assuming the connection string is obfuscated within the app ) ?
>>
>>Google [sql server ip address]. Looking at a few of the hits, they seem to rely on running the IPConfig command-line utility via the xp_cmdshell extended stored procedure (which you may not have permission to run).
>
>I could set the permissions for that, but I was hoping there was something magical the app could extract from the connection without actually deciphering the connection string.
>
>Looks like it will just be easier to make the path a setting in the app itself and either set it manually through interface or have the app set it in the routine that locates the server on install. I will need to setup that folder and it's permissions on the server anyway, so I guess that will be the cleanest ( the install, the server etc are all completely under my control ) Just wanted to learn a trick if i could ( and the command line thing may come in handy - I'll look it up .)
>
>Thanks.

Out of curiosity, why do you care where it's running?