Ok. Thanks Hi Cristian, I’m surprised you do not know the drive letters of the server. Sorry if we missed giving you the info... ideally, you should know where data is located on the server in order to locate data files acurately. Searching for files remotely is as fast as doing so locally on the server. In fact it’s even quicker :-) C: contains the OSD: contains the pagefile - not sure you’ll need to look for much data there ;-)L: contains the SQL transaction logsP: contains shared data used for eEnterprise etc...S: contains the SQL data filesT: contains the tempDB That’s the way the cluster is built, no matter which node is the active one. This should help you find files efficently. Please let me know if you need more info. Regards,Patrick De : MesBoulles, Cristian
Envoyé : 3 mai 2007 14:25
À : Poncet, Patrick
Objet : RE: Access cluster serversNo it doesn’t help Patrick.I am looking for a file…have no idea what are the drive letters of the server.And using Remote Desktop would have taken me 15 sec to find the file. I have 30 min trying to find it…blindly. What’s the point? Let me work on this project…when it will be in prod I don’t care if it takes 3 h to find a file..We are in a rush with this project…and the things are not going well at all L All we need are other things to slow us down…. Hope you will understand what I am trying to say and I hope you will take care of this… Thanks a lot! Hello Cristian, You may connect to the administrative shares of the server e.g.: servernamed$ ... then use the windows built-in search feature to look for the file you need. Ideally, we should create the appropriate shares that point to the appropriate physical folders on the server, with the appropriate permissions because administrative shares are dangerous :-) That’s hopefully the direction we’ll take once we complete the plan of normalisation of server accesses. I hope this helps, Take care! Patrick De : MesBoulles, Cristian
Envoyé : 3 mai 2007 13:56
À : Poncet, Patrick
Objet : RE: Access cluster serversOook. I am looking for a file on the server. Have no idea where is it…how can I find it using the remote admin tools? Hi! Normally not... as I explained below, we try to avoid logging on locally onto servers and use tools from the admin pack and control panel to connect remotely to the specific items we need to manage on the remote server. Regards,Patrick De : MesBoulles, Cristian
Envoyé : 3 mai 2007 11:58
À : Poncet, Patrick
Objet : RE: Access cluster serversCan i connect on the server user Remote Desktop with this user? Thanks Hi Cristian, Sorry for the delay. As per your request, you are now Administrator of 10.1.4.196 (QC1S196), the cluster using our model (in progress) for normalizing server accesses. Please make sure you avoid accessing a cluster node individually and always refer to the cluster itself. We must always use QC1S196. In other words, we should never refer to QC1S192 or QC1S193. As local sessions should be used only for adding/removing software and hardware drivers, access to the server should be performed exclusively using local tools (admin pack or local control panel applets) on your PC, using the "run as" feature with a right-click on the shortcut to the tool and using your Administration account. Your administration account on the server is is_balc. I will forward your password in a subsequent email that you may change later by opening a windows session on your system (open a session and change your password). De : MesBoulles, Cristian
Envoyé : 2 mai 2007 16:18
À : Poncet, Patrick
Cc : Bernier, Paul; Labonte, Mario
Objet : RE: Access cluster serversIn the setup phase it’s hard to identify the exact access I need.It really depends on the needs. For example: I had to recreate the replication, the database distribution existed before, was detached but the files were still on the disk.So to recreate it I had to delete this files (I asked Mario to do it).This is just an example so it’s hard to anticipate what other situations may appear. I can ask Mario to do this things but I find this inefficient and it delaying the things (and we don’t have much time to spare).He is also very busy so I don’t think he has time to baby seat me. When this project will be in production we will see the day-by-day needs. But now having admin rights will spare us of wasting time. Speaking of wasting time…righting emails doesn’t help J Thank you! Hi Cristian, We are actually meeting on this topic today. We are following best practice methods to normalize access to servers for everyone within the IT department. We are putting together a security model that will allow us to accomodate your request. It’ll be a few days before we can define the complete model. However, since you are in a rush, we can accomodate an intermediate solution if you would please define more accurately what you need to do on the cluster. i.e.: access perfmon data (cpu usage, disk queue length etc), access event viewer content, access log file on servers file systems etc... Please let us know what your immediate access requirements are. Thanks,Patrick De : MesBoulles, Cristian
Envoyé : 2 mai 2007 14:27
À : Poncet, Patrick
Cc : Bernier, Paul; Labonte, Mario
Objet : Access cluster serversI need admin rights on both nodes of the cluster in Quebec.Please take care of this as soon as possible. Not having the rights is slowing down my work (I have to keep asking Mario to do things for me). Thank you Cristian MesBoullesAdministrateur de bases de données/ Database AdministratorCSTI / ITSC Téléphone: 555-555-2427 ext: 3748Télécopieur: 555-555-0717E-mail: cristian.MesBoulles@La_Conne.ca