Jeremy's Blog
Register
< Back to OSY 1.0 thread list

OSY 1.0 Thread Viewer

Thread #: 1840

SQL Server 2000.

Madan

Mon May 13 21:26:27 2002

Good stuff.

M.

Madan

Mon May 13 21:29:47 2002

Crap. I spoke to soon. It won't connect to my remote db.

...

M.

Magus

Mon May 13 21:30:45 2002

/me looks at the copy he got of MSDN downloads...
PaulHill

Tue May 14 07:24:38 2002

Setup your remote DB over TCPIP (port 1433) which is the default connection on SQL 2000.
PaulHill

Tue May 14 07:28:40 2002

Who's your daddy?
PaulHill

Tue May 14 07:29:09 2002

Who's Your Daddy?
PaulHill

Tue May 14 07:29:33 2002

I'M YOUR DADDY!
AllYorBaseRBelong2Us

Tue May 14 10:53:06 2002

Your're my daddy paul :)

now where's my allowance!

Madan

Tue May 14 12:00:26 2002

Ok...uhm. In English this time?

:)

Thanks.

M.

(Edited by Madan at 5:01 am on May 14, 2002)

DrPizza

Tue May 14 13:09:13 2002

What the fuck is "it"?

SQL Server has no business connecting to remote databases.

Enterprise Manager, Query Analyzer, and DTS, however, might.

Madan

Tue May 14 13:29:18 2002

EM is what I'm using. It won't connect to the remote SQL 7 db.

Any ideas why not?

M.

DrPizza

Tue May 14 14:18:37 2002

Yeah, something's wrong.

Um, some details?

Like, what are you trying to do?  Register it in EM?  Windows or SQL Server authentication?  IP or Named Pipes or what?

etc. etc.

Madan

Tue May 14 19:37:34 2002

I'm using EM on SQL Server 2k demo(developer) to enter a remote SQL 7 db. I'm using SQL server authentication. I created a new group in the EM, with the addy of the server, and then used the SQL server authentication with user name and password to enter the remote db.

It worked with my SQL 7 EM but my 2k demo won't.

It just hangs.

M.

Madan

Tue May 14 23:16:42 2002

Reparative BUMP
PaoloM

Tue May 14 23:21:17 2002

Ask doctorl33t@yahoo.com, maybe he didn't have his forum spammed.
Madan

Tue May 14 23:27:37 2002

...

Touche.

I'll figure it out on my own.

M.

HitScan

Wed May 15 13:16:00 2002

They may use different versions of the SQL Server Tabular DataStream protocol. (how the EM "talks" to the server) Which would be why 7's EM works fine with a 7 db, but the 2k EM can't talk to it. You may have to pitch the 2k EM or talk someone into installing the full version of 2k on that server (lots of luck with the fundage for that...)

Of course, it's entirely possible that I don't know what I'm talking about and DrPizza or Paul Hill will come school us both on backwrds compatability, but in the meantime, if I were you I'd stick to what works. :)

DrPizza

Wed May 15 19:20:46 2002

MSSQL 8's EM will certainly talk to MSSQL 7, but until Madan answers all the questions I posed him, there's not a lot to say.

Is it actually hanging or just waiting for a timeout (i.e. what happens if you leave it for a few minutes)?

Madan

Wed May 15 20:00:06 2002

I answered the questions you gave me.

I told you I'm using SQL 2k EM to tap into a remote SQL 7 Server, run by an external hosting company, on a shared host machine.  That my machine is Win 98b.
I told you that I set up the new SQL group by using the add group and then inserted the address: sql06.innerhost.com

I also told you that I'm using SQL Server authentication, since I have the username and password. And finally, I told you that I attempt to click the database tab within that group, named HSTORE(address: sql06.innerhost.com) and that it gives the processing cursor(multiple overlapping boxes) but does nothing. I.E., it "hangs".

What precisely, were the questions you were referring to?

madan.

DrPizza

Thu May 16 17:19:09 2002

from Madan posted at 9:00 pm on May 15, 2002

I answered the questions you gave me.

I told you I'm using SQL 2k EM to tap into a remote SQL 7 Server, run by an external hosting company, on a shared host machine.  That my machine is Win 98b.
I told you that I set up the new SQL group by using the add group and then inserted the address: sql06.innerhost.com

I also told you that I'm using SQL Server authentication, since I have the username and password. And finally, I told you that I attempt to click the database tab within that group, named HSTORE(address: sql06.innerhost.com) and that it gives the processing cursor(multiple overlapping boxes) but does nothing. I.E., it "hangs".
What precisely, were the questions you were referring to?


IP or Named Pipes or what?

The processing cursor is an hourglass.

If you leave it a couple of minutes, is it still giving you the hourglass, or does it come back with an error?

Madan

Thu May 16 17:40:14 2002

What do you mean by "pipes or IP"?

I never leave it for more than a minute and a half. But it doesn't connect after 1.5 minutes.

is an hourglass

Not on my machine.

M.

HitScan

Thu May 16 19:46:22 2002

He means how does the EM connect to the remote machine. IP means it connects to it's IP address on port 1433, whereas named pipes connect through a special share on the remote machine. (I think. Technically.)
In other words, hunt down the connection options type dtuff and type up what you see. :)
Madan

Thu May 16 20:13:21 2002

I have no fucking idea.

I'm assuming that since I'm using a domain, that it would be via IP, no?

M.

HitScan

Thu May 16 21:48:32 2002

Hard to say. Were I to guess (and I am, completely in the dark...) I'd say a domain means you can use Pipes, since you can be authenticated by the DC and your permissions can be checked for pipe access. I could be completely mistaken, it wouldn't be the first time. Sadly, if there is no connection type settings dialog you can find I have no clue, since I have never had access to the EM, and have only recently been able to use VS.Net to act as one for my MSDE databases.
DrPizza

Mon May 20 20:43:14 2002

Well (a) find out how to find out (i.e. read the help files) (b) tell me.  It could be either.  It will probably be IP, but it pays to make sure.
martin007

Wed May 22 09:09:28 2002

Turn off your firewall and see if that helps.

Teh firewall always causes problems for me.