Solved

can't conect to db in SS2005

Posted on 2008-06-18
4
171 Views
Last Modified: 2010-03-19
Hi,

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.

Any ideas?

Thanks.

0
Comment
Question by:Leprechaun
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 

Author Comment

by:Leprechaun
ID: 21815151
I checked and I don't see any privileges associated with "public", so I guess that's a red herring.
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 250 total points
ID: 21815181
make sure that you're an admin on your local machine and that your admin account is running the mssqlserver service.  Have you set your SQL instance up to allow windows and SQL connections?  If not, do so (right click on the server) and then set the sa password.  Login using the sa account.
0
 

Author Comment

by:Leprechaun
ID: 21815372
Thanks Chapmandew. I'm pretty sure I set this earlier, but maybe not. When I just checked, the db was set to Windows Authentication only, so I toggled that and restarted the service.

That didn't solve the problem, though it changed the error from the "no trusted conections" one to "login failed for user 'sa'".

Experimenting aimlessly, I tried to changing the password to empty and tried. It worked!

So then I changed the pwd again, and it worked again. Now things appear to be working as they should.

Weird. Do passwords get corrupted?

Not sure whether your suggestion fixed it, but if nothing else your tip started the chain of events that led to the solution. Thanks.

0
 
LVL 60

Expert Comment

by:chapmandew
ID: 21815394
Maybe you just typed in the password wrong???  Now that you're in, go and make sure your windows account is able to access the server.  

Sounds like you're good to go.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question