Re: Login failure

From: anees (anees_at_sharekhan.com)
Date: 06/17/03 

Date: Mon, 16 Jun 2003 22:23:40 -0700

hi dejan
thanks for yr reply and kind co-operation, but the sad
part is that the problem still exist. i have tried the
solution u had provided but the error still exist. after
changing the registry of sql server 7 from 1 to 0 the
error popped up is :
'connection failure general network error.check yr network
documentation
connectionopen [gethostbyname [][]]' while loggin through
sa user.
thanks again for the reply. looking forward for yr co-
operation.
>-----Original Message-----
>Maybe you have to change the authentication mode to Mixed
(I guess you have
>mode Windows Only). You can change this in registry:
>In SQL Server 7.0, the key is:
>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft
\MSSQLServer\MSSQLServer\LoginMode
>In SQL Server 2000, the key is:
>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MicrosoftSQLServer\<
instance_name>\MSS
>QLServer\LoginMode
>
>In 7.0 valid values are 0 and 1, in 2000 1 and 2. Change
the value and
>restart the SQL Server. Try to connect with sa login.
>
>--
>Dejan Sarka, SQL Server MVP
>FAQ from Neil & others at: http://www.sqlserverfaq.com
>Please reply only to the newsgroups.
>PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>
>"anees" <anees@sharekhan.com> wrote in message
>news:039301c333f4$02e16ab0$a001280a@phx.gbl...
>> thanks for yr reply. but i tried to login through sa but
>> it dosnt work, it gives the error 'not associated with
the
>> trusted sql server connection.
>>
>> anees
>> sharekhan.com
>> >-----Original Message-----
>> >You can use the SA internal login. Hope you know the
>> password.
>> >
>> >--
>> >Dejan Sarka, SQL Server MVP
>> >FAQ from Neil & others at: http://www.sqlserverfaq.com
>> >Please reply only to the newsgroups.
>> >PASS - the definitive, global community
>> >for SQL Server professionals - http://www.sqlpass.org
>> >
>> >"anees" <anees@sharekhan.com> wrote in message
>> >news:4bcc01c333e0$99ee7ba0$3101280a@phx.gbl...
>> >> i have deleted built in administrator & local server
>> >> connection and i am unable to connect to my local
>> server.
>> >> how can i establish connection? i am working on
windows
>> NT
>> >> 4 workstation and sql server is installed on the same
>> >> machine ? thanks for yr reply in advance.
>> >>
>> >> anees
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Re: Create indexed view
    ... Columnist, SQL Server Professional ... "Dejan Markic" wrote in message ... I'm just interested about the query with which I can ... select id,name from t1 union all ...
    (microsoft.public.sqlserver.programming)
  • Re: Login failure
    ... i got the solution atlast. ... from there connection is being established and sql server ... >hi dejan ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server DBA Tools
    ... Dejan, thanks for the reply. ... are no cross-server, multi-database documenting/management tools. ... >> I'm very new to the SQL Server DBA world. ... >> would be great if this tool could mine general database ...
    (microsoft.public.sqlserver.tools)
  • Re: Windows authentication failed on SQL2000 +NT4
    ... Thanks for your reply Dejan, ... followed the instructions from the SQL Server Book. ... > You have to grant access to SQL Server to Win users and groups. ...
    (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)