Showing results 1 to 10 of 10

Thread: Problem with remote connection to Analyzer SQL Server

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Problem with remote connection to Analyzer SQL Server

    Hello colleagues
    I installed Zenon Analyzer v2.1 (SQL Server and Manager) on server computer with Windows 7 Professional Rus x64 and ZAMS on another engineering computer with Windows 7 Professional Rus x32.
    ZAMS on server(local) PC can connect to Analyzer SQL Server without any problem.

    But ZAMS on engineering computer couldn’t connect to Analyzer SQL Server. When I started function “Refresh server list” ZAMS didn’t show Analyzer SQL Server in scanning list at all. Although another SQL servers from server were displayed. If I specified database server manual when got error, screenshot is in attacmets.

    Both computers are in common domain and have same users with authorization rights on the license server and Analyzer Manager. A network connection was established and tcp port is opened. The remote connection to Analyzer SQL server was allowed. All SQL server services were started.

    Why ZAMS from engineering PC can’t find Analyzer SQL Server? How to find a reason?
    Is this a limit of my demo license?

    best regards
    Attached Thumbnails Attached Thumbnails lic.jpg   sql server profile.jpg   connect_error.jpg  

  2. #2
    Join Date
    15.07.2011
    Posts
    18

    Default Re: Problem with remote connection to Analyzer SQL Server

    It is definatly not a restriction of the demo-license. You have all Options and it is just time limited.


    What happens if you click on in the Login Dialog and you enter the SQL-instance manually? (Syntax: GERMANOV-NOTE\ZA2)
    Then it directly tries to Access the SQL-Server. If this is successful, you just Need to select the database you want to be connected to from the list and confirm the Login Dialog.

  3. #3

    Default Re: Problem with remote connection to Analyzer SQL Server

    Hello Thomas

    When I click on in the Login Dialog and you enter the SQL-instance manually then I get error, you can see this error on screen shot in my previous message.

    I also tried to connect to this SQL server from remote (engineering) PC using software built into windows. And got error - "SQL server not exist or access denied". But I already made full access for domain user, you can see screenshots in attachments.

    A possibility to select necessary SQL server from list is better then waiting for 5 minutes for "Refresh server list" or to enter server name manually.

    bet regars
    Attached Thumbnails Attached Thumbnails sql_list.jpg   mes1.jpg  
    Attached Files Attached Files

  4. #4
    Join Date
    15.07.2011
    Posts
    18

    Default Re: Problem with remote connection to Analyzer SQL Server

    For searching SQL-instances basic Windows functionality is used.. For any reasons the other PC cannot be seen. Can you ping the Analyzer Server from the Client-Computer? Can you connect from the Client Computer with the SQL Server Management Studio to the SQL-Instance? Did you try to disable the User Account Control?

    Pease check this.

  5. #5

    Default Re: Problem with remote connection to Analyzer SQL Server

    Hello Thomas

    Ping to server by IP work good. But ping by name don't work and show incorrect IP address.
    Tomorrow I will ask our admin about it.
    Attached Thumbnails Attached Thumbnails connect.jpg  

  6. #6
    Join Date
    15.07.2011
    Posts
    18

    Default Re: Problem with remote connection to Analyzer SQL Server

    Hello Altera,

    ZAMS can also work with the IP-Address instead of the computer name. Unless you have solved the Problem with the Name Resolution you can use the IP.

  7. #7

    Default Re: Problem with remote connection to Analyzer SQL Server

    Hello Thomas

    Now ping to Analyzer server PC by name is OK.
    But SQL Server Management Studio on client PC still can't connect to the SQL-Instance also.
    May be google will help me but now I don't understand a reason.

  8. #8
    Join Date
    15.07.2011
    Posts
    18

    Default Re: Problem with remote connection to Analyzer SQL Server

    Hello altera,

    If also the SQL Server Management Studio cannot connect it must be a Basic Problem. I suppose you used the same user to Login as on the Analyzer Server. For me it seems to be a Firewall Problem on the Server or on the Client PC.

Similar Threads

  1. Zenon server & Client Connection
    By sidramsatyal in forum zenon Network
    Replies: 3
    Last Post: 7th July 2014, 13:26
  2. Historian SQL Server
    By junior in forum zenon Supervisor
    Replies: 3
    Last Post: 27th March 2014, 14:27
  3. SQL Server Logdatei
    By kwb in forum zenon Supervisor
    Replies: 1
    Last Post: 3rd March 2009, 12:00
  4. Problem with OPC Connection
    By mastr in forum Drivers
    Replies: 1
    Last Post: 20th August 2008, 13:14
  5. Timeseries data and SQL Server
    By nsko in forum Drivers
    Replies: 2
    Last Post: 28th May 2008, 08:20

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •