Connect sql server 2000 with C#.net in a LAN network environment

Question

I've built a software that should be running in client pc in a lan network. I've installed the software in a client pc. I want to configure a pc that will be acting as database server. But from the client pc sql server 2000(database server) is not connecting. I'm using string connstring = Data Source=SHOMEN-IT;Initial Catalog=master;Integrated Security=True;User id=shomen;Password='';; Should I need to change the string or should I need to install any other tool? How can I be able to connect database server in client-server environment? Regards Shomen --------------------------------------------------------------------------------

John Penn · Answer

If you're specifying Integrated Security=True then you shouldn't need to give a username and password. Either set it to false or leave it set to True and remove the username and password. Can you copy/paste the error message here? It would be a big help.