Apr

25

Unable to add certain Active Directory users as Windows Logons to SQL Server 2008 on Windows Server 2008 R2

By pcurd

Last week I faced an issue where I was unable to create Windows Logons for SQL Server 2008 from Active Directory users on a Windows Server 2008 R2 server when a Windows Server 2008 server was able to.

The error was a 15401 error which are quite common and usually mean your Server Principal names are wrong, however I had checked this and knew it was not an authentication issue. See my post on Server Principal Names for more details on this. Plus I was able to add other users. The error was “Error 15401 – Windows NT user or group ‘domain\username’ not found”.

There is a Knowledge Base article which describes the problem (with a hotfix) but the symptoms are not the same as the knowledge base so I hope this makes it easier to find. The knowledge base article is KB976494 (Error 1789 when you use the LookupAccountName function on a computer that is running Windows 7 or Windows Server 2008 R2) http://support.microsoft.com/kb/976494.

Reblog this post [with Zemanta]

Oct

31

Microsoft Office 97 on Windows 7

By pcurd

As per my last post we are testing some legacy systems on Windows 7.

One of my colleagues has begun the testing process with Office 97.

Beginning the process, it started off badly with a message ‘Are you sure you want to install this software from an unknown publisher’. Mm well, yes, I guess Microsoft, I do want to install Microsoft software.

During a regular install with binder, HTML editor and something else small I can’t remember removed there were 3 errors about there not being a default email client installed. As we plan to install Office 2003, including Outlook, over the top I wasn’t worried about these.

Access 97

The main important app for us is Access 97 so this was the first to be tested. It opened fine, even clippy seemed pleased with his new home. A few simple self contained databases with tables, queries and forms, with some vba module code, opened fine.

To be tested: We plan to test with non-form module code and reports next week. Then SQL links.

Result: So far all is working and response time is good.

(This post is still under construction)

Oct

31

Legacy software on Windows 7

By pcurd

One of the duties my department has is to evaluate new software and check for compatibility with existing systems and other software. With the release of Windows 7 in the last two weeks it therefore made sense to up the testing from a few packages on the RTM to our entire suite on the final code.

One of my colleages has begun this process this week and I will blog some of the findings as they happen. I will put up a post for each major package to aid the googlefu of the posts!

Please feel free to leave comments with any other experiences or findings.

Aug

4

Trigger Scheduled Tasks Remotely

By pcurd

Just had to trigger a windows scheduled task remotely and was struggling to find VBScript etc to do it when I found a rather natty tool – SCHTASKS.exe.

Very helpful tool that works locally or remotely and by file path or schedule name.

However, there is an odd bug listed here http://www.onnraves.com/2009/05/20/running-scheduled-tasks-from-the-command-line/ which stumbled me for a little while. If you get the error “The parameter is incorrect” this is definitely the place to go.

(To summarise in case of link rot, the “.” character must not be in your task name)