SQL Connection problem - Help!

I have an app using VB/ADO to connect to SQL databases. No problem on more
than 300 client installs... except for one.. (isn't it always the case?)

Well, this one has me pulling my hair out..

For various reasons (the most important being our app is very often
installed on small peer-to-peer networks with no domain server) we use mixed
authentication mode. When we install the database we create our own
logins/users with varying levels of access. These are embedded into our
apps, and we haven't had any problems so far.

In this one case, I was attempting to install our database into a default
instance of a standard SQl Server 2000 (as opposed to MSDE which at least
half our clients use). My login procedure fails with no administrative
access using either the sa login or NT security. The guy logging on is
using an Administrator login and defintely knows the sa password. (This is
using SQLDMO, but ADO is failing also)

I take him into Enterprise Manager opn the server and he can log in, change
the sa password.. checked that sa is the owner, that it is using mixxed
mode, etc.. still cannot connect from a worksation on their network.

I checked to make sure they have no firewall set up.. nothing. This is
Windows 2000, btw..

Anyway.. I tried installing a new instance of SQL. This new instance does
not even show up on the client workstations. Only the original default
instace shows up. Even manually constructing a connection to the new
instance returns the ADO error :

-2147467259 - [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid
connection.

Both of these were installed from a SQL Server CD version : 8.00.194 with
SP4 applied after install.

Could there be some licensing issue which prevents a client from connecting?
(Should I install an instance of MSDE and test with that?) I've googled and
looked at newsgroups til I am blue in the face, but this one really has me
stumped.. Help!

Thanks in advance,
Jerry


.

Relevant Pages

  • Re: Unable to install 64bit SQL 2005 on Windows 2008 Cluster
    ... cluster installation of SQL. ... All of the database files are on the SAN share. ... Below are the logs from the install. ... SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM ...
    (microsoft.public.sqlserver.clustering)
  • RE: SPS WSS SQL 2000 same machine
    ... that the MSSQL$SHAREPOINT SQL Service instance is not running. ... both are installed on the SQL Server Default instance. ... You MUST install WSS before SPS. ... However, when selecting the Database ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Just say no to threads [Was: Software architecture]
    ... they knew there was going to be a database in the app. ... Now my colleague just spent a couple/three weeks designing an SQL ... Turns out they have a flat file of sample information, ...
    (comp.object)
  • Re: Offline application for reporting and collect data
    ... Build one user interface that points to either you SQL Server database (when ... Build custom synchronization routines to deal with 'data exchange / ... to install SQL server and restore the database backup in the system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
Loading