Client server Connectivity in SQL 2005 SP3

vyanku

I install SQL 2005 on Win 2003 server.
Then I install navision create database ans users as per requirnment and add them in SQL server also.
On that server when I am trying to connect server it connects sussessfully with any user.
But when I am trying from other PC it will shows me error server not found.
But it shows the name of the server in the list of all servers.
Is it necessary to install SQL server 2005 client on client PC ?
if not then what must be the problem??? ](*,)

nunomaia

Check remote connections

http://www.mibuso.com/forum/viewtopic.php?t=20898

vyanku

I am using enterprise edition.
Will you please tell me how to activate remote connection manually?

vyanku

hi I done that also.
Now it shows me another error

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object '$ndo$dbproperty',database 'name of database' ,schema'dbo'

Any body please suggest any solution.

nunomaia

Did you synchronized users?

vyanku

If we change any property of the user in SQL is it necessary to synchronize avery time?

kine

1) Change the security model to simple
2) Read the documentation about the security models. There are cases when you need to sync the security.

vyanku

1) Change the security model to simple
2) Read the documentation about the security models. There are cases when you need to sync the security.

Did you mean the sequrity model of SQL?
Will you please tell me how to change the sequrity model to simple?

kine

I mean Nav security model (there is just simple Recovery model in MS SQL). File - Database - Alter - Advanced - Security model. For more info see documentation (Security Synchronization in Navision 4.0 SP3.doc).

nunomaia

After synchronization did it solved that permissions problem?

vyanku

again I am getting the same error message

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object '$ndo$dbproperty',database 'name of database' ,schema'dbo'

diptish.naskar

vyanku wrote:

again I am getting the same error message

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object '$ndo$dbproperty',database 'name of database' ,schema'dbo'

Hi Vyanku,

Try this, on the client machine(obviously other than the server) open the add an entry to the host file and change the services file and provide the port no. by default Navision uses 2407. Save the files and then try to connect the same.

Hope this works for you.

vyanku

Thanks
My Problem is solved.