Showing posts with label network. Show all posts
Showing posts with label network. Show all posts

Friday, March 23, 2012

Loopback Adapter Hides Instance Names

I have laptops that require the loopback adapter when they are not
connected. However when they connect back to the network the networked
servers display just the computer name not the / instancename. Any
ideas? It only happens on network instances. The local instances are
correct. This happens in Enterprise Manager, Access connection tool
and using SQL-DMO.
Gary Shane LimIn message <ogfj31dfgdq76mvs61hj3aofv0k6vpg1j0@.4ax.com>, Shane Lim
<gslim@.blizzardice.com> writes
>I have laptops that require the loopback adapter when they are not
>connected. However when they connect back to the network the networked
>servers display just the computer name not the / instancename. Any
>ideas? It only happens on network instances. The local instances are
>correct. This happens in Enterprise Manager, Access connection tool
>and using SQL-DMO.
>Gary Shane Lim
Have you tried Bridging the Loopback Adapter to your main Lan Adapter.
This way your network settings remain the same whether on the network or
not.
--
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com

Loopback Adapter Hides Instance Names

I have laptops that require the loopback adapter when they are not
connected. However when they connect back to the network the networked
servers display just the computer name not the / instancename. Any
ideas? It only happens on network instances. The local instances are
correct. This happens in Enterprise Manager, Access connection tool
and using SQL-DMO.
Gary Shane Lim
In message <ogfj31dfgdq76mvs61hj3aofv0k6vpg1j0@.4ax.com>, Shane Lim
<gslim@.blizzardice.com> writes
>I have laptops that require the loopback adapter when they are not
>connected. However when they connect back to the network the networked
>servers display just the computer name not the / instancename. Any
>ideas? It only happens on network instances. The local instances are
>correct. This happens in Enterprise Manager, Access connection tool
>and using SQL-DMO.
>Gary Shane Lim
Have you tried Bridging the Loopback Adapter to your main Lan Adapter.
This way your network settings remain the same whether on the network or
not.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
sql

Loopback Adapter Hides Instance Names

I have laptops that require the loopback adapter when they are not
connected. However when they connect back to the network the networked
servers display just the computer name not the / instancename. Any
ideas? It only happens on network instances. The local instances are
correct. This happens in Enterprise Manager, Access connection tool
and using SQL-DMO.
Gary Shane LimIn message <ogfj31dfgdq76mvs61hj3aofv0k6vpg1j0@.4ax.com>, Shane Lim
<gslim@.blizzardice.com> writes
>I have laptops that require the loopback adapter when they are not
>connected. However when they connect back to the network the networked
>servers display just the computer name not the / instancename. Any
>ideas? It only happens on network instances. The local instances are
>correct. This happens in Enterprise Manager, Access connection tool
>and using SQL-DMO.
>Gary Shane Lim
Have you tried Bridging the Loopback Adapter to your main Lan Adapter.
This way your network settings remain the same whether on the network or
not.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com

Wednesday, March 7, 2012

Looking for SQL installation documentation on a clustered network

Hi,
I am looking for a SQL 2000 installation documention on a clustered network.
Online links/documentation is preferred than books.
Thanks,
Mehul
Here are several resources related to SQL Clustering, some for SQL 2000 and
some for SQL 2005.
Cluster -How to Configure Virtual Server 2005 in Order to Setup a Test SQL
Server Cluster
http://www.sql-server-performance.co...al_server1.asp
Cluster -Installing a Failover Cluster
http://msdn2.microsoft.com/en-us/library/ms179410.aspx
Cluster -Patterns and Practices, High Availability
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Cluster -SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Cluster -TechNet Support WebCast: How to cluster Microsoft SQL Server 2005
by using Microsoft Virtual Server
http://support.microsoft.com/default.aspx?kbid=891798
Cluster -Using Microsoft Virtual Server 2005 to Create and Configure a
Two-Node Microsoft Windows Server 2003 Cluster
http://www.microsoft.com/technet/pro...y/cvs2005.mspx
Cluster
http://www.microsoft.com/technet/pro...lus.mspx#EUEBG
http://www.microsoft.com/windows2000...ustersteps.asp
http://www.support.microsoft.com/?id=254321
http://technet2.microsoft.com/Window...mspx?mfr=true
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Mehul" <Mehul@.discussions.microsoft.com> wrote in message
news:AD991F6F-9707-439E-B305-6F9961DA70D4@.microsoft.com...
> Hi,
> I am looking for a SQL 2000 installation documention on a clustered
> network.
> Online links/documentation is preferred than books.
> Thanks,
> Mehul