Login failed when connecting to SQL Server

icemanback · 2011-02-07

Hi everybody,

I'm trying to install nav 2009 in a three tier architecture following this solution :

NAVSQL = W2K8 Domain Controller + SQL Server (192.168.1.1)
NAVSERVER = NAV Server Components (192.168.1.2)
NAVCLIENT = Windows 7 with RoleTailoredClient (192.168.1.3)

When i launch "Microsoft.Dynamics.Nav.Client" from NAVCLIENT, i get this message :
"The login failed when connecting to SQL Server NAVSQL\my_instance_name"

Times before, I fixed one problem with enabling the object change listener, the error was : "Cannot connect the Change Listener to SQL Server".

Does anyone have an idea ?

Thanks

Angelita

mohana_cse06 · 2011-02-07

Is it 2009 or SP1 or R2?

is ur instance added with Windows Authentication?
Can you be able to connect through Classic?

icemanback · 2011-02-07

mohana_cse06 wrote:

Is it 2009 or SP1 or R2?

SP1

mohana_cse06 wrote:

is ur instance added with Windows Authentication?

I created this instance instead of the default instance name when i installed SQL SERVER

mohana_cse06 wrote:

Can you be able to connect through Classic?

How can i change the way to connect ? directly from sql ? from the roletailored client ?

mohana_cse06 · 2011-02-07

I created this instance instead of the default instance name when i installed SQL SERVER

I mean to ask your login ID..

How can i change the way to connect ? directly from sql ? from the roletailored client ?

Directly from SQL..

And what is the value in "DatabaseInstance" of Custom Settings file..

If "DatabaseInstance" has some value...change it to blank and try
<add key="DatabaseInstance" value=""></add>

icemanback · 2011-02-07

Where i can find this parameter file ?

Sorry, but it's the first time that i work with sql server and dynamics nav 2009.

mohana_cse06 · 2011-02-08

icemanback wrote:

Where i can find this parameter file ?

Sorry, but it's the first time that i work with sql server and dynamics nav 2009.

IN NAVSERVER = NAV Server Components (192.168.1.2) at
C:\Program Files\Microsoft Dynamics NAV\60\Service

mark_au · 2011-02-09

Sounds like a delegation issue:

http://msdn.microsoft.com/en-us/library/dd568720.aspx

Otherwise I think you can give explicit permissions in SQL Server to the computer running the NAV Server to get around the issue, but I can't remember for sure.

julkifli33 · 2011-08-18

mark_au wrote:

Sounds like a delegation issue:

http://msdn.microsoft.com/en-us/library/dd568720.aspx

Otherwise I think you can give explicit permissions in SQL Server to the computer running the NAV Server to get around the issue, but I can't remember for sure.

i always have problem when creating SPN
--> Insufficient access rights to perform the operation.

what should i do??

kine · 2011-08-26

You need to be domain admin to be able to create SPNs...

Login failed when connecting to SQL Server

Comments

Categories