WCF service on local IIS not working

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
using System.Web.Security;

namespace WcfTest
{
    // NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Service1" in code, svc and config file together.
    // NOTE: In order to launch WCF Test Client for testing this service, please select Service1.svc or Service1.svc.cs at the Solution Explorer and start debugging.
    public class Service1 : IService1
    {
        public string SDConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbSmartDocConnectionString"].ConnectionString;
        public string sql = string.Empty;

        public string getCountry() //Works fine in the development server but not in ISS
        {
            string name = string.Empty;
            using (SqlConnection spConn = new SqlConnection())
            {
                sql = "SELECT TOP 1 Land FROM Countries";
                spConn.ConnectionString = SDConnectionString;
                SqlCommand cmd = new SqlCommand(sql, spConn);
                spConn.Open();
                SqlDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    name = rdr[0].ToString();
                }
            }
            return name;
        }

        public Boolean Login(string usr, string psw) //Works fine in the development server but not in ISS
        {
            Boolean ok = false;
            if (Membership.ValidateUser(usr, psw))
            {
                ok = true;
            }
            return ok;
        }

        public string GetData(int value) //Works fine in the development server as well as in ISS
        {
            return string.Format("You entered: {0}", value);
        }

    }
}

Select allOpen in new window

When a service runs under the LocalSystem account on a computer that is a domain member, the service has whatever network access is granted to the computer account, or to any groups of which the computer account is a member.