 |
|
|
|
Next: Transactional Replication
|
| Author |
Message |
External
Since: Oct 20, 2004
Posts: 15
|
(Msg. 1) Posted: Wed Nov 05, 2008 12:05 am
Post subject: SQL Server setup using multiple IP Addresses
Archived from groups: microsoft>public>sqlserver>setup (more info?)
|
|
|
I know it's not best practice, but i have a sql server (2000 Std) with two
NICs in two different LANs.
My Problem is that the sql server only responds to the first IP Address.
Even when i try connecting locally over the second ip address, the server
does not respond.
I searched through all settings, but did not find any option as just to
respond to one (given) ip address.
That SQL Server was setup to replace a server with an identical setup (reg.
the two LANs), where it worked. Unfortunately the sql server on the (old)
server fails to start (server was removed from the domain, ms sql service
does not start). So seeking for the solution on the (formerly) working
machine is not an option. |
|
| Back to top |
|
 | |
External
Since: Jan 15, 2007
Posts: 80
|
(Msg. 2) Posted: Fri Nov 07, 2008 2:08 pm
Post subject: Re: SQL Server setup using multiple IP Addresses [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Did you change operating systems?
Windows XP and Windows Server 2003 use the "weak host" model.
A connection on a network interface allows packets coming in on any other
network interface. Arrival interface reauthorization is used on a weak host
computer to implement interface-specific policies.
Vista and Windows Server 2008 use the "strong host" model.
A connection on a network interface accepts only packets that come in on the
same interface. Therefore, arrival interface reauthorization is not used on
a strong host computer.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"Markus" wrote in message
>I know it's not best practice, but i have a sql server (2000 Std) with two
> NICs in two different LANs.
>
> My Problem is that the sql server only responds to the first IP Address.
>
> Even when i try connecting locally over the second ip address, the server
> does not respond.
>
> I searched through all settings, but did not find any option as just to
> respond to one (given) ip address.
>
> That SQL Server was setup to replace a server with an identical setup
> (reg.
> the two LANs), where it worked. Unfortunately the sql server on the (old)
> server fails to start (server was removed from the domain, ms sql service
> does not start). So seeking for the solution on the (formerly) working
> machine is not an option. |
|
| Back to top |
|
| |
External
Since: Oct 20, 2004
Posts: 15
|
(Msg. 3) Posted: Sat Nov 08, 2008 2:05 am
Post subject: Re: SQL Server setup using multiple IP Addresses [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I did not CHANGE the OS, i restored the backup from the old sql server on a
new one, running windows 2003.
I don't see where your explanation is going...
So basically i have two networks on the machine and SQL Server is only
responding to requests on one of the two - in sql server 2005 i can choose
if the server is responding to which ip addresses...
didn't find sth similar in 2k.
Br,
Markus
"Rick Byham, (MSFT)" wrote:
> Did you change operating systems?
> Windows XP and Windows Server 2003 use the "weak host" model.
> A connection on a network interface allows packets coming in on any other
> network interface. Arrival interface reauthorization is used on a weak host
> computer to implement interface-specific policies.
>
> Vista and Windows Server 2008 use the "strong host" model.
> A connection on a network interface accepts only packets that come in on the
> same interface. Therefore, arrival interface reauthorization is not used on
> a strong host computer.
>
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no rights.
> >> Stay informed about: SQL Server setup using multiple IP Addresses |
|
| Back to top |
|
| |
External
Since: Jan 15, 2007
Posts: 80
|
(Msg. 4) Posted: Mon Nov 10, 2008 9:27 am
Post subject: Re: SQL Server setup using multiple IP Addresses [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I was thinking of a possible explanation that only occurs when the computer
is Vista or Windows Server 2003 and when the firewall is on. What is your
OS? If you turn off the firewall can you connect through the second IP
address indicating that the firewall setting is part of the problem?
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"Markus" wrote in message
>I did not CHANGE the OS, i restored the backup from the old sql server on a
> new one, running windows 2003.
>
> I don't see where your explanation is going...
>
> So basically i have two networks on the machine and SQL Server is only
> responding to requests on one of the two - in sql server 2005 i can
> choose
> if the server is responding to which ip addresses...
>
> didn't find sth similar in 2k.
>
> Br,
>
> Markus
>
> "Rick Byham, (MSFT)" wrote:
>
>> Did you change operating systems?
>> Windows XP and Windows Server 2003 use the "weak host" model.
>> A connection on a network interface allows packets coming in on any other
>> network interface. Arrival interface reauthorization is used on a weak
>> host
>> computer to implement interface-specific policies.
>>
>> Vista and Windows Server 2008 use the "strong host" model.
>> A connection on a network interface accepts only packets that come in on
>> the
>> same interface. Therefore, arrival interface reauthorization is not used
>> on
>> a strong host computer.
>>
>> --
>> Rick Byham (MSFT), SQL Server Books Online
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> >> Stay informed about: SQL Server setup using multiple IP Addresses |
|
| Back to top |
|
| |
External
Since: Oct 20, 2004
Posts: 15
|
(Msg. 5) Posted: Tue Nov 11, 2008 1:56 am
Post subject: Re: SQL Server setup using multiple IP Addresses [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Rick,
Thanks for coming back to this -
as i pointed out above, the system is Win2003. Firewallfunctions are
completely disabled.
It does not seem to be a Windows Problem... (Ping, Network share etc are
working over that ip)
"Rick Byham, (MSFT)" wrote:
> I was thinking of a possible explanation that only occurs when the computer
> is Vista or Windows Server 2003 and when the firewall is on. What is your
> OS? If you turn off the firewall can you connect through the second IP
> address indicating that the firewall setting is part of the problem?
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no rights. >> Stay informed about: SQL Server setup using multiple IP Addresses |
|
| Back to top |
|
| |
External
Since: Jan 15, 2007
Posts: 80
|
(Msg. 6) Posted: Tue Nov 11, 2008 9:00 am
Post subject: Re: SQL Server setup using multiple IP Addresses [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Check the SQL Server error log. It should have a statement similar to :
2008-10-24 08:24:55.93 server SQL server listening on <IPaddress>: <port
number>.
That can at least tell you what SQL Server thinks it's doing.
Are both IP addresses listed? Are there any errors?
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"Markus" wrote in message
> Hi Rick,
>
> Thanks for coming back to this -
>
> as i pointed out above, the system is Win2003. Firewallfunctions are
> completely disabled.
>
> It does not seem to be a Windows Problem... (Ping, Network share etc are
> working over that ip)
>
>
>
> "Rick Byham, (MSFT)" wrote:
>
>> I was thinking of a possible explanation that only occurs when the
>> computer
>> is Vista or Windows Server 2003 and when the firewall is on. What is your
>> OS? If you turn off the firewall can you connect through the second IP
>> address indicating that the firewall setting is part of the problem?
>> --
>> Rick Byham (MSFT), SQL Server Books Online
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
> >> Stay informed about: SQL Server setup using multiple IP Addresses |
|
| Back to top |
|
| |
External
Since: Oct 20, 2004
Posts: 15
|
(Msg. 7) Posted: Wed Nov 12, 2008 6:23 am
Post subject: Re: SQL Server setup using multiple IP Addresses [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
The Error Log just states that the sql server is monitoring Named Pipes and
Shared Memory, TCP / IP in general is working, though...
I found the solution now:
i had to remove TCP / IP from the used Protocols and Enable it again, then
restart the sql server to ahve it running on (later installed) additional
Network Interfaces.
Hope this helps anyone!
Markus
"Rick Byham, (MSFT)" wrote:
> Check the SQL Server error log. It should have a statement similar to :
> 2008-10-24 08:24:55.93 server SQL server listening on <IPaddress>: <port
> number>.
>
> That can at least tell you what SQL Server thinks it's doing.
> Are both IP addresses listed? Are there any errors?
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no rights. >> Stay informed about: SQL Server setup using multiple IP Addresses |
|
| Back to top |
|
| |
| Related Topics: | SQL Server Setup could not run - I am trying to install sql 2005 but i am getting that error: SQL Server Setup could not run. Another instance of SQL Server Setup is already running. The running instance must complete before you can run SQL Server Setup again. Message pump returning:....
SQL Server 2005 Setup - I try to install SQL Server 2005, but when the setup install the Framework 2.0 find the Beta Components (I unistall the VS2005 Beta and all components) What i make? Victor
sql server 2000 setup - I have the evaluation edition of SQL Server 2000 and trying to install the 'client tools' namely the Enterprise Manager on my PC. I'm getting an error when running the installation program. I get as far as choosing the location to install to, and..
Linked server setup - I have to setup the link server.the Remote server is alrady registered in my enterprise mangaer using Client Network utility. When i setup the Linked server,error message says:- the server does not exist or access denied. Can you help me the General...
SQL Server Setup + System Resources - Hi All, My company currently has SBS 2003 Premium which comes with SQL server 2000. We are considering installing SQL server for an optional server component which is not essential, and therefore we would like to know if SQL Server 2000 uses up a lot of... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
