VERY NEWBIE: Connection string for web page?

Dear Experts,

I'm a dummy about web pages anyway, and I'm trying to do my first within Visual Studio 2005.  It's failing with:

SqlException (0x80131904): Login failed for user 'MyNormalLogin'

'MyNormalLogin' is the login I normally use to access the database in a Windows desktop application.  My guess is I need to change that to an 'IUSR_Something' login, which is already set up on the database.

What I cannot figure is how to create another ConnectionString.  I know where in the ASP to plug it in.  I just don't know how to create it.  Could anyone clue me in?

Thanks!
BrianMc1958
BrianMc1958Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Carl TawnSystems and Integration DeveloperCommented:
If "MyNormalLogin" is valid on the SQL server then it should be valid full-stop, irrespective of whether you are connecting from a desktop or web app. Maybe you have typed the password incorrectly or failed to provide a password at all.

Your connection string should look something like:

    Server=YourSQLServer;Initial Catalog=YourDatabase;UID=MyNormalLogin;PWD=YourPassword;"

If you are using SQL logins, or else:

    Server=YourSQLServer;Initial Catalog=YourDatabase;Integrated Security=SSPI;

If you are using Windows based login. The error message you are getting simply suggests that the password is incorrect.

Hope this helps.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BrianMc1958Author Commented:
Thanks.  I can try that.  However, I still can't figure out how to MAKE another connection string.  It seems like VS treats it as it's own little object, maybe because of security issues.  I had somehow defined one yesterday, but can't figure it out again...  Could you tell me where that's done?

Thank again,
BrianMc1958
0
Carl TawnSystems and Integration DeveloperCommented:
You can define your connection string in all sorts of places, so it really depends on how you are going about it.

You may possibly have done it through the Server Explorer (which you get to via the View menu). Here you can define database connections and drag/drop them into your pages and have VS automatically create the connection objects for you.
0
BrianMc1958Author Commented:
OK.  Found it.  And you were right--I was just missing the password.

Thanks!
BrianMc1958
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.