mibuso.com

Microsoft Business Solutions online community
It is currently Wed May 22, 2013 11:43 am

View unanswered posts | View active topics


Board index » Other » SQL General

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 
  What's this MUID? [MUID:GEEF] Previous topic | Next topic 
Author Message
ouredp
 Post subject: Database user acces on SQL2008
PostPosted: Mon Dec 21, 2009 2:27 pm 
Offline

Joined: Fri Feb 20, 2004 2:09 pm
Posts: 39
Location: Offenburg
Country: Germany (de)
Hello,

We are in migration test moving from sql2000 nav4.3 on sql2008 nav 5.1

I took a Navision Backup and restored it on a new empty 5.1 database with standard security model on our sql2008 server.
I synchronized the security.

Login with windows login works fine but I can´t login with an sql server login & password.

I tried to configure the rights thru SQL security and navision SUPER role as well. Databaselogin even comes with the error: wrong user or wrong password .

Is there something missing in the server setup ? Navision setup ?

SQL2008 on Windows 2008
Navision Client 5.1 running on WinXp
Top
 Profile  
 
ara3n
 Post subject: Re: Database user acces on SQL2008
PostPosted: Mon Dec 21, 2009 3:54 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
the db sql server logins need to be added manually to sql server.


I think you can create a sql script or google for it.

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/

Top
 Profile  
 
ouredp
 Post subject: Re: Database user acces on SQL2008
PostPosted: Tue Dec 22, 2009 10:24 am 
Offline

Joined: Fri Feb 20, 2004 2:09 pm
Posts: 39
Location: Offenburg
Country: Germany (de)
:oops:

After looking at the server log I discovered that it was configured to "windows login only".

Changing the config to both window and server solved the problem.
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 

Board index » Other » SQL General

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: