Happy Guy

Passed my last exam today, I'm an MCSE now!!!!!!! Cool!!!!!! Thanks to all the braindumps posted, I would never have passed without them. I passed all the other exams without problems and I must warn all those taking this exam, it is not that easy!!! I failed it twice before just scraping through the third time. There are a couple of strange things about this test, I just didn't seem to get the simulations right no matter what I did and there were a few curveball ODBC and ISAPI/CGI questions which really confused me. Another thing is the MOC material is really really not enough to get anyone through, PC Age is cool (covers about 60% as mentioned in other braindumps) Even Technet material couldn't answer some of the ODBC stuff 100% for me, I ended up making deductions for myself. I must admit that I have no working experience of IIS4 and even though I installed it on my home computer and did all the labs, it still didn't seem to help me get through the sims which is weird. I didn't even struggle with the sims in the exam, and most of the questions 'seemed' straightforward, well...go figure. Another thing is I did this one as a self study course, I attended courses for all the other exams and passed them okay, so I guess this tells you something about instructor led courses eh?

Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

–The most common cause is that the connection string is a session variable initialized in the Global.asa and Global.asa is not firing. You may check to see that the variable is being initialized correctly by adding the following code to the .asp page: <%= "'auth_user' is " & request.servervariables("auth_user")%> <P> <%= "'auth_type' is " & request.servervariables("auth_type")%> <P> <%= "connection string is " & session("your_connectionstring")%> <P>

- If the Global.asa is not firing, check to make sure it is in an Application Root for IIS 4.0, or a Virtual Root with the "Execute" check box selected if running under IIS 3.0. Also, a bug detailed in the Microsoft Knowledge Base article Q173742, may prevent the Global.asa from being fired when Windows NT permissions have restricted access to the folder.

- The DSN name is not found. Check to make sure a 'User' type DSN is not being used.

- If using a File or System DSN, try changing the connection string to "DSN=MySystemDSN" or "DBQ=MyFileDSN" as appropriate. Simplify!

- Check to make sure that the most current drivers are installed. If in doubt, download the latest MDAC (Microsoft Data Access Components) from the following Web site:

Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' Microsoft][ODBC Microsoft SQL Driver] Logon Failed() Cause -----

-This error is generated by SQL server if it does not accept or recognize the logon account and/or password being submitted (if using Standard security) or if there is no Windows NT account to SQL account mapping (when using Integrated security). –

-If you are using standard security, the SQL account name and password are incorrect. Try the system Admin account and password (UID= "SA" and NULL password). These must be defined on the connection string line. DSN's do not store user names and passwords. –

-If using Integrated security, check the Windows NT account that is calling the page, and find out what account (if any) it is mapped to. –

-SQL does not allow an underscore in a SQL account name. If someone manually mapped the Windows NT IUSR_machinename account to a SQL account of the same name, it fails. Map any account that uses an underscore to an account name on SQL that does not use the underscore.

Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed- User: Reason: Not defined as a valid user of a trusted SQL Server connection. Cause ----- -

-Integrated Security is turned on in the SQL Enterprise Manager, and the Windows NT account being used has not been mapped to a SQL account. –

-Try changing SQL to use Standard Security (In Enterprise Manager, select Server/ SQL Server/Configure[ASCII 133]/Security Options/Standard. - If running under IIS 4.0, turn off "Password Synchronization" for that project.

Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][DBMSSOCN] General network error. Check your network document Cause -----

-This may occur when a SQL server computer is renamed. DSN's that reference the old name fail when the computer name cannot be located

IIS4 exam questions

Microsoft made me sign an agreement not to tell anyone what was in the exam, well I can say that the braindumps seem to have them covered although the answers are something else!!! Research the answers for yourself!!! Don't believe just anyone, you must be confident that you understand the answer yourself.

Good luck to all of you, you have my sympathy!

Happyguy