Connection String

Question

Post reply

Connection String

nabeelbanares

Valued Member

Points: 59
More actions
April 15, 2008 at 6:13 pm

#189155

I have a connection string here that produces, or should produce, a connection to an SQL database:

This sits inside my web config file. The problem is that everytime i go to execute my program, it used to go as far as User ID and then the program used o crash citing invalid keyword at UserID. Having done some research, i have ensured both User ID, Password and Initial catalog are valid keywords for a SQL Connection however now the program moves forward to the point where the connection opens in my program before crashing. The user ID, password and stuff is fine but still no joy. Is anyone able to see where i am going wrong so i can make corrections?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mahesh Bote SSCrazy Eights Points: 9107 More actions · Answer 1

[font="Verdana"]does it throwing any error? Or whether do you able to connect to DB or not ?

Meantion some more details.

By the way, at UserId add domain name. i.e. UserID should be:

@domainname\{your UserId} and then try with password.

Mahesh[/font]

MH-09-AM-8694

Stephanie Giovannini SSCertifiable Points: 7422 More actions · Answer 2

I think you have to escape the less than and greater than signs (angle brackets) as < and > or else everything in brackets is stripped out, thus the connection string you tried to post is gone.

Yes, the escaped brackets in my post appeared. Use the ampersand + lt/gt + semicolon escape sequence.

Loner SSC-Insane Points: 21279 More actions · Answer 3

Is your SQL Server window authenticated? I have been tried to solve this problem since last month. Somehow even I put the password in the connection string, it dropped during the execution. If you search the internet, a lot of people having this problem. The best way is to have the SQL Server window authenticated.