开发者

SQL authentication in SQL Server 2008

I have this problem.

I first connect(log) to SQL Server using SQL开发者_StackOverflow社区 Management Studio the authentication is set to Windows Authentication.

Then I go to the Security => Logins folder and add a user, the authentication is: SQL Server authentication, I give him also the sysadmin role [all roles]

I try to login as that user, but I can't

I tried everything but no result

How can this be corrected?


You should enable SQL Authentication; it isn't enabled by default.

In SSMS, right-click on the top-level (server) node, select Properties. Then click on Security in the left-hand panel, then select the "SQL Server and Windows Authentication mode" radio button in the right-hand panel.


You also have to restart you sql server. For me it start working only after restart.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜