SQL Server Authentication Question (easy I think)

From: skitrees (skitrees_at_discussions.microsoft.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 11:51:02 -0800

I don't know if I have the authentication setup correctly on my SQL server.
I set the authentication to use SQL and Windows (instead of just Windows).

I assigned a domain user as the SQL username as well, and belongs to the
administrators group.

I have an application which is supposed to offer a connection string to the
SQL server and modify a table. However, each time I attempt to connect - I
get a logon failure in the event viewer. UNLESS I leave the user ID and
password blank - then it connect perfectly well. I look in event viewer and
see that when the UID and PWD fields are left blank, it is logging on as
administrator.

What am I missing?

How can I setup UserA on the SQL server, and have ONLY UserA be able to
access the database from the network? What could I be missing which is
causing valid usernames to be declined, yet allows the admin to logon
(default when UserID and Password fields are left blank in my connection
string?)

Any help would be greatly appreciated.

I am new to SQL and it is entirely possible that I set something up
incorrectly during install or something.

Thanks.

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)
  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)