Solved

can't conect to db in SS2005

Posted on 2008-06-18
4
166 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
  • 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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now