Re: Login Failed - not accepting parameters

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hi

Do you have mixed mode authentication set? Can you log in as SA in Query
Analyser?

John

<jason@xxxxxxxxxxxxxxx> wrote in message
news:epVC7JuEGHA.2380@xxxxxxxxxxxxxxxxxxxxxxx
>I recently installed ms sql server Developer Edtion 2000 on an advanced
>server 2003 OS.
>
> I am not trying to get a Beta Contact Management System called Wired
> Contact Enterprise to link up to the sql server.
>
> I have not made any databases....I am just trying to establish a
> connection.
>
> BUT, for some reason the connection login is failing...see here for error
> message:
>
> http://www.catamarans.com/images/screenshot/LoginFailed.gif
>
> ADO Connection Exception: Login Failed for user 'sa': Reason: Not
> associated with a trusted SQL Server Connection Alias: WCE
>
> I have tried changing the SA passord in sql server under 'security' for
> the default MASTER database...but still pick up error above.
>
> When I did the install - excuse me - I think I may have selected Windows
> Auth Mode.....is there a way to fix the problem?
>
> Thanks
> Jason
>
>


.



Relevant Pages

  • Re: VS 2008 Team - Database not supported / Cant load file or ass
    ... Visual Studio 2008 Team Database Edition ... SQL Server 2005 Enterprise SP2 ... Unable to add data connection. ... Install the following from Microsoft SQL Server 2008 Feature Pack RC0, ...
    (microsoft.public.vstudio.general)
  • Re: Connection to SQL Server from within the emulator - newbie que
    ... 'Personal' edition of SQL Server 2000 installed. ... using the IP address with another application apart from the emulator? ... to install it, then use ipconfig.exe to see what IP address the loopback ... connection but is not plugged into a physical network connection. ...
    (microsoft.public.dotnet.framework.compactframework)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help Please Wit Error
    ... Occasionally I receive the error you are mentioning when the SQL Server ... I have had to completely remove the MDAC and re-install it as well ... see an example of the connection string you are using. ... Please install Microsoft Data Access Components ...
    (microsoft.public.dotnet.csharp.general)
  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)