Link to home
Start Free TrialLog in
Avatar of Keerthi Kamarthi
Keerthi Kamarthi

asked on

ConnectionStrings in web.config configuration file

I am trying to setup complete Microsoft SQL Server to another machine, for this I successfully restored db into Microsoft SQL Server Express 2008 R2 version from Microsoft SQL server 2000 version.

Now I am using ASP.NET and Microsoft SQL Server 2008 R2 Express for creating asp.net forms authentication , the .aspx.file is not connected to a database, I got an error like Login failed for user 'vinay' while compiling .aspx file on browser with IP Address. I gave database authentication in web.config file, Is anywhere wants to give database authentication other than web.config file. My database name is : CPS, password is: Indi123$, userId is : vinay and I server Name: my system name i.e, IV-27, but I have a doubt why we are using key in connectionString, my statement in web.cofig for database connection is  <add key="CPSWebAppl" value="Server=IV-27;Database=CPS;UId=vinay;Password=Indi123$;" />

Below is the attachment of User generated imagegetting error while compiling .aspx file on browser with IP Address.

Please help me to compile with IP address in browser.
SOLUTION
Avatar of Martin Miller
Martin Miller
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hopefully you're using a  Server, User ID and Password as isn't good idea to post those kind of information in a public website.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Can we close this?