| Author |
Topic |
|
Dennis Falls
Starting Member
41 Posts |
 Posted - 2006-06-13 : 14:19:19
|
| Ok, I'm about at my wits end. I have 4 laptops on our LAN running SQL Server 2000 Personal Edition. All have SP4 installed.The problem is that I am only able to register one of them from my Enterprise Manager. From the other 3, no matter what machine I try to register I get the error "SQLServer does not exist or access denied."As far as I can tell, the setup is the same on each instance. What can I possibly be missing? |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-13 : 16:41:39
|
| Sounds like the Service Pack for WinXp which ups the "Firewall strength" and makes SQL Server's ports invisible as a consequence.Kristen |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-13 : 16:47:25
|
| If Kristen's idea doesn't work, then you should try adding an alias on your client that points to these other boxes. You can add the client via Client Network Utility.Tara Kizeraka tduggan |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-06-14 : 01:11:33
|
| So add "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe" to the list of execptions in "Windows Firewall" or other 3rd party personal firewall you may be using.-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-14 : 01:37:27
|
| If the laptops will be connected to the internet I also recommend that you change the default port number for SQL - otherwise all the port scanners will be trying to hack the SA password and steal the data - and even if they don't succeed the onslaught will probably bring the machine to its knees.Kristen |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-06-14 : 02:03:08
|
| Most computers ARE connected to the internet, just not directly. So if you don't have a dial-up connection or ortherwise has a public IP adress, then that there is little to worry about.-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-14 : 02:07:14
|
| "Most computers ARE connected to the internet"Indeed, but my comment applies specifically if the firewall in XP is being disabled. Of course if there is further protection "downstream" - e.g. a company firewall - then that should be sufficient, but I was assuming that as they are laptops they will be connecting directly to the Internet!Kristen |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-06-14 : 02:20:26
|
| Im not saying you are wrong, just clarifying the 'connected to the internet' part.On a side note: A few years back I had a WinXP with no service packs that was getting a dial-up internet connection, it was infected with a virus with in the first 5-10 min it was online, so you wouldnt even have time to download and install any service packs or hotfixes, less to to say an antivirus program, before you get unwanted visitors. Its a harsh world out there in public-IP-land.-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those. |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-06-14 : 02:26:19
|
| Im not familiar with the Personal Edition, does it has tcp/ip connections enabled by default? If not then that needs to be activated as well.-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those. |
|
|
|
Dennis Falls
Starting Member
41 Posts |
Posted - 2006-06-14 : 10:35:17
|
| Thanks for the great suggestions. I was able to make the connections by adding the sqlservr.exe to the exceptions list. Of course this does not explain why I was able to connect to one of the laptops, that did not and still does not have that exception and is at the same version(both windows and sql server) as the other 3.So, do I now need to change the default port and if so, is there a recommended port?One further question, if I change the port, do I need to create an alias using the client network utility? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-14 : 13:02:59
|
| Only change the port if you will have people connecting to the database externally from the Internet. The recommendation for the port number is that it be 5 digits. And don't share it with anyone on the Internet.When you change the port, you might need to add an alias. Sometimes you don't, sometimes you do. I keep a reg file that has all of the instances that I need to connect to. I then send it to another DBA if he needs to get connected to the same ones that I do or if I get a new machine (my new laptop is coming on Friday!).Tara Kizeraka tduggan |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-06-14 : 13:10:58
|
| If the client and server is on the same LAN then you usually wont need to make an alias or otherwise explesitly use the port number when connecting, else you do. The client only tries to scan (or how ever it does it) for non standard port numbers when the server is on the same LAN segment.-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those. |
|
|
|
arshadkhwaja
Starting Member
5 Posts |
Posted - 2006-06-18 : 06:46:10
|
| Did ur server use windows security? |
|
|
|
|
Register SQL Server