Re: Login problem
From: BP Margolin (email@example.com)
From: "BP Margolin" <firstname.lastname@example.org> Date: Sun, 20 Apr 2003 13:44:11 -0400
I'm not sure that I completely understand your current setup, but it sounds as if you either want to:
(1) right click the SQL Server Group, and choose the New SQL Server Registration option, or
(2) right click the SQL Server instance name, and go with the Edit SQL Server Registration Properties option.
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"Ben" <ben@NOSPAMtsp.com> wrote in message news:ORM4yZzBDHA.1612@TK2MSFTNGP11.phx.gbl...
> I've seen lots of similar problems to do with the SQL server or Windows
> Authentication problems, but nothing exactly the same as mine. Basically, I
> have SQL Server 2000 trial edition running on XP pro. I've set it to
> Windows Authenticaiton, but if I try to expand my servers branch in the
> management console, then I get the message "Login failed for user..."
> Obviously I need to get past this point to even try to set up an SQL
> authenticated user. (I have tried the built in SA account, with SQL Server
> authentication on, but then get the trusted connection message.)
> I have also chaanged the registry key to allow mixed authentication - no
> luck there.
> Ay help apprecaited