April 4, 2005 at 11:22 am
When I try to make a database connection between my frontpage web page and SQL I get the following error:
Server error: Unable to connect to a database from the web server using the connection string 'DRIVER={SQL Server};SERVER=gem-dr1;DATABASE=syslog;UID=sysloguser;PWD=***'.
The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)
I have this domain user setup with permissions on the database, and have the user setup in IIS for anonymous access. What am I missing?
April 4, 2005 at 11:32 am
Appears your connection sting is missing "Provider=oledbconnection" before your "Server".
In Visual Studio for your code behind page you need to add Imports System.Data and Imports System.Data.OledbClient if your using this provider or
Imports System.Data
Imports System.Data.SqlClient
April 4, 2005 at 11:36 am
April 4, 2005 at 11:55 am
Would I have to go into ODBC connections on the webserver and create a system connection (or user connection) to that database?
Also, I don't see where it would let me enter "Provider=oledbconnection" because I am using the database connection wizard.
April 4, 2005 at 4:32 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply