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 |
|
Fremo
Starting Member
3 Posts |
 Posted - 2011-01-08 : 14:48:54
|
| Heyy..theres a way to connect from my PC to others SQL Server 2000 if i got the id / pw?Hope someone can help :D |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-08 : 15:03:05
|
You can connect to any SQL server with the proper credentials from SQL Enterprise manager.Do you mean to ask "How can I execute query to another SQL server from a different SQL server?" To do this, the servers would have to be linked.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
Fremo
Starting Member
3 Posts |
Posted - 2011-01-08 : 15:17:07
|
| How to do it,can u explain me it xD? |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-08 : 15:20:02
|
Presuming you have SQL 2000 Enterprise manager, 1. Open Enterprise Manager, navigate to SQL Server Group (default group) 2. Right Click on SQL Server Group, select "New SQL Server Registration" 3. Type the SQL Server Name (found in your Control Panel) in the "Available Servers" text box and click "Add." Click "Next" 4. Select the appropriate authentication and provide your credentials.Now that SQL is registered, you can connect to the instance.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
Fremo
Starting Member
3 Posts |
Posted - 2011-01-08 : 15:22:46
|
| i cant find SQL Server name o.o where is it? |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-08 : 16:06:45
|
You kinda have to have the name first to be able to connect to it. Especially if it is on an another PC.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-09 : 01:15:38
|
| I hope both the PCs are in same domain. first check whether they can acces each other------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Connect to SQL Server with other PC?