Re: SQL Access Help!!!

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

From: Sunny Jacobs (SunnyJacobs_at_discussions.microsoft.com)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 14:01:04 -0800

Using Enterprise Manager, I created new login and chose the security group
that I want members to have access (Windows authentication was selected) and
I am still having the problem. With Admin credential, no problem. I am new to
database connectivity, so whatever info you can think of to resolve this
problem will be greatly appreciated.

Thanks for your reply

Sunny

"JD" wrote:

> Sunny,
> What steps have you taken to add either that user or the group, that
> user belongs to, as valid SQL Server logins?
>
> JD
>
>
> "Sunny Jacobs" <Sunny Jacobs@discussions.microsoft.com> wrote in message
> news:F70720FA-C8EF-4AF7-9E4D-316274804AF7@microsoft.com...
> > Hi Everyone,
> > This is my first SQL Server setup and I am having some problem. Here's the
> > problem: I have SQL Server 2000 running on SMB Server 2003. I configured
> the
> > SQL server to use Windows authentication; however, when a user try to log
> > onto the server using Enterprise Manager from an XP client, I get "Login
> > failed..." error. However, when I login from the client's pc with domain
> > administrator credentials, I connect successfully to the SQL server. What
> am
> > I doing wrong that users are not connecting? Help!; Help!
>
>
>

Relevant Pages

  • Re: SQL Access Help!!!
    ... user belongs to, as valid SQL Server logins? ... > This is my first SQL Server setup and I am having some problem. ... when I login from the client's pc with domain ...
    (microsoft.public.sqlserver.setup)
  • Re: AD Security group
    ... Please post the exact error message, ... you get for the login failures. ... I add a AD Security Group into the Server Logins but the users with in ... The plataform is Win2003 and Sql Server 2005. ...
    (microsoft.public.sqlserver.security)
  • 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)