Named Pipes

I have a SQL Server 2000 Enterprise Edition database with a Windows 2000
operating system. The Client Network Utility the protocols that are Enabled
are TCP/IP and Named Pipes.
TCP/IP is the first protocol in the list and second is Named Pipes.
Could Named Pipes in the Enable protocol list slow down the database or
connection performance?
Thank You,If it's just the fact that the Named Pipes protocol is enabled, there
shouldn't be any performance implication. If you are talking about the
performance implication of using named pipes vs. using TCP/IP, I'm not aware
of any significant difference as of late, although there were some references
in the past (well, way back) about named pipes being less performant in some
cases (see http://support.microsoft.com/?kbid=156430 for an example. Note
that it's last reviewed in 2003)
In general, I prefer TCP/IP not because of any performance implication, but
for administrative convenience. For instance, names pipes depend on NetBIOS,
and require more ports through a firewall.
Linchi
"Joe K." wrote:
> I have a SQL Server 2000 Enterprise Edition database with a Windows 2000
> operating system. The Client Network Utility the protocols that are Enabled
> are TCP/IP and Named Pipes.
> TCP/IP is the first protocol in the list and second is Named Pipes.
> Could Named Pipes in the Enable protocol list slow down the database or
> connection performance?
> Thank You,
>

named instances and sp3a - how to enable access?

As I understand it, the slammer virus took advantage of port 1434 which is e
nabled over udp for sql clients to find out the ports named instances are us
ing. If applying sp3a disables listening on port 1434, can named instances s
till be used? Do the ports
need to be known and hardcoded in advance?
TIA,
John BrownIn the Server network Utiliy simply choose a fixed port number, and the
clients would have to know the fixed port number to connect.
Or you could still use Dynamic ports, (the check box) and enable port 1434,
and the end user does NOT have to know the port number...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F9DBE64E-3137-41B3-91D1-ECDFC0086B08@.microsoft.com...
> As I understand it, the slammer virus took advantage of port 1434 which is
enabled over udp for sql clients to find out the ports named instances are
using. If applying sp3a disables listening on port 1434, can named instances
still be used? Do the ports need to be known and hardcoded in advance?
> TIA,
> John Brown|||Thanks Wayne,
so if I enable 1434, does this open me up to the slammer virus still?
TIA,
John Brown|||SP3a fixes the exploit in the SQL Server Resolution Service used by Slammer,
it does not stop the server listening on UDP1434 as this is required for
resolving endpoints for named instances unless every client has the port
hard coded into a connection string or an alias in the client network
utlity. As long as you have SP3a applied you'll be okay but make sure that
port is still blocked on external firewalls.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F5708C23-286E-49B6-88BC-4CD6C5F1C768@.microsoft.com...
> Thanks Wayne,
> so if I enable 1434, does this open me up to the slammer virus still?
> TIA,
> John Brown

named instances and sp3a - how to enable access?

As I understand it, the slammer virus took advantage of port 1434 which is enabled over udp for sql clients to find out the ports named instances are using. If applying sp3a disables listening on port 1434, can named instances still be used? Do the ports need to be known and hardcoded in advance
TIA
John BrownIn the Server network Utiliy simply choose a fixed port number, and the
clients would have to know the fixed port number to connect.
Or you could still use Dynamic ports, (the check box) and enable port 1434,
and the end user does NOT have to know the port number...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F9DBE64E-3137-41B3-91D1-ECDFC0086B08@.microsoft.com...
> As I understand it, the slammer virus took advantage of port 1434 which is
enabled over udp for sql clients to find out the ports named instances are
using. If applying sp3a disables listening on port 1434, can named instances
still be used? Do the ports need to be known and hardcoded in advance?
> TIA,
> John Brown|||SP3a fixes the exploit in the SQL Server Resolution Service used by Slammer,
it does not stop the server listening on UDP1434 as this is required for
resolving endpoints for named instances unless every client has the port
hard coded into a connection string or an alias in the client network
utlity. As long as you have SP3a applied you'll be okay but make sure that
port is still blocked on external firewalls.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"John Brown" <anonymous@.discussions.microsoft.com> wrote in message
news:F5708C23-286E-49B6-88BC-4CD6C5F1C768@.microsoft.com...
> Thanks Wayne,
> so if I enable 1434, does this open me up to the slammer virus still?
> TIA,
> John Brown

name pipe VS tcpip

I found that I can only use name pipe to connect to the sql server.
When I use tcpip, it fails to connect.
I am sure I have enabled the TCP/IP protocol in SQL server
What causes it?
sql is using port no.1433 and I have try using dynamically determine port
and force it to 1433 in ODBC setting.
thank you very much
"!" <!@.!.!> wrote in message news:%236FqHb0qEHA.3416@.TK2MSFTNGP15.phx.gbl...
> I found that I can only use name pipe to connect to the sql server.
> When I use tcpip, it fails to connect.
> I am sure I have enabled the TCP/IP protocol in SQL server
> What causes it?
> sql is using port no.1433 and I have try using dynamically determine port
> and force it to 1433 in ODBC setting.
There are a lot of reasons that this can fail, application type being one of
them. Reference the following as a troubleshooting guide:
http://support.microsoft.com/default...b;en-us;827422
Steve

My SQL Server Agent

hi,
my sql server agent, in the properties window, mail
profile is not enabled?
can somebody help me, what is the problem, i am new to
this area.
thanks
sathyathanks Jens >--Original Message--
>Hello Sathya,
>you have to use a MAPI E-Mail Client to use the integrated Mail functions of
>SQL Server. For example installing Outlook and adding a mail profile to the
>server will make you able to use the Mail-Profile specified for the
>computer.
>HTH, Jens S=FC=DFmeyer.
>Don=B4t know how to do this?
>Just read:
>http://groups.google.de/groups?
q=3Dmapi+sql+server&hl=3Dde&lr=3D&ie=3DUTF-8&oe=3DUTF-8
>&selm=3D3b4939ad_2%40news.nwlink.com&rnum=3D1
>
>> my sql server agent, in the properties window, mail
>> profile is not enabled?
>
>.
>

My Report feature

Currently - our Reporting Services site is setup so that all Domain Users can access it. We are starting to use Report Builder now. I have enabled the My Reports folder feature that that creates a user folder for anyone that logs onto the site. Is there a way to just create the user folders for certain people?

Yes. You do not have to use the "My Reports" function at all. Just create a folder for each user under the Home folder and then assign them at least browser rights to that folder. Also, be sure they have browser rights to the Home folder or they will not be able to see their own folder as this follows a hierachial structure.