Exact steps to setup a SQLOLEDB connection using a browser
Posted on 2007-11-13
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="Provider=sqloledb;Data Source=JTLAPTOP,1433;Initial Catalog=myDB;User ID=JTLAPTOP\JT;Password=xxxxxxxx;"
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?