SQL

Parvardigar

Hello

To test out Nav 2013 off the domain I am installing Nav 2013 demo on a stand alone Windows 2008 Server.
I have created a workgroup so that I can test Nav server and then install a client on one workstation.

During the install following the walk through I ran into this difficulty: "the sql server instance exists but a connection could not be established verify that sql server is running, the tcp/ip protocol is enabled and, that a login exists for your windows account. "

The SQL server is running as I checked out services.msc. Tcp/ip protocol is enabled. Though I have internet access I did check that to prove true. I logged into the stand alone server using the Admin account and by use of the admin account I am installing the Nav 2013 server.

If there is a remedy let me know, thanks.

thegunzo

Make sure that you have;
The correct database name
The correct sql server name and sql server instance name
Make the user running the service tier needs db_owner for the NAV database

bbrown

The login account, running the service, does not (and should not) need to be DB_Owner. It needs membership in the following database roles: DB_Datareader, DB_datawriter, and db_ddladmin. This is in addition to other server rights that it needs (those are outside the scope of this discussion)