- 积分
- 15
- 注册时间
- 2010-10-20
- 积分
- 15

|

楼主 |
发表于 2010-10-25 10:13:14
显示全部楼层
回复 8# wuyun
不是高手-_-
在帮助里面有,贴出来,我原来以为要装几个G的那个sql server,后来发现只要装这个EXPRESS几十兆的运行环境就ok了,注意就是授权方式选SQL和windows共同授权就ok了
Tip: If the server is installed locally, you can use the Database Configuration Tester to test for this problem and fix it automatically.
Using an account with Administrator privileges on the local computer, change the authentication mode for the server to SQL Server and Windows authentication mode.
On Microsoft SQL Server:
Run Start | Programs | Microsoft SQL Server | Enterprise Manager.
In the tree on the left, right-click the name of the server and select Properties. The SQL Server Properties (Configure) dialog box appears.
Click the Security tab.
Under Authentication, select SQL Server and Windows, and click OK.
On SQL Server Express, the user inte**ce for configuring the server is not installed by default. If you do not have it, download it from Microsoft: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
Run Start | Programs | Microsoft SQL Server 2005 | SQL Server Management. The Connect to Server window appears.
Select the server name and Windows Authentication. Click Connect. The Microsoft SQL Server Management Studio Express window appears.
In the tree on the left, right-click the name of the server and select Properties. The Server Properties dialog box appears.
At the left, click Security.
Under Server authentication, select SQL Server and Windows authentication mode, and click OK.
Cause 5 |
评分
-
查看全部评分
|