Re: Login failed for user 'sa'. C#, SqlServer 2000

I will give that a try, thanks. In the meantime I moved the database to
another computer and everything worked fine. Once I get this project
finished up I will go back and check the sql settings on the first computer.

"gabe garza" wrote:

> If you're currently setup for SqlServer and Windows authentication then use
> Query Analyzer to login using sa and your password for sa.
> If you get the same problem then SQL Server isn't setup for SqlServer
> authentication, it's only setup for Windows authentication.
>
> If you're able to login using Query Analyzer then post the actual code (not
> just the connection string) that you're using, something is wrong with that
> code.
>
>
>
> "Shawn K" <ShawnK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:FE992BB3-9C44-403F-84F8-19FF8CE2BCFD@xxxxxxxxxxxxxxxx
> > This is driving me nuts. I have found plenty of newsgroups that discuss
> > this
> > subject and not one of them helped. I have tried multiple connection
> > strings
> > to connect to a database on another computer. The current string
> > erver=hostMachine;Database=hostDatabase;User ID=sa;Password=hostPassword
> > produces the following error:
> >
> > Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> > Server
> > connection.
> >
> > So I tried another string using "Trusted_Connection=Yes" which produces an
> > error that user 'null' was not trusted.
> >
> > SqlServer is currently setup to use SqlServer and Windows authentication,
> > which is why I don't understand why providing the username and password
> > for
> > the server would return that error. I also double checked and reset the
> > password in enterprise manager and that still did not help. I'm at my
> > wits
> > end so any assistance would be appreciated. Thanks in advance.
>
>
>
.

Relevant Pages

  • Re: Login failed for user sa. C#, SqlServer 2000
    ... If you're currently setup for SqlServer and Windows authentication then use ... Query Analyzer to login using sa and your password for sa. ... If you get the same problem then SQL Server isn't setup for SqlServer ...
    (microsoft.public.dotnet.framework.adonet)
  • Problem facing while packaging the SQLDMO.dll
    ... Studio 2005, C#.Net 2.0 with the SQLServer 2000 as the database.I have used ... database to the other database. ... But the SetUp is not working fine when I ... installed my setup in the Client's machine where only SQLServer 2000 will be ...
    (microsoft.public.sqlserver.server)
  • Re: data access strategy
    ... there is a domain which is why my app was originally setup to use windows authentication. ... So temporary way is to use the VPN but I'd like to build a module of my app to run on a windows mobile device so I'll keep trying to get remote DB access working......unless this is a really bad idea. ...
    (microsoft.public.sqlserver.connect)
  • Re: Registration from Enterprise Manager
    ... >I have a sqlserver SQLA which I have registered in EM with a sqlserver ... >problem is that when I look at the security log of SQLA, ... >failure audits but with a uid that I am logging in to my local machine with. ... >sending windows authentication requests at the same time. ...
    (microsoft.public.sqlserver.connect)
  • Re: Password require when login into outlook
    ... the (insert latest virus name here) virus, all mail sent to my personal ... After searching google.groups.com and finding no answer, Lillian asked: ... | not windows authentication, ... so how to setup ...
    (microsoft.public.outlook)
Loading