我想在sql server 2008中为我的数据库创建用户登录 [英] i want to create a User login for my database in sql server 2008

问题描述

大家好，

i有问题...我想为我的数据库创建一个登录用户..



For我做了以下过程...



1.在服务器资源管理器中，我继续安全然后登录，然后右键单击新登录



2.在常规标签中，我设置了登录名。并检查sql server authentication并设置passward



3.然后在默认数据库中选择master，在default language中设置english



4在服务器角色...检查所有角色



5.在用户映射中我选择我想要创建登录用户的数据库。



6.并在状态授予权限并启用登录。



7.然后点击确定。







但这不起作用。当我尝试登录时，它说...



与服务器成功建立连接，但在登录过程中发生错误。（提供者：共享内存提供程序，错误：0 - 管道的另一端没有进程。）（Microsoft SQL Server，错误：233）





然后我也在sql server配置管理器中启用了namedpipe ..



但它给出了同样的错误...请给出suggetion ..我在哪里我的进程错了..？

解决方案

确保SQL SERVER服务正在运行。

您可以启用/启动SQL Server服务执行以下步骤。



转到控制面板>>管理工具>>服务>>

查找SQL SERVER（MSSQLSERVER）>>右键单击>>属性>>启动类型自动并单击开始。

确保服务器已准备好接受远程连接。



默认情况下没有启用。

除了以前的全部内容，请确保在连接时防火墙已关闭另一台PC上的数据库



创建用户后别忘了重新启动服务器

右键单击服务器并选择重新启动

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.. ?

解决方案

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.

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

It's not enabled by default.

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

这篇关于我想在sql server 2008中为我的数据库创建用户登录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！