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
共11页: 1 [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] 下一页
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")%> <%= "'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 Serve
共11页: 上一页 [1] 2 [3] [4] [5] [6] [7] [8] [9] [10] [11] 下一页
r] 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
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?
共11页: 上一页 [1] [2] 3 [4] [5] [6] [7] [8] [9] [10] [11] 下一页
>Create common .idc filled for all HTML files
Create common .htx file for all HTML files
Rename all .htm files to .asp files
Use server-side include directives in the HTML file
Answer:4
The server-side include (SSI) directives component allows Internet Information Server to include text, graphics, or application information in a Hypertext Markup Language (HTML) page just before sending the HTML page to a user. SSI can be used to include, for example, a time or date stamp, a copyright notice, or a form for a customer to fill out and return to your organization. Using SSI to include a file is an easy way to incorporate text or graphics that will be repeated in many files. Rather than typing repeated information into every file, SSI allows you to use a statement to instruct the Web server to read from a single file instead.
The Web server processes SSI directives while it is processes the HTML page. When it reaches an SSI directive, the Web server inserts the contents of the included file directly into the HTML page. If the included file in turn contains an SSI directive, that file is also inserted.
You have three offices, each with an SMTP server connected via the internet. How do you secure them?
SSL
restrict by ip address
Answer:1
You want to publish the company newsletter to 500 users so that they can search the last six months by keyword. How?
NNTP
WWW and Index Server
Answer: 2 (use WWW to search the newsletter)
allow a range of IP addresses 192.168.0.96 - 192.168.0.127 deny all others.
192.168.0.0, 255.255.255.224
192.168.0.96, 255.255.255.192
192.168.0.96, 255.255.255.224
192.168.0.127, 255.255.255.192
Answer:3
Web Site configured to allow only a group of IP addresses to access it. The set-up was: 192.168.0.96 (Submask 255.255.255.224). What range of addresses allowed?
192.168.0.96 - 192.168.0.127
192.168.0.89 - 192.168.0.120
192.168.0.91 - 192.168.0.132
192.168.0.95 - 192.168.0.129
Answer: 1
You are behind a firewall and w[1] [2] [3] 下一页
|
