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.
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.
This post was deleted for the following reason: at poster's request -- mathowie
This thread is closed to new comments.
posted by about_time at 9:53 AM on August 4, 2009