Jump to content
  • Advertisement
Sign in to follow this  
kag1

[web] Problems Connecting to MS SQL Server

This topic is 5124 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

Hi, for some reason I have a problem connecting to my ms sql server, I have the address and password right and everything, but it always has problems connecting..no matter what program i'm using, no matter which computer i'm on and (dial up, college campus, without firewall on..). But for some reason, when making .asp pages, it connects perfectly and fine..leading me to believe i must be doing something wrong on my end.. Can someone think of something I'm doing wrong..or not doing that would get me to connect? I've tried EMS MS SQL Manager and some DinoSoft program with no luck getting it to connect..please help

Share this post


Link to post
Share on other sites
Advertisement
What is the error that it gives you when trying to connect? Does it even reach the SQL server, or does it timeout? If it times out, chances are it's a firewall issue.

Share this post


Link to post
Share on other sites
It always gives errors like check the host name and username and password..or the dino program gives me a

Quote:

java.sql.SQLException: Connection refused: connect
at net.sourceforge.jtds.jdbc.TdsConnection.allocateTds(Unknown Source)
at net.sourceforge.jtds.jdbc.TdsConnection.<init>(Unknown Source)
at net.sourceforge.jtds.jdbc.Driver.connect(Unknown Source)
at com.dnsalias.java.sqlclient.drivers.StandardClient.openConnection(StandardClient.java:132)
at com.dnsalias.java.sqlclient.drivers.StandardClient.openConnection(StandardClient.java:119)
at com.dnsalias.java.sqlclient.DBLogin.run(DBLogin.java:482)
at com.dnsalias.java.sqlclient.util.ThreadPool.run(ThreadPool.java:43)
at java.lang.Thread.run(Unknown Source)

I don't know if that means anything or not..

Share this post


Link to post
Share on other sites
The server is located at mssql.megasqlservers.com ...I can't get that to respond to pings or anything like that (i'm not sure that its suppose to..)..is that part of my problem possibly?

Share this post


Link to post
Share on other sites
I tried http://www.aspenterprisemanager.com/ to connect to the MS SQL server and that didn't work either...I don't know how thats possible when all my scripts made in just regular asp can connect and modify things just fine

Any Ideas anyone?

Share this post


Link to post
Share on other sites
Have your host actually given you permission to access it externally? Some web hosts will only grant access internally (or to their DMZ) meaning that all external connections are firewalled off. If this is the case, you're out of luck I'm afraid. Otherwise, check that the connection port is correct and check other configuration details with your host to make sure you don't have to do anything special.

Share this post


Link to post
Share on other sites
Is this your host by any chance? If so, have you followed the instructions on the FAQ?

Edit: I can connect to it via osql, I just can't login (no username/password)

Share this post


Link to post
Share on other sites
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

GameDev.net is your game development community. Create an account for your GameDev Portfolio and participate in the largest developer community in the games industry.

Sign me up!