MSSQL 2k5 cannot connect with CF8

Forum|Forum|17 years ago
November 29, 2008
5 replies
1648 views

Hi,

I'm setting up CF8 and MSSQL 2005 on a laptop that is normally connected to a domain. When I try to connect a db using the MS SQL Driver I get the following error:

Connection verification failed for data source: OTT
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]A username was not
specified and the driver could not establish a connection using NTLM (type 2)
integrated security: InitializeSecurityContext, 0x80090304
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver]A username was not specified and the driver could not establish a
connection using NTLM (type 2) integrated security: InitializeSecurityContext,
0x80090304

A search for this error hasn't really brought up any useful solutions. Any suggestions.

TIA,

doug

Database access

This topic has been closed for replies.

Correct answer DJ Smith

The problem was hopefully resolved after reading a lot of the blog replies at http://carehart.org/blog/client/index.cfm/2006/7/8/sql2k5_Error_establishing_socket

My problem was that the SQL Config Mgr was saying SQL was using TCP port 1433, whereas it was really using a different port. And when I would restart SQL, the port would change to something else.

So after many many tries, it is working ... knock on wood. I've never had this kind of trouble installing MSSQL 2k or even 2005 on multiple other dev boxes.

Doug

D

DJ SmithAuthorCorrect answer

Inspiring

The problem was hopefully resolved after reading a lot of the blog replies at http://carehart.org/blog/client/index.cfm/2006/7/8/sql2k5_Error_establishing_socket

My problem was that the SQL Config Mgr was saying SQL was using TCP port 1433, whereas it was really using a different port. And when I would restart SQL, the port would change to something else.

So after many many tries, it is working ... knock on wood. I've never had this kind of trouble installing MSSQL 2k or even 2005 on multiple other dev boxes.

Doug

Michael Borbor

Inspiring

Well as far as I know ColdFusion cannot connect to MS SQL using Windows authentication , you need to change the MS SQL Security Server settings to allow Windows and Sql Authentication Modes, then in the Server security create a user and a password associate it with a db, set the db permissions, then you also need to allow remote tcp/ip connection because by default SQL 2005 has this option disabled, you could use the SQL Server Surface Area Configuration to do this. And you'll be ready to go.

D

DJ SmithAuthor

Inspiring

Thanks for the link. I've tried that too and still no connection.

Any other suggestions?

Doug

D

Daverms

Inspiring

Hi,

Try this workaround...

http://www.talkingtree.com/blog/index.cfm/2004/6/17/20040617

N

Newsgroup_User

Inspiring

> Connection verification failed for data source: OTT
> java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]A username was not
> specified

> Any
> suggestions.

So, like, did you specify a user name in your datasource?

--
Adam

D

DJ SmithAuthor

Inspiring

Yes I did. When I use my login/pw I get the following error:

Connection verification failed for data source: LifePlanner
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'xxxx@myuniversity.edu'. The user is not associated with a trusted SQL Server connection.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'xxxx@myuniversity.edu'. The user is not associated with a trusted SQL Server connection.

So do I need to reinstall MSSQL and set it up differently? I'm running this laptop away from its usual office connection. I had originally set up the MSSQL as I usually do on other computers with windows authentication only.

Doug

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded