| Author |
Topic |
|
nvella
Starting Member
8 Posts |
 Posted - 2008-01-17 : 07:07:29
|
| Hi everybody, its my first time implementing sql express 2005.basically we installed sql express 2005 sp2 on a file sharing server. server is connected to another 7 work stations. all work stations can ping server, but not all of them can connect to the sql server. some connect without a problem and others give us a timeout expired (most common error we get). we use the sql login sa, and also have created logins so we can access through windows auth. can anyone give me an insight to this problem or maybe someone has encountered this problem?thanks |
|
|
nvella
Starting Member
8 Posts |
Posted - 2008-01-17 : 07:21:04
|
| forgot to add....all work stations have same settings, ports 1434 and 1433 and sql browser are enabled. and can telnet the server. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-19 : 23:53:29
|
| Do you use same protocol (tcp/ip, named pipes) on those machines? |
|
|
|
nvella
Starting Member
8 Posts |
Posted - 2008-01-21 : 10:56:59
|
| after some testing idecided to switch off the server windows firewall, which apparently wasnt making any exceptions on the ports mentioned before. In this sense i made a step forward to getting to the root of the porblem, although i still have to find out how i have to configure this firewall so i can leave it running but allowing me remote connections. |
|
|
|
sa_keles
Starting Member
9 Posts |
Posted - 2008-01-24 : 07:36:36
|
| open your firawall, there will be a link (change preferences or something like this) on special stuations tab there will be add connection point(or something like this) you can add your port there (should be 1433 but not sure)Open up your heart and let the sun shine in |
|
|
|
nvella
Starting Member
8 Posts |
Posted - 2008-01-24 : 07:41:40
|
| already done that but seems firewall is ignoring the rule, done it for udp 1434, tcp 1433, sqlbrowser.exe and sqlservr.exe |
|
|
|
sa_keles
Starting Member
9 Posts |
Posted - 2008-01-24 : 08:13:21
|
| could be another firewall? you should check your virus program, windows firewall and other firewall programs if installedOpen up your heart and let the sun shine in |
|
|
|
nvella
Starting Member
8 Posts |
Posted - 2008-01-24 : 08:40:34
|
| none of that...client has only widnows firewall on his server! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-24 : 23:01:23
|
| Did you check which protocol used on those machines? |
|
|
|
nvella
Starting Member
8 Posts |
Posted - 2008-01-25 : 05:39:05
|
| Yes already mentioned in the above posts, i am using uniform protocols on all machines and all machines with the above mentioned ports and services in the exception tab of the windows firewall. I have no idea where else i am going to look tof ind the casue of the problem but for now client is working with firewall switched off as its only a relatively small business using server for file sharing purposes. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-26 : 00:46:52
|
| What's uniform protocol? Sql uses tcp/ip or named pipes, double check in sql server configuration manager. |
|
|
|
nvella
Starting Member
8 Posts |
Posted - 2008-01-28 : 03:00:19
|
| with uniform protocol i meant same protocols, as in tcp/ip and named pipes, they are both enabled. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 20:51:26
|
| But client only uses one protocol to talk to sql server. |
|
|
|
nvella
Starting Member
8 Posts |
Posted - 2008-01-29 : 03:09:00
|
| you can choose to activate one of them or both anyway the client decied to switch off the firewall. |
|
|
|
|
Help needed for sql express