General information
Category:
Installation, Setup and Configuration
>>>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only