how good are certmagic.com to prepare
for ccna and mcse exams . i have a long
learning ahead to do and will realy like
some practice questions to practice
myself . anyone have any idea about certmagic
exams , plz let me know
I am looking for a set of books that realy cover the SQL
7.0 cert exams. Do you have any comments on the
following and or any suggestions.
Microsoft Sql Server 7.0 System Administration Training Kit
Microsoft Sql Server 7.0 Database Implementation Training Kit
Thank You,
Andy Robbins
Sr. Dba at Aurora Loan Services
Hello,
I have a SQL 2005 test system set up that I need to test with protocol encryption, and had in mind to peform this test using a self-signed SSL certificate. I have read the guides and requirements from MS as well as the few blogs I could find on the subject and I've *almost* gotten it to work, but I'm failing at what seems to be the last step - getting clients to connect.. Here is what I've done:
-Created a self-signed certificate (I've tried using SSL Diagnostics from the IIS Diagnostics package, makecert.exe from .NET SDK, and OpenSSL) with the 'Server Authentication' purpose, with a CN that matches the server name, along with a private key. I've imported the cert in the local computer's personal store (also in LC's Trusted Root).
-SQL Server Configuration Manager sees the certificate and allows selecting it in the configuration. I've done this and selected 'Force Encryption' in the protocol settings.
-Restarted SQL Server, errorlog says 'The certificate was sucessfully loaded for encryption'.
-Tried connecting locally using SSMS and setting encryption: No problem.
-Exported the cert from the store and imported it into the LC's Trusted Root store on the client comp.
Here's where the problems begin.
1: Client is still apparently able to connect *unencrypted* to the SQL Server (I tested with SSMS on the client machine, it states under connection properties that the conn is not encrypted)
2: When trying to connect encrypted, SSMS returns an error during the pre-login handshake saying "The certificate's CN name does not match the passed value." When using the same cert in IIS there are no problems whatsoever, and the CN in the cert does indeed match the server name so I'm thinking the real error is hiding beneath the one that is thrown.
Also tried to configure the SQL Client Network Utility to force encryption from the client side, but this didn't seem to have any effect. I tried to use Network Monitor to capture network traffic, but since it appears to be encrypted (SQL encrypts login handshake anyway afaik) I couldn't get much out of it.. Does anyone have any tips?
When sql 2005 is created a cert is also created in the Data directory of that instance. What is that cert? Is it the Service Master Key? I noticed that I can movecopydelete it while sql server is running so it doesn't appear to be very secure..
TIA,
Barkingdog
Does anyone know when these will be available?
TIA, cfr
Does anyone know of a self test area for the MCDBA exams?
View 1 Replies View RelatedI'm just looking for some SQL SERVER 7.0 ADMIN/DESIGN exams, regarding my preparation for the MCP exams.
Thanks
I know SQL Server 2005 isn't out yet untill next year, but I am wondering if anyone knows about when the MCP exams might come out for it?
I am an MCSD and MCAD, and I am thinking about getting MCDBA soon, and I am wondering if it would be better for me to wait for the SQL Server 2005 exams.
Can anyone tell me where to find a site with Braindumps specifically for Brainbench exams SQL ANSI and SQL Server 2000? Even though they are "open book", they are more challenging than I previously thought. Or if not, can anyone suggest some VERY useful books/materials to pass exams with Intermediate-Expert level knowledge of SQL and SQL Server?
Responses can be directed to stevengara@hotmail.com
Thanks,
Steve G.
Hi all,
I am new to SQL Server 2000 and i want to take MCP exams in SQL,
can any one suggest me what exams i have to write.
Thank's & Regard's
Peter
Can anybody answer :
Are MCDBA (SQL Server 2000) exams still available today ?
Is it worth going for this exam today, in spite of the fact SQL Server 2005 has been released ?
There are twelve more exams will retire on March 31st, 2009. Microsoft has announced this information. These exams focus on technologies will be no longer included in Microsoft mainstream support. The exams are currently required to achieve Microsoft Certified Application Developer (MCAD), Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Database Administrator (MCDBA) certifications.
Details:
Developer exams that retire on March 31, 2009
€¢ Exam 70-300: Analyzing Requirements and Defining Microsoft .NET Solution Architectures
€¢ Exam 70-301: Managing, Organizing, and Delivering IT Projects by Using Microsoft Solutions Framework 3.0
€¢ Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
€¢ Exam 70-306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
€¢ Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
€¢ Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
€¢ Exam 70-316: Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
€¢ Exam 70-320: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework
€¢ Exam 70-330: Implementing Security for Applications with Microsoft Visual Basic .NET
€¢ Exam 70-340: Implementing Security for Applications with Microsoft Visual C# .NET
Microsoft SQL Server exams that retire on March 31, 2009
€¢ Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
€¢ Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
This article is quoted from microsoft.com.