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?
0
Comments
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.
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
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 :?:
a standard name 2003SRV\SQL2008
Sql authent
default
I will check, good idea!
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
Good idea, why didn't I think of that :whistle:
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?