| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2005-03-24 : 22:17:39
|
| I had an issue in my production. The following information is from SQL Server logs: 2005-03-20 14:32:22.37 server SQL server listening on TCP, Shared Memory, Named Pipes.2005-03-20 15:02:36.32 server SQL server listening on TCP, Shared Memory, Named Pipes.2005-03-20 15:04:33.38 server SQL server listening on TCP, Shared Memory, Named Pipes.2005-03-21 02:02:19.71 server SQL server listening on TCP, Shared Memory, Named Pipes.2005-03-22 02:02:09.70 server SQL server listening on TCP, Shared Memory.2005-03-23 02:02:10.73 server SQL server listening on TCP, Shared Memory.2005-03-24 02:02:09.00 server SQL server listening on TCP, Shared Memory.How can I find when exactly the Named Pipes was disabled? And who did it?Canada DBA |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-24 : 22:19:39
|
| you can't. that is why you should lock your server down so only a select few can make changes to the system. -ec |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2005-03-25 : 23:09:26
|
How? quote:
Originally posted by eyechart
you can't. that is why you should lock your server down so only a select few can make changes to the system. -ec
Canada DBA |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-03-25 : 23:22:47
|
| 1. Regarding disabling named pipes; is it only possible from within SQL Server EM's properties or it is possible to do it from within Windows? I want to know has someone done it from within the Windows or SQL-Server.2. There is a SQLAdmin domain id which can log in to the SQL Server as well. Almost everybody knows this id and the password. How can I control people to prevent these kind of issues?Canada DBA |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-26 : 06:53:07
|
| 1. The Server Network utility can be run without using Enterprise Manager.2. You deny access to that SQL admin ID. Admin passwords are meant for admins only. If you can't control people's use of this login, remove the login from your SQL Server. |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-03-26 : 11:42:15
|
| Hey Rob, Would you explain more about The Server Network utility can be run without using Enterprise Manager. I want to find out if someone using EM has disabled the Named Pipes or one of our Network teams did it.Canada DBA |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-26 : 11:46:46
|
quote:
Originally posted by farhadr
Hey Rob, Would you explain more about The Server Network utility can be run without using Enterprise Manager. I want to find out if someone using EM has disabled the Named Pipes or one of our Network teams did it.
The server network utility is in the program group for SQL Server. Anyone who can login to your server (and has admin privs) can run the utility and disable named pipes.-ec |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-03-26 : 11:50:00
|
My DTS packages are using the SQLAdmin id to access a file server to import daily text files. I am using SQLAdmin because it is a domain id. If I deny access to SQL Server, then what happens to the DTS packages?quote:
Originally posted by robvolk
2. You deny access to that SQL admin ID. Admin passwords are meant for admins only. If you can't control people's use of this login, remove the login from your SQL Server.
Canada DBA |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-03-26 : 11:54:58
|
| Eyechart, The server network utility is in the program group for SQL Server.Would you address me step by step. I want to locate it.Canada DBA |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-26 : 12:01:08
|
quote:
Originally posted by farhadr
Eyechart, The server network utility is in the program group for SQL Server.Would you address me step by step. I want to locate it.
Look in the program group for SQL Server and you will find the Server Network Utility. It is sitting there right next to Enterprise Manager and Query Analyzer.Also, please familiarize yourself with BOL (Books Online). This is another item in the SQL Server program group. Look up any terms that we use that you don't understand in it first. Please don't take offense to this, but you need to take a class on SQL Server administration.-ec |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-26 : 13:45:24
|
quote:
My DTS packages are using the SQLAdmin id to access a file server to import daily text files. I am using SQLAdmin because it is a domain id. If I deny access to SQL Server, then what happens to the DTS packages?
This ID should have the absolute minimum permissions necessary to perform the task at hand. There is no reason for a DTS package to require admin-level privileges. You will need domain permissions to access network resources, but that's all. |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-03-29 : 10:38:13
|
I was confused by "program group" term. I found the Server Network Utility in the SQL Server menu under Programs.  quote:
Originally posted by eyechart
quote:
Originally posted by farhadr
Eyechart, The server network utility is in the program group for SQL Server.Would you address me step by step. I want to locate it.
Look in the program group for SQL Server and you will find the Server Network Utility. It is sitting there right next to Enterprise Manager and Query Analyzer.Also, please familiarize yourself with BOL (Books Online). This is another item in the SQL Server program group. Look up any terms that we use that you don't understand in it first. Please don't take offense to this, but you need to take a class on SQL Server administration.-ec
Canada DBA |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-03-31 : 09:07:20
|
| Still the Named Pipe in production is disabled. Can I enable it without any issue? Should I do it after work hours?Canada DBA |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-31 : 10:37:12
|
| You can re-enable it any time, it won't cause any problems. |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-03-31 : 10:59:04
|
Thanks Rob!quote:
Originally posted by robvolk
You can re-enable it any time, it won't cause any problems.
Canada DBA |
|
|
|
|
When Named Pipes was disabled?