Trouble with ConnectionString - What is my User ID and password

--------------------------------------------------------------------------------

Hi,

I don't know if this is the right forum to post, but I would really appreciate any help.I have posted this on other post hoping for a solution only for weeks to pass with no replies. I've been trying it for day and I haven't been able to figure it out. Is the syntax wrong? Do I have to write username and password in the single quotes or double quotes or none. What is my password? Do I have to set up Sql Server 2005 Express to use SQL Server Authentication? If so, I tried that couldn't even set that up. Is my server not running properly? What? Do some programs require Windows Server installation? I am just trying to get it run only on my computer (localhost).

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.

And it is highlighting this part:

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


I am using SQL Server 2005 express.

IIS from vista original.

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

If you have mySQL installed there's a utility built in called MySQL Administrator that shows you all of that information. If you didn't set one it's usually username: root password: admin.

Go here to find your connection string syntax:

http://www.connectionstrings.com/sql-server-2005

The thing is this website I am trying to run was designed with sql server 2005 as the database. I could'nt find "sql server 2005" so I downloaded "sql server 2005 express", would that make a difference?

I simply added the database (sql script) by opening the sql.script it seemed to load everything. And I checked what subdirectory it should be in as well. Do I need to also press execute button after double clicking the sql script (which opened the sql server management studio express automatically). The reason I am asking is because when I click execute I get error message "Cannot find the user 'bla bla', because it does not exist or you do not have permission"

check this script:


Since this script was originally designed on another system, it doesn't work on mine. The thing is I don't know what I have to replace "bla" with and where to find out what the username is. But does this matter, since the tables are created. I can check them from the gui in sql server management studio express.

Also the website was previously run on a Windows server. Does it matter if I have vista instead?

I'd really appreciate your help.

Thanks,

Mike