Login Failed - not accepting parameters

Tech-Archive recommends: Speed Up your PC by fixing your registry

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)
  • 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)
  • Re: Help Please Wit Error
    ... > extracted from MDAC 2.8 RTF. ... >> Occasionally I receive the error you are mentioning when the SQL Server ... >> see an example of the connection string you are using. ... Please install Microsoft Data Access Components ...
    (microsoft.public.dotnet.csharp.general)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)