SP1 Installer Can't Connect

Hot Topic

how long need ALTER DATATABLE (DATABASE) SET ENABLE_BROKER ?
Transfer Objects Doesnt allow 2 connections to the same server
SSIS Diagramming
web query
Sql server Express 2005 Advanced
New Server Registration to External Database
Change an Access Database to SQL Server
How to dynamically change width?
Visual Studio Command Prompt
classes Vs structs

SQL Server

Items that are filled in
Vacumming Question
Str() not locale aware
matrix sum
Page Number Needed in Report Header
Advice on a database Replication
Query Designer in SQL 2005 is total %#%!@
SSIS Package Configurations Stored in SQL Server Table
Replication -- New Subscription Wizard SQL Mobile error, please help..
How connect SQL server 2000 with c#.net .....?

SP1 Installer Can't Connect

The installer for SP1 can't seem to connect to my unnamed instance of SQL Server 2005 Developer, even though:
  • I'm using Windows Authentication (don't ask...)
  • I can connect with no problem using SSMS using those exact same credentials
Anyone know how to get this to work I've downloaded the installer from our MSDN Subscription, so I can't imagine what the issue could be (and I'm just a dev, not a DBA).

Thanks,
Rob

Answer this question

SP1 Installer Can't Connect

  • DMOORE

    Do you get this error after you click the Next button on the Authentication Mode Screen

    On the Authentication Mode Screen within setup how any entries to you have in the grid What are the entries

    When you connect through SSMS, how are you connecting

    Peter Saddow {Microsoft}



  • Graham Parker

    Anyone

  • Loknar - DBA

    I double-clicked the executable to run it, as per normal.
    The error I get is:
    "Your account account information could not be verified for one or more instances.
    Ensure that you can connect to all the selected instances using the account information provided.
    To proceed further deselect the instances with which connectivity cannot be established."
    Thanks,
    Rob

  • aschreiber2

    If you have more then one server listed in the grid on the Authenication Mode screen, ensure the connection mode that you expect is listed along with the server. If there are more than one entry, select Advanced and then Edit to change the mode for the selected server. If this is fine, try Profiling the server instance you are trying to upgrade -- are you seeing within Profiler the login attempt If you are trying to connect using "sa" ensure Mixed-Mode authenication is turned on.

    Plese let us know if you continue to have problems.



  • Yel

    I have the same problem. It did not help for me. Still getting the Invalid Login Information box.

    I'm trying to connect with "sa" password. With same login details I can connect fine with SQL Server Studio Management and do anything I want, but SP1 can't connect for some reason.



  • neuralsea8

    Hi,

    that happened for me during the setup process if you have a mixed authentication (instances with only Windows and other one with Windows AND SQL Server Authentication). There should be a advanced security option on that screen where you can put a SQL Server login or the option Windows authentication for every single instane if they bhave different in authentication. That should fix the problem for you.

    HTH, jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • HLDev

    Hi,

    how did you execute the SP1 package Which error do you get during the installation of the SP1 package

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de

    ---
  • SP1 Installer Can't Connect
Answer this question