Sunday, March 20, 2011

mssql2k and apache

Hi,
I have to connect to mssql2k in my django app . everything goes well
in "manage.py runserver" but I cant connect to mssql when I use
apache . I tried both pymssql and pyodbc , nothing changed. installing
sp4 "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" changed nothing too.

this line has problem
cn = pymssql.connect(host=server,trusted=True ,user=mssql_username,
password=server_pwd, database='mydatabase')

authentication mode: sql authentication
mssql_username: I tried sa , server\Guest , user defined

error message :

SQL Server message 18452, severity 14, state 1, line 0:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.

thanks

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home


Real Estate