client server app on local desktop in ncomputing environment

9500 pts.
Tags:
.NET
Client server software
ncomputing
SQL Server
I am using a locally desktop hosted sql server/ .net app on ncomputing. It allows to open and work only in one of the ncomputing nodes at a time and that too with Admin login.
How do I work on it on all nodes.
How do I login with local users logins instead of Admin login to work in the app.


Software/Hardware used:
sql server, .net, ncomputing

Answer Wiki

Thanks. We'll let you know when a new response is added.

This is a bit complex question. Shortly I can answer this way:
Each node needs at least connectivity tools. You are not saying what SQL Server version you use. In general however there is always required minimum. So you should use the setup and load minimum. Next depends on your requirements you need to make sure that there is at least <b>NT Network Authority\Network Service</b> Log in setting. That you can set through <b>SQL Server Configuration Manager</b>. Next you have to decide what the <b>Server Authentication</b> you prefer – <b>Windows Authentication Mode</b> or <b>Windows and Server</b> mode. That you can change from server properties. If you selected Windows and Server mode then you can create the logins in the server and use them to connect however there is Windows Only Authentication preferred. If you are not going outside of you network you can actually choose Windows and Server mode if is more convenient for you. When all is set and you want to connect to the server from NET application then you need to use <b>Microsoft SQL Server (OLE DB)</b> Provider for <b>SQL Server 2000</b> and <b>SQL Server Provider</b> or <b>Native Provider</b> for any hirer version of the Server.
That is shortly all. If you need more info regarding each subject I mentioned her I believe that the best it could be to read about it in <b>Books Online</b> related to the version of SQL Server. Like I said above this is complex subject and is difficult to answer in several words.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following