We have NAV 4.0 SP 1 SQL Option. In most of time, when the end users access database, the Net Type is Defaut and it work well. But now I found when I select TCP/IP socket type, the access error message is “can not found the server…”. However, if Name Pipes, the access work well.
I am not sure why TCP/IP socket doesn’t work. The SQL installlation are all standard default configuration. And the OS is Windows 2003 server.
Does any one have such kind of experience? Thanks in advance.
In SQL Server Surface Manager you can define witch connection type SQL Server will accept remote connections.
Our SQL instance is SQL 2000. Could you please tell me where I can find Surface Manager? Thanks.
Sorry that tool is for SQL Server 2005. In SQL Server 2000 right click in server name and will see Network configuration. In Enable protocols you can enable TCP.
I just check the Network configuration, and found Named Pipes and TCP/IP are enabled protocols. And its default port is 1433. So I am confused on this. It seems TCP/IP is enabled, but it doesn’t work…
Can you connect to SQL Server remotely using another tool? For example such has SQL Server enterprise Manager?
Yes, I did. The connection via SQL Server enterprise Manager and Query Ananlyzer are both ok…