The operating system returned the error 1231

elwin68elwin68 Member Posts: 153
Hello,

For demo and test purposes I have created a virtual machine (Microsoft Virtual PC) with NAV 2009 on SQL 2008.
In the VPC the following software is installed:
- Windows XP SP3
- SQL Server 2008 Express with advanced services
- NAV 2009

For NAV2009 the installation is done for SQL and native. For both a NAS is installed.
The SQL installation works fine.
The native installation has a problem with windows authentication. I can't use windows login to access the database. The following error occures:
The operating system returned the rror (1231)
The network location cannot be reached. For information about network troubleshooting, see Windows Help.

I can use the work around to use database login.
The same error occures with the NAS (native).

How can I complete my demo VPC with a working NAS for the native database?

Thanks in advance.

Answers

  • krikikriki Member, Moderator Posts: 9,118
    Try to give to the NAS the TCP/IP+port of the server and not the servername.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • elwin68elwin68 Member Posts: 153
    Thanks for your answer. It's working!

    When I read your answer I knew it would work :-)
  • krikikriki Member, Moderator Posts: 9,118
    elwin wrote:
    Thanks for your answer. It's working!

    When I read your answer I knew it would work :-)

    Considering the error message, I just thought Windows didn't find the computer/service, so lets make sure he finds it, by using the IP+port.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • anon2132anon2132 Member Posts: 12
    Hello,

    I am having the same error on a native database. A Windows user can't log in, however a Database user can.

    The Windows users are NAS and another user. It returns the 1231 error when logging in. DB users can login with no issue.

    The Windows users can log in when the file is opened directly (ie with the db server turned off). They are Administrators. They are local Windows accounts, not domain accounts.

    The db server has been run as a local account which is an Administrator, it has also been run as Local System.

    The hosts and services are correct.

    I have tried the above method. Does any one have an further suggestions for this?! Thanks in advance.
  • krikikriki Member, Moderator Posts: 9,118
    Have you tried to run the client directly on the server and to open the DB as Windows user? This way you avoid going on the network. Maybe that is giving problems. Remember also to create the windows user you will use in the NAV-DB.
    To try, you might try as servername : 127.0.0.1 or 127.0.0.1:pppp (if you are not using the default port).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.