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.
0
Answers
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
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.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
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.
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).
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!