SPRASAD Posted March 30, 2003 Posted March 30, 2003 I am trying to learn SQL server with .Net. I am writing a simple app for a client. Its good learning tool for me. Right now I am using SQL 2000 and and using localhost as the server. The default in Code Samples. It seems to be working in my office but I know its not going to work at my clients. The data will be sitting on the server and my system will be running on a couple of stations. I know this must be simple but I like to know how I get the Server, User and Password to the Server. How do you guys handle this? Any help will be greatly appreciated. Thanks Sunil Prasad sunilprasad@dccnet.com Quote
anand Posted March 30, 2003 Posted March 30, 2003 Hi Sunil I am not getting ur problem actually...u said u are using the server name as Localhost...and when u are going to instal ur application in ur client system which have another server name(instance of sql server) u should have to give the server name of the sql server in that client machine and u should have to give the username abd password according to the sql s erver authendication in client machine...i think this will help u ..if not i am sorry.......... Satya gummadi009@yahoo.com Quote Satya
Guest mutant Posted March 30, 2003 Posted March 30, 2003 Maybe you could prompt the user for UserName,Pass and server name the first time he/she uses the program and then store it in registry. And then when you need it just read it from there. Quote
Cassio Posted March 31, 2003 Posted March 31, 2003 You can also save it in a xml file. Or if the clients are logged in the servers domain you can use integrated security. Quote Stream of Consciousness (My blog)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.