in "server network utility" enable Named Pipes protocol...you should be able it access it from your local network, or application using the database server name
(find this by running select @@servername on the server)
If you want it to still be accesible on the outside, leave TCP/IP enabled with ext ip in properties
The Thing is My SQL Server is hosted by our Service Provider
Now What should I ask My Service Provider to do to bring it to local IP
as so far I was using Public IP.
So what should be done
So that my client application is able to to access the database server which is in Local network in the service Provider
Can you guide me further
you need to ask your provider to set up a NAT (network address translation) for you. basically you will be asking them to forward any requests made on a certain port (1433 for sql default) on the external IP to the relevant port on your internal IP ...
client apps will still use external IP for connections...