none
SQL server connection and OBDC failed RRS feed

  • Question

  • I am running Windows 2003 x64 with SQL Server Enterprise 2005 (x64 edition).. Complete install was done (along with reporting services & Integration services)

    However, after I run up SQL Management Studio I can only login as .\ as "Server Name'

    Using the actual name, fails even though its all services are running.:

    When I try and add OBDC Data source The list to select "Which SQL connection to use" is empty..

     I try and enter the server name: MSSQLSERVER and I get the same error

    Checked protocols under Confguration Manager, and Remote access is checked under "connections" pane of Management Studio...

    Firewall is also "OFF" as one less thing to troubleshoot. This is all on local system

    Any other suggestions I could try ?



    • Edited by TECH198 Tuesday, January 21, 2020 1:10 AM
    Tuesday, January 21, 2020 1:10 AM

Answers

  • By the error message you entered MSSQLSERVER as server name, right? You don't have to use the service name, you have to use the machine name and by the screenshots its TEST-12B9347ED4

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by TECH198 Thursday, January 23, 2020 1:02 AM
    Tuesday, January 21, 2020 7:58 AM

All replies