Re: why only sa can connect to SQL server 2005 instance?

Check the SQL Server error log and look at the state for the
login failure. That will give you more specific reasons as
to why the login failed.
You can check the state values and their meanings and find
more information at:
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

-Sue

On Thu, 16 Aug 2007 18:06:56 -0700, Theresa
<Theresa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi:

I have a SQL 2005 instance (standard edition with sp2 on windows 2003
server) located on different domain.

I can connect to it by using sa only via SQL server management studio. I
need to use SQL login.

I created another user called 'test' and granted with sysadmin server role,
but I got following error:

Login failed for user 'test'. (Microsoft SQL Server, Error: 18456)

I searched on the internet two days with no luck.

Any idea?

Thanks in advance.

.

Relevant Pages

  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
Loading