i want to create a User login for my database in sql server 2008

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

hi to all ,
i have a problem ... i want to create a login user for my database ..

For this i did the following process ...

1. In server explorer i go on "Security" and then on "Login" and then on right click "New Login"

2. In "general" tab i set a "Login name" . and check "sql server authentication" and set passward

3. Then in "Default database" i select "master" and in "default language" i set "english"

4 In server roles ... check all roles

5. in "user mapping " i select database for which i want to create login user .

6. And in "status" grant permision and enable login .

7. And then click ok .

But this is not working. when i try to login , it says ...

"A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)"

and then i also enable namedpipe in sql server configuration manager ..

but it gives the same error ... pls give suggetion .. where i am wrong in my process.. ?

Posted 29-Oct-13 23:26pm

GDdixit

Add a Solution

Comments

GDdixit 30-Oct-13 5:44am

i have checked . it is selected as "sql server and windows authentication mode"

sp_suresh 30-Oct-13 5:56am

Please go through
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
and
http://msdn.microsoft.com/en-us/library/ms175496(v=sql.110).aspx also

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Dipesh Wadhwa · Answer 1 · 2013-10-30T01:46:00

Solution 2

Make sure that SQL SERVER service is running.
You can enable/start SQL Server service by doing following steps.

Go to Control Panel >> Administrative Tools >> Services >>
Find SQL SERVER(MSSQLSERVER) >> Right Click >> Properties >> Startup Type Automatic & Click Start.

Posted 30-Oct-13 1:46am

Dipesh Wadhwa

marius_enric · Answer 2 · 2013-10-29T23:36:00

Solution 1

Be sure that the server is ready to accept remote connections.

It's not enabled by default.

Posted 29-Oct-13 23:36pm

marius_enric

Comments

GDdixit 30-Oct-13 5:44am

where can i check this frnd ?

GDdixit 30-Oct-13 5:48am

ok i have seeing this . this is already checked in property

Gamal.Harb · Answer 3 · 2014-02-02T22:08:00

Solution 3

in addition to the whole previous make sure that the firewall is turned off if you connect to that database on another PC

and after creating the user don't forget to restart your server
right click on the server and choose restart

Posted 2-Feb-14 22:08pm

Gamal.Harb

Updated 2-Feb-14 22:12pm

v2