Cannot connect in mixed mode after installing SQL2K on client

From: Carl Olsson (caos_at_regerar.com)
Date: 11/22/04 

Date: 22 Nov 2004 03:44:18 -0800

Server: W2K server with SQL 7.0, all WU patches applied
Client: W2K professional, all WU patches applied

I have an application that resides entirely on the server, only a
shortcut is installed on the client. It connects to SQL using mixed
mode authentication.

When I installed SQL server 2000 (that is, as much of it as it is
possible to install on a non-server W2K) on my client I no longer
could connect to the server. The error message from the app said I had
no access to the server. I haven't written this app myself so I do not
know what the connection string looks like.

I can still connect successfully from another computer.
Nobody that signs on to my computer can connect.

I know SQL 2000 defaults to using trusted mode authentication but does
it also prevent usage of mixed mode? Sounds too weird to be true...
Better suggestions, anyone?

Relevant Pages

  • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server). ... > 20 tables in different relations with eachother in the database, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now successfully installed them. ... Access front end to a SQL database, Excel can be a front end, A word mail merge document could access a SQL database via ODBC. ... We are trying to install the client software. ... We understand that a Northwind training database is available for SQL Server. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: TDS vs. TCP
    ... I start capturing the network traffic between SQL ... Server and the client. ... I don't see any TDS packets but the communication between SQL ... stand-a-lone server and the client, ...
    (microsoft.public.sqlserver.clustering)
  • Re: DMX Query response time
    ... the prediction is done in client-side. ... In SQL 2005, all predictions are performed in the server. ... >>>> server are remoted to the client and cached into client memory until ...
    (microsoft.public.sqlserver.datamining)