Re: SQL Server registration failed because of the connection failure displayed below

From: Peter Afonin (pva@speakeasy.net)
Date: 07/24/02 

From: "Peter Afonin" <pva@speakeasy.net>
Date: Tue, 23 Jul 2002 22:16:59 -0700

Thank you, Linda.

I've never changed the name of the server or my password. I have no problem
connecting to the SQL server if I use Windows authentication. I start having
problem when I want to switch to SQL server authentication.

Peter

"linda deng[MS]" <lideng@online.microsoft.com> wrote in message
news:x9xq#brMCHA.1956@cpmsftngxa07...
> Hi Peter,
>
> Based on your pervious post, I would like to confirm some details with
you.
> Did you change the server name after the SQL Server's installation? If so,
> please execute the following statements to fix it.
>
> sp_dropserver <old_name>
> go
> sp_addserver <newname>, local
> go
>
> Please try to connect to the SQL Server with 'isql -E' in the command
> prompt. Can you make it?
>
> Since you can see the Security tab in the Properties window, it means that
> you can connect to SQL Server. Please make sure that the password of the
> startup account isn't changed, and you can start the MSSQLSERVER service
> smoothly.
>
> Sincerely,
>
> Linda Deng
> Microsoft Support Engineer
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>

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: Microsoft Web Data Administrator
    ... > login USING WINDOWS NT Integrated Security.... ... if you can not connect using SQL Server authentication at all, ...
    (microsoft.public.sqlserver.msde)
  • 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)