Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2005-09-17 : 08:00:56
|
| Hi I have a SQL Server that uses mixed mode , I have given it a real IP ....from home when i connect on the dial up & use the EM & then try registering it using the real ip & the sa username & pasword .It says that Access denmied to the SQL Server..... or the server does not exists There is no firewall ... I am directly connected to the Internet & so is the SQL Box Can anyone please let me the reason for it & how to solve this problemThanks |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-17 : 10:17:09
|
Can you ping the IP address from home? I hope this isn't an SQL Server installation at your workplace. If so, you should be fired.  What port is the SQL SErver setup on? Did you enable TCP/IP protocol? Is that port traffic blocked from internet traffic by whatever network the SQL Server is hosted on?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2005-09-18 : 14:34:00
|
| Thanks derrickleggettCurrently I have not configured anything for the SQL box , its as a normal SQL that comes up with the default winzarde installation so i belive its port 1433.... There is nothing blocked by my internet. I can even ping the box.I did enable the TCP/IP....But still not able to connect |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-18 : 16:24:41
|
| Is this on your network at home? If so, are you using a linksys, d-link, or similar router to maintain your connection to the internet? If so, you will have to go into the router configuration and either:1. Add the host this SQL Server is on to the "DMZ" environment, or2. Enable outside access to TCP/IP port 1433. Before doing that, I would go ahead and change the port in the network configuration utility to something else and permit access to that particular port. You will then probably need to specify the port in whatever application is connecting from the internet. The format, depending on type of connection used, will be IP,port or IP:port.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
Connection to sql server fails