Default option for "Net Type"

afarr

When connecting to Navision (on SQL 2008), some users have the Net Type set to "Named Pipes" by default.
How can they set this to default to the "Default" option, or "TCP" option?

Is it just a matter of deleting their .zup file?

Thanks,
Alastair

kriki

You can create a shortcut to the finsql.exe and put a parameter in it "NETTYPE=TCP". You can also add other parameters to connect directly to the correct DB.

aquawater

For SQL Server, I think the correct value should be

nettype=Default

kriki

aquawater wrote:

For SQL Server, I think the correct value should be

nettype=Default

Best use TCP for performance.

aquawater

Thanks.

But I don't see the difference. Windows authentication login is still slow... ](*,)

afarr

Thanks for the replies.

Unfortunately it doesn't seem to work.
I opened a database using TCP. I closed and re-opened the client to check that it was still using TCP.
I then added NETTYPE=DEFAULT, I closed and re-opened Navision, and it still connected using TCP.

aquawater

Using shortcut doesn't set a default value permanently.

It only works if you run navision from that shortcut you just created.