asp.net and remote sql server connection

[Jmshastri]

if i want to connect a remote database server with ms SQL server 2000 to asp.net application in vb.net, what content should i provide in the web.config file? i am using visual studio.net 2003 i have tried following tags in web.config files Should i change any kind of user authorization settings for this task? Please help me. it's very urgent

[Rajiya]

hi U can try out these settings: Note: here S1 is ur remote server name. and xyz is ur Database name. -- modified at 22:51 Sunday 5th March, 2006

[Jmshastri]

Thanks for the response. but the code snipet you have given is taken as html tags. so you should check the check box given below the text area so the tags will be ignored. please reply back. thanking you in anticipation. jwalant

[Rajiya]

Hi, I have ignored the HTML tags now, U can check the code again.Hope it helps u out. Regards, Riz