I am getting an error saying the following error on localhost, "[Macromedia][SQLServer JDBC Driver]A username was not
specified and the driver could not establish a connection using NTLM (type 2)
The strange thing is that I would only get this error if I am NOT connected to the internet at all. If I have any kind of internet access at all, I would NOT get this error. The MS SQL server is running on my computer, which uses the Windows authentication. I have checked the network configuration settings in my SQL Server Configuration Manager; the TCP/IP is enabled.
Does anyone know how to get this problem resolved?
Thanks in advance,
Does "not connected to the Internet" mean that your PC is disconnected from your LAN, or that your LAN is disconnected from the Internet? if the former, then the problem is probably that you don't have an IP address (because there is no network to give you one). If the later, then it's something else.
Windows authentication requires that your computer be able to talk to the domain controller (or verify that it can't talk to the domain controller, I guess), if your computer is a member of a domain. If both of these are on your laptop, you might as well just use native SQL logins (untrusted connections) instead of Windows authentication (trusted connections).
Dave Watts, CTO, Fig Leaf Software
Read this before you post: