>>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.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.