|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
||||
|
||||
|
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 Last edited by mystic7 : September 24th, 2009 at 06:19 PM. |
|
#3
|
|||
|
|||
|
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: Code:
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'bla') EXEC sys.sp_executesql N'CREATE SCHEMA [bla] AUTHORIZATION [bla]' 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 |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Trouble with ConnectionString - What is my User ID and password |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|