munira
January 31st, 2000, 01:15 AM
Hello
I have SQL Server 6.5 installed on a Windows NT Server machine. While installation the security type selected, was SQL Server authentication. Later i selected the Configure option of the server and changed the Security option from SQL Server authentication to Windows NT authentication.
After this I am not able to commect to the Server. I get the foll error:
"Not defined as a valid user of trusted SQL Server Connection."
Also, the Configure option of the Server is now disabled, due to which i am not able to reset my Security option.
The problem is that in the Enterprise manager itself, when i Click on the Server. It gives me the above mentioned error and does not allow me to view or modify any configuration.
Kindly help at the earliest.
Munira
I have SQL Server 6.5 installed on a Windows NT Server machine. While installation the security type selected, was SQL Server authentication. Later i selected the Configure option of the server and changed the Security option from SQL Server authentication to Windows NT authentication.
After this I am not able to commect to the Server. I get the foll error:
"Not defined as a valid user of trusted SQL Server Connection."
Also, the Configure option of the Server is now disabled, due to which i am not able to reset my Security option.
The problem is that in the Enterprise manager itself, when i Click on the Server. It gives me the above mentioned error and does not allow me to view or modify any configuration.
Kindly help at the earliest.
Munira