access denied
August 4, 2009 9:40 AM   Subscribe

I would like to write some python programs to access the data on my MS SQL Server 2008. Can you please help me with the configuration of the server to allow this? I'm not able to use the new accounts I've created. I'm not sure what I'm doing wrong, but i'm positive I am overlooking something simple.

I have MS SQL Server 2008 set up in an XP virtual machine.
The python package is installed correctly, but when I issue the connect() call, I get an authentication error. I have created a user under the security->logins->new user menu using "SQL server authentication". (I also tried using straight SQL CREATE)

I don't think python is the problem, as I get an error message from the server if I use the Management Studio to try to connect the user I created. So it looks like I haven't set up the account correctly.

(In case it's relevant, I do get a .NET error every time I start up the sql studio. I can click through and everything seems fine other than this account creation problem.

Any advice or pointers to a web page discusses this problem? I found lots of web pages, but none point out something that I'm doing wrong. Thanks for your help.
posted by about_time to Computers & Internet (1 answer total)

This post was deleted for the following reason: at poster's request -- mathowie

 
Response by poster: Opps, never mind. i found my own answer. I had to enable SQL logins.
posted by about_time at 9:53 AM on August 4, 2009


« Older Artist groupware. Please find enclosed a list of...   |   Film Scheduling Resources? Newer »
This thread is closed to new comments.