Re: Microsoft SQL support
Re: Microsoft SQL support
- Subject: Re: Microsoft SQL support
- From: Ute Hoffmann <email@hidden>
- Date: Fri, 18 May 2007 00:48:59 +0200
What is your driver error message and what have you put into eomodeler
for the connection to the database.
Question: Has your User the App connects through the right connection
rights for the MS SQL DB? There are two ways of authentication with MS
SQL Server (windows and another one). You need to define a User with
non-window authentication (whindows is the default when you create a
new User and you cannot change it to the other way by the admin tools,
at least you could not last summer). I had to open cmd on the windows
server where the database run and change the user authentification
scheme via commandline. If you think this may be your problem, please
contact me and I will find you the file where I saved what I had to
enter into cmd to get the user rights of the database right.
Secondly make sure your database server is configured to receive
network requests. I had to change things in the db server admin before
I got my first connection to my db.
If you need it I can also send you the driver I use with MSSQL server.
I remember there were two and one did not work, I do not remember why
it did not work.
regards
Ute
Am Donnerstag, 17.05.07 um 22:59 Uhr schrieb Tom Jones:
Hello,
I'm new to WO and I'm having some issues connecting to MS SQL 2005. I
found
a jdbc driver for MSSQL2005 on MS site and I thought used the right URL
syntax but I keep getting a driver error message.
Has anyone set this up before and if so could you please share.
Thanks,
Tom
PS: I'm using WO on a Mac OS X 10.4.9 system.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
pixelmind.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden