Skip to Content

Not able to access the Sql in Client

Hi

I have installed sql 2005 and sap 2007b in client server. It was installed succesfully but i am not able to access in client machine.

While installing sql whether we have to give " Network service " instead of that i have give " Local system" so i think it was not allowing to acces the server in network in client Pc.

Now without uninstalling the sql and sap we can change the setting to access in the netwrk client Pc??? or i have to uninstall all then again ihave to install with " network service"

Pls Guide me.

Giri

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Aug 12, 2009 at 05:17 AM

    Hi!

    Try to instal the sqlclin and select SAP Server name in the Server Text Box instead of LOCAL

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 12, 2009 at 06:59 AM

    Hi,

    You have to select Built in system account with Local System in the service account window.

    It wont work if Network Service is chosen,then i am afraid you have to reinstall everything.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Giridharan Venkatachalam

      Hi!

      Sorry i don't no in detail or depth, for SAP B1 installation and Client Connectivity that is not required.

      U can get the Help of SQL from MSDN.

  • avatar image
    Former Member
    Aug 12, 2009 at 07:38 AM

    Hi Giri,

    Check the thread

    client-setup-sql-server-selection

    You can find the Native Client on the SQL 2005 CD or check on this page

    http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

    Regards

    Jambulingam.P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 12, 2009 at 11:58 AM

    Hi Giri,

    In SQL Server Help file content are i pasted here

    Using the Local Service Account
    
    The Local Service account is a special, built-in account that is similar to an authenticated user account. 
    The Local Service account has the same level of access to resources and objects
     as members of the Users group. This limited access helps safeguard your system 
    if individual services or processes are compromised. Services that run as the Local 
    Service account access network resources as a null session with no credentials.
    
    Using the Network Service Account
    
    The Network Service account is a special, built-in account that is similar to an authenticated 
    user account. The Network Service account has the same level of access to resources and 
    objects as members of the Users group. Services that run as the Network Service account 
    access network resources using the credentials of the computer account.
    
    Important:  
    
    Microsoft recommends that you do not use the Network Service account for the SQL Server 
    or SQL Server Agent services. Local User or Domain User accounts are more appropriate 
    for these SQL services.
     
    
    
    Using the Local System Account
    
    The Local System account is a highly privileged account; use caution when assigning 
    Local System permissions to SQL Server service accounts.
    
    Security Note:  
    
    To increase the security of your SQL Server installation, run SQL Server services under 
    a local Windows account with the lowest possible privileges.
    
    

    Regards

    Jambulingam.P

    Edited by: Jambulingam P on Aug 12, 2009 1:58 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Suraj

      Some times it showing the server name, sometimes it was not showing...

      Erro msg is : " Connection failed;

      SQl state:'08001'

      sql server error:0

      [miscrosoft][SQL Native Client] uanble to complete the process due to delay in opening server conn,"

      One more Erroe Msg:

      Connection failed;

      SQl state:'08001'

      sql server error:0

      [miscrosoft][SQL Native Client] Sql N/w interfaces erorr locatin services /instance specified[xffffffffff]

      connection failed

      sql state"'hyt00'

      ....

      ...

      ...

      Giri

  • avatar image
    Former Member
    Aug 13, 2009 at 07:49 AM

    Hi Giri,

    Wheather in Client Machine when clicking the ChangeServer button

    you type the IP Address of the server Instead of Server Name.

    Confirm me the SQL Server User Name is sa is correct ?

    Regards

    Jambulingam.P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 13, 2009 at 09:55 AM

    Hi Giri,

    This issue is One Partcular Client Machine or all the client machine.

    Regards

    Jambulingam.P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 13, 2009 at 10:39 AM

    Hi Giri,

    Better Post a Message to SAP Support Center with HIGH Priority.

    Regards

    Jambulingam.P

    Add comment
    10|10000 characters needed characters exceeded