Solved

can't conect to db in SS2005

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Pivot Query Problem 9 47
Restrict result set 1 39
tempdb log keep growing 7 33
Need help in debugging a UDF results 7 19
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
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…

809 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