SqlServerKudos - Stories tagged with access

access

atom rss
1
kudos
spam Kudos Remove

SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of?
published 24 days, 6 hours, 21 minutes ago posted by sasa 32 days, 6 hours, 42 minutes ago
Wednesday, July 07, 2010 1:37:08 PM GMT Tuesday, June 29, 2010 1:15:59 PM GMT
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
spam Kudos Remove

SQL Server SSIS package performance series - resolve the low-memory conditions
published 95 days, 11 hours, 37 minutes ago posted by sasa 100 days, 12 hours, 47 minutes ago
Tuesday, April 27, 2010 8:20:33 AM GMT Thursday, April 22, 2010 7:10:49 AM GMT
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: 1 | comment | | source: sqlserver-qa.net
tags: access, benchmarking, Best Practices, low memory, package, perfmon, Performance, SQL Server, SSAS, SSIS
1
kudos
spam Kudos Remove

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'
published 193 days, 21 hours, 1 minute ago posted by sasa 200 days, 47 minutes ago
Monday, January 18, 2010 10:56:27 PM GMT Tuesday, January 12, 2010 7:10:48 PM GMT
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
spam Kudos Remove

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
published 225 days, 23 hours, 20 minutes ago posted by sasa 235 days, 11 hours, 33 minutes ago
Thursday, December 17, 2009 8:37:44 PM GMT Tuesday, December 08, 2009 8:25:15 AM GMT
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: 0 | 2 comments | | source: sqlserver-qa.net
tags: access, policy based framework, sa, Security, SQL Server 2008, SQLServer, Upgrade, upgrade advisor
1
kudos
spam Kudos Remove

SQL Server Replication upgrade practices - choose optimal upgrade options
published 268 days, 2 hours, 21 minutes ago posted by sasa 277 days, 11 hours, 55 minutes ago
Thursday, November 05, 2009 5:36:44 PM GMT Tuesday, October 27, 2009 8:02:58 AM GMT
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
spam Kudos Remove

How SQL Server 2008 can help to build fast track data warehouse?
published 285 days, 4 hours, 35 minutes ago posted by sasa 294 days, 17 hours, 10 minutes ago
Monday, October 19, 2009 3:22:40 PM GMT Saturday, October 10, 2009 2:47:37 AM GMT
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
spam Kudos Remove

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 306 days, 6 hours ago posted by sasa 308 days, 17 hours, 45 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Saturday, September 26, 2009 2:12:43 AM GMT
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