asked on

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

ASKER CERTIFIED SOLUTION

Carl Tawn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

BrianMc1958

ASKER

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

Carl Tawn

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.

BrianMc1958

ASKER

OK. Found it. And you were right--I was just missing the password.

Thanks!
BrianMc1958