Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

can't conect to db in SS2005

Posted on 2008-06-18
4
Medium Priority
?
179 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 750 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 Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

876 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