thesimpsonator
IS-IT--Management
Hi folks,
thought it was something to do with my connection code etc that i was having trouble connecting to the database i have on my site, however think it's more something to do with permissions on the database itself.
to load the database i had to load the mdf onto the database partition of my hosts site. the dsn for the connection was created with the host.
so, i added a database to sql server management studio, imported data from the actual database then uploaded the relevant mdf.
every tme i try connecting i get a login error:
get similar error on localhost, not too clued up on sql just need to get this bloody thing working as its holding up my developing the rest of my site!!
any ideas as to what/where i'm going wrong would be greatly appreciated.
regards
chris.
thought it was something to do with my connection code etc that i was having trouble connecting to the database i have on my site, however think it's more something to do with permissions on the database itself.
to load the database i had to load the mdf onto the database partition of my hosts site. the dsn for the connection was created with the host.
so, i added a database to sql server management studio, imported data from the actual database then uploaded the relevant mdf.
every tme i try connecting i get a login error:
Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection.
/stocklist.asp, line 8
get similar error on localhost, not too clued up on sql just need to get this bloody thing working as its holding up my developing the rest of my site!!
any ideas as to what/where i'm going wrong would be greatly appreciated.
regards
chris.