Adding a MS SQL Server DSN *Newby*

[Skotopia]

I am having the same issue and don't know what I am doing wrong. I left the default port, used the Database name and just put in localhost for server. Anyone know what to do?

[mxstu]

Originally posted by: Skotopia
I am having the same issue and don't know what I am doing wrong. I left the
default port, used the Database name and just put in localhost for server.
Anyone know what to do?


The following settings worked for me with SQL Server 2000 running on the same
machine as the CF Server. "Northwind" is obviously the test database installed
with SQL Server. The only issues I encountered were due to problems with
firewall software preventing the connection, resulting in errors like
"connection refused". Once I updated the firewall settings all was well.

Driver: Microsoft SQL Server
CF Data Source Name: Northwind
Database: Northwind
Server: 127.0.0.1
UserName: (your sql server user - for example - "sa" )
Password: (user password)
Port: 1433

If that doesn't work, you may want to post any error messages and maybe
somebody can help you.

[Skotopia]

Thanks for responding. Okay I used the port and host name you specified., and
I input the name of my database properly. In SQL I created a user for my
database and gave it a password, the values of which i then input into this
data source: so the input fields of the data source looks like:

The name of the data source
The database name
127.0.0.1 port: 1433
dude
dude's password

This still gives me the error:
Connection verification failed for data source: Anima System
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to
connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username, password,
URL, and other connectivity info.


If someone can help I'd be very very grateful!

[Skotopia]

It's also worth noting that my default data sources work, and my SQL server and CF server are both on my computer.

[The ScareCrow]

FYI

If using windows xp or I think server 2003 you have to install sql server sp3
after you install the sp for windows.

You also may need to exclude the port in the windows firewall if it's on, this
link will show you how

[url]http://www.winnetmag.com/SQLServer/Article/ArticleID/43777/SQLServer_43777.html[/url]

Ken