Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gdeconto
Posting Yak Master
107 Posts |
 Posted - 2002-02-06 : 15:16:46
|
| I am having difficulties in connecting to a sql2k server that is in another domain. Any help/guidance appreciated.Here are the specifics:1. I connect to my office from home using vpn; I have my own local domain, which is not the same as the one at the office; my login id and pw are the same on both and I have full domain administrator access to both2. the win2k + sql2k server is setup for both sql and windows authentication3. I can connect to the server from my home using pcanywhere, ping, etc (and vice versa) so I know connectivity is not the issue4. I am trying to use query analyser (QA) and enterprise manager (EM) to connect to the server to work on it directly (ie without pcanywhere)5. my home workstation (win2k) is using tcp/ip as the primary protocol to connect (ie via sql server client network utility)6. I can successfully register the server in EM using windows authentication, however I can't see or access anything in that server (ie when open up the tables folder, I see "(no items)")7. likewise, I can successfully register the server in EM using SQL authentication (ie using new sql accounts or SA account), however I can't see or access anything in that server8. I have NO problems whatsoever accessing SQL7 servers on the same network using either windows or sql authentication9. I have NO problems accessing the server from workstations connected to the network (ie my workstation at the office)10. I am not the only user with this problem so my local setup is not the issue.This is a tough nut to crack. Does anyone have any suggestions?? |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-06 : 18:10:16
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;Q280836&id=280836&SD=MSKBHTH-Chad |
 |
|
|
DGMelkin
Starting Member
24 Posts |
Posted - 2002-02-06 : 18:14:43
|
| Can you run an isql/osql statement against the server on the other network? Also, are you registering the IP address or the servername of the other SQL Server? If you're using the name, try the IP address.The other thought is creating an Alias for the machine in your Client Network Utility. I don't know much about them other than we have to use those to connect to some servers we have on a separate network.Just some thoughts. I have no clue if they'll help or not.-D |
|
|
|
gdeconto
Posting Yak Master
107 Posts |
Posted - 2002-02-07 : 11:40:41
|
| Appreciate your feedback guys.I am going to try Chadmat's info tonight, but don't know if it applies as this is not, I think, a remote server issue.Re DGMelkin's questions:I can't run any query on the problem office sql server from my home computer because it does not allow me to connect using either windows or sql authentication. As mentioned, I have NO problem with the other nt4/sql7 servers.I have tried connecting using the computer name, the ip address and using an alias; none of these worked.Any other ideas??? |
|
|
|
|
|
|
|
|
cross domain sql server access problem