server wont show up on Navision clients server list??

Simo_ba

I have up running SQL service with navision database on it, but the server itself wont show up on Navision clients server list when I'm trying to open it.
But if I type the server name manually on the servername textfield and browse databases it founds the database and I'm able to connect it.

Anyone had this problem?

dmccrae

The server lookup list (the Server virtual table) has never reliably shown all available servers - from 5.0 the behaviour has been changed to only look at local machine server instances, so explicitly is no longer showing network servers (exception: the one you are currently connected to, if any, is included).

garak

do you run your database under SQL2005?
If yes, the Listed Servers will only displayed when running "SQL Server-Browser" service

http://technet.microsoft.com/en-us/libr ... 81087.aspx

Regards

Simo_ba

FYI 'i'm using NAV 4.03 / SQL2005,
it's wired sometimes it showup the server but not my sql instance and sometimes it dosn't.
is it possible that bcause i have 2 sql instance on my server??
i can't understand ](*,).
thank you

Simo_ba

garak wrote:

do you run your database under SQL2005?
If yes, the Listed Servers will only displayed when running "SQL Server-Browser" service

http://technet.microsoft.com/en-us/libr ... 81087.aspx

Regards

yes, SQL Server-Browser" is runnig
but it still not showen up ](*,)

dgroeser

i have the same problem, the sql browser ist running but it not shown the server?

ara3n

In 5.0 they no longer search for SQL Instances. So you can only see local SQL instance.