saturation
asked on
Exact steps to setup a SQLOLEDB connection using a browser
I have an ASP web application that I have created using an Access database, but I recently upgraded to SQL Server and imported the data using Enterprise Manager. Now, however, I cannot seem to get past the following error:
*******
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'JTLAPTOP\jt'.
*******
My connection string is
CONST strDataSourceName="Provide r=sqloledb ;Data Source=JTLAPTOP,1433;Initi al Catalog=myDB;User ID=JTLAPTOP\JT;Password=xx xxxxxx;"
Here are some other setups I have:
1) LOCAL SQL Server registration--Mixed Mode with the System account as the "Startup Service Account."
2) Added JTLAPTOP\JT as a User to my "myDB" database through Enterprise Manager and given full access to the tables.
3) I have given access through IIS to the IUSR_JTLAPTOP account. Lastly, I have added the "myDB" database to the ODBC "System DSN" as a SQL Server database (although I'm not sure I need to do this).
I'm stuck. What exactly do I need to do from start to finish (from after creating the database and some tables to ) to get even the simplest ASP page I have setup to test the connection (a "hello world" test)--or just to get this thing up and running?
*******
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'JTLAPTOP\jt'.
*******
My connection string is
CONST strDataSourceName="Provide
Here are some other setups I have:
1) LOCAL SQL Server registration--Mixed Mode with the System account as the "Startup Service Account."
2) Added JTLAPTOP\JT as a User to my "myDB" database through Enterprise Manager and given full access to the tables.
3) I have given access through IIS to the IUSR_JTLAPTOP account. Lastly, I have added the "myDB" database to the ODBC "System DSN" as a SQL Server database (although I'm not sure I need to do this).
I'm stuck. What exactly do I need to do from start to finish (from after creating the database and some tables to ) to get even the simplest ASP page I have setup to test the connection (a "hello world" test)--or just to get this thing up and running?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER