Search Amazon.com:
Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us $3,400 per month for bandwidth bills alone, and since we don't believe in shoving popup ads to our registered users, we try to make the money back through forum registrations.
«12 »
  • Post
  • Reply
cptInsane0
Apr 10, 2007

...and a clown with no head

Umm, it shouldn't take 3 hours. Took me about 15 minutes.

Adbot
ADBOT LOVES YOU

Ashex
Jun 24, 2007

These pipes are cleeeean!!!

It does vary by hardware, there's four updates to apply with reboots/running spconfig between each.

tomapot
Apr 7, 2005
Suppose you're thinkin' about a plate o' shrimp. Suddenly someone'll say, like, plate, or shrimp, or plate o' shrimp out of the blue, no explanation. No point in lookin' for one, either. It's all part of a cosmic unconciousness.

zapateria posted:

Spending Friday night installing SP1 and the June CU I just can't believe that on todays computers with tens of gigabytes of ram and quad core cpus, it literally takes 3 hours to replace a bunch of files, or what the hell it is it's doing.

Depending on the patches it also updates the database schema. So it also depends on the SQL server and the size of the databases.

Edit: And the number of servers in your farm. We have 2 Web Front Ends, and 3 Application Servers. So installing bits on all 5 then runing the config wizard on all of them took some time.

Beelzebubba9
Feb 24, 2004


Hi all,

I was tasked with creating an internal KB for my department to maintain process documentation, how-to articles, SAS70 documentation and department records. Other than requiring levels of access rights, this seems like about the simplest KB deployment I could imagine, and I was planning on using Sharepoint Foundation to build it. My understanding is that almost any CM software (wiki, Drupal site) could handle the same function, but I'm more familiar with Windows than Linux and I wanted to use this as a chance to learn Sharepoint since it seems to be increasingly common. I'm not working against any hard deadline and I don't expect the dataset to come close to the 4GB limit of SQL Express 2008, so this seems like a perfect learning experience. In addtion to the points laid out in the OP, I was wondering:

1. Is it a bad idea to use Sharepoint Foundation? Would I love life more if I just used an OSS alternative?
2. Is using Sharepoint Foundation's internal database a bad idea for such a simple site?
3. If something miraculous happens and people start using the site beyond the original intentions, how hard is it to export the databse to a real SQL server farm and/or update the Sharepoint install from Foundation?
4. Does anyone have a good resource for site design and/or templates? Or should I just shell out $40 and buy the Professional SharePoint 2010 Administration book that was recommended earlier in this thread?

Thanks in advance.

Corvettefisher
Sep 8, 2007



Beelzebubba9 posted:


1. Is it a bad idea to use Sharepoint Foundation? Would I love life more if I just used an OSS alternative?
2. Is using Sharepoint Foundation's internal database a bad idea for such a simple site?
3. If something miraculous happens and people start using the site beyond the original intentions, how hard is it to export the databse to a real SQL server farm and/or update the Sharepoint install from Foundation?
4. Does anyone have a good resource for site design and/or templates? Or should I just shell out $40 and buy the Professional SharePoint 2010 Administration book that was recommended earlier in this thread?

Thanks in advance.

First Questions for you!

1. How many employees do you have? How many of those will be using this
2. Is this Knowledge base going to be getting documents uploaded? office type files, pdf, small databases, etc?
3. How often are people going to be adding and taking away from it?
4. What hardware do you have? NAS? Servers? Network? Sharepoint loves to gobble resources make sure you don't have a shotty set up. DNS also HAS to be working fine for sharepoint to work right, you do not want it on a domain with a iffy DNS


My opinion as of now, but answer the previous and following questions for a more defined answer

1. Yes it can be done with foundation, will it be as easy as the next level up? Probably not, you will most likely need to get more in the nitty gritty and script a lot of stuff. I would recommend going to Standard, for future expansion and just great features you will thank yourself on later on it will help. I don't think foundation has the ability to Failover or cluster.
2. Depends, Do you want to be looking for a new job when the server shits itself? and it will happen! Small companies usually can get away with the internal workings, but if you have over 50 seats look into a stand alone SQL server, with backups!
3. If there is even the slightest possibility that this is going to become a day-to-day application usage get a standalone SQL server trust me, SQL and Sharepoint will run on the same host but you are going to get crippling speeds in I/O, High Mem usage, and CPU cycles. Sharepoint already is going to eat alot of hardware, don't push it. Run these things in VMs if possible snapshots will save your rear end.
4. That books is kinda okay, it will put you to sleep, your best chance is that book and this one http://www.amazon.com/Microsoft-Sha...18877937&sr=1-1

Yes I used that too, it is a great visual reference, and believe me you will use it.

Beelzebubba9
Feb 24, 2004


Corvettefisher posted:

1. How many employees do you have? How many of those will be using this

The company has ~70 employees, but I doubt more than 30 will ever access the site in total, let alone at once. My department employs maybe 30 people, but I only expect 5-10 of them to contrinute to the site in total.

Basically we have very little process documentation and most of our records are scattered around as various folders of .PDFs and Excel Spreadsheets and what I'd like to do is consolidate them into a centrally managed and searchable system so that if I and my predecessor get hit by a bus the rest of the company won't be SOL.

Corvettefisher posted:

2. Is this Knowledge base going to be getting documents uploaded? office type files, pdf, small databases, etc?

Yes. I don't imagine that there will be any great quantity, but I careers have likely been ended over less ambigious speculation.

Corvettefisher posted:

3. How often are people going to be adding and taking away from it?

Once all of the outstanding content gets integrated into the site, I expect no more than a few times a week.

Corvettefisher posted:

4. What hardware do you have? NAS? Servers? Network? Sharepoint loves to gobble resources make sure you don't have a shotty set up. DNS also HAS to be working fine for sharepoint to work right, you do not want it on a domain with a iffy DNS

The company has a number of NOCs and pretty massive hardware resources available (I just finished setting up a 2k8 R2 test server in a VM with 8GB of RAM), so unless we're talking about a bare-to-the-metal install on a dual socket server with 64GB of RAM and SSDs for IO then I think we'll be fine. Our DNS is pretty rock solid, and if it breaks, it gets fixed ASAP by people far more capable than I.


Corvettefisher posted:

My opinion as of now, but answer the previous and following questions for a more defined answer

1. Yes it can be done with foundation, will it be as easy as the next level up? Probably not, you will most likely need to get more in the nitty gritty and script a lot of stuff. I would recommend going to Standard, for future expansion and just great features you will thank yourself on later on it will help. I don't think foundation has the ability to Failover or cluster.
2. Depends, Do you want to be looking for a new job when the server shits itself? and it will happen! Small companies usually can get away with the internal workings, but if you have over 50 seats look into a stand alone SQL server, with backups!
3. If there is even the slightest possibility that this is going to become a day-to-day application usage get a standalone SQL server trust me, SQL and Sharepoint will run on the same host but you are going to get crippling speeds in I/O, High Mem usage, and CPU cycles. Sharepoint already is going to eat alot of hardware, don't push it. Run these things in VMs if possible snapshots will save your rear end.
4. That books is kinda okay, it will put you to sleep, your best chance is that book and this one http://www.amazon.com/Microsoft-Sha...18877937&sr=1-1

Yes I used that too, it is a great visual reference, and believe me you will use it.

1. What, roughly, are the licensing costs for Sharepoint Standard?
2. Again, pardon my ignorance, but would would the approximate licensing costs for that be?
3. Thanks!
4. I'll definitely take a look at the book.

Corvettefisher
Sep 8, 2007



Beelzebubba9 posted:

The company has ~70 employees, but I doubt more than 30 will ever access the site in total, let alone at once. My department employs maybe 30 people, but I only expect 5-10 of them to contrinute to the site in total.
Standard will handle that fine, but I would get in a meeting with some people and see if you plan on expanding any time soon.

quote:

Basically we have very little process documentation and most of our records are scattered around as various folders of .PDFs and Excel Spreadsheets and what I'd like to do is consolidate them into a centrally managed and searchable system so that if I and my predecessor get hit by a bus the rest of the company won't be SOL.
Okay, then looking into standard will be a better option, workflows can be a God send in the right enviroment.

Yes. I don't imagine that there will be any great quantity, but I careers have likely been ended over less ambigious speculation.
Okay, then looking into standard will be a better option, workflows can be a God send in the right environment. If it is consolidating all your companies mission critical data don't use the SQL express, look into a SQL server. Sharepoint does quite a bit of backend I/O and it will become apperent when you have 10-20 users all trying to access pdfs at 9am. Plus a full SQL server has nice backup features and what not, but do what is in your budget and SLA's


quote:

Once all of the outstanding content gets integrated into the site, I expect no more than a few times a week.
Good just do not let them make it a ticketing solution


quote:

The company has a number of NOCs and pretty massive hardware resources available (I just finished setting up a 2k8 R2 test server in a VM with 8GB of RAM), so unless we're talking about a bare-to-the-metal install on a dual socket server with 64GB of RAM and SSDs for IO then I think we'll be fine. Our DNS is pretty rock solid, and if it breaks, it gets fixed ASAP by people far more capable than I.

Wow... Sounds like you got the back end! Sharepoint will probably run you about 8GB for the number of users you have(I am projecting for all users as a failsafe), probably 4~5GB for a dedicated SQL server.


quote:

1. What, roughly, are the licensing costs for Sharepoint Standard?
2. Again, pardon my ignorance, but would would the approximate licensing costsfor that be?

Foundations is free with server 2008 r2, Standard is like 799(this might be for Office communicator 2010) or 2 grand I can't really remember off the top of my head. I will look through a previous work order.

You can compare editions here
http://sharepoint.microsoft.com/en-...Comparison.aspx
check what is best, lemme know if you have any other questions

Sharepoint Foundations install => http://www.microsoft.com/download/e...ls.aspx?id=5970
OP if you see this can you add the link to the OP

Corvettefisher fucked around with this message at Oct 17, 2011 around 20:34

Beelzebubba9
Feb 24, 2004


Corvettefisher posted:

awesome advice

Thank you very much! This is all very useful.

GateheaD
Sep 27, 2005

Gatorade me bitch


Our document management software is basically SQL + some lovely plugins for office, which isnt update anymore.

About 100 users on Citrix/ Desktops with about 50,000 documents.

Sharepoint going to cut it, will it make my life easier, why do I work here?

KennyTheFish
Jan 13, 2004


Sharepoint is like a pair of vice grips when working on a car. It is never the correct tool, but it can normally be a brute force substitute.

Corvettefisher
Sep 8, 2007



GateheaD posted:

Our document management software is basically SQL + some lovely plugins for office, which isnt update anymore.

About 100 users on Citrix/ Desktops with about 50,000 documents.

Sharepoint going to cut it, will it make my life easier, why do I work here?
Probably, users will take a bit of time getting use to SharePoint(Que training sessions!!!), ACL's can be a pain depending how strict you need it to be. And Sharepoint usually takes someone reading the logs once a week, and managing backend stuff.

It will make your life easier from citrix but don't expect to be able to snooze in the office.

Ashex
Jun 24, 2007

These pipes are cleeeean!!!

Corvettefisher posted:

Probably, users will take a bit of time getting use to SharePoint(Que training sessions!!!), ACL's can be a pain depending how strict you need it to be. And Sharepoint usually takes someone reading the logs once a week, and managing backend stuff.

It will make your life easier from citrix but don't expect to be able to snooze in the office.

Don't forget about audiences, that's an easy way to filter links and web parts. On the main page I have a document library that's only visible to people in the engineering group, I've considered adding an announcement section that displays info based on the office you're in.

whiskas
May 30, 2005


Just got this in my inbox:

Hi Whiskas,

I don’t have SharePoint on my computer can you have that arranged?

Jane Doe
Executive Assistant


Systems like Sharepoint will never be truly useful until the paper pushing/file cabinet generation retires.

Pray for me.

cptInsane0
Apr 10, 2007

...and a clown with no head

Yeah, the older generation is always reluctant/too uneducated(in technology) to adapt to new stuff quickly. Much of my company has no idea what the corporate intranet even is, despite the emails they were sent for months before it launched. Now I go to new hire orientation and tell them about it, as well as the yearly re-certification trainings. It gets some people that otherwise had no clue, but for many, it goes in one ear and out the other.

Misogynist
Jul 14, 2003

hubthumping

cptInsane0 posted:

Yeah, the older generation is always reluctant/too uneducated(in technology) to adapt to new stuff quickly. Much of my company has no idea what the corporate intranet even is, despite the emails they were sent for months before it launched. Now I go to new hire orientation and tell them about it, as well as the yearly re-certification trainings. It gets some people that otherwise had no clue, but for many, it goes in one ear and out the other.
General rule of IT: people need tech demos showing them all the cool poo poo they can do or they don't get it.

cptInsane0
Apr 10, 2007

...and a clown with no head

Yep. I do that, but they still don't quite get it. The orientation helps some, and the fact that they have to go there to check their pay stubs.

whiskas
May 30, 2005


Misogynist posted:

General rule of IT: people need tech demos showing them all the cool poo poo they can do or they don't get it.

The general problem with tech demos: if you were to ask a random person in your audience to do a task that you had just demonstrated they would likely stumble around the interface clumsily, and eventually admit failure.

The second problem with tech demos: you're demonstrating that you know how to work the system. From that point on if anyone needs something done in that system they'll just ask you to do it, as opposed to doing it themselves.

Pro Tip:

If I'm doing any kind of training or orientation session in SharePoint I WILL pick a random person and ask them to do a task I had just demonstrated. 90% of the time they have trouble but that's fine and expected. First, you have a chance to address a lot of issues the other people in your audience would have had if they were to try and repeat it on their own. And secondly, it makes them pay attention because they're afraid they'll be picked next and made a fool out of. Finally, having a tech geek do stuff in front of them and say it's easy isn't very convincing. But having the bimbo blond secretary do it in front of them does prove it is easy.

cptInsane0
Apr 10, 2007

...and a clown with no head

I am trying to make a collapsible list, and as of right now, I am following this guide: http://plugins.jquery.com/project/menuTree

I have set up my list like that, which is how I had already set it up before I decided to make it collapse, and I followed the instructions.

However, I don't actually have access to the <head> section of the page. Not without going into the master page, and I don't especially feel like doing that. So, can I just include the library in-line? If so, I have already done that, and it didn't do much. Also, it shows some CSS to use to style the thing, and I know how to put that inline, but it doesn't really tell you how to label your list items to designate them as something to collapse and expand. It looks like the anchor is what does it. I am not sure if It is just not calling the jquery library properly. Do I need to just do that in a separate web part? If so, does it go above or below the list?

Ashex
Jun 24, 2007

These pipes are cleeeean!!!

Word of advice: Never remove the farm admin from the administrators group as the User profile service app will shoot itself in the face.

I tried to change the user it the service app runs under and which unprovisioned it resulting in me having to rebuild it (manage to keep the DBs intact)which got it back to working however as soon as I rebooted it after some updates it failed to start so I had to set it back to run under the farm admin.

Also, anyone got suggestions for making SharePoint more Project management friendly? I'm setting up a site for my team so we can keep track of our projects and I want to be able to easily look and see who's working on what project and see what's on our roadmap. I'm currently using tasks but it's kinda limited.

Mr. Gravy
Mar 17, 2004

Oh! Mr. Gravy!

Would you guys happen to know of any "official" resources that essentially describe why Sharepoint is a bad idea?

One of our clients is getting really wanting to implement Sharepoint for document management and ticketing, and based on what I've seen so far in this thread, that seems like a fairly bad idea. If there's anything I could point them to that might change their minds, please let me know.

Corvettefisher
Sep 8, 2007



Mr. Gravy posted:

Would you guys happen to know of any "official" resources that essentially describe why Sharepoint is a bad idea?

One of our clients is getting really wanting to implement Sharepoint for document management and ticketing, and based on what I've seen so far in this thread, that seems like a fairly bad idea. If there's anything I could point them to that might change their minds, please let me know.

Sharepoint isn't a bad idea, Just show them the Total Cost of setting up and running it. Most companies will run from it, unless they actually need it.

Ashex
Jun 24, 2007

These pipes are cleeeean!!!

Mr. Gravy posted:

One of our clients is getting really wanting to implement Sharepoint for document management and ticketing, and based on what I've seen so far in this thread, that seems like a fairly bad idea.

Most of what you're reading here is a bunch of windows admins bitching about SharePoint. It doesn't matter what system we're administering, we're still going to bitch about it.

KennyTheFish
Jan 13, 2004


When we finish bitching about Sharepoint, we move on to our backup and ticket systems.

Ashex
Jun 24, 2007

These pipes are cleeeean!!!

I'm moving on to greener pastures which means I'm passing on the torch for being the SharePoint admin. The new guy doesn't start until the end of the month though so I've got time to write up docs and such but I'm going to train him on SharePoint even though I'll be his backup.

Anyone got ideas for things I should mention? My plan is to tear down my test server and walk him through building it from scratch so he knows about all the working bits to it.

Corvettefisher
Sep 8, 2007



Ashex posted:

I'm moving on to greener pastures which means I'm passing on the torch for being the SharePoint admin. The new guy doesn't start until the end of the month though so I've got time to write up docs and such but I'm going to train him on SharePoint even though I'll be his backup.

Anyone got ideas for things I should mention? My plan is to tear down my test server and walk him through building it from scratch so he knows about all the working bits to it.

Passwords, Backup procedures, custom site/xml scripts, update policies, and what normal load is. Everything else he should be able to grasp if he has EXP

Ashex
Jun 24, 2007

These pipes are cleeeean!!!

Corvettefisher posted:

Passwords, Backup procedures, custom site/xml scripts, update policies, and what normal load is. Everything else he should be able to grasp if he has EXP

You reminded me to update the architecture document! It's got most of that in there, I'll need to add in the bit about document templates and columns too.


To add to SharePoint mindfuckery, I can't get my audiences to work. I know why but when I fix it to work nobody sees anything

The source of the issue is how our domain is setup, we have separate sub-domains for each continent, so eur.company.com, aus.company.com, and na.company.com

the problem arises in that the domain name for na.company.com is different fromthe forest name, so while it's location at na.company.com you login with foo\user.

So the user profile app imported all the user profiles and it looks fine for the other domains but na.company.com is all jacked up. I tried enabling netbios but it still imports as na\user.

When audiences aren't working everyone sees everything, if I correct the issue (add the user profile proxy to the service connection for the web app) then audiences work but since the domain na\ doesn't exist nobody sees anything.

Edit: Looks like I need to do this.

Ashex fucked around with this message at Nov 11, 2011 around 21:29

the spyder
Feb 18, 2011

Lost an Apex seal? Find it at Spyder's home for Lost Rotarys

Fun times, Engineering Manager just asked if we could start using Sharepoint. He thinks it is just part of Office and automatically links everyone together!

Corvettefisher
Sep 8, 2007



the spyder posted:

Fun times, Engineering Manager just asked if we could start using Sharepoint. He thinks it is just part of Office and automatically links everyone together!



Well, if you have someone to set it up right most of the stuff will sync office things, but it is a shitload of backend work

the spyder
Feb 18, 2011

Lost an Apex seal? Find it at Spyder's home for Lost Rotarys

I am the admin, but thankfully I got them to put it off until spring after our new vm environment will be in place and I can focus on all the fun things I have read about Sharepoint.

Ashex
Jun 24, 2007

These pipes are cleeeean!!!

Technically you can link SharePoint to the office apps! I added a Document library to outlook so I can dig up information people ask about quickly. I also have OneNote notebooks stored on SharePoint so I can share it with multiple people! You can also open documents directly through a office app using the document url.

theperminator
Sep 16, 2009

Boil up some Mountain Dew; it's gonna be a long night.

I'm working with Sharepoint Foundation for a customer, and they're having an issue uploading large files.
I've managed to increase the max filesize by setting maxAllowedContentLength to 2147483647 and this works when I upload, but not the customer.

I believe this is to do with the executionTimeout setting in IIS, because when i limit my upload speed to match his DSL connection it fails to upload, but works when not limited to 512Kb/s

I've set executiontimeout to 3600 in the sharepoint - 80 vhost's web.config and the web.config in 14/Template/Layouts and restarted IIS but it doesn't fix the issue.

Anyone know what I'm missing here?

UFO
Sep 11, 2001
ASK ME ABOUT NEVER HITTING THE REPORT BUTTON AGAIN.
I'm great at pissing off the admins!

My infopath form library for our CSRs has reached over 50k entries! Yippie!

I've got real time tracking for several different groups, accountability has sky rocketed, data entry is swift and efficient, reports are automated and our response time to outages (large ISP) is better than ever. God drat, we needed this SO bad. I love hunting out these terrible processes and gutting them to pieces.

Projects just around the corner include revamping our retention group and voice provisioning team (dear god, their current implementation...). On top of it, my management has seen fit to give me a junior/apprentice to work with. He's your typical mountain dew sperg but he has some great abilities and is learning to work in our environment.

The biggest hurdle I've encountered so far is the initial design and development phase. I've come to understand that if some part of the process is cumbersome, it is because I'm going about it incorrectly. This train of thought seems to fit every time.

Tab8715
May 20, 2006


Has anyone attempted the 70-667 SharePoint Configuration Exam? I'm going to start studying studying pretty soon here, I'm rather interested how the will affect my future employment but it seems most SharePoint jobs are mostly for development.

FlyWhiteBoy
Jul 13, 2004


I'm new to SP and being forced to implement MOSS 2007 at our organization. Can someone recommend a good backup solution for SP? Someone has recommended Idera in addition to our normal server backups so we can easily restore individual files that a user accidentally deletes.

Mierdaan
Sep 14, 2004



FlyWhiteBoy posted:

good backup solution for SP

Corvettefisher
Sep 8, 2007



FlyWhiteBoy posted:

I'm new to SP and being forced to implement MOSS 2007 at our organization. Can someone recommend a good backup solution for SP? Someone has recommended Idera in addition to our normal server backups so we can easily restore individual files that a user accidentally deletes.

Run it virtually and take snapshots.... really the easiest way

Ashex
Jun 24, 2007

These pipes are cleeeean!!!

FlyWhiteBoy posted:

I'm new to SP and being forced to implement MOSS 2007 at our organization. Can someone recommend a good backup solution for SP? Someone has recommended Idera in addition to our normal server backups so we can easily restore individual files that a user accidentally deletes.

Use stsadm for making site backups. And why the hell are you using 2007? Whoever decided to go with that over 2010 is an idiot.

FlyWhiteBoy
Jul 13, 2004


Ashex posted:

Use stsadm for making site backups. And why the hell are you using 2007? Whoever decided to go with that over 2010 is an idiot.

It was purchased several years ago and hasn't been used. Also we have Commvault currently backing up my test environment but I think a SP specific backup solution like Idera might work a little better. From what I understand I'll be able to recover individual files and changes more easily.

jebrown84
Aug 27, 2005

Help me Johnny Boy you're my only hope.

So I am trying to add a Content Database from a Sharepoint 2.0 to Sharepoint 3.0 on a different server. I'm using the stsadm command to add the database but I keep getting a "'Docs_PK' is not a constraint." I've googled the error and haven't come up with much in ways of fixing it. I'm a SQL newb so I'd appreciate some guidance.

Adbot
ADBOT LOVES YOU

FlyWhiteBoy
Jul 13, 2004


I'm getting a really weird invalid input error when attempting to create a new web application. How can I clear all the database information and IIS metabase data to essentially do a new fresh install? Easy answer would be to reinstall the OS on both servers but I have some configurations I'd like to keep.

TLDR: I broke my SP install how do I start over?

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply
«12 »