How can we help you today? How can we help you today?

SQL Backup GUI error can't connect

I've done three installs, no problem, but I'm on my 4th install, and I'm getting the following error opening SQL Backup GUI after typing in my SQL Server credentials: "Failed to connect to any instances of SQL Server on the local machine."

I'm using the default instance, and I can open SQL Query Analyzer locally & remotely and open by name, and also can use "." locally. I've used my own credentials (with system administrator role) and sa, neither work.

I'm running 3.2.0.2... I've rolled back to 3.2.0 also, no change.
joshmurrah
0

Comments

4 comments

Sort by
  • petey
    Does the message appear immediately, or after a while (~15 seconds)? And this is SQL Server 2000, not 7?
    petey
    0
  • joshmurrah
    Yep, it's SQL 2000, and it's immediate, no delay whatsoever.
    joshmurrah
    0
  • petey
    SQL Backup reads the following registry value

    HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\InstalledInstances

    to find out the names of the installed local instances (MSSQLSERVER being the default instance). Does everyone have rights to at least read the HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server key?
    petey
    0
  • joshmurrah
    My apologies, I just found out today that this is in fact a SQL 7.0 box... wasn't aware we still had any online!
    joshmurrah
    0

Add comment

Please sign in to leave a comment.