Norton Internet Security & SQL Server

Hi,

Just installed Norton Internet Security on an XP workstation that also has
SQL Server on it.

I now find that I cannot access SQL Server and multiple messages are being
issued by NIS.

When I switch off the Firewall & Intrusion Detection I can access SQL
Server.

Does anyone know how to configure NIS so that I can use it alongside SQL
Server?

Thanks,

Mike.Uytkownik "Mike Stogden" <news@.uniquest.demon.co.uk> napisa w wiadomoci
news:bhaolh$i5i$1$8300dec7@.news.demon.co.uk...
> Hi,
> Just installed Norton Internet Security on an XP workstation that also has
> SQL Server on it.
> I now find that I cannot access SQL Server and multiple messages are being
> issued by NIS.
> When I switch off the Firewall & Intrusion Detection I can access SQL
> Server.
> Does anyone know how to configure NIS so that I can use it alongside SQL
> Server?
Hi, try this:

permit UDP OUT and IN protocol for

SQL Server Service Manager (sqlmangr.exe)
SQL Server Windows NT (sqlserver.exe)

And TCP OUT and IN protocol for

SQL Tracing Tool (profiler.exe)
ISQL (isqlw.exe)

from any adress:any port and this should work, and then try fit your rules
to be more security

best regards
Marcin D

NoRows Leaves Extra White Space

I have a report with multiple tables and datasets. The problem is if one of
the tables/datasets doesn't have any data I get too much white space between
the sections. I tried to set the visiblity property on the table but that
doesn't work if there is no data being returned via the dataset.
For example:
John Does (1st table)
Background Info (2nd table)
Education (3rd table)
This looks fine because there is data in all 3 tables/datasets
Now if there is no background info I get this:
John Doe (1st table)
Education (3rd table)
When I want this:
John Doe (1st table)
Education (3rd table)
I can't combine the info to one table for reasons I won't go into.
Thanks!Try putting each table inside a rectangle and setting the rectangle property
visiblility to Hidden = True if no rows are returned for the rectangles child
table. Additionally, put all 3 rectangles/tables inside a 'master'
rectangle. This will help control some of your whitespace issues.
--
Andy Potter
blog: http://sqlreportingservices.spaces.live.com/
"Anonymous" wrote:
> I have a report with multiple tables and datasets. The problem is if one of
> the tables/datasets doesn't have any data I get too much white space between
> the sections. I tried to set the visiblity property on the table but that
> doesn't work if there is no data being returned via the dataset.
> For example:
> John Does (1st table)
> Background Info (2nd table)
> Education (3rd table)
> This looks fine because there is data in all 3 tables/datasets
> Now if there is no background info I get this:
> John Doe (1st table)
>
> Education (3rd table)
> When I want this:
> John Doe (1st table)
> Education (3rd table)
> I can't combine the info to one table for reasons I won't go into.
> Thanks!
>

Normalizing help and naming conventions

I have an Access Database that I am working on normalizing to SQL Server.
This Access database has been revised multiple times, each time the
programmer (not me!) didn't work to get the existing data to the same level
as the revised program. For instance, the HairColor column has the
following DISTINCT values,
Auburn
Black
Black/Gray
Blonde
Brown
Brown/Gray
Dark Brown
Gray
Gray/Black
Gray/Brown
Lt. Brown
Red
Red-blonde
Red/Blonde
Red/Brown
Now the current revision of the Access database limits the values for the
HairColor column to,
Black
Blonde
Brown
Gray
Red
So I need to make the current values reflect the current dropdown. I know
how to go about this, but have a question about normalizing this database.
Should I create a seperate table, HairColor and then assign ID's to the
HairColor column? What is the benefit of doing it this way, instead of just
leaving the text in there?
Also, if I am to create a new table, how does the naming convention work
with that? Should I prefix my table name with fk_HairColor, or something
like that?
Any advice is appreciated!
Thanks!
drewI would create a table named HairColor with the columns:
HairColorID int
HairColor varchar (20)
In any table that references this table, you can create a foreign key. You
will take up less space in your DB overall. Also, consider what would
happen if you decided to change "Lt. Brown" to "Light Brown". With the
normalized version, you change it in only one place.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Drew" <drewDOTlaingATswvtc.dmhmrsas.virginia.gov> wrote in message
news:eh9TXyLXGHA.5024@.TK2MSFTNGP04.phx.gbl...
I have an Access Database that I am working on normalizing to SQL Server.
This Access database has been revised multiple times, each time the
programmer (not me!) didn't work to get the existing data to the same level
as the revised program. For instance, the HairColor column has the
following DISTINCT values,
Auburn
Black
Black/Gray
Blonde
Brown
Brown/Gray
Dark Brown
Gray
Gray/Black
Gray/Brown
Lt. Brown
Red
Red-blonde
Red/Blonde
Red/Brown
Now the current revision of the Access database limits the values for the
HairColor column to,
Black
Blonde
Brown
Gray
Red
So I need to make the current values reflect the current dropdown. I know
how to go about this, but have a question about normalizing this database.
Should I create a seperate table, HairColor and then assign ID's to the
HairColor column? What is the benefit of doing it this way, instead of just
leaving the text in there?
Also, if I am to create a new table, how does the naming convention work
with that? Should I prefix my table name with fk_HairColor, or something
like that?
Any advice is appreciated!
Thanks!
drew|||Thanks for the response... I thought it was better to replace it with a FK,
but am trying to convince my boss the same...
So you don't use a different naming convention with FKs? I just have about
30 tables on this database and it is getting harder to read for each FK
table I include...
Thanks,
Drew
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:O5jEK4LXGHA.3808@.TK2MSFTNGP04.phx.gbl...
>I would create a table named HairColor with the columns:
> HairColorID int
> HairColor varchar (20)
> In any table that references this table, you can create a foreign key.
> You
> will take up less space in your DB overall. Also, consider what would
> happen if you decided to change "Lt. Brown" to "Light Brown". With the
> normalized version, you change it in only one place.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Drew" <drewDOTlaingATswvtc.dmhmrsas.virginia.gov> wrote in message
> news:eh9TXyLXGHA.5024@.TK2MSFTNGP04.phx.gbl...
> I have an Access Database that I am working on normalizing to SQL Server.
> This Access database has been revised multiple times, each time the
> programmer (not me!) didn't work to get the existing data to the same
> level
> as the revised program. For instance, the HairColor column has the
> following DISTINCT values,
> Auburn
> Black
> Black/Gray
> Blonde
> Brown
> Brown/Gray
> Dark Brown
> Gray
> Gray/Black
> Gray/Brown
> Lt. Brown
> Red
> Red-blonde
> Red/Blonde
> Red/Brown
> Now the current revision of the Access database limits the values for the
> HairColor column to,
> Black
> Blonde
> Brown
> Gray
> Red
> So I need to make the current values reflect the current dropdown. I know
> how to go about this, but have a question about normalizing this database.
> Should I create a seperate table, HairColor and then assign ID's to the
> HairColor column? What is the benefit of doing it this way, instead of
> just
> leaving the text in there?
> Also, if I am to create a new table, how does the naming convention work
> with that? Should I prefix my table name with fk_HairColor, or something
> like that?
> Any advice is appreciated!
> Thanks!
> drew
>|||I did say to use a foreign key. Here's an example. Let's say that you have
a Persons table, and each person has a hair colour. Here's how the Persons
table would go:
create table Persons
(
PersonID int primary key
, HairColorID int not null
FOREIGN KEY FK1_Persons
REFERENCES HairColor
, ...
)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Drew" <drewDOTlaingATswvtc.dmhmrsas.virginia.gov> wrote in message
news:uW2Bs7LXGHA.196@.TK2MSFTNGP04.phx.gbl...
Thanks for the response... I thought it was better to replace it with a FK,
but am trying to convince my boss the same...
So you don't use a different naming convention with FKs? I just have about
30 tables on this database and it is getting harder to read for each FK
table I include...
Thanks,
Drew
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:O5jEK4LXGHA.3808@.TK2MSFTNGP04.phx.gbl...
>I would create a table named HairColor with the columns:
> HairColorID int
> HairColor varchar (20)
> In any table that references this table, you can create a foreign key.
> You
> will take up less space in your DB overall. Also, consider what would
> happen if you decided to change "Lt. Brown" to "Light Brown". With the
> normalized version, you change it in only one place.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Drew" <drewDOTlaingATswvtc.dmhmrsas.virginia.gov> wrote in message
> news:eh9TXyLXGHA.5024@.TK2MSFTNGP04.phx.gbl...
> I have an Access Database that I am working on normalizing to SQL Server.
> This Access database has been revised multiple times, each time the
> programmer (not me!) didn't work to get the existing data to the same
> level
> as the revised program. For instance, the HairColor column has the
> following DISTINCT values,
> Auburn
> Black
> Black/Gray
> Blonde
> Brown
> Brown/Gray
> Dark Brown
> Gray
> Gray/Black
> Gray/Brown
> Lt. Brown
> Red
> Red-blonde
> Red/Blonde
> Red/Brown
> Now the current revision of the Access database limits the values for the
> HairColor column to,
> Black
> Blonde
> Brown
> Gray
> Red
> So I need to make the current values reflect the current dropdown. I know
> how to go about this, but have a question about normalizing this database.
> Should I create a seperate table, HairColor and then assign ID's to the
> HairColor column? What is the benefit of doing it this way, instead of
> just
> leaving the text in there?
> Also, if I am to create a new table, how does the naming convention work
> with that? Should I prefix my table name with fk_HairColor, or something
> like that?
> Any advice is appreciated!
> Thanks!
> drew
>|||>> Should I create a seperate table, HairColor and then assign ID's to the
HairColor column? What is the benefit of doing it this way, instead of
just
leaving the text in there? <<
Let's start with basics:
1) Do your research! Is there an industry standard code for hair
colors? Use it
2) If not, then design an encoding that has a missing and/or misc code
value -- Hey, I am bald!
3) If you expect the values to change, the list to be long, or that you
willneed to add other information later, then put the encoding into a
separate table.
4) If you expect the values to be static, the list to be short or that
you will not need to add other information later, then put the encoding
into a CHECK() constraint. For example, the ISO sex codes are going to
stay the same for awhile, as are the two-letter state codes.
Get a copy of SQL PROGRAMMING STYLE. You never, never prefix a data
element name with thigns to tell you (1) Where it is used -- so no
table names (2) how it is used -- so no pk- or fk- crap (3) how it is
store, so no data types. Follow ISO-11179 rules and name a thing for
what it is, independent of its location or usage.
Do not blindly design an encoding as a numbered list. Think about
hierarchical ("Dewey Decimal") codes, abbreviation codes, etc. That
is also in SQL PROGRAMMING STYLE.|||I second getting SQL Programming Style. I read it in 2 ws. It is
any easy read.|||For the record, I was agreeing with you!
Drew
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eYsy3EMXGHA.752@.TK2MSFTNGP02.phx.gbl...
>I did say to use a foreign key. Here's an example. Let's say that you
>have
> a Persons table, and each person has a hair colour. Here's how the
> Persons
> table would go:
> create table Persons
> (
> PersonID int primary key
> , HairColorID int not null
> FOREIGN KEY FK1_Persons
> REFERENCES HairColor
> , ...
> )
>
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Drew" <drewDOTlaingATswvtc.dmhmrsas.virginia.gov> wrote in message
> news:uW2Bs7LXGHA.196@.TK2MSFTNGP04.phx.gbl...
> Thanks for the response... I thought it was better to replace it with a
> FK,
> but am trying to convince my boss the same...
> So you don't use a different naming convention with FKs? I just have
> about
> 30 tables on this database and it is getting harder to read for each FK
> table I include...
> Thanks,
> Drew
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:O5jEK4LXGHA.3808@.TK2MSFTNGP04.phx.gbl...
>

NOP command in Sysprocesses

Looking at blocking on a SQL Server 2000 system sitting on Windows 2003
Server I am somtimes catching a blocker sitting with multiple locks and
a command of NOP blocking an update user looking for a exclusive key
lock.
The main question is what is NOP command in SQL Server? Of the ones
I've been able to witness, the commands that come up as NOP, during the
blocking period will change to a INSERT cmd.
This system is SQL Server 2k Enterprise on a 4 processor box with AWE
mode and 16gb of memory.
I can't find any reference to this in any documentation and I seem to
recall hearing what such a command represented at one time but can't
find it now. My feeling is that this might help me identify some
performance issues (beyond the bad code I've already identified) so it
would help to understand what causes SQL Server to post that as a
command in Sysprocesses.
thanks
NOP stands for no operation, which is a low level instruction that waits for
a specific number of cpu cycles. I am not much familiar with how it impacts
SQL server, but a quick googling suggests it may impact deadlocking, when
one process waiting for a resource held by the another process.
Anith
|||Anith Sen wrote:
> NOP stands for no operation, which is a low level instruction that waits for
> a specific number of cpu cycles. I am not much familiar with how it impacts
> SQL server, but a quick googling suggests it may impact deadlocking, when
> one process waiting for a resource held by the another process.
>
Unfortunately I can't find any information regarding SQL Server
specifically, not even in the Inside SQL Server books I've read over
time.
I'm still seeing it show up, it's not part of a deadlock as the
deadlock isn't being found by basic tracking, though what found is it's
a user creating a block. When I first catch the fact a block is
occuring I see the command NOP. 3 seconds later I check again and the
block is still occuring but the command says UPDATE.
I've searched the web extensively as well, so hopefully someone with
more visibility to the SQL Engine will see this and pipe up.
One interesting component, the server this is running on is a Quad
Processor Dell box with 4 Dual Core Xeon processors (1st generation
dual core chips) and they have it running hyperthreading as well. So
SQL sees 16 processors but there are really only 4 dual cores, which in
this family of Intels acts like about 1.5 each.
|||Mike H wrote:
...
> I'm still seeing it show up, it's not part of a deadlock as the
> deadlock isn't being found by basic tracking, though what found is it's
> a user creating a block. When I first catch the fact a block is
> occuring I see the command NOP. 3 seconds later I check again and the
> block is still occuring but the command says UPDATE.
> I've searched the web extensively as well, so hopefully someone with
> more visibility to the SQL Engine will see this and pipe up.
...
It's suprising that this is a valid wait state in SQL Server but no one
knows where it's coming from. I still see these come up and it would
be very helpful to know what's causing them.
|||Mike H wrote:
> Mike H wrote:
> ...
> ...
> It's suprising that this is a valid wait state in SQL Server but no one
> knows where it's coming from. I still see these come up and it would
> be very helpful to know what's causing them.
bueller ? anyone?

NOP command in Sysprocesses

Looking at blocking on a SQL Server 2000 system sitting on Windows 2003
Server I am somtimes catching a blocker sitting with multiple locks and
a command of NOP blocking an update user looking for a exclusive key
lock.
The main question is what is NOP command in SQL Server? Of the ones
I've been able to witness, the commands that come up as NOP, during the
blocking period will change to a INSERT cmd.
This system is SQL Server 2k Enterprise on a 4 processor box with AWE
mode and 16gb of memory.
I can't find any reference to this in any documentation and I seem to
recall hearing what such a command represented at one time but can't
find it now. My feeling is that this might help me identify some
performance issues (beyond the bad code I've already identified) so it
would help to understand what causes SQL Server to post that as a
command in Sysprocesses.
thanksNOP stands for no operation, which is a low level instruction that waits for
a specific number of cpu cycles. I am not much familiar with how it impacts
SQL server, but a quick googling suggests it may impact deadlocking, when
one process waiting for a resource held by the another process.
--
Anith|||Anith Sen wrote:
> NOP stands for no operation, which is a low level instruction that waits for
> a specific number of cpu cycles. I am not much familiar with how it impacts
> SQL server, but a quick googling suggests it may impact deadlocking, when
> one process waiting for a resource held by the another process.
>
Unfortunately I can't find any information regarding SQL Server
specifically, not even in the Inside SQL Server books I've read over
time.
I'm still seeing it show up, it's not part of a deadlock as the
deadlock isn't being found by basic tracking, though what found is it's
a user creating a block. When I first catch the fact a block is
occuring I see the command NOP. 3 seconds later I check again and the
block is still occuring but the command says UPDATE.
I've searched the web extensively as well, so hopefully someone with
more visibility to the SQL Engine will see this and pipe up.
One interesting component, the server this is running on is a Quad
Processor Dell box with 4 Dual Core Xeon processors (1st generation
dual core chips) and they have it running hyperthreading as well. So
SQL sees 16 processors but there are really only 4 dual cores, which in
this family of Intels acts like about 1.5 each.|||Mike H wrote:
...
> I'm still seeing it show up, it's not part of a deadlock as the
> deadlock isn't being found by basic tracking, though what found is it's
> a user creating a block. When I first catch the fact a block is
> occuring I see the command NOP. 3 seconds later I check again and the
> block is still occuring but the command says UPDATE.
> I've searched the web extensively as well, so hopefully someone with
> more visibility to the SQL Engine will see this and pipe up.
...
It's suprising that this is a valid wait state in SQL Server but no one
knows where it's coming from. I still see these come up and it would
be very helpful to know what's causing them.|||Mike H wrote:
> Mike H wrote:
> ...
> > I'm still seeing it show up, it's not part of a deadlock as the
> > deadlock isn't being found by basic tracking, though what found is it's
> > a user creating a block. When I first catch the fact a block is
> > occuring I see the command NOP. 3 seconds later I check again and the
> > block is still occuring but the command says UPDATE.
> >
> > I've searched the web extensively as well, so hopefully someone with
> > more visibility to the SQL Engine will see this and pipe up.
> ...
> It's suprising that this is a valid wait state in SQL Server but no one
> knows where it's coming from. I still see these come up and it would
> be very helpful to know what's causing them.
bueller ? anyone?

NOP command in Sysprocesses

Looking at blocking on a SQL Server 2000 system sitting on Windows 2003
Server I am somtimes catching a blocker sitting with multiple locks and
a command of NOP blocking an update user looking for a exclusive key
lock.
The main question is what is NOP command in SQL Server? Of the ones
I've been able to witness, the commands that come up as NOP, during the
blocking period will change to a INSERT cmd.
This system is SQL Server 2k Enterprise on a 4 processor box with AWE
mode and 16gb of memory.
I can't find any reference to this in any documentation and I seem to
recall hearing what such a command represented at one time but can't
find it now. My feeling is that this might help me identify some
performance issues (beyond the bad code I've already identified) so it
would help to understand what causes SQL Server to post that as a
command in Sysprocesses.
thanksNOP stands for no operation, which is a low level instruction that waits for
a specific number of cpu cycles. I am not much familiar with how it impacts
SQL server, but a quick googling suggests it may impact deadlocking, when
one process waiting for a resource held by the another process.
Anith|||Anith Sen wrote:
> NOP stands for no operation, which is a low level instruction that waits f
or
> a specific number of cpu cycles. I am not much familiar with how it impact
s
> SQL server, but a quick googling suggests it may impact deadlocking, when
> one process waiting for a resource held by the another process.
>
Unfortunately I can't find any information regarding SQL Server
specifically, not even in the Inside SQL Server books I've read over
time.
I'm still seeing it show up, it's not part of a deadlock as the
deadlock isn't being found by basic tracking, though what found is it's
a user creating a block. When I first catch the fact a block is
occuring I see the command NOP. 3 seconds later I check again and the
block is still occuring but the command says UPDATE.
I've searched the web extensively as well, so hopefully someone with
more visibility to the SQL Engine will see this and pipe up.
One interesting component, the server this is running on is a Quad
Processor Dell box with 4 Dual Core Xeon processors (1st generation
dual core chips) and they have it running hyperthreading as well. So
SQL sees 16 processors but there are really only 4 dual cores, which in
this family of Intels acts like about 1.5 each.|||Mike H wrote:
...
> I'm still seeing it show up, it's not part of a deadlock as the
> deadlock isn't being found by basic tracking, though what found is it's
> a user creating a block. When I first catch the fact a block is
> occuring I see the command NOP. 3 seconds later I check again and the
> block is still occuring but the command says UPDATE.
> I've searched the web extensively as well, so hopefully someone with
> more visibility to the SQL Engine will see this and pipe up.
...
It's suprising that this is a valid wait state in SQL Server but no one
knows where it's coming from. I still see these come up and it would
be very helpful to know what's causing them.|||Mike H wrote:
> Mike H wrote:
> ...
> ...
> It's suprising that this is a valid wait state in SQL Server but no one
> knows where it's coming from. I still see these come up and it would
> be very helpful to know what's causing them.
bueller ? anyone?

Noob Diving into DTS Packages

Is it possible to import a CSV and break the contents into multiple
tables?On Apr 9, 3:59 pm, "JGiotta" <jdgio...@.gmail.com> wrote:
> Is it possible to import a CSV and break the contents into multiple
> tables?
Use a staging table for that
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Thanks, I'll look into it.
Do you recommend any book that cover DTS well?|||On Apr 9, 5:05 pm, "JGiotta" <jdgio...@.gmail.com> wrote:
> Thanks, I'll look into it.
> Do you recommend any book that cover DTS well?
Here is one I like
Professional SQL Server 2000 DTS (Data Transformation Services
by Mark Chaffin , Brian Knight , Todd Robinson
http://www.amazon.com/gp/product/0764543687/102-5735017-0910517?ie=UTF8&tag=sql08-20&linkCode=xm2&camp=1789&creativeASIN=0764543687
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Thanks again

Non-Equi Joins

I am taking Microsoft Course 4329 on Joining Data from Multiple Tables in
SQL Server 2005, and I am stumped in the Lab, Task 2, Step 3.

How can I rewrite the following SQL Statement to produce the same results by
using a non-equality operator in the join?

use adventureworks
select firstname + ' ' + lastname as name, gender, vacationhours as hours
from humanresources.employee e join person.contact c on e.contactid=c.contactid
where gender='f' and vacationhours>50
order by hours desc

Thanks in advance for your help!

--Justin--

There may be mulitple answers,

use adventureworks
select firstname + ' ' + lastname as name, gender, vacationhours as hours
from humanresources.employee e CROSS JOIN person.contact c where e.contactid=c.contactid
and gender='f' and vacationhours>50
order by hours desc

or

use adventureworks
select firstname + ' ' + lastname as name, gender, vacationhours as hours
from humanresources.employee e JOIN person.contact c On vacationhours>50 where e.contactid=c.contactid
and gender='f'
order by hours desc

Non-clustered indexes on 1 separate fileGroup?

Hi Guys,

I am reviewing the storage structure of my growing db.

I am going to create multiple FileGroups and db files.
Most of the filegroups will be used to allow table partitioning and put the heavily used partitions on different storage than the read-only archives. TempDB will also have its own filegroup/storage.

For Indexes, I have a doubt. I am sure I can have all my non-clustered indexes on a separate fileGroup and storage but what about primary keys and/or clustered indexes?

Should I move them to the same filegroup than the non-clustered indexes or should I leave them with the data? What would be best?

I am running a 100GB reporting datamart on SQL2005 enterprise, There are almost no transactions, just a daily and weekly refresh. I will soon have more storage, SAN or NetApp, not sure yet.

Thanks,

Philippe

Hi

Moving your indexes to a seperate filegroup can improve the parallism of some querries that need to work with indexes and then do a bookmark lookup afterwards. If you have a VLDB like you said you should consider doing it, since the indexes cant be kept in memory all the time. So when you access the indexes it will not block the retrieval of your data from the other partition.

Non default port

I am using SQL 2005 and have multiple instances installed on multiple
servers. None are on the default port. When I connect to box 01
without specifying the port in the connection string, it connects.
But on box 02, it will only connect to the instance if I specify the
port name. Is this because it will only connect to the default
instance without specifying a port? or is there something else I need
to have setup on box 02 to make this work?
thanks in advance
> Is this because it will only connect to the default
> instance without specifying a port? or is there something else I need
> to have setup on box 02 to make this work?
Check to ensure the SQL Browser service is running as Tibor suggested.
Another possible cause is that UDP port 1434 is blocked.
When you connect to the default instance, TCP port 1433 is used by default.
When you connect to a named instance without a specifying a port, the client
requests a list of the named instances and corresponding ports via UDP port
1434 (this is the SQL Browser service). The client then determines the
named instance port.
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Victag" <miketaggart@.gmail.com> wrote in message
news:0ef672ad-08dd-49da-8ff6-1abfcf4982bb@.s12g2000prg.googlegroups.com...
>I am using SQL 2005 and have multiple instances installed on multiple
> servers. None are on the default port. When I connect to box 01
> without specifying the port in the connection string, it connects.
> But on box 02, it will only connect to the instance if I specify the
> port name. Is this because it will only connect to the default
> instance without specifying a port? or is there something else I need
> to have setup on box 02 to make this work?
> thanks in advance
|||On Mar 13, 4:26Xam, "Dan Guzman" <guzma...@.nospam-
online.sbcglobal.net> wrote:
> Check to ensure the SQL Browser service is running as Tibor suggested.
> Another possible cause is that UDP port 1434 is blocked.
> When you connect to the default instance, TCP port 1433 is used by default..
> When you connect to a named instance without a specifying a port, the client
> requests a list of the named instances and corresponding ports via UDP port
> 1434 (this is the SQL Browser service). XThe client then determines the
> named instance port.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVPhttp://weblogs.sqlteam.com/dang/
> "Victag" <miketagg...@.gmail.com> wrote in message
> news:0ef672ad-08dd-49da-8ff6-1abfcf4982bb@.s12g2000prg.googlegroups.com...
>
>
> - Show quoted text -
Thanks folks! I have checked and the Browser service is disabled on
both boxes (event he working one), so I could try turning it on, but I
would rather explain/understand what the difference is between these
boxes. I have also confirmed that no ports are blocked at all. Any
other suggestions?
|||Hi,
You can access named instances (if you know port number) in this way:
tcp:server_name,port_number
Regards,
anxcomp
|||On Mar 13, 11:12Xam, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> <<Thanks folks! XI have checked and the Browser service is disabled on
> both boxes (event he working one), so I could try turning it on, but I
> would rather explain/understand what the difference is between these
> boxes. XI have also confirmed that no ports are blocked at all. XAny
> other suggestions?>>
> We can only explain how things work:
> When you connect to a default instance (no backslash and instance name), the data access components
> will connect to port 1433. The SQL Server service by default listens to 1433 for a default instance
> (well-known port).
> The port number for a named instance is determined dynamically the first time you start the
> instance. SQL Server asks Windows for an available port, uses it and stores the port number in the
> registry (as you can see using SQL Server Configuration Manager). It will try to use the same port
> number on subsequent start-ups.
> If you from the client app only specify machine name/IP backslash instancename, then you need some
> component to translate this instance name to a port number. That componentis SQL Server Browser
> service. The client data access components connects to the SSB service using port 1434 UDP and
> passes the instance name, and the SSB service returns the port number. Youcan also from the client
> app specify machine/IP comma portnumber, so there would now be no use for the SSB service. SQL
> Server 2000 didn't come with an SSB service so for 2000 the database engine did this job (listening
> on port 1434).
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Victag" <miketagg...@.gmail.com> wrote in message
> news:bee0415f-6523-45e7-9d46-ad9a01846809@.d62g2000hsf.googlegroups.com...
> On Mar 13, 4:26 am, "Dan Guzman" <guzma...@.nospam-
>
>
> online.sbcglobal.net> wrote:
>
>
>
>
>
> Thanks folks! XI have checked and the Browser service is disabled on
> both boxes (event he working one), so I could try turning it on, but I
> would rather explain/understand what the difference is between these
> boxes. XI have also confirmed that no ports are blocked at all. XAny
> other suggestions... Hide quoted text -
> - Show quoted text -
Thanks again. I have made progress and found that the boxes that are
not working have many client aliases created on them, some of which
appear to be invalid. When I deleted the aliases that did not exist
on the server that is working, it fixed them. So now that I know how
to fix it, I am curious to know how these bad aliases got created
since we did not create them manually.
|||"Victag" wrote:

>I am curious to know how these bad aliases got created
> since we did not create them manually.
Did you install Visio? For example Visio installation process create for me
some alias. I have to delete it manually.
Regards,
anxcomp

Non default port

I am using SQL 2005 and have multiple instances installed on multiple
servers. None are on the default port. When I connect to box 01
without specifying the port in the connection string, it connects.
But on box 02, it will only connect to the instance if I specify the
port name. Is this because it will only connect to the default
instance without specifying a port? or is there something else I need
to have setup on box 02 to make this work?
thanks in advance :)See if the SQL Server Browser service is started on box 02.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Victag" <miketaggart@.gmail.com> wrote in message
news:0ef672ad-08dd-49da-8ff6-1abfcf4982bb@.s12g2000prg.googlegroups.com...
>I am using SQL 2005 and have multiple instances installed on multiple
> servers. None are on the default port. When I connect to box 01
> without specifying the port in the connection string, it connects.
> But on box 02, it will only connect to the instance if I specify the
> port name. Is this because it will only connect to the default
> instance without specifying a port? or is there something else I need
> to have setup on box 02 to make this work?
> thanks in advance :)|||> Is this because it will only connect to the default
> instance without specifying a port? or is there something else I need
> to have setup on box 02 to make this work?
Check to ensure the SQL Browser service is running as Tibor suggested.
Another possible cause is that UDP port 1434 is blocked.
When you connect to the default instance, TCP port 1433 is used by default.
When you connect to a named instance without a specifying a port, the client
requests a list of the named instances and corresponding ports via UDP port
1434 (this is the SQL Browser service). The client then determines the
named instance port.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Victag" <miketaggart@.gmail.com> wrote in message
news:0ef672ad-08dd-49da-8ff6-1abfcf4982bb@.s12g2000prg.googlegroups.com...
>I am using SQL 2005 and have multiple instances installed on multiple
> servers. None are on the default port. When I connect to box 01
> without specifying the port in the connection string, it connects.
> But on box 02, it will only connect to the instance if I specify the
> port name. Is this because it will only connect to the default
> instance without specifying a port? or is there something else I need
> to have setup on box 02 to make this work?
> thanks in advance :)|||On Mar 13, 4:26=A0am, "Dan Guzman" <guzma...@.nospam-
online.sbcglobal.net> wrote:
> > Is this because it will only connect to the default
> > instance without specifying a port? or is there something else I need
> > to have setup on box 02 to make this work?
> Check to ensure the SQL Browser service is running as Tibor suggested.
> Another possible cause is that UDP port 1434 is blocked.
> When you connect to the default instance, TCP port 1433 is used by default=.
> When you connect to a named instance without a specifying a port, the clie=nt
> requests a list of the named instances and corresponding ports via UDP por=t
> 1434 (this is the SQL Browser service). =A0The client then determines the
> named instance port.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVPhttp://weblogs.sqlteam.com/dang/
> "Victag" <miketagg...@.gmail.com> wrote in message
> news:0ef672ad-08dd-49da-8ff6-1abfcf4982bb@.s12g2000prg.googlegroups.com...
>
> >I am using SQL 2005 and have multiple instances installed on multiple
> > servers. =A0None are on the default port. =A0When I connect to box 01
> > without specifying the port in the connection string, it connects.
> > But on box 02, it will only connect to the instance if I specify the
> > port name. =A0Is this because it will only connect to the default
> > instance without specifying a port? or is there something else I need
> > to have setup on box 02 to make this work?
> > thanks in advance :)- Hide quoted text -
> - Show quoted text -
Thanks folks! I have checked and the Browser service is disabled on
both boxes (event he working one), so I could try turning it on, but I
would rather explain/understand what the difference is between these
boxes. I have also confirmed that no ports are blocked at all. Any
other suggestions?|||<<Thanks folks! I have checked and the Browser service is disabled on
both boxes (event he working one), so I could try turning it on, but I
would rather explain/understand what the difference is between these
boxes. I have also confirmed that no ports are blocked at all. Any
other suggestions?>>
We can only explain how things work:
When you connect to a default instance (no backslash and instance name), the data access components
will connect to port 1433. The SQL Server service by default listens to 1433 for a default instance
(well-known port).
The port number for a named instance is determined dynamically the first time you start the
instance. SQL Server asks Windows for an available port, uses it and stores the port number in the
registry (as you can see using SQL Server Configuration Manager). It will try to use the same port
number on subsequent start-ups.
If you from the client app only specify machine name/IP backslash instancename, then you need some
component to translate this instance name to a port number. That component is SQL Server Browser
service. The client data access components connects to the SSB service using port 1434 UDP and
passes the instance name, and the SSB service returns the port number. You can also from the client
app specify machine/IP comma portnumber, so there would now be no use for the SSB service. SQL
Server 2000 didn't come with an SSB service so for 2000 the database engine did this job (listening
on port 1434).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Victag" <miketaggart@.gmail.com> wrote in message
news:bee0415f-6523-45e7-9d46-ad9a01846809@.d62g2000hsf.googlegroups.com...
On Mar 13, 4:26 am, "Dan Guzman" <guzma...@.nospam-
online.sbcglobal.net> wrote:
> > Is this because it will only connect to the default
> > instance without specifying a port? or is there something else I need
> > to have setup on box 02 to make this work?
> Check to ensure the SQL Browser service is running as Tibor suggested.
> Another possible cause is that UDP port 1434 is blocked.
> When you connect to the default instance, TCP port 1433 is used by default.
> When you connect to a named instance without a specifying a port, the client
> requests a list of the named instances and corresponding ports via UDP port
> 1434 (this is the SQL Browser service). The client then determines the
> named instance port.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVPhttp://weblogs.sqlteam.com/dang/
> "Victag" <miketagg...@.gmail.com> wrote in message
> news:0ef672ad-08dd-49da-8ff6-1abfcf4982bb@.s12g2000prg.googlegroups.com...
>
> >I am using SQL 2005 and have multiple instances installed on multiple
> > servers. None are on the default port. When I connect to box 01
> > without specifying the port in the connection string, it connects.
> > But on box 02, it will only connect to the instance if I specify the
> > port name. Is this because it will only connect to the default
> > instance without specifying a port? or is there something else I need
> > to have setup on box 02 to make this work?
> > thanks in advance :)- Hide quoted text -
> - Show quoted text -
Thanks folks! I have checked and the Browser service is disabled on
both boxes (event he working one), so I could try turning it on, but I
would rather explain/understand what the difference is between these
boxes. I have also confirmed that no ports are blocked at all. Any
other suggestions?|||Hi,
You can access named instances (if you know port number) in this way:
tcp:server_name,port_number
--
Regards,
anxcomp|||On Mar 13, 11:12=A0am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> <<Thanks folks! =A0I have checked and the Browser service is disabled on
> both boxes (event he working one), so I could try turning it on, but I
> would rather explain/understand what the difference is between these
> boxes. =A0I have also confirmed that no ports are blocked at all. =A0Any
> other suggestions?>>
> We can only explain how things work:
> When you connect to a default instance (no backslash and instance name), t=he data access components
> will connect to port 1433. The SQL Server service by default listens to 14=33 for a default instance
> (well-known port).
> The port number for a named instance is determined dynamically the first t=ime you start the
> instance. SQL Server asks Windows for an available port, uses it and store=s the port number in the
> registry (as you can see using SQL Server Configuration Manager). It will =try to use the same port
> number on subsequent start-ups.
> If you from the client app only specify machine name/IP backslash instance=name, then you need some
> component to translate this instance name to a port number. That component= is SQL Server Browser
> service. The client data access components connects to the SSB service usi=ng port 1434 UDP and
> passes the instance name, and the SSB service returns the port number. You= can also from the client
> app specify machine/IP comma portnumber, so there would now be no use for =the SSB service. SQL
> Server 2000 didn't come with an SSB service so for 2000 the database engin=e did this job (listening
> on port 1434).
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph=
ttp://sqlblog.com/blogs/tibor_karaszi
> "Victag" <miketagg...@.gmail.com> wrote in message
> news:bee0415f-6523-45e7-9d46-ad9a01846809@.d62g2000hsf.googlegroups.com...
> On Mar 13, 4:26 am, "Dan Guzman" <guzma...@.nospam-
>
>
> online.sbcglobal.net> wrote:
> > > Is this because it will only connect to the default
> > > instance without specifying a port? or is there something else I need
> > > to have setup on box 02 to make this work?
> > Check to ensure the SQL Browser service is running as Tibor suggested.
> > Another possible cause is that UDP port 1434 is blocked.
> > When you connect to the default instance, TCP port 1433 is used by defau=lt.
> > When you connect to a named instance without a specifying a port, the cl=ient
> > requests a list of the named instances and corresponding ports via UDP p=ort
> > 1434 (this is the SQL Browser service). The client then determines the
> > named instance port.
> > --
> > Hope this helps.
> > Dan Guzman
> > SQL Server MVPhttp://weblogs.sqlteam.com/dang/
> > "Victag" <miketagg...@.gmail.com> wrote in message
> >news:0ef672ad-08dd-49da-8ff6-1abfcf4982bb@.s12g2000prg.googlegroups.com...=
> > >I am using SQL 2005 and have multiple instances installed on multiple
> > > servers. None are on the default port. When I connect to box 01
> > > without specifying the port in the connection string, it connects.
> > > But on box 02, it will only connect to the instance if I specify the
> > > port name. Is this because it will only connect to the default
> > > instance without specifying a port? or is there something else I need
> > > to have setup on box 02 to make this work?
> > > thanks in advance :)- Hide quoted text -
> > - Show quoted text -
> Thanks folks! =A0I have checked and the Browser service is disabled on
> both boxes (event he working one), so I could try turning it on, but I
> would rather explain/understand what the difference is between these
> boxes. =A0I have also confirmed that no ports are blocked at all. =A0Any
> other suggestions... Hide quoted text -
> - Show quoted text -
Thanks again. I have made progress and found that the boxes that are
not working have many client aliases created on them, some of which
appear to be invalid. When I deleted the aliases that did not exist
on the server that is working, it fixed them. So now that I know how
to fix it, I am curious to know how these bad aliases got created
since we did not create them manually.|||"Victag" wrote:
>I am curious to know how these bad aliases got created
> since we did not create them manually.
Did you install Visio? For example Visio installation process create for me
some alias. I have to delete it manually.
Regards,
anxcomp

No. of Distribution Database

How many distribution databases can we have ? ... Say I have one publisher
/Published DB and multiple subscribers.
Can I have as many distribution dbs as the no. of subscribing dbs or just
one per published db or just one per publisher ? Can someone get my basics
straight ?
Each publisher can have its own distribution database, but only one.
You can have multiple distribution databases per distribution server with
one or more publisher's using each.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OHj4cDtFFHA.3732@.tk2msftngp13.phx.gbl...
> How many distribution databases can we have ? ... Say I have one publisher
> /Published DB and multiple subscribers.
> Can I have as many distribution dbs as the no. of subscribing dbs or just
> one per published db or just one per publisher ? Can someone get my basics
> straight ?
>
|||So even if the publisher has 4 published dbs, they all write to just one
distribution database.Right ?
Also how easy is to move the distribution db from a local server to a remote
server ?
Also what about once we do move to a remote server and say have multiple
distribution dbs, how easy is it to modify the properties ?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OX7r73tFFHA.1740@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Each publisher can have its own distribution database, but only one.
> You can have multiple distribution databases per distribution server with
> one or more publisher's using each.
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OHj4cDtFFHA.3732@.tk2msftngp13.phx.gbl...
publisher[vbcol=seagreen]
just[vbcol=seagreen]
basics
>
|||Also curious to know if multiple publishers can use the same distribution db
?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OX7r73tFFHA.1740@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Each publisher can have its own distribution database, but only one.
> You can have multiple distribution databases per distribution server with
> one or more publisher's using each.
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OHj4cDtFFHA.3732@.tk2msftngp13.phx.gbl...
publisher[vbcol=seagreen]
just[vbcol=seagreen]
basics
>
|||That is correct - all publications from one publisher will use the same
distribution db.
It is simple to move the distribution db from a local server to a remote
one. All you do is drop all publications and subscriptions, disable
replication, reinstall replication and configure it for the remote
distributor, and then recreate all of your publications and subscriptions.
Modifying the properties of a distribution database is simple. It is best
done on the distributor.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uOtuzHuFFHA.3648@.TK2MSFTNGP10.phx.gbl...
> So even if the publisher has 4 published dbs, they all write to just one
> distribution database.Right ?
> Also how easy is to move the distribution db from a local server to a
remote[vbcol=seagreen]
> server ?
> Also what about once we do move to a remote server and say have multiple
> distribution dbs, how easy is it to modify the properties ?
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OX7r73tFFHA.1740@.TK2MSFTNGP09.phx.gbl...
with
> publisher
> just
> basics
>
|||Multiple publishers by default will use the same distribution database,
unless you select another distribution database.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:esvEUJuFFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Also curious to know if multiple publishers can use the same distribution
db[vbcol=seagreen]
> ?
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OX7r73tFFHA.1740@.TK2MSFTNGP09.phx.gbl...
with
> publisher
> just
> basics
>