Connecting to SQL server

  • jflynn
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2305
  • Loc: Baker City, Oregon

Post 3+ Months Ago

I am trying to connect to and SQL server over the internet and get the following error.

"sql server does not exist or access denied"

The program that connected before was on an Windows XP machine and worked fine. I am currently using the same program but it is now installed on a Windows Server 2003 machine.

What in WS2k3 is differant then the WinXP and would be causing this problem?

The firewall on the WS2K3 is turned off.

Thanks in advance.
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Don2007
  • Web Master
  • Web Master
  • Don2007
  • Posts: 4924
  • Loc: NY

Post 3+ Months Ago

Who owns the SQL server? Shouldn't you be asking them if the server is still running or if your account is still valid or if the client software has to be activated?
  • jflynn
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2305
  • Loc: Baker City, Oregon

Post 3+ Months Ago

Let me rephrase a line from above.

The Old Computer (winxp) STILL works.
  • Don2007
  • Web Master
  • Web Master
  • Don2007
  • Posts: 4924
  • Loc: NY

Post 3+ Months Ago

Then activation of the client software is still a possibility. Other than that, is Norton or one of the other so called internet security software packages running?
  • jflynn
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2305
  • Loc: Baker City, Oregon

Post 3+ Months Ago

Like I said, the only thing differant between the 2 machines is that one is WindowsXP and one is Windows Server 2003.

I need to know if there is a extra bit of security somwhere on the server that is blocking the program from reaching the SQL server.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

jflynn

I assume the SQL server you are trying to connect to resides also on a Windows server.

Do you have your Win2K3 server set up as a Domain Controller? I assume the one that SQL is on is also a DC. And I assume they are also different domains?

I'm thinking you might have to set up some kind of trust, which wouldn't have been necessary with XP.
  • jflynn
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2305
  • Loc: Baker City, Oregon

Post 3+ Months Ago

mine is not a DC.

I have no control over the SQL server so a trust would not be available. this is going to be interesting. I'm going to do a little more research on what the program is actually trying ot do when it "connects".

Why is it that the "simple" things are Never simple? Argh! I'll get back if i have another question.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

ODBC connection? Correct driver? I have one application that we had to install SQL native client driver vs SQL driver and then make the connection with the SQL native client.

Post Information

  • Total Posts in this topic: 8 posts
  • Users browsing this forum: No registered users and 66 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.