New Server Cannot 'See Out'

Hi All,
Not sure where to put this post, hope this is the right place.
Relatively new to SQL, not sure what info you need, so here we go: We
have a Windows 2000 Server running SQL 2000 ("Server1) in location 1.
This server is outside of the firewall.
We have a network setup in location 2 where we are doing development and
also have a server in that location (everything at location 2 is behind
the same firewall). There is a new server in location 2 running Windows
2003 Server and SQL Server 2005.
The problem is that Server2 cannot see Server1, and Server1 cannot see
Server2.
If, using Object Explorer, I click Connect > Database Engine, and put in
the details for Server2, I get an error that the database does not reply.
Also, if trying to connect from Server2 to Server1 (registering a db), I
get an access denied or does not exist error.
Any of the development machines at location 2 can see and connect to
Server1, but Server2 cannot. Also, any of the Dev machines can see and
connect to Server2 as well, but Server1 cannot.
1433 is not blocked in the firewall of location2, since all Dev machines
can access SQL on Server1.
I'm really at a loss, and any ideas would be most helpful.
Thanks,
MichaelIt sounds like port 1433 is blocked at the firewall. The firewall is between
Server1 and Location2, nothing is going through the firewall.
You need to open a port (the default is 1433) in the firewall to allow 2-way
tcp traffic, and then set a firewall rule that restricts traffic to just the
IP addresses of Server1 and Server2.
And if you want a bit more obscurity, you could even use a different port.
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Michael" <itsjustme@.nospam.nospam> wrote in message
news:OK6RHwkoGHA.516@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> Not sure where to put this post, hope this is the right place. Relatively
> new to SQL, not sure what info you need, so here we go: We have a Windows
> 2000 Server running SQL 2000 ("Server1) in location 1. This server is
> outside of the firewall.
> We have a network setup in location 2 where we are doing development and
> also have a server in that location (everything at location 2 is behind
> the same firewall). There is a new server in location 2 running Windows
> 2003 Server and SQL Server 2005.
> The problem is that Server2 cannot see Server1, and Server1 cannot see
> Server2.
> If, using Object Explorer, I click Connect > Database Engine, and put in
> the details for Server2, I get an error that the database does not reply.
> Also, if trying to connect from Server2 to Server1 (registering a db), I
> get an access denied or does not exist error.
> Any of the development machines at location 2 can see and connect to
> Server1, but Server2 cannot. Also, any of the Dev machines can see and
> connect to Server2 as well, but Server1 cannot.
> 1433 is not blocked in the firewall of location2, since all Dev machines
> can access SQL on Server1.
> I'm really at a loss, and any ideas would be most helpful.
> Thanks,
> Michael|||HI,
Thanks, but thats not it. Remember, we have numerous developer systems
sitting behind the same firewall, each has SQL 2005 developer version
installed, and they have perfect communication through the firewall with
Server1.
Arnie Rowland wrote:
> It sounds like port 1433 is blocked at the firewall. The firewall is betwe
en
> Server1 and Location2, nothing is going through the firewall.
> You need to open a port (the default is 1433) in the firewall to allow 2-w
ay
> tcp traffic, and then set a firewall rule that restricts traffic to just t
he
> IP addresses of Server1 and Server2.
> And if you want a bit more obscurity, you could even use a different port.
>|||Hi Michael,
Thank you for your posting!
Would you please try to add an alias of the Server1 in the server 2?
Please follow these steps:
1. Open Start Menu, All Programs, Microsoft SQL Server 2005, Configuration
Tools, SQL Server Configuration Manager.
2. In the left panel, click SQL Native Client Configuration, then
right-click Aliases, click New Alias.
3. In the Alias-New dialogbox, please type the Alias Name you want , and
type the Server1 name in the server section. Type 1433 in the Port No.
After that, please click OK.
4. Please try to connect to the Server 1 and let me know the result. Thank
you!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Also, make sure you look at the network configuration tab (Right-click in
enterprise manager on the server in question, choose properties) of the
MSDE/SQL Server itself. Sometimes the named pipes and TCP/IP protocols do no
t
get added, and therefore nothing other than enterprise manager can connect!
James
"Wei Lu [MSFT]" wrote:

> Hi Michael,
> Thank you for your posting!
> Would you please try to add an alias of the Server1 in the server 2?
> Please follow these steps:
> 1. Open Start Menu, All Programs, Microsoft SQL Server 2005, Configuration
> Tools, SQL Server Configuration Manager.
> 2. In the left panel, click SQL Native Client Configuration, then
> right-click Aliases, click New Alias.
> 3. In the Alias-New dialogbox, please type the Alias Name you want , and
> type the Server1 name in the server section. Type 1433 in the Port No.
> After that, please click OK.
> 4. Please try to connect to the Server 1 and let me know the result. Thank
> you!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Wei Lu and James,
I followed your directions and created the Alias (and ensured the
protocols are present). I then logged into Server 2 and did exactly
these steps:
Start > All Programs > Mircosoft SQL Server 2005 > SQL Server Management
Studio.
Once it opened, I logged into the local instance of SQL Server. Then, I
did these steps:
In Object Explorer (along left side of screen, with only my local
instance showing), I clicked Connect > Database Engine. I then entered
the following information:
Server Name = 64.203.xxx.xxx
Authentication = SQL Server Authentication
username = xxx
password = xxx
On the Connection Properties tab, I tried it with default, and also
TCP/IP. Each time, I get the message below:
TITLE: Connect to Server
--
Cannot connect to 64.203.xxx.xxx
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: TCP Provider, error: 0 - A connection attempt
failed because the connected party did not properly respond after a
period of time, or established connection failed because connected host
has failed to respond.) (Microsoft SQL Server, Error: 10060)
Am I doing something wrong or missing something?
Thanks,
Michael
ps. Sorry for my delayed response, was out with a severe cold.
James Vickers wrote:[vbcol=seagreen]
> Also, make sure you look at the network configuration tab (Right-click in
> enterprise manager on the server in question, choose properties) of the
> MSDE/SQL Server itself. Sometimes the named pipes and TCP/IP protocols do
not
> get added, and therefore nothing other than enterprise manager can connect
!
> James
>
> "Wei Lu [MSFT]" wrote:
>|||Hi Michael,
Thank you for the update.
From your description, I suggest you to make sure you could connect to the
SQL Server 2000 now.
Here is an article for you to troubleshoot the connectivity issue:
827422 How to troubleshoot connectivity issues in SQL Server 2000
http://support.microsoft.com/defaul...kb;EN-US;827422
Hope this will be helpful!
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
You may want to check if client machine in location 1 can access server1
properly. Also, please note that if it is not default instance, you shall
configure a static port on server and open it via firewall.
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/kb/287932/EN-US/
You may want to ping from server2 to server1, and use the following command
to check if port is opened properly
telnet <server1> 1433
If you have any update, please let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============

New Database Error Message

I am relatively new to SQL Server. I created a new
database with (and without) the new database wizard.
When I get to the end of the wizard, I get an error
message [error 1038] indicating that I cannot use empty
object or column and should use a space instead. The new
database gets created and is listed in the tree diagram.
I get a similar error message when I open the new
database and try and add a new table to it. I am running
on the local server. Anyone have any ideas?
Thanks.
Joe
I have never run across this error but do you have spaces in any of your
object names by any chance?
Andrew J. Kelly SQL MVP
"Joe" <josephmicheli@.sbcglobal.net> wrote in message
news:740101c494d6$7bc4be20$a601280a@.phx.gbl...
> I am relatively new to SQL Server. I created a new
> database with (and without) the new database wizard.
> When I get to the end of the wizard, I get an error
> message [error 1038] indicating that I cannot use empty
> object or column and should use a space instead. The new
> database gets created and is listed in the tree diagram.
> I get a similar error message when I open the new
> database and try and add a new table to it. I am running
> on the local server. Anyone have any ideas?
> Thanks.
> Joe
|||The the new database I created was a default created by
the wizard. The wizard did not allow me to add/modify any
of the objects in the database. I believe it uses
the "model" database that comes with SQL Server 2000. When
I compared the new one to the model, the number of tables
were the same (19) and the table names looked to be the
same.
>--Original Message--
>I have never run across this error but do you have spaces
in any of your[vbcol=seagreen]
>object names by any chance?
>--
>Andrew J. Kelly SQL MVP
>
>"Joe" <josephmicheli@.sbcglobal.net> wrote in message
>news:740101c494d6$7bc4be20$a601280a@.phx.gbl...
new[vbcol=seagreen]
running
>
>.
>
|||I never use the wizard so I wasn't sure what was going on and if maybe you
tried to use spaces in the DB name. You might want to get in the habit of
using commands such as CREATE DATABASE instead. This allows for much more
control and better information if an error occurs. To create a database is
pretty easy. Check out CREATE DATABASE in BooksOnLine for samples and
details.
Andrew J. Kelly SQL MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:089101c494df$69d374a0$a401280a@.phx.gbl...[vbcol=seagreen]
> The the new database I created was a default created by
> the wizard. The wizard did not allow me to add/modify any
> of the objects in the database. I believe it uses
> the "model" database that comes with SQL Server 2000. When
> I compared the new one to the model, the number of tables
> were the same (19) and the table names looked to be the
> same.
> in any of your
> new
> running