connection local SQL Server 2008 db
Posted on 2012-03-12
I guess someone could help me with this 'local SQL Server connection experience'...
I´ve SUCCESSFULLY created a local SQL server database connection through Dreamweaver (tested and worked), and I´ve also created SUCCESSFULLY a recordset that (when tested) gives me some fields of a table that is inside this local SQL server database.
The problem is, when the (ASP) page is populated with the recordset and I try to run the page through my local server, I get the error white page with the following message:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user '[nameOfmyMachine]\IUSR_[specificname]-14A780B05'.
/folderName/TestingSQL_local.asp, line 9
where line 9 is the
rsTesting_cmd.ActiveConnection = MM_connSQL_local_STRING ...
I know that this connection string is working properly (when testing the connection through Dreamweaver), therefore I guess I have some problem with the local database permission... I´m 100% ignorant on these matters...