SQL Server run as a service for both? server+ client pc

Hanney · 2008-11-29

Hi there
my client want to use sql server 2005, so i refer navision manual,according to the w1w1isql.pdf,

'In the sql server Option by Dynamics NAV, SQL Server is run as a service. The SQL Server Option for Dynamics NAV requires that SQL Server is able to look up Active Directory to get lists of Windows user groups for authentication purposes. You must therefore ensure that the SQL Server service is running as the NT Authority\Network Service account'

My question is if i going to install for server and client pc. need i to follow this step for both pc?or just for server only?

Thank you

kine · 2008-11-29

MS SQL Server is installed only on the server, it is why the name is "server" ;-) You need only NAV client on the client PC (it is why the name is "client" ;-))

You need to install MS SQL server on the client pc only when you want it for some testing purpose or for local copy of the database etc...

Hanney · 2008-12-01

Thanks for quick reply
According to the w1w1isql.pdf,

To ensure that the service is running as NT Authority\Network Service:
1 On the SQL Server computer locate the MSSQLSERVER service, right-click it and click
Properties.
2 In the Properties window, click the Log On tab.
3 In the Log On tab, under Log on as click This Account and enter NT
Authority\NetworkService and click OK.'

I got error after I follow this step.

The error sound like this:
" Windows could not start the SQL Server(MSSQLSERVER) on Local Computer.For more information, review the System Event Log.If This is a non-Microsoft, contact the service vendor, and refer to service-specific error code 17058"

Can anybody explain tome why this error came out?

Thank you

kine · 2008-12-01

And is there some information in the event log other than you posted?

SQL Server run as a service for both? server+ client pc

Comments

Categories