EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / SQL Server DSN problem

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: SQL Server DSN problem

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

Richard
12-01-2006 @ 10:27 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 85
Joined: Sep 2006

Hello...

I have just installed SQL Server 2005 express, and I am having problems creating a DNS for it.

I put in the datasource name, and the name of the database.  My developement server is geomatic-server.  Do i need to put in a username or password???  

What should the port number be???

Thx,
Rich

twista
12-03-2006 @ 9:47 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 232
Joined: Jun 2006

My first suggestion is to download the SQL Server Management Studio Express.Here

Then setting it up is a breeze. Open up the management studio, connect to your local server with windows intergrated security. Then you should see a tree view with lots of folders on one side.

To add a new log in:
Open the folder "Security"
Double click Subfolder "Logins"
In the main window you should see some weird info. Right click in a blank space and click "New Login"

Enter the name, and make sure you select "SQL Server Authentication".. enter the password and you should be set. You can now use that username and password to set up your DSN.

The Default port for SQL Server is 1433. So that should work just fine for you.

good luck Smile

-------------
-Morgan
Lead Trainer of the Ninja Squirrels
quote:

every time you store comma delimited values in a relational database, God kills a kitty.
-CJ

Richard
12-11-2006 @ 11:09 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 85
Joined: Sep 2006

Connection verification failed for data source: rich
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect

Hello...

I am still not being able to make a connection.  This is the error that I am getting???

Rich

SirRawlins
12-11-2006 @ 1:51 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 951
Joined: Mar 2006

This is quite a common issue with Express2k5, and becomes even more common if you've upgraded to 7.2.

I've had it a couple of times while setting up DSN's and found this article pretty handy, i beleive its one that megan also blogged about a few weeks back,

http://vmccurley.blogspot.com/2006/10/connecting-coldfusion-to-sql-server_1199.html

Hope that helps,

Rob

twista
12-13-2006 @ 9:06 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 232
Joined: Jun 2006

Look in this forum for my posting that says "can't connect". jjfutbol posted a very good solution.

-------------
-Morgan
Lead Trainer of the Ninja Squirrels
quote:

every time you store comma delimited values in a relational database, God kills a kitty.
-CJ


Website Designed and Developed by Pablo Varando.