Not able to access the Sql in Client

[former_member206437]

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

[Former Member]

Hi Giri,

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

Regards

Jambulingam.P

[former_member206437]

Hi Jambu

Pls clear my points whether we have to install the sql in client pc also??? i struggling from last 2 days. if i have raised the ticket to sap they will answer after a week oly i think so already me in delay in projectt so pls help me out

giri

Edited by: Giri dharan on Aug 14, 2009 3:59 PM

[Former Member]

You definitely no need to install the SQL Server in client PC. It may just give you all headache if you decide to do so.

Thanks,

Gordon

[Former Member]

Hi Giri,

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

Regards

Jambulingam.P

[former_member206437]

Hi Jambu

we have tried in 3 systems same problem. what will be the cause..

Giri

[Former Member]

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

[former_member206437]

Hi Jambu

username is ' sa' only and i tried by given ip address also but no soln.

giri

[Former Member]

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

[former_member206437]

Hi Jambu

Thanks for ur valuable answer.

Giri

[former_member206437]

Hi

Still i am not able to connect the server in client pc.

I have installed windows installer 3.1, sql native client and sbo client.

in server field it showing the server name but when after password given its giving error

help me out

Giri

[Former Member]

What error it gives ?

[former_member206437]

Hi

when i am trying to connect the server from client side it was giving error

giri

[Former Member]

Hi!

Do u able to ping ur server from clint machine ?

[former_member206437]

Ya suraj.. thats y i am wondering that it was pinging but i am not able to get it

Giri

[Former Member]

Hi!

Did, all services of SQL is started and running in SAP Server aswell in client ?

[former_member206437]

Hi Suraj

In SQl Server Conf. manager all services are running ( Enabled).

Protocols for Mssqlserver - shared memory,named pipes,tcp/ip,via all r enabled

sql native client conf -- client -- all are enabled

But in client p/c where i have to check???

Giri

[Former Member]

Hi!

Can u put the Error message wht it showing on the screen.

Wheather in Client Machine did u able to see your Server Name when clicking the DropDown Box in ChangeServer

[former_member206437]

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

[Former Member]

Hi Giri,

Check the thread

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&Displa...

Regards

Jambulingam.P

[msundararaja_perumal]

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.

[former_member206437]

Hi Sundara

I have installed Sql With " Local System " only it was not allowing to access the Sql database in network Client. The Error is like Check whether Remote Access of SQl Server is applicable or not.

Giri

[msundararaja_perumal]

Hi,

Are you able to access the client machine?

If no,check whether proper permissions are assigned in the sap b1 server.

If yes then have you reinstall sql 2005 native client,restart the client machine.

Ensure that you are following the instructions given in the administration guide sql.

[former_member206437]

Hi Sundararaja / Jambulingam

If i understood properly then first i have to install sql 2005 native client in client m/c then i have to install Client Sbo then i have to try to access the SQl.

First Clear my Dought i have installed the Sql server in " Local System in Build in account system whether i have to change into "Network services " for accessing the server in network

Giri

Edited by: Giri dharan on Aug 12, 2009 1:36 PM

[Former Member]

Not require to change it to "Network services "

[former_member206437]

Hi

If u dont mind then what is difference in that can u explain that briefly

Giri

[Former Member]

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.

[Former Member]

Hi!

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