Problem in database connection

Question

0.00/5 (No votes)

See more:

when i tried to open my database an error occur "cannot open database...[database path].. requested by the login. login failed.login failed for user 'user-pc\user'.

[edit]SHOUTING removed - OriginalGriff[/edit]

Posted 3-May-14 0:26am

Dolly Nimavat

Updated 3-May-14 0:35am

OriginalGriff

v2

Add a Solution

Comments

OriginalGriff 3-May-14 6:36am

DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.

OriginalGriff 3-May-14 6:36am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

Rahul VB 3-May-14 7:06am

Is this Deja Vu? :-)

Maciej Los 3-May-14 7:15am

Do you feel that you have seen it before? :laugh:

Rahul VB 3-May-14 7:25am

I feel so, because every time i see, griff is always up with such kind of an answer. so at times i get confused with whether it was the same question or the same answer. :))

Maciej Los 3-May-14 7:29am

I'd say: it's standard statement! It is used whenever OP posted "Unclear or Incomplete question" ;)

Rahul VB 3-May-14 7:30am

By the way Sir, you resemble Tymothy Olyphant from Hitman movie (dont mind, just kidding).
How do pursue both law and programming together. I think you are an OutLaw programmer :))). Again kidding. Very interesting Sir.

OriginalGriff 3-May-14 7:18am

No, "Reja Vu" - "the feeling that you will be here again".

Maciej Los 3-May-14 7:27am

:laugh:

Rahul VB 3-May-14 7:28am

I guess so. And yes i remember, i think we discussed Reja Vu before, dint we OG?

OriginalGriff 3-May-14 7:33am

...and I get the feeling we will again... :laugh:

Rahul VB 3-May-14 7:35am

How do you actually think of such things OG? :))))) and even i fall in your trap every time :)).

:laugh:

Rahul VB 3-May-14 7:39am

By the way Griff, i posted an article and now i am nervous i hope it is liked. Its still in review.

OriginalGriff 3-May-14 8:27am

Currently your article status is:
"An update for this article has been received, is in the queue, and will be processed soon."
Which means you sent an update to the staff, and it'll get done when they get to it - they are normally pretty quick, but it's a weekend (and a holiday weekend in the UK as well, so Canada may be on holiday too) so you can probably expect some delays.

Richard MacCutchan 3-May-14 6:36am

What part of that message (LOGIN FAILED) are you not able to understand?

King Fisher 3-May-14 7:30am

Do You see any error code ?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-05-03T01:25:00

Solution 1

There are 2 ways of authentication to the SQL server[^];

Windows authentication - is the default, and is often referred to as integrated security because this SQL Server security model is tightly integrated with Windows. Specific Windows user and group accounts are trusted to log in to SQL Server. Windows users who have already been authenticated do not have to present additional credentials
Mixed mode - supports authentication both by Windows and by SQL Server. User name and password pairs are maintained within SQL Server

You did not specify what kind of method you have chosen.

Run MS SQL Server Management Studio[^] and check it. Depending on these settings, set proper connection string[^].

For further information, please see:
Recommendations and Guidelines on Configuring the Authentication Mode for SQL Server[^]
Choose an Authentication Mode[^]
Change Server Authentication Mode[^]

Posted 3-May-14 1:25am

Maciej Los

Comments

Rahul VB 3-May-14 7:31am

Very nice.

Maciej Los 3-May-14 7:47am

Thank you ;)

King Fisher 3-May-14 7:32am

Claps For Answered Unclear Question :) my 5

Rahul VB 3-May-14 7:36am

Is king_fisher your favorite brand brother? its mine too :)

Maciej Los 3-May-14 7:47am

Let's say: all members of this forum are my friends ;) It's the Biggest Family of the World!

King Fisher 3-May-14 8:00am

He he he ;)

King Fisher 3-May-14 7:59am

of course i am ;)

Maciej Los 3-May-14 7:47am

Thank you ;)

Rahul VB 3-May-14 8:35am

Me too :) So let us raise a toast to this answer!!! :)

Maciej Los 3-May-14 8:46am

;)

Problem in database connection

1 solution

Solution 1

Add your solution here

Preview 0

Problem in database connection

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us