no items in SQL Server Group

In my enterprise mngr under Microsoft sql Servers
Sql Server Group

I see (No Items)

My network guy doesnt no much about this and i know nothing (all my experience is with db on my local hd.

Please let me know as much as possible.

ThanksYou must first a register a sever, right mouse button within sql server groups.

No connection to local SQL Server when no network connection

Hi !
We are using Windows XP,
ADO.NET in our application (programming language: C#),
MS SQL Server 2000.
The computer is a SONY notebook.
SQL server is running on the same machine as the application.
The application has worked in many, many cases under W2K and even XP.
But on that computer it doesn't work:
When there is no network connection,
then the application CANNOT connect to our DB.
On the other hand, Enterprise Manager CAN connect.
When we plug in the network and restart the computer,
then the application CAN connect.
However, SQL Server is running locally !
The connection string for connecting our app to the database is something
like:
sqlConnection.ConnectionString =
"packet size=4096;user id=BIS;persist security info=false;initial
catalog=BIS; server=(local)";
How can we fix that problem ?
Your kind help would be appreciated.
Peter
I have had similar issues - am not sure why though.
However,I seem to be able to connect by either using the (local) or the
actual PC name - it just seems to change its behaviour depending on the
network connectivity status.
Hope this is of some help.
LeMuppet
lemuppet
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message411117.html

No connection to local SQL Server when no network connection

Hi !
We are using Windows XP,
ADO in our application,
MS SQL Server 2000.
(Programming language: Delphi 5;
ADO components: from Adonis;
The computer is a SONY notebook).
SQL server is running on the same machine as the application.
The application has worked in many, many cases under W2K and even XP.
But on that computer it doesn't work:
When there is no network connection, then the application CANNOT connect to
our DB.
On the other hand, Enterprise Manager CAN connect.
When we plug in the network and restart the computer, then the application
CAN connect.
However, SQL Server is running locally !
The connection string for connecting our app to the database is something
like:
'Provider=SQLOLEDB.1; Password="";Persist Security Info=True;User
ID=Bis;Initial Catalog=BIS;Data Source=127.0.0.1'
How can we fix that problem ?
Is this a problem of MS SQL Server administration ?
Your kind help would be appreciated.
PeterThe soluition is to use named pipes to connect as
Enterprise manager will if IP: 127.0.0.1 cannot connect.
Change your connection string to :
'Provider=SQLOLEDB.1; Password="";Persist Security
Info=True;User
ID=Bis;Initial Catalog=BIS;Data Source=(local)'
This should fix the problem.
>--Original Message--
>Hi !
>We are using Windows XP,
>ADO in our application,
>MS SQL Server 2000.
>(Programming language: Delphi 5;
> ADO components: from Adonis;
> The computer is a SONY notebook).
>SQL server is running on the same machine as the
application.
>The application has worked in many, many cases under W2K
and even XP.
>But on that computer it doesn't work:
>When there is no network connection, then the application
CANNOT connect to
>our DB.
>On the other hand, Enterprise Manager CAN connect.
>When we plug in the network and restart the computer,
then the application
>CAN connect.
>However, SQL Server is running locally !
>The connection string for connecting our app to the
database is something
>like:
> 'Provider=SQLOLEDB.1; Password="";Persist Security
Info=True;User
>ID=Bis;Initial Catalog=BIS;Data Source=127.0.0.1'
>How can we fix that problem ?
>Is this a problem of MS SQL Server administration ?
>Your kind help would be appreciated.
>Peter
>
>.
>|||> Change your connection string to :
> 'Provider=SQLOLEDB.1; Password="";Persist Security
> Info=True;User
> ID=Bis;Initial Catalog=BIS;Data Source=(local)'
It worked.
Thanks a lot !

No connection to local SQL Server when no network connection

The soluition is to use named pipes to connect as
Enterprise manager will if IP: 127.0.0.1 cannot connect.
Change your connection string to :
'Provider=SQLOLEDB.1; Password="";Persist Security
Info=True;User
ID=Bis;Initial Catalog=BIS;Data Source=(local)'
This should fix the problem.

>--Original Message--
>Hi !
>We are using Windows XP,
>ADO in our application,
>MS SQL Server 2000.
>(Programming language: Delphi 5;
> ADO components: from Adonis;
> The computer is a SONY notebook).
>SQL server is running on the same machine as the
application.
>The application has worked in many, many cases under W2K
and even XP.
>But on that computer it doesn't work:
>When there is no network connection, then the application
CANNOT connect to
>our DB.
>On the other hand, Enterprise Manager CAN connect.
>When we plug in the network and restart the computer,
then the application
>CAN connect.
>However, SQL Server is running locally !
>The connection string for connecting our app to the
database is something
>like:
> 'Provider=SQLOLEDB.1; Password="";Persist Security
Info=True;User
>ID=Bis;Initial Catalog=BIS;Data Source=127.0.0.1'
>How can we fix that problem ?
>Is this a problem of MS SQL Server administration ?
>Your kind help would be appreciated.
>Peter
>
>.
>
> Change your connection string to :
> 'Provider=SQLOLEDB.1; Password="";Persist Security
> Info=True;User
> ID=Bis;Initial Catalog=BIS;Data Source=(local)'
It worked.
Thanks a lot !

No Agent Indication

How can I tell if my SQL Server Agent is running without using the EM? The
network admins have control of the server in such a way as to not let the DBA
start or stop the service on the server. This of course does not light up
the indicator in the EM for the Agent.Hi
If you run sp_who2 or query sysprocesses, you will see connections from
Agent. They are always there as they poll for jobs.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D060BCE2-BE0D-493A-81FD-C0E7E18C9E15@.microsoft.com...
> How can I tell if my SQL Server Agent is running without using the EM?
> The
> network admins have control of the server in such a way as to not let the
> DBA
> start or stop the service on the server. This of course does not light up
> the indicator in the EM for the Agent.sql

NLB and SQL2005

Hi,
early on in SQL2005 (Yukon's) life, there was talk for Network Load
Balancing support.
Now that it's (more or less) out, the documentation makes no mention of
support for NLB.
There's talk of clusters, mirroring and replication and while mirroring
seems to come close, it's still and active/passive configuration (with the
addition of a watcher!).
Hopefully this is just buried in the docs somewhere on the install CD (I'm
waiting for the Dec MSDN DVDs, which presumably will include SQL2005 RTM),
but I'd have thought it would be online somewhere.
Anyone spotted it?
Thanks
CraigThere is no "NLB" or other form of transparent SQL scale-out in SQL Server
2005 (other than the Distributed Partitioned Views carried over from SQL
Server 2000). Mirroring does allow the mirror copy to be accessed read-only
for reporting. And there is a shared read-only reporting database feature.
In some cases those address the need for scale-out.
There is the notion of a Service-Oriented Database Architecture (SODA) in
SQL Server 2005 that can be used to achieve scale-out. It is transparent at
the level of a service interface, not at the level of SQL. It isn't
explicitly talked about in BOL. I wrote a white paper about it a year ago,
but haven't seen Microsoft publish it yet. It was supposed to be available
at launch. Dave Campbell has given presentations on it, at launch and I
believe also at PDC (and perhaps PASS).
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Craig Humphrey" <CraigHumphreyHatesSpam@.newsgroup.nospam> wrote in message
news:uWpmgmX6FHA.3684@.TK2MSFTNGP12.phx.gbl...
> Hi,
> early on in SQL2005 (Yukon's) life, there was talk for Network Load
> Balancing support.
> Now that it's (more or less) out, the documentation makes no mention of
> support for NLB.
> There's talk of clusters, mirroring and replication and while mirroring
> seems to come close, it's still and active/passive configuration (with the
> addition of a watcher!).
> Hopefully this is just buried in the docs somewhere on the install CD (I'm
> waiting for the Dec MSDN DVDs, which presumably will include SQL2005 RTM),
> but I'd have thought it would be online somewhere.
> Anyone spotted it?
> Thanks
> Craig
>|||In addition to Hal's comments:
For mirroring, you will probably be able to define a database snapshot of a
mirrored database and
use that snapshot as a read-only database. However, you will work against a
snapshot which will be
up to as old as the interval for creating the snapshots.
Also, you can have several database instances accessing the same read-only d
ata using the SSB
thinking: http://support.microsoft.com/?kbid=910378
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Craig Humphrey" <CraigHumphreyHatesSpam@.newsgroup.nospam> wrote in message
news:uWpmgmX6FHA.3684@.TK2MSFTNGP12.phx.gbl...
> Hi,
> early on in SQL2005 (Yukon's) life, there was talk for Network Load Balanc
ing support.
> Now that it's (more or less) out, the documentation makes no mention of su
pport for NLB.
> There's talk of clusters, mirroring and replication and while mirroring se
ems to come close, it's
> still and active/passive configuration (with the addition of a watcher!).
> Hopefully this is just buried in the docs somewhere on the install CD (I'm
waiting for the Dec
> MSDN DVDs, which presumably will include SQL2005 RTM), but I'd have though
t it would be online
> somewhere.
> Anyone spotted it?
> Thanks
> Craig
>

NLB and SQL2005

Hi,
early on in SQL2005 (Yukon's) life, there was talk for Network Load
Balancing support.
Now that it's (more or less) out, the documentation makes no mention of
support for NLB.
There's talk of clusters, mirroring and replication and while mirroring
seems to come close, it's still and active/passive configuration (with the
addition of a watcher!).
Hopefully this is just buried in the docs somewhere on the install CD (I'm
waiting for the Dec MSDN DVDs, which presumably will include SQL2005 RTM),
but I'd have thought it would be online somewhere.
Anyone spotted it?
Thanks
CraigThere is no "NLB" or other form of transparent SQL scale-out in SQL Server
2005 (other than the Distributed Partitioned Views carried over from SQL
Server 2000). Mirroring does allow the mirror copy to be accessed read-only
for reporting. And there is a shared read-only reporting database feature.
In some cases those address the need for scale-out.
There is the notion of a Service-Oriented Database Architecture (SODA) in
SQL Server 2005 that can be used to achieve scale-out. It is transparent at
the level of a service interface, not at the level of SQL. It isn't
explicitly talked about in BOL. I wrote a white paper about it a year ago,
but haven't seen Microsoft publish it yet. It was supposed to be available
at launch. Dave Campbell has given presentations on it, at launch and I
believe also at PDC (and perhaps PASS).
--
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Craig Humphrey" <CraigHumphreyHatesSpam@.newsgroup.nospam> wrote in message
news:uWpmgmX6FHA.3684@.TK2MSFTNGP12.phx.gbl...
> Hi,
> early on in SQL2005 (Yukon's) life, there was talk for Network Load
> Balancing support.
> Now that it's (more or less) out, the documentation makes no mention of
> support for NLB.
> There's talk of clusters, mirroring and replication and while mirroring
> seems to come close, it's still and active/passive configuration (with the
> addition of a watcher!).
> Hopefully this is just buried in the docs somewhere on the install CD (I'm
> waiting for the Dec MSDN DVDs, which presumably will include SQL2005 RTM),
> but I'd have thought it would be online somewhere.
> Anyone spotted it?
> Thanks
> Craig
>|||In addition to Hal's comments:
For mirroring, you will probably be able to define a database snapshot of a mirrored database and
use that snapshot as a read-only database. However, you will work against a snapshot which will be
up to as old as the interval for creating the snapshots.
Also, you can have several database instances accessing the same read-only data using the SSB
thinking: http://support.microsoft.com/?kbid=910378
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Craig Humphrey" <CraigHumphreyHatesSpam@.newsgroup.nospam> wrote in message
news:uWpmgmX6FHA.3684@.TK2MSFTNGP12.phx.gbl...
> Hi,
> early on in SQL2005 (Yukon's) life, there was talk for Network Load Balancing support.
> Now that it's (more or less) out, the documentation makes no mention of support for NLB.
> There's talk of clusters, mirroring and replication and while mirroring seems to come close, it's
> still and active/passive configuration (with the addition of a watcher!).
> Hopefully this is just buried in the docs somewhere on the install CD (I'm waiting for the Dec
> MSDN DVDs, which presumably will include SQL2005 RTM), but I'd have thought it would be online
> somewhere.
> Anyone spotted it?
> Thanks
> Craig
>

NLB and SQL2005

Hi,
early on in SQL2005 (Yukon's) life, there was talk for Network Load
Balancing support.
Now that it's (more or less) out, the documentation makes no mention of
support for NLB.
There's talk of clusters, mirroring and replication and while mirroring
seems to come close, it's still and active/passive configuration (with the
addition of a watcher!).
Hopefully this is just buried in the docs somewhere on the install CD (I'm
waiting for the Dec MSDN DVDs, which presumably will include SQL2005 RTM),
but I'd have thought it would be online somewhere.
Anyone spotted it?
Thanks
Craig
There is no "NLB" or other form of transparent SQL scale-out in SQL Server
2005 (other than the Distributed Partitioned Views carried over from SQL
Server 2000). Mirroring does allow the mirror copy to be accessed read-only
for reporting. And there is a shared read-only reporting database feature.
In some cases those address the need for scale-out.
There is the notion of a Service-Oriented Database Architecture (SODA) in
SQL Server 2005 that can be used to achieve scale-out. It is transparent at
the level of a service interface, not at the level of SQL. It isn't
explicitly talked about in BOL. I wrote a white paper about it a year ago,
but haven't seen Microsoft publish it yet. It was supposed to be available
at launch. Dave Campbell has given presentations on it, at launch and I
believe also at PDC (and perhaps PASS).
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Craig Humphrey" <CraigHumphreyHatesSpam@.newsgroup.nospam> wrote in message
news:uWpmgmX6FHA.3684@.TK2MSFTNGP12.phx.gbl...
> Hi,
> early on in SQL2005 (Yukon's) life, there was talk for Network Load
> Balancing support.
> Now that it's (more or less) out, the documentation makes no mention of
> support for NLB.
> There's talk of clusters, mirroring and replication and while mirroring
> seems to come close, it's still and active/passive configuration (with the
> addition of a watcher!).
> Hopefully this is just buried in the docs somewhere on the install CD (I'm
> waiting for the Dec MSDN DVDs, which presumably will include SQL2005 RTM),
> but I'd have thought it would be online somewhere.
> Anyone spotted it?
> Thanks
> Craig
>
|||In addition to Hal's comments:
For mirroring, you will probably be able to define a database snapshot of a mirrored database and
use that snapshot as a read-only database. However, you will work against a snapshot which will be
up to as old as the interval for creating the snapshots.
Also, you can have several database instances accessing the same read-only data using the SSB
thinking: http://support.microsoft.com/?kbid=910378
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Craig Humphrey" <CraigHumphreyHatesSpam@.newsgroup.nospam> wrote in message
news:uWpmgmX6FHA.3684@.TK2MSFTNGP12.phx.gbl...
> Hi,
> early on in SQL2005 (Yukon's) life, there was talk for Network Load Balancing support.
> Now that it's (more or less) out, the documentation makes no mention of support for NLB.
> There's talk of clusters, mirroring and replication and while mirroring seems to come close, it's
> still and active/passive configuration (with the addition of a watcher!).
> Hopefully this is just buried in the docs somewhere on the install CD (I'm waiting for the Dec
> MSDN DVDs, which presumably will include SQL2005 RTM), but I'd have thought it would be online
> somewhere.
> Anyone spotted it?
> Thanks
> Craig
>

NIC questions

Hi,
I have installed 2 NICs on a Server. One of them is
connected to company's network (IP Address is assigned by
company's DHCP Server). The other one is connected to a
private testing network and I plan to use that server as
AD in the testing LAN.
I would like to know
1) Is it necessary to consider the sequnce of binding of
the NICs ? Company LAN - Local Area Connection and
Private LAN - Local Area Connection 2. Does the sequence
significant ?
2) From my understanding, when we run ipconfig/all, the
first NIC shown is the primary NIC. How can we change the
sequence ?
Thanks
For SQL Server, the order is irrelevant. SQL binds to all valid addresses
that exist at service startup.
Change the binding order for your NICs to change the order they appear in
the IPCONFIG output.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
> Hi,
> I have installed 2 NICs on a Server. One of them is
> connected to company's network (IP Address is assigned by
> company's DHCP Server). The other one is connected to a
> private testing network and I plan to use that server as
> AD in the testing LAN.
> I would like to know
> 1) Is it necessary to consider the sequnce of binding of
> the NICs ? Company LAN - Local Area Connection and
> Private LAN - Local Area Connection 2. Does the sequence
> significant ?
> 2) From my understanding, when we run ipconfig/all, the
> first NIC shown is the primary NIC. How can we change the
> sequence ?
> Thanks
>
|||Dear Geoff,
Thank you for your reply. I should have posted it to Windows Server
newsgroup.
However, how do I change the binding order for the NICs ?
Thanks
Peter
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
> For SQL Server, the order is irrelevant. SQL binds to all valid addresses
> that exist at service startup.
> Change the binding order for your NICs to change the order they appear in
> the IPCONFIG output.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
>
|||This may vary slightly by OS version.
On the Network Connections page, Select ADVANCED | Advanced Settings on the
menu. First page should be Adapters and Bindings. Change the order as you
need to.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:uhbAlqquFHA.3792@.TK2MSFTNGP10.phx.gbl...
> Dear Geoff,
> Thank you for your reply. I should have posted it to Windows Server
> newsgroup.
> However, how do I change the binding order for the NICs ?
> Thanks
> Peter
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
>

NIC questions

Hi,
I have installed 2 NICs on a Server. One of them is
connected to company's network (IP Address is assigned by
company's DHCP Server). The other one is connected to a
private testing network and I plan to use that server as
AD in the testing LAN.
I would like to know
1) Is it necessary to consider the sequnce of binding of
the NICs ? Company LAN - Local Area Connection and
Private LAN - Local Area Connection 2. Does the sequence
significant ?
2) From my understanding, when we run ipconfig/all, the
first NIC shown is the primary NIC. How can we change the
sequence ?
ThanksFor SQL Server, the order is irrelevant. SQL binds to all valid addresses
that exist at service startup.
Change the binding order for your NICs to change the order they appear in
the IPCONFIG output.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
> Hi,
> I have installed 2 NICs on a Server. One of them is
> connected to company's network (IP Address is assigned by
> company's DHCP Server). The other one is connected to a
> private testing network and I plan to use that server as
> AD in the testing LAN.
> I would like to know
> 1) Is it necessary to consider the sequnce of binding of
> the NICs ? Company LAN - Local Area Connection and
> Private LAN - Local Area Connection 2. Does the sequence
> significant ?
> 2) From my understanding, when we run ipconfig/all, the
> first NIC shown is the primary NIC. How can we change the
> sequence ?
> Thanks
>|||Dear Geoff,
Thank you for your reply. I should have posted it to Windows Server
newsgroup.
However, how do I change the binding order for the NICs ?
Thanks
Peter
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
> For SQL Server, the order is irrelevant. SQL binds to all valid addresses
> that exist at service startup.
> Change the binding order for your NICs to change the order they appear in
> the IPCONFIG output.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
>|||This may vary slightly by OS version.
On the Network Connections page, Select ADVANCED | Advanced Settings on the
menu. First page should be Adapters and Bindings. Change the order as you
need to.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:uhbAlqquFHA.3792@.TK2MSFTNGP10.phx.gbl...
> Dear Geoff,
> Thank you for your reply. I should have posted it to Windows Server
> newsgroup.
> However, how do I change the binding order for the NICs ?
> Thanks
> Peter
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
>

NIC questions

Hi,
I have installed 2 NICs on a Server. One of them is
connected to company's network (IP Address is assigned by
company's DHCP Server). The other one is connected to a
private testing network and I plan to use that server as
AD in the testing LAN.
I would like to know
1) Is it necessary to consider the sequnce of binding of
the NICs ? Company LAN - Local Area Connection and
Private LAN - Local Area Connection 2. Does the sequence
significant ?
2) From my understanding, when we run ipconfig/all, the
first NIC shown is the primary NIC. How can we change the
sequence ?
ThanksFor SQL Server, the order is irrelevant. SQL binds to all valid addresses
that exist at service startup.
Change the binding order for your NICs to change the order they appear in
the IPCONFIG output.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
> Hi,
> I have installed 2 NICs on a Server. One of them is
> connected to company's network (IP Address is assigned by
> company's DHCP Server). The other one is connected to a
> private testing network and I plan to use that server as
> AD in the testing LAN.
> I would like to know
> 1) Is it necessary to consider the sequnce of binding of
> the NICs ? Company LAN - Local Area Connection and
> Private LAN - Local Area Connection 2. Does the sequence
> significant ?
> 2) From my understanding, when we run ipconfig/all, the
> first NIC shown is the primary NIC. How can we change the
> sequence ?
> Thanks
>|||Dear Geoff,
Thank you for your reply. I should have posted it to Windows Server
newsgroup.
However, how do I change the binding order for the NICs ?
Thanks
Peter
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
> For SQL Server, the order is irrelevant. SQL binds to all valid addresses
> that exist at service startup.
> Change the binding order for your NICs to change the order they appear in
> the IPCONFIG output.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
>> Hi,
>> I have installed 2 NICs on a Server. One of them is
>> connected to company's network (IP Address is assigned by
>> company's DHCP Server). The other one is connected to a
>> private testing network and I plan to use that server as
>> AD in the testing LAN.
>> I would like to know
>> 1) Is it necessary to consider the sequnce of binding of
>> the NICs ? Company LAN - Local Area Connection and
>> Private LAN - Local Area Connection 2. Does the sequence
>> significant ?
>> 2) From my understanding, when we run ipconfig/all, the
>> first NIC shown is the primary NIC. How can we change the
>> sequence ?
>> Thanks
>|||This may vary slightly by OS version.
On the Network Connections page, Select ADVANCED | Advanced Settings on the
menu. First page should be Adapters and Bindings. Change the order as you
need to.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:uhbAlqquFHA.3792@.TK2MSFTNGP10.phx.gbl...
> Dear Geoff,
> Thank you for your reply. I should have posted it to Windows Server
> newsgroup.
> However, how do I change the binding order for the NICs ?
> Thanks
> Peter
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
>> For SQL Server, the order is irrelevant. SQL binds to all valid
>> addresses that exist at service startup.
>> Change the binding order for your NICs to change the order they appear in
>> the IPCONFIG output.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
>> news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
>> Hi,
>> I have installed 2 NICs on a Server. One of them is
>> connected to company's network (IP Address is assigned by
>> company's DHCP Server). The other one is connected to a
>> private testing network and I plan to use that server as
>> AD in the testing LAN.
>> I would like to know
>> 1) Is it necessary to consider the sequnce of binding of
>> the NICs ? Company LAN - Local Area Connection and
>> Private LAN - Local Area Connection 2. Does the sequence
>> significant ?
>> 2) From my understanding, when we run ipconfig/all, the
>> first NIC shown is the primary NIC. How can we change the
>> sequence ?
>> Thanks
>>
>

NIC Card in SQL server

The network folks would like to change the NIC on SQL server to support a ne
w
Gig port that the server will be connecting to. Any issues that may affect
any databases that I should be concerned about?
Thanks,Hi
If you have to shut it down, make sure that it is done cleanly you may want
to check connections and what they are doing, then should be fine.
I assume that you are not renaming the server?
Is the IP address is staying the same, or if you change the IP address there
is nothing such as a firewall expecting it to be static?
John
"Niles" wrote:

> The network folks would like to change the NIC on SQL server to support a
new
> Gig port that the server will be connecting to. Any issues that may affec
t
> any databases that I should be concerned about?
> Thanks,

NIC Card in SQL server

The network folks would like to change the NIC on SQL server to support a new
Gig port that the server will be connecting to. Any issues that may affect
any databases that I should be concerned about?
Thanks,Hi
If you have to shut it down, make sure that it is done cleanly you may want
to check connections and what they are doing, then should be fine.
I assume that you are not renaming the server?
Is the IP address is staying the same, or if you change the IP address there
is nothing such as a firewall expecting it to be static?
John
"Niles" wrote:
> The network folks would like to change the NIC on SQL server to support a new
> Gig port that the server will be connecting to. Any issues that may affect
> any databases that I should be concerned about?
> Thanks,

NIC Card in SQL server

The network folks would like to change the NIC on SQL server to support a new
Gig port that the server will be connecting to. Any issues that may affect
any databases that I should be concerned about?
Thanks,
Hi
If you have to shut it down, make sure that it is done cleanly you may want
to check connections and what they are doing, then should be fine.
I assume that you are not renaming the server?
Is the IP address is staying the same, or if you change the IP address there
is nothing such as a firewall expecting it to be static?
John
"Niles" wrote:

> The network folks would like to change the NIC on SQL server to support a new
> Gig port that the server will be connecting to. Any issues that may affect
> any databases that I should be concerned about?
> Thanks,

newsequentialid

HI

Does anyone know if the sentence below from BOL means newsequentialid does not generate unique id on computer with network card? we have a sql database that uses newid for several tables, I want to switch to newsequentialid to reduce page splits

The GUIDs generated by NEWSEQUENTIALID() are unique within a particular computer only if the computer does not have a network card

thanks

Pauli

Hi,

see this article for more information:

http://sqljunkies.com/Article/4067A1B1-C31C-4EAF-86C3-80513451FC03.scuk

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

newbie: sql server problem

Hey
I have a little network consisting of 2 computers (1 winXP computer and 1
windows server 2003 computer)
I installed windows server 2003 a week ago... and now it works as domain
controller in my little domain (set up because I want to learn more about
domain/AD etc)...
3 days ago I installed Windows Sharepoint Services on this windows server
computer.
Now when I on the windows server computer look at the bottom of the screen I
see 1 icons to the right... the icon is the sql server service icon. But
this is strange to me... Usually this icon should have a green symbol or a
red symbol telling the status of sql server.. But it shows nothing... The
icon shows a computer and in front of the computer bubble is placed.
Usuallly this bubble has a green arrow or red sign telling the status of sql
server but here on my computer it is white - nothing inside the bubble...
I haven't installed Sql Server by myself, it must have been embedded in the
other installations (i've installed sharepoint)
When I double click on the icon "Sql Server Service Manager" is opened. In
"Sql Server Service Manager" I see that the field named "Server" is blank,
and when I click on the down arrow at the this field the computer name of my
winXP computer is shown - it doesn't display the name of my server. The
"Services" field is blank too...
What am I doing wrong here?
JeffOn your 2003 Server machine, go to Start -> Administrative Tools ->
Services. Find the MSSQLSERVER service, and if it doesn't have a
status of "Started", right-click on it and start it. Check the
SQLSERVERAGENT service as well.|||Hey
Thanks for helping me!
But I cannot find those services, the only services I find that are related
to sqlserver are these:
SQLAgent$SHAREPOINT (not running, set to start manually)
MSSQL$SHAREPOINT (started)
MSSQLServerADHelper (not running, set to start manually)
I'm considering to do a complete reinstall of windows server 2003 on this
computer...
Jeff
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1148648757.026292.309250@.j55g2000cwa.googlegroups.com...
> On your 2003 Server machine, go to Start -> Administrative Tools ->
> Services. Find the MSSQLSERVER service, and if it doesn't have a
> status of "Started", right-click on it and start it. Check the
> SQLSERVERAGENT service as well.
>|||Jeff wrote:
> Hey
> Thanks for helping me!
> But I cannot find those services, the only services I find that are relate
d
> to sqlserver are these:
> SQLAgent$SHAREPOINT (not running, set to start manually)
> MSSQL$SHAREPOINT (started)
> MSSQLServerADHelper (not running, set to start manually)
> I'm considering to do a complete reinstall of windows server 2003 on this
> computer...
>
Surely this is MSDE (cut down version of SQL Server 2000), MS Sharepoint
must use the MSDE engine, a quick google search would seem to verify this|||So is this correct then?:
Now when I on the windows server computer look at the bottom of the screen I
see 1 icon to the right... the icon is the sql server service icon. But this
is strange to me... Usually this icon should have a green symbol or a red
symbol telling the status of sql server.. But it shows nothing... The icon
shows a computer and in front of the computer bubble is placed. Usuallly
this bubble has a green arrow or red sign telling the status of sql server
but here on my computer it is white - nothing inside the bubble...
I haven't installed Sql Server by myself, it must have been embedded in the
other installations (i've installed sharepoint)
When I double click on the icon "Sql Server Service Manager" is opened. In
"Sql Server Service Manager" I see that the field named "Server" is blank,
and when I click on the down arrow at the this field the computer name of my
winXP computer is shown - it doesn't display the name of my server. The
"Services" field is blank too...
Is this as it should be?..
Jeff
"Chris Vowles" <NO_SPAM_PLEASE_chris_vowles@.hotmail.com_NO_SPAM_PLEASE>
wrote in message news:e570b5$6dd$1$8300dec7@.news.demon.co.uk...
> Jeff wrote:
> Surely this is MSDE (cut down version of SQL Server 2000), MS Sharepoint
> must use the MSDE engine, a quick google search would seem to verify this
>|||On Fri, 26 May 2006 15:20:38 +0200, Jeff wrote:

>I'm considering to do a complete reinstall of windows server 2003 on this
>computer...
Hi Jeff,
Hold it - no need to rush into re-installs.
The icon you are seeing in the system tray bellongs to SQL Service
Manager. This tools, which can be used to start and stop the main SQL
Server services, is installed with any edition of SQL Server 2000
(including MSDE, which was appparently installed as part of your Windows
Sharepoint Services installation). It is also added to yoour startup
group, so that the icon will show after each restart. Personally, I
remove it from the startup group and start and stop my services from
other tools, like Enterprise Manager or SSMS. But since MSDE doesn't
include those tools, you might prefer to keep using the Service Manager.
Now, you can have multiple instance of SQL Server and/or MSDE installed
on a single machine - zero or one "default" instance, and zero or more
"named" instances. But the Service Manager shows only one red or green
status dot. So you'll have to tell it which instance to monitor. (And
you can change it as often as you want).
The empty circle without greenn or red status symbol shows that Service
Manager is not yet set to watch a specific instance, and it didn't find
a default instance to watch either. So you'll have to tell it where to
look.
Right-click the system tray icon and select "Open SQL Server Service
Manager" from the pop-up list. Since you repport the Server dropdown
list to be emmppty, you'll have to type the name yourself. The service
name of a named instance consistts of two parts: the name of the
computer where the service runs (in your case the name of your WinXP
computer, unless I misunderstood your messages) and the instance name,
seperated by backslashes.

>SQLAgent$SHAREPOINT (not running, set to start manually)
>MSSQL$SHAREPOINT (started)
>MSSQLServerADHelper (not running, set to start manually)
From these names, I can see that a named instance is installed on your
computer, and that it's name is SHAREPOINT.
So assuming that the name of your WinXP computer is JEFF, you should now
type "JEFF\SHAREPOINT" (without the quotes) in the server field. Then
click the "Refresh services" button. Finally, select "SQL Server" in the
"Services" dropdown.
Hugo Kornelis, SQL Server MVP

newbie: sql server problem

Hey
I have a little network consisting of 2 computers (1 winXP computer and 1
windows server 2003 computer)
I installed windows server 2003 a week ago... and now it works as domain
controller in my little domain (set up because I want to learn more about
domain/AD etc)...
3 days ago I installed Windows Sharepoint Services on this windows server
computer.
Now when I on the windows server computer look at the bottom of the screen I
see 1 icons to the right... the icon is the sql server service icon. But
this is strange to me... Usually this icon should have a green symbol or a
red symbol telling the status of sql server.. But it shows nothing... The
icon shows a computer and in front of the computer bubble is placed.
Usuallly this bubble has a green arrow or red sign telling the status of sql
server but here on my computer it is white - nothing inside the bubble...
I haven't installed Sql Server by myself, it must have been embedded in the
other installations (i've installed sharepoint)
When I double click on the icon "Sql Server Service Manager" is opened. In
"Sql Server Service Manager" I see that the field named "Server" is blank,
and when I click on the down arrow at the this field the computer name of my
winXP computer is shown - it doesn't display the name of my server. The
"Services" field is blank too...
What am I doing wrong here?
JeffOn your 2003 Server machine, go to Start -> Administrative Tools ->
Services. Find the MSSQLSERVER service, and if it doesn't have a
status of "Started", right-click on it and start it. Check the
SQLSERVERAGENT service as well.|||Hey
Thanks for helping me!
But I cannot find those services, the only services I find that are related
to sqlserver are these:
SQLAgent$SHAREPOINT (not running, set to start manually)
MSSQL$SHAREPOINT (started)
MSSQLServerADHelper (not running, set to start manually)
I'm considering to do a complete reinstall of windows server 2003 on this
computer...
Jeff
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1148648757.026292.309250@.j55g2000cwa.googlegroups.com...
> On your 2003 Server machine, go to Start -> Administrative Tools ->
> Services. Find the MSSQLSERVER service, and if it doesn't have a
> status of "Started", right-click on it and start it. Check the
> SQLSERVERAGENT service as well.
>|||Jeff wrote:
> Hey
> Thanks for helping me!
> But I cannot find those services, the only services I find that are related
> to sqlserver are these:
> SQLAgent$SHAREPOINT (not running, set to start manually)
> MSSQL$SHAREPOINT (started)
> MSSQLServerADHelper (not running, set to start manually)
> I'm considering to do a complete reinstall of windows server 2003 on this
> computer...
>
Surely this is MSDE (cut down version of SQL Server 2000), MS Sharepoint
must use the MSDE engine, a quick google search would seem to verify this|||So is this correct then?:
Now when I on the windows server computer look at the bottom of the screen I
see 1 icon to the right... the icon is the sql server service icon. But this
is strange to me... Usually this icon should have a green symbol or a red
symbol telling the status of sql server.. But it shows nothing... The icon
shows a computer and in front of the computer bubble is placed. Usuallly
this bubble has a green arrow or red sign telling the status of sql server
but here on my computer it is white - nothing inside the bubble...
I haven't installed Sql Server by myself, it must have been embedded in the
other installations (i've installed sharepoint)
When I double click on the icon "Sql Server Service Manager" is opened. In
"Sql Server Service Manager" I see that the field named "Server" is blank,
and when I click on the down arrow at the this field the computer name of my
winXP computer is shown - it doesn't display the name of my server. The
"Services" field is blank too...
Is this as it should be?..
Jeff
"Chris Vowles" <NO_SPAM_PLEASE_chris_vowles@.hotmail.com_NO_SPAM_PLEASE>
wrote in message news:e570b5$6dd$1$8300dec7@.news.demon.co.uk...
> Jeff wrote:
>> Hey
>> Thanks for helping me!
>> But I cannot find those services, the only services I find that are
>> related to sqlserver are these:
>> SQLAgent$SHAREPOINT (not running, set to start manually)
>> MSSQL$SHAREPOINT (started)
>> MSSQLServerADHelper (not running, set to start manually)
>> I'm considering to do a complete reinstall of windows server 2003 on this
>> computer...
> Surely this is MSDE (cut down version of SQL Server 2000), MS Sharepoint
> must use the MSDE engine, a quick google search would seem to verify this
>|||On Fri, 26 May 2006 15:20:38 +0200, Jeff wrote:
>I'm considering to do a complete reinstall of windows server 2003 on this
>computer...
Hi Jeff,
Hold it - no need to rush into re-installs.
The icon you are seeing in the system tray bellongs to SQL Service
Manager. This tools, which can be used to start and stop the main SQL
Server services, is installed with any edition of SQL Server 2000
(including MSDE, which was appparently installed as part of your Windows
Sharepoint Services installation). It is also added to yoour startup
group, so that the icon will show after each restart. Personally, I
remove it from the startup group and start and stop my services from
other tools, like Enterprise Manager or SSMS. But since MSDE doesn't
include those tools, you might prefer to keep using the Service Manager.
Now, you can have multiple instance of SQL Server and/or MSDE installed
on a single machine - zero or one "default" instance, and zero or more
"named" instances. But the Service Manager shows only one red or green
status dot. So you'll have to tell it which instance to monitor. (And
you can change it as often as you want).
The empty circle without greenn or red status symbol shows that Service
Manager is not yet set to watch a specific instance, and it didn't find
a default instance to watch either. So you'll have to tell it where to
look.
Right-click the system tray icon and select "Open SQL Server Service
Manager" from the pop-up list. Since you repport the Server dropdown
list to be emmppty, you'll have to type the name yourself. The service
name of a named instance consistts of two parts: the name of the
computer where the service runs (in your case the name of your WinXP
computer, unless I misunderstood your messages) and the instance name,
seperated by backslashes.
>SQLAgent$SHAREPOINT (not running, set to start manually)
>MSSQL$SHAREPOINT (started)
>MSSQLServerADHelper (not running, set to start manually)
From these names, I can see that a named instance is installed on your
computer, and that it's name is SHAREPOINT.
So assuming that the name of your WinXP computer is JEFF, you should now
type "JEFF\SHAREPOINT" (without the quotes) in the server field. Then
click the "Refresh services" button. Finally, select "SQL Server" in the
"Services" dropdown.
--
Hugo Kornelis, SQL Server MVP