sql server not found

  • Thread starter Thread starter DC Gringo
  • Start date Start date
D

DC Gringo

I've been having trouble connecting to a 2nd instance of a SQL Server 2k
with some VB.NET code from my WinXP Prof workstation. My application
connects just fine from a Win2k machine with a like Client Network Utility
setup. I think I'm finding that my developer workstation is having problems
with SQL connectivity in general. I'm getting somewhat random "cannot
generate SSPI context" errors from my client database tools, but they're not
occurring at the same time as my failing VB.NET code. In fact, right now,
I'm only having problems with my VB.NET app.

Thoughts?

_____
DC G
 
In many instances, simply changing the binding order (on either server or
client -- as your client may not have SQL client tools, it is easier on the
server). In most web apps, placing TCP/IP at the top of the binding will
help.

If the machine is Windows 2000, make sure the latest SP is installed, as
there were some problems cleared up in SPs.

Also, the Windows NT LM Security Support Provider is installed. You can
check the event log for SQL Server errors to confirm this is the problem.
You will have to use named pipes if not, which could be a bear IF this is a
web app.

Here is a KB for you:
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
Back
Top