rpwillis

Hi Alex, That's a very good point. Easily sorted by putting individual permissions on the photos in the document library though. Richard SalamanderSoft

In SharePoint Central Admin go to Share Services Administration: SharedServices > User Profile and properties Click View Profile Properties at the bottom Open the drop down for Name and select Edit Under Property Import Mapping select "Enter field to map: (Clear to unmap)" Type samaccountname in the text field OK to save. You'll then need to run a full import and then wait for the Profile Synchronization to run (by default hourly). Richard SalamanderSoft http://www.salamandersoft.co.uk Active Directory & SharePoint provisioning

Out of the box with MOSS, you should be able to set what the display name is set to in the "User profile and properties" section of the Shared Services section of Central Admin. Technet has more details at http://technet.microsoft.com/en-us/library/cc263503.aspx. Alternatively you can use the SharePoint object model to set it to whatever you want. I've done this in a few schools to have display names like Mr Smith, rather than the AD display name. Richard SalamanderSoft Active Directory & SharePoint provisioning

Can you connect to the database using anything else such as management studio? Is the service for the instance running? Richard

Similarly to Geoff's suggestion for VMWare you could install Virtual PC and install Excel 97 and whatever depends on that in there.

If you are using an instance of Sql Server rather than the default instance, then try servername\instancename for host server e.g. localhost\instance1. You could also try it with the machine name instead of localhost if that doesn't work. Richard SalamanderSoft Limited http://www.salamandersoft.co.uk Active Directory, SharePoint & Moodle provisioning

Under the covers the site directory is just a list with the different categories as columns in it. There's a guide to customising it at http://office.microsoft.com/en-us/sharepointserver/HA101065641033.aspx Richard SalamanderSoft Limited http://www.salamandersoft.co.uk Active Directory & SharePoint provisioning

When I've put an xlsx in a document library I don't get the option to view in web browser at all, whatever the permission level. It always opens in Excel. Are you using Excel Services with it? Richard

It's possibly to do with versioning. Check the version of the file and see if there's only a minor version saved. If so you have 2 possibilities: 1. Publish a major version. 2. Change the versioning settings of the document library so that Draft Item Security is set to "Any user who can read items." Richard SalamanderSoft Limited

Have you looked at the "Browser-enabled Documents" setting under Document Library Settings | Advanced? Richard SalamanderSoft Limited

Just noticed your reply posted while composing mine. Try setting the "Mapping List Url" property to http://calendar:43431/Lists/ColourCalendarMapping Richard SalamanderSoft http://www.salamandersoft.co.uk

AAM should sort it. Otherwise you could set the CalendarColourCoderWebPart property "Mapping List Url" to use the internal url to the category to colour mapping list. This will be something along the lines of http://servername/sites/aaa/bbb/Lists/listname where if you view the list within SharePoint the url in the address is http://servername/sites/aaa/bbb/Lists/listname/AllItems.aspx Richard SalamanderSoft http://www.salamandersoft.co.uk

You could always set it up in a virtual server. Both VMWare and Microsoft Virtual Server are free, but you do need a license for the O/S you are going to install. Richard SalamanderSoft Limited

Within the Sims home page there is an optional panel for My Reports. This displays a list of reports assigned to the user which have been automatically run. If you had a birthday report your users could click on it to see the results. It might take a bit of setting up though - if you wanted to limit the results to those in their reg group you'd probably need to create a report for each tutor. Regards, Richard http://www.salamandersoft.co.uk

Hi Frazer, How I resolved this was to give the Sql Server user higher permissions. Try: Have a look at which user Sql Server is running as in Administrative Tools/Services. It will either be SQL Server (MSSQLSERVER) or SQL Server (INSTANCENAME). Add this user to the local administrators group. Re-start the service and then try attaching the database using DbAttach. Once it's working you should be able to reduce the permissions level again, but I haven't tried this since my instance is a test system. Regards, Richard http://www.salamandersoft.co.uk

Hi Alis_Klar, The free SharePoint VLE is the SharePoint Learning Kit (SLK). http://www.codeplex.com/SLK There's also the Microsoft Learning Gateway (MLG), again free, where is to make a school portal. http://www.codeplex.com/SLK http://www.learninggateway.net The SLK can be used in a vanilla SharePoint setup or integrated as part of MLG. If you're unhappy with the ImageViewer webpart there's an open source replacement for it http://www.codeplex.com/ImageUpload This allows the user to upload the image into the webpart where it is then automatically displayed. Regards, Richard

Hi Frazer, I had exactly this problem a few days ago. I tracked it down to the fact that the user Sql Server was running as didn't have permission to write to the registry. As per best Microsoft practices, it had minimum permissions. I added it to the local administrators group (it is a test system) and deleted then re-attached the database and it worked with no problem. There was actually a message when attaching the database that it couldn't write a registry key, but it was buried in a mass of other statements about setting and unsetting database settings, and didn't flag it as a major issue. Regards, Richard http://www.salamandersoft.co.uk

If you are looking for a quick and easy addition, Google Checkout and Paypal might work for you. Once you've signed up, you can add buttons to your website which automatically take the parents to the relevant sites to pay. Obviously there's a cost, but Google Checkout charges less than Paypal at 1.5% + £0.15 per transaction. This is pretty good for credit card transactions though. Richard

I know Twynham school in Dorset has done this. There's a link to a document which describes their SharePoint set up at http://www.sharepointblogs.com/ajp/archive/2008/02/19/examplar-sharepoint-site-in-education-using-sql-2005-reports-in-moss.aspx I think Dave Coleman would be happy to speak to you about how they did it - his email is on the front page of the document. Richard

From the description I would guess that you've got the web application set up to impersonate the logged in user. If this is the case, when you log in externally and provide a username and password ASP can run exactly with your permissions and access the network as if it is you because it knows your password. If you automatically log in, i.e. are running it internally through the network, it still runs as you, however the browser passes it a security token describing who you are, but not what your password is. This token can be used to access other resources on the same machine as IIS as though it was you, but cannot access other servers as the token cannot be passed from the server to another machine. If this is the problem, then you can give permissions to the asp account as SYNACK suggests or should be able to set explicit user credentials to access LDAP which should work in both cases, but then you have the problem of securing the password. Richard

Hi, I'll be the first to admit that the website does need some work. I had quickly thrown up the FAQ as I had a couple of questions in a row about how I accessed Sims. I've now added a bit more detail on it now about Facility CMIS and other systems - so thanks for the feedback. http://www.salamandersoft.co.uk/faq.html My current customers are all Sims or Facility CMIS, but in previous work I've integrated with Phoenix and Integris so I have experience of dealing with other systems as well. Thanks, Richard

Just happened to be browsing

Hi Gary, You can get me at [email protected]. Regards, Richard

Just tried using the link supplied which failed. Googling led to http://saltis.org/ Richard

Hi, You can do this fairly simply by aliasing the columns. If they have different incompatible datatypes you may need to cast one to the other. A sample script is create table pupil (studentid int, name varchar(10)) go create table teacher (staffcode char(2), name varchar(10)) go insert into pupil(studentid, name) values(1, 'fred') insert into pupil(studentid, name) values(2, 'sam') insert into teacher(staffcode, name) values('AA', 'bob') go create view members as select cast(studentid as varchar) as memberid, name from pupil union select staffcode as memberid, name from teacher go select * from members go drop view members drop table pupil drop table teacher go Richard