Browse by Tags

Real-time replication with SQL Server reporting, strategies and resolution to the problems?

Published 30 January 8 12:23 PM | SSQA.net

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always have a primary focus in providing protection for the data assets stored in SQL Server. Protection that...

Filed under: sql server, microsoft, data, integration, security, download, replication, reporting services, magazine, windows it pro

Security best practices - personally & technically

Published 26 January 8 8:12 AM | SSQA.net

See this awesome post about how best you can adopt security and beaware about which is right and which is wrong Avoiding the bad guys - detecting potentially malicious advertising campaigns that is applicable on both personal security & techinical...

Filed under: business continuity, sql server, microsoft, blogs, integration, security

Configure Reporting Services on a DMZ environment?

Published 2 October 7 11:29 AM | SSQA.net

Few things you need to consider before letting the users use Reporting Services within a DMZ environment where the Servers are exposed to the INternet and to safeguard the servers from hackers. In this case you must be aware that SQL Server uses TCP port...

Filed under: sql server, integration, security, error log, reporting services, internet, dmz, browser

Simple steps to monitor Replication activities

Published 23 August 7 10:6 AM | SSQA.net

There are few simple steps involved to monitor the replication actvites, as usual with Replication Monitor is useful to monitor the overall health of a replication topology. Replication Monitor provides detailed information on the status and performance...

Filed under: sql server, integration, security, replication, monitor, troubleshoot, transactional

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). [ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found

Published 21 August 7 9:6 AM | SSQA.net

--------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState...

Filed under: sql server, high availability, integration, security, ssms, error, surface, not found

Taking advantages of Cryptographic features in SQL 2005 - security

Published 12 May 7 5:16 AM | SqlServer-QA.net (SSQA)

When I had a chance to know about encryption features in SQL Server I always go with books online as a first hand information, but there is more to ask about this feature in 2005 version: Have you ever thought about encryption in SQL Server, how to implement...

Filed under: sql server, integration, ssis, security, ssas, cache, entry