Browse by Tags

• associated with a trusted
• compressed
• login failed
• mastlog.ldf
• 启动不了

• Microsoft SQL Server Error 18452: Login failed ... not associated with a trusted SQL server connection

  Microsoft SQL Server 2005中改变登录方式和2000中几乎一样，只是Management Studio和以前的EM界面有一些区别： Microsoft SQL Server 2000: Open The SQL Server Enterprise Manager Start menu > Programs > Microsoft SQL Server > Enterprise Manager) Expand the tree-control until you can your server Right click on the server name and "SQL Server Properties (Configure)" window will open Select the Security tab For "Authentication", select "SQL Server and Windows" Microsoft SQL Server 2005: 1. Open the... Posted Nov 21 2007, 02:49 PM by Coolboy with | with no comments Filed under: sql2005, associated with a trusted, login failed

• sql 2005启动不了

  The file "C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. 2007-11-21 14:08:00.68 spid5s Error: 5118, Severity: 16, State: 1. 2007-11-21 14:08:00.68 spid5s try try 选中C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA文件夹，右键属性->高级->选中或不选中压缩内容以便节省磁盘空间->确定 Posted Nov 21 2007, 02:41 PM by Coolboy with | with no comments Filed under: mastlog.ldf, compressed, sql2005, 启动不了