Can't connect to sql server

MEMMEM Member Posts: 57
I have a strange issue.

I installed an Sql server 2008, then I installed on the server a navision 5.01 sql client.

Then I created the database, the problem is that I did not succed to connect to this database from anothe computer.

All the machines are in the same damaine, I can ping on the IP adress of the server #-o :-k

any Idea?

Comments

  • ta5ta5 Member Posts: 1,164
    Do you get an error message while trying to connect?
    Thomas
  • MEMMEM Member Posts: 57
    ta5 wrote:
    Do you get an error message while trying to connect?
    Thomas

    yes

    No server response
    And when I try de find the server name in the Loginn form I can't find it.
    I can't also connect when I write the IP serve adress in the server name.
  • David_SingletonDavid_Singleton Member Posts: 5,479
    Can you connect SSMS to the server from the client?
    David Singleton
  • MEMMEM Member Posts: 57
    Can you connect SSMS to the server from the client?


    are you speaking about sql managment studio?

    I'm not a specialist of SQL so if you can explain me haw I do this I will test!

    Thank's
  • garakgarak Member Posts: 3,263
    Yes he mean the SQL Server Management Studio (SSMS).

    1. Do you connect via DNS Name or IP
    2. Has the SQL Server Insance a own name like MYSQLServer or is it the Default Name (Name of the Machine)
    2. if yes, u must enter as Servername in the loginwindow: IP\MYSQLSEVER or DNSNAME\MYSQLSERVER
    3. Windows or SQL Authent. :?:
    4. Have you checked the "Net Type" behind Tab "Advanced" on Form "Open Database":?: What is the setting there:?:
    5. is a Firewall activated on the CLient PCs and maybe there the Port for SQL blocked :?:

    6. Have you tested if you can logon if you use a Client direct on the SQL Server or tested with SSMS :?:
    Do you make it right, it works too!
  • MEMMEM Member Posts: 57
    1. Do you connect via DNS Name or IP
    I tried bouth with out success
    2. Has the SQL Server Insance a own name like MYSQLServer or is it the Default Name (Name of the Machine)
    2. if yes, u must enter as Servername in the loginwindow: IP\MYSQLSEVER or DNSNAME\MYSQLSERVER

    a standard name 2003SRV\SQL2008
    3. Windows or SQL Authent. :?:

    Sql authent
    4. Have you checked the "Net Type" behind Tab "Advanced" on Form "Open Database":?: What is the setting there:?:

    default
    5. is a Firewall activated on the CLient PCs and maybe there the Port for SQL blocked :?:

    I will check, good idea!
  • MEMMEM Member Posts: 57
    No Firewall on the clients #-o
  • garakgarak Member Posts: 3,263
    garak wrote:
    6. Have you tested if you can logon if you use a Client direct on the SQL Server or tested with SSMS :?:
    Do you make it right, it works too!
  • MEMMEM Member Posts: 57
    garak wrote:
    garak wrote:
    6. Have you tested if you can logon if you use a Client direct on the SQL Server or tested with SSMS :?:


    do you mean if I test to connect with a navision client installed on the sql server computer?

    Yes and I can connect to the database with out any problem but I can't connect via the other Clients in the network
  • David_SingletonDavid_Singleton Member Posts: 5,479
    garak wrote:
    6. Have you tested if you can logon if you use a Client direct on the SQL Server or tested with SSMS :?:

    Good idea, why didn't I think of that :whistle:
    David Singleton
  • garakgarak Member Posts: 3,263
    MEM wrote:
    garak wrote:
    garak wrote:
    6. Have you tested if you can logon if you use a Client direct on the SQL Server or tested with SSMS :?:


    do you mean if I test to connect with a navision client installed on the sql server computer?

    Yes and I can connect to the database with out any problem but I can't connect via the other Clients in the network

    Yes, that was i mean. But u doesn't need to install the client, copy the Clientfolder is enough.
    OK. On the servermachine self you can connect. But not viea network. Thats the point to start.

    What is the setting of the SQL server for remote connections?

    Got to SQL server (i mean remote not by foot) and open the "SQL Server Surface Area Configuration"
    (Start -> MS SQL Server 2005 -> Configuration Tools)

    Click there one Surface Area Configuration for Service and Connections.
    On the left site is Database Engine. Click on the + if it is not open (-)
    Click on Remote Connections.
    What is there set? Local Connections only or the second option. If second option, what is there the suboption?
    Do you make it right, it works too!
Sign In or Register to comment.