SqlServerKudos

access

1
kudos

Kudos

Cumulative Update package 11 for SQL Server 2008 R2 is available for download

published 148 days, 19 minutes ago posted by

sa 155 days, 1 hour, 14 minutes ago

Cumulative Update package 11 for SQL Server 2008 R2 is available for download

The latest instalment of Cumulative Update package for SQL Server 2008 R2 is available for download, before implement it on production make sure you test the installation. Build 10.50.1809.0 (cumulative update) and the parent build of this build is 10.50.1807.0. The list of issues are as follows with their KBA: VSTS bug number KB article number Description 834627 955850 (http://support.microsoft.com/kb/955850/ ) Error message when you try to use the binaries from the SQL Server System CLR Types package..... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: access, Best Practices, cumulative update, Documentation, downgrade, download, linked server, SQL Server

1
kudos

Kudos

SQL Server Manageability Series: how to change the default path of .cache files of a data collector? #sql #mdw #dba

published 334 days, 16 hours ago posted by

sa 343 days, 16 hours, 40 minutes ago

SQL Server Manageability Series: how to change the default path of .cache files of a data collector? #sql #mdw #dba

How to change the default path of .cache files of a data collector after the Management Data Warehouse (MDW has been setup? This was the question asked by one of the DBAs in a client's place, instantly I enquired that were there any folder specified while setting up the MDW and obvious answer was no as there were left default. This means all the .CACHE files are stored under %C\TEMP directory which may post out of disk space problem on the server where the MDW is setup to collect. Going back to basics...... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: access, Best Practices, cache reports, cookbook, data collector, data files, DBA, management data warehouse, mdw, SQL Server, temp

1
kudos

Kudos

SQL Server agent: Property pagersendsubjectonly is not available for alert system this property may not exist for this object or may not be retrievable due to insufficient access rights.

published 496 days, 2 hours, 25 minutes ago posted by

sa 504 days, 2 hours, 48 minutes ago

SQL Server agent: Property pagersendsubjectonly is not available for alert system this property may not exist for this object or may not be retrievable due to insufficient access rights.

Do you see this error in your environment? Is it a frequently occuring issue? In the recent time in a 64 bit environment we started to get this alert generated and DBAs complaining sometimes are unable to view the SQLAgent jobs on that remote server. If we observe the error text it clearly states " ....this property may not exist for this object or may not be retrievable due to insufficient access rights ". The first part is property may not exist for this object which means a tools problem and to...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: access, permissions, property, rights, Security, SQL Server, SQL Server Agent, SSMS

1
kudos

Kudos

SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of?

published 686 days, 16 hours, 46 minutes ago posted by

sa 694 days, 17 hours, 7 minutes ago

$SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of?$

Here is an interesting 'sql security' discussion I had during the SASSUG usergroup interaction with regard to BUILTIN\Administrator role from SQL Server 2008 onwards. Since SQL Server 2005 the instance has been classified as 'secured by design/default' by cutting down the elevated access to the SQL Server. From the operating system side login privilege, by default SQL adds the group BUILTIN\Administrators to the sysadmin fixed server role, meaning that any local NT administrator is automatically...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: access, Best Practices, builtin\administrator, control, DAC, DBA, dedicated admin console, registry, Security, SQL Server, UAC, windows authentication

1
kudos

Kudos

SQL Server SSIS package performance series - resolve the low-memory conditions

published 757 days, 22 hours, 3 minutes ago posted by

sa 762 days, 23 hours, 12 minutes ago

SQL Server SSIS package performance series - resolve the low-memory conditions

SSIS Packages are integral part of database management activities, that all ETL based activities can be managed efficiently. The primary usage for these packages is to manage the movement of data from one place to another. To do that, the package needs to know where it is moving data from and where it is moving data to. Now a days the environment of source & destination server is not limited to a network or between 2 systems, it is diversified into global locations that typically enables Integration...(r... (more)

category: News | clicked: 2 | comment | | source: sqlserver-qa.net

tags: access, benchmarking, Best Practices, low memory, package, perfmon, Performance, SQL Server, SSAS, SSIS

1
kudos

Kudos

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

published 856 days, 7 hours, 27 minutes ago posted by

sa 862 days, 11 hours, 12 minutes ago

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

No doubt that the error on subject line will get no where! This is presented when trying to open a Database Properties using SQL Server Managment Studio, going back to history on the SQL instance where this is presented is an upgraded database instance having upto date service packs (SQL Server 2008 SP1) with no cumulative update packages. Further information on full error text is below: Access Object Collector error: Database Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngin... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: access, dll, error, Management Studio, path, registered, sp_configure, SQL Server, SSMS, system

1
kudos

Kudos

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

published 888 days, 9 hours, 45 minutes ago posted by

sa 897 days, 21 hours, 58 minutes ago

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

One of the SQL Server 2008 upgrade process hampered with the error on the subject line and following text box was displayed: For some reason the similar issue hasn't been displayed when Upgrade Advisor has been chosen to find the first hand issues, as per http://sqlserver-qa.net/blogs/tools/archive/2008/01/22/upgrade-blurg.aspx and http://sqlserver-qa.net/blogs/tools/archive/tags/upgrade+advisor/default.aspx posts here. Coming to the root cause of the issue one of the KBA refers that .... this issue...(r... (more)

category: News | clicked: 3 | 2 comments | | source: sqlserver-qa.net

tags: access, policy based framework, sa, Security, SQL Server 2008, SQLServer, Upgrade, upgrade advisor

1
kudos

Kudos

SQL Server Replication upgrade practices - choose optimal upgrade options

published 930 days, 12 hours, 46 minutes ago posted by

sa 939 days, 22 hours, 20 minutes ago

SQL Server Replication upgrade practices - choose optimal upgrade options

SQL Server Upgrade task needs a thorough planning and testing before you deploy the process in production environment. In this regard when performing an upgrade to a replicated environment, DBAs must make sure that all changes have been applied to all the databases that are involved in the replication topology before they attempt the upgrade. If your application databases are not involved in Replication procedures then you can proceed as per your pre-planning process. IN any case all the attributes...(re... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: access, jet, MERGE, oledb, replication, SQL Server, transactional replication, Upgrade, Version

1
kudos

Kudos

How SQL Server 2008 can help to build fast track data warehouse?

published 947 days, 15 hours, 1 minute ago posted by

sa 957 days, 3 hours, 36 minutes ago

How SQL Server 2008 can help to build fast track data warehouse?

Beginning of this year I have posted here about Build your BI skills in fast track data warehouse and based on that I have had few questions and feedback on how best we can take help of SQL Server 2008 features to build the fast track data warehouse. Based on the material and resources available on Microsoft site the approach must be on data access layer, configuration (hardware, software) and maintaining the normalization practices.When you talk about Business Intelligence then data access layer...(read... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: access, attributes, cpu, data warehouse, disk, fast track, Memory, Performance, SQL Server

1
kudos

Kudos

MSG 10314 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE.

published 968 days, 16 hours, 26 minutes ago posted by

sa 971 days, 4 hours, 10 minutes ago

MSG 10314 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE.

As it states on the subject line this is an error that would cause when the system is trying to load assembly due to the permissions, the second part of the subject also needs consideration that server may be running out of resources & security issue. Msg 10314, Level 16, State 11, Line 2 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: .NET, access, Assemblies, BOL, CLR, error, Login, login mapping, privileges, Security, sid, SQL Server, versioncontrol

Welcome!

access

Cumulative Update package 11 for SQL Server 2008 R2 is available for download

SQL Server Manageability Series: how to change the default path of .cache files of a data collector? #sql #mdw #dba

SQL Server agent: Property pagersendsubjectonly is not available for alert system this property may not exist for this object or may not be retrievable due to insufficient access rights.

SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of?

SQL Server SSIS package performance series - resolve the low-memory conditions

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

SQL Server Replication upgrade practices - choose optimal upgrade options

How SQL Server 2008 can help to build fast track data warehouse?

MSG 10314 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE.

Open ID Login

Standard Login

Forgot Password?

Sign up