When you browse an ASP on a web site, you got an error message: ODBC Driver error "80004005" Data source name not found and no default driver specified. ODBC driver not configured Database name is not configured correctly Data source name is not configured correctly IIS computer cannot resolve the DNS name of the SQL server database Answer : 3
A user tries to connect to a database via your company website and receives the error (don't know this exactly)Microsoft OLE DB Provider for ODBC Drivers error '80004005'
(the 3 start the same way and end like this):
LOGIN FAILURE GENERAL NETWORK ERROR Can not find Name Space and no driver defined.
Each question has the same answers:
the user has insufficient permissions to access the database. the user has insufficient permissions to access RESOURCES in the database. recent revisions of the database changed the connection method from named pipes to TCP/IP. the database was recently moved to another server.... 3 questions on SQL ODBC errors:
A user tries to connect to a database via your company website and receives the error "ODBC ..." LOGIN FAILURE ? The user has insufficient permissions to access the database...
A user tries to connect to a database via your company website and receives the error "ODBC ..." General Network Error ? Due to heavy use the database has been recently moved to another server......
A user tries to connect to a database via your company website and receives the error "ODBC ..." SOURCE NAME NOT FOUND OR NO DEFAULT DRIVER FOUND ? Incorrectly configured Data Source Name (DSN) .......
The choices were:
The user has insufficient permissions to access the database. The user has insufficient permissions to access RESOURCES in the database. Recent revisions of the database changed the connection method from named pipes to TCP/IP. Due to heavy use the database was recently moved to another server.... Incorrectly configured Data Source Name (DSN) .... ODBC stuff from Microsoft themselves
The following resources address 80004005 errors:
http://support.microsoft.com/support/kb/articles/q183/0/60.asp and http://support.microsoft.com/support/odbc/faq/faq3663.asp
Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driv
er 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")%>
<%= "'auth_type' is " & request.servervariables("auth_type")%>
<%= "connection string is " & session("your_connectionstring")%>
- 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] Lo
gin 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
Which parameter listed below are store in metabase: (choose two) IIS help file location Virtual directory security settings Web site home directory location Microsoft Management Console Snap-In definitions. Microsoft Site Server Express Content Analyzer Toolbar Positions Answer:2,3
Key Metabase Entries
The metabase does not include all of the entries of the Windows NT registry, only those pertinent to Internet Information Server administration. For these settings, the metabase offers more advanced features including speed, scriptability, and remote administration. The following list describes the types of property settings stored in the metabase.
Computer and Web site properties. Properties configurable at the computer and Web site level. Logging properties. Properties configurable for Web site activity logging. FTP-specific properties. Properties configurable for FTP services only. HTTP-specific properties. Properties configurable for Hypertext Transport Protocol (HTTP) services only. Virtual directory and directory properties. Properties configurable at the virtual directory and directory level. File properties. Properties configurable at the file level. Filter properties. Properties configurable for filters. SSL key properties. Properties configurable for Secure Sockets Layer (SSL) keys.
There are 100 web pages on a web site sharing common elements. If you are the administrator of this web site, and the web pages need to be updated three times every day, what is the most least administrative efforts way to maintain this web site? Create comm
