I'm trying to create a local version of our website on my PC (XP Pro SP3, on Bootcamp). I saved a backup of the db from the production server, copied it over to my pc, and restored it locally.
It looks fine. I'm able to query it and play with it in MS SS Mgt Studio, but I can't connect to it through my user.
When I try to open a connection using a user and password I know to be correct, I get the "no trusted connections message.
I'm new to SS2005. My previous experience is with SS2000, if that makes much difference.
I've compared my setup to the production db and the only difference in terms of privileges is that local machine doesn't have a server role that the corresponding user has on the prod server, "public". It's not in my install. On the prod server, the user's a member of that group, as well.
Otherwise, it has the same permissions for dbs and users.