April 15, 2008 at 6:27 am
Hi
I am using Visual web developer in conjunction with SQL server 2005 to construct an e-commerce website. the problem i am facing is, having produced the site to where it is now using a book, when it comes to executing the file, there is an unhandled exception in that the userID is an invalid keyword.
my web config file has the username sa and password that was given to me by the book. But i am assuming that the username and password in my sql server 2005 will be different. can anyone tell how i can check the username and password in my sql server 2005? at installation, i cant remember coming across any prompts to insert one. so if someone can guide i would be really greatful
April 15, 2008 at 10:46 am
Did you install SQL Server yourself or did someone else install it?
If you installed it, there was an option for setting up Mixed Mode authentication, which means both Windows security and SQL username/password security. If you didn't set it up when you installed it, you'll need to go to the Security tab for the server in Management Studio, and make the changes you need.
I recommend against using "sa" as the username for any applications. Set up and use a login that's more appropriate for the application.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 15, 2008 at 11:26 am
Thanks for that GSqaured
How would i do this exactly? I installed it but it came on the back off the visual web developer install that i downloaded from microsoft. It installed it itself and then was, supposedly, ready for use. Is there any chance you can give me specific guidelines in how this can be done?
Really appreciate your help.
Oh btw, it says the UserID is an invalid keyword. will doing what you said resolve this?
April 15, 2008 at 12:34 pm
I don't know about the invalid keyword thing.
Visual Web Developer comes with SQL Express. You'll need to download SQL Express Management Studio from microsoft. http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
Once you've downloaded and installed that, check Books Online. It has step-by-step instructions on how to do what you need here, and a ton of other useful information about SQL Server. You'll need to get familiar with it if you want to work with SQL.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply