1863014 Members
1515 Online
110446 Solutions
New Discussion

SQL problem !!!!

 
Chapaya
Frequent Advisor

SQL problem !!!!

Hello all ,

I have SQL 7.0 sp3 on NT4 .
The registration is disconnected once a day :(
what can i do to solve this proble, ?

Eran .
1 REPLY 1
Paul Sperry
Honored Contributor

Re: SQL problem !!!!

Try

deleting Server Registration (with Enterprise
Manager). Then create a new Server Registration, but instead of typing
in the machine name for the Server Registration Name, selected (LOCAL) from
the drop down list box. After that edit the registration to change the
Login Name to "sa" and leave the Password blank.