SQL Server Performance

Connection failed check sql server registration pr

Discussion in 'General DBA Questions' started by aaronsandy, Feb 27, 2005.

  1. aaronsandy New Member

    when i click on the firstinstance of my sql server to see its tree view im getting this message."Connection failed check sql server registration properties.".I tried to reconnect it but no use.What to do now?
  2. ranjitjain New Member

    the message implies...

    connection with sql server cld not b established.
    restart ur sql server EM or ur application.
    if not solved, edit sql server registration properties.

    if not solved, delete and re create new sql server registration.
    try logging off and re login in ur OS.
  3. aaronsandy New Member

    I deleted registration properties and tried to register the server again .But this time I am getting the following err 'sqlserver doesnot exist or access denied.[]Connection open[]'.I noticed that This problem is comming with windows authentication only.
    When i edited the registration properties and opt for sql server authentication its working fine.Whats wrong with windows authentication?
  4. ranjitjain New Member

    Access is denied with windows User name as the windows user does not have administrator rights. change user rights to access the new sql server from domain controller
  5. satya Moderator

Share This Page