Trouble with ConnectionString - What is my User ID and password

[Mike_Gore]

Hi,

I know the format is right, but what is my user ID and password. I get this error when I try to open the webpage on localhost:

HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid.

I am using SQL Server 2005 express.

I am running this on my computer, still working on the webpage, so no remote server or anything just want to access the webpage I have done on my PC.

How do I find out what my username and password is. I am not sure if 127.0.0.1 is correct, but as I said I am running this on my computer. Its IE7.

Thanks,

Mike

[dannystommen]

<add key="ConnectionString" value="Data Source=127.0.0.1\SQLEXPRESS;Initial Catalog=UDG;Persist Security Info=True;User ID=username;PWD=password;"/>


Try changing in into localhost and see what happens

<add key="ConnectionString" value="Data Source=localhost\SQLEXPRESS;Initial Catalog=UDG;Persist Security Info=True;User ID=username;PWD=password;"/>

[Mike_Gore]

tried localhost, didn't work.

[eclipsed4utoo]

you connection string attribute for the password should be "Password" not "PWD". Though that is not causing your issue(but it will).

as for what the username and password is, what did you set them as? During the setup of SQL Express, you are asked to put in a password for the "sa" account. So use "sa" as the username, and whatever you entered during the setup as the password.

Is SQL Express running? Go to Start --> Control Panel --> Administrative Tools --> Services ... and look for the SQL Express service(s). Are they started?

Also, what did you name your instance of SQL Express? During the setup, there was a screen that should have had 2 radio buttons. One said to use the instance name that is in the corresponding textbox. The other said to use the default name. Which did you choose?

[Mike_Gore]

there is one services called SQL Server Browser which is disabled. But I can't enable this process. Doesn't allow me to start this service. Could this be the cause? If so how do I enable it?

I think I chose windows authentication, not sure. Can I get to that screen and select username and password, or would I have to reinstall it?

[eclipsed4utoo]

You will need to reinstall. After reinstall, try again(putting in the username and password), and see if that works or gives you a different error message.

[dglienna]

Authentication problems? Here's Beth Massi's blog showing how to do it:

http://blogs.msdn.com/bethmassi/archive/2008/09/17/enabling-remote-sql-express-2008-network-connections-on-vista.aspx

[Mike_Gore]

Thanks everyone. It is working now. :-)