Can't connect to sql server

MEM

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?

ta5

Do you get an error message while trying to connect?
Thomas

MEM

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_Singleton

Can you connect SSMS to the server from the client?

MEM

David Singleton wrote:

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

garak

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 :?:

MEM

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!

MEM

No Firewall on the clients #-o

garak

garak wrote:

6. Have you tested if you can logon if you use a Client direct on the SQL Server or tested with SSMS :?:

MEM

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_Singleton

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:

garak

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?