3 Replies Latest reply on Sep 18, 2014 11:38 AM by markfreeman

    connecting to 2005 sql server on my UCServer

    buffit New Member

      I was able to do this a long time ago, but lost how I did it.

       

      I either want to connect either with an ODBC Data connector and use access 2010 or I want to use SQL server Management studio to connect to the UCServer.  It appears to be running SQL 2005.

       

      I get a message of it can be found or access denied.  I have the username and password, which I believe are correct.  But, I have no way to check to see if they are.

       

      Suggestions?

        • Re: connecting to 2005 sql server on my UCServer
          markfreeman Employee

          You can test your connection to the SQL server from a command prompt

           

          Enter the following

           

          osql -U user -P password -S Your_target_machine\Your_instance

           

          For example, I was able to test access to a remote SQL server with the following command from my UC Server

           

          osql -U TrainODBC -P Password1 -S ODBCSRV\NETVANTAUC

           

          -Mark

            • Re: connecting to 2005 sql server on my UCServer
              buffit New Member

              Mark,

               

              Thanks for the info, sorry took so long to get back to this.  I was able to get in, but have a new question.  The instance I got into was serverip\objectworld.

               

              I am seeing a lot of objects and such, but no real data.  Would there be a server name like you suggested \netvantatuc that might have the actual call data?

                • Re: connecting to 2005 sql server on my UCServer
                  markfreeman Employee

                  Buffit,

                  Sorry for late replay, been slammed teaching on the road for the past 5 weeks.  So it looks like your trying to connect to the UC Server SQL Database. ADTRAN does not recommend users to mess with these DBs. If you delete or mess something up, your UC Sever could break and Technical Support will not be able to assist you in fixing this since  this is not allowed.

                   

                  In class we teach that you can add new tables to this DB that you can use in the UC Server but we do not teach or recommend going through or changing the other tables.

                   

                  What exactly are you looking for or looking to do?

                   

                  -mark