October 2007 - Posts

• SQL Server 2005 SP2 - Access Denied on MSSQL\Data directory

  This was a strange occurance I found recently. If you encounter the error SQL Server Setup failed to modify security permissions on file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ you might want to look at the permissions on every file Read More... Posted Monday, October 22, 2007 3:50 PM by mab | 0 Comments Filed under: SQL Server

• Issue with SSIS Package calling stored procedure OUTPUT datetime parameter type

  Symptom The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 3 ("@parameter"): Data type 0xE7 has an invalid data length or metadata length. Solution Installing SP2 my help. http://msdn2.microsoft.com/en-us/sql/bb426877.aspx Read More... Posted Thursday, October 18, 2007 4:06 PM by mab | 1 Comments Filed under: SQL Server

• SQL Server 2005 Job, SSIS Step, Data Sources Access Denied

  This particular issue was interesting. I was troubleshooting an issue where an individual had rights to run their SSIS Step in a SQL Job. They could also change variables being passed, add/remove steps in job, almost everything except modify the Data Read More... Posted Sunday, October 14, 2007 7:52 PM by mab | 1 Comments Filed under: SQL Server