Login/connection problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: larzeb (larzeb_at_community.nospam)
Date: 02/01/05 

Date: Tue, 01 Feb 2005 14:25:15 -0800

I have installed SQL Server 2000 SP3a on an XP machine and running in
mixed mode. I log on using a local user name belonging to the
Administrators group.

When I attempt to connect to the DB through .Net with the following
string:

Data Source=(local);Initial Catalog=Cat;User ID=user;Password=pwd" or
Data Source=(local);Initial Catalog=Cat;UID=user;PWD=pwd"

I receive the following error:

Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.

However, I can login using osql -Uuser and password pwd.

What am I missing here? I am desperate!

TIA, Larzeb

Relevant Pages

  • Re: Regarding setup for SharePoint Services 2.0...
    ... But after installation, all WSS functionality will ... continue to work if you switch back to Mixed Mode. ... like) that get real flaky if you are not running in Windows Only SQL Server ... advantages to Microsoft from a security perspective moving to a Windows Only ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Regarding setup for SharePoint Services 2.0...
    ... that means it's OK to set up SQL Server ... authentication as mixed mode when installing WSS? ... > following the single-server installation guide for that product. ... > mode or when wondering if mixed mode is a solid solution. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Regarding setup for SharePoint Services 2.0...
    ... For what it's worth I've just done a Project Server 2003 installation ... to the SQL Server 2K installation part of the guide it stressed that SQL ... Server 2K must be installed in mixed mode because you were going ... > advantages to Microsoft from a security perspective moving to a Windows ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Asp.Net "login failed for user NT Authority/Network service"
    ... Hi Bassel, ... I was looking for "NT Authority/Network Service" ... without showing up as a local user. ... You can do this in SQL Server Enterprise Manager under ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Questions about SQL on SBS Premium
    ... Changing the authentication from Windows to Mixed mode will not ... Just make sure you secure this SQL Server ... The authentication mode needs to be set to mixed mode (it is currently ...
    (microsoft.public.windows.server.sbs)