the problem is likely your connection string. Your application is trying to log in with the ASPNET user which is the default account used by all asp.net applications.
1) make sure your SQL Server installation is to set for SQL Server and Windows Authentication. You can right click on the server in SQL Enterprise Manager and select Properties. The authentication settings are on the Security Tab. 2) set your connection string to use the sa account you have set up. The following is all you need in the connection string... server=YourServerName;uid=sa;pwd=YourPassword;database=YourDatabase On 8/5/05, sheetal <[EMAIL PROTECTED]> wrote: > Hi, > thiz iz my first question in this group.I am using Windows XP operating > system and i installed sql server 2000. When i am trying to connect to the > sqlserver in asp.net i am getting this is error > "Login failed for user systemname\aspnet". I used the default user Sa and > also customized user of the database but same error.But its working in > vb.net windows application. I searched 2 find the solution but nothing helped > me. > Thanks in advance, > sheetal > > > > --------------------------------- > Too much spam in your inbox? Yahoo! Mail gives you the best spam protection > for FREE! > http://in.mail.yahoo.com > > [Non-text portions of this message have been removed] > > > > > > Yahoo! Groups Links > > > > > > > -- Dean Fiala Very Practical Software, Inc http://www.vpsw.com ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h5h6do2/M=362335.6886445.7839731.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123247810/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
