| Author |
Topic |
|
enak
Starting Member
34 Posts |
 Posted - 2007-01-24 : 11:13:00
|
| I am not sure if this is the correct forum but here it goes.I came into work this morning and rebooted my development machine only to find that I could no longer connect to any of the Db servers on the network. I can go to another machine and connect from there so I think that something is corrupt in my Enterprise Manager.I tried to upgrade, thinking that it would install the drivers again but it did not.How can I fix this without reinstalling client again?I am using SQL Server 2000. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-24 : 11:27:49
|
| Check whether you can access those machines by PINGing them. You may have network problem on your machine.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
enak
Starting Member
34 Posts |
Posted - 2007-01-24 : 11:32:35
|
| I can ping them from that machine. |
|
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2007-01-25 : 00:28:01
|
| what is the error u gets ? |
|
|
|
enak
Starting Member
34 Posts |
Posted - 2007-01-29 : 10:15:05
|
| A connection could not be established to SERVER.Reason: Data sources name not found an not default driver specified.Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the SERVER node) and try again. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-29 : 10:18:04
|
| It happens sometimes, unfortenately.The only remedy is to add the servers again in the EM.Peter LarssonHelsingborg, Sweden |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-01-29 : 10:45:16
|
They don't call it Enterprise Mangler for nothing  steve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
enak
Starting Member
34 Posts |
Posted - 2007-01-29 : 13:09:59
|
| I have uninstalled and reinstalled MS SQL Server 2000 client tools but I still can not access any of the servers.Any other thoughts? |
|
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2007-01-29 : 13:14:46
|
| try right click a server group and click new sql server registration and try re-register your unaccessible servers . |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
Enterprise Manager