Jonno

Sorry, I meant are you running it as part of a scheduled task or logon script or something?

Is domain admin or server local admin rights enough and should hybrid authentication been enabled during MSDE setup? I just tested it with server local admin rights, and it worked fine. The machine is a test box that's not on a domain, however, so your mileage may vary. Hybrid authentication should have been enabled during MSDE setup for you to be able to use Windows authentication. If not, if it's SQL Server 2005, you can enable it with SQL Server Management Studio; right-click the server, choose "Properties", click "Security" and choose "SQL Server and Windows Authentication mode." If you know the logon details for a member of the SQL 'sysadmin' group, you can use that instead. Hope that helps.

How are you running the script?

Hmm interesting. Can you post some example code. Thanks EXEC sp_password @new = 'newpassword', @loginame = 'sa'; You need admin rights to do this obviously (simplest way is presumably via Windows authentication).

If you're talking about the .CDB file that the Facility Administration software uses, that's a binary config file that tells the administration program (amongst other things) the connection string to use to connect to the DB. They're created by the administration program, and they don't really tell it what fields to use; rather where the database server actually is and how to connect to it and so on. I don't know how Groupcall integrates with other products (I assume it gathers data like name, telephone number, year group etc, attendance information etc?) - but the option of pulling data directly from the SQL database is always open to you, if Groupcall allows you to do some kind of manual import. (Alternatively, surely Facility allows you to export data in some known format like CSV?)

Seconded. I do a lot of work with Visual C++, Visual C# and Visual Web Developer, and I've yet to come across any real limitation with the 2005 Express editions. SQL Server Express 2005 is pretty good too, if you want to tie an ASP.NET site to it. Best thing is of course, that they're free.

You can give the admin .exe a filename and it'll open it on launching. So you can make a shortcut to, for example: \\server\facility\admin\cmisadmin.exe \\server\facility\admin\admin1.cdb and it'll automagically open admin1.cdb when they double-click the shortcut.

Have you ever viewed E-Portal in firefox?? You can drag all the little sections round the screen to create a 'customised' homepage, and it saves their locations when you close the page. IE won't let you do this! Mike We recently had Facility + ePortal installed, and I questioned the guy installing it, so a couple of things: You are always using Tomcat when you are using ePortal; the IIS interface is just an ISAPI plugin that forwards the requests to the Tomcat server. I imagine it also allows single sign-on to work with LDAP. Why on earth Serco would say the IIS interface is more reliable than not using it is beyond me. They actually couldn't get the IIS interface working on our system (oh the hilarity of watching them crowbar the software onto a 64-bit OS...) so they left us with just the plain Tomcat installation. It's interesting that you can't drag the sections around in IE... I had a discussion with the engineer about this and he told me "IE doesn't support it." And there was me thinking IE was capable of DHTML for years...