Couldn’t send mail with MS SQL Server 2005

So I’ve been struggling trying to send SQL Agent job notifications to operators.

[codesyntax lang=”sql”]
Msg 515, Level 16, State 2, Procedure sp_validate_user, Line 19
Cannot insert the value NULL into column ‘permission path’, table ‘@temp’; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 107
No global profile is configured. Specify a profile name in the @profile_name parameter.
Continue reading “Couldn’t send mail with MS SQL Server 2005”

FreeTDS installation directory is not a FreeTDS installation directory

I recently discovered an error whilst trying to (re)install an older PHP version on a client’s server. My client required PHP recompiling with MS SQL support. This in turn requires FreeTDS. Installing FreeTDS is very simple, but PHP wasn’t.

Continue reading “FreeTDS installation directory is not a FreeTDS installation directory”

Upgrading from SQL 2000 to 2005 Error -1

Ever had your Upgrade Advisor return an error while upgrading an instance of SQL Server 2000 to SQL Server 2005?

UpgradeAdvisor returned  -1 .

I have, in two different circumstances,

  • While choosing an instance from the installed instances and choosing one of them to upgrade.
  • While running upgrade advisor exclusively.

Continue reading “Upgrading from SQL 2000 to 2005 Error -1”