随笔分类 -  Database-SQL

SQL database
摘要:Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005You may have faced the issue of losing the SQL Server SA password. Perhaps you followed the security best-practice of removing the builtin\Administrators from the sysadmin server role, and no one you can find is in 阅读全文
posted @ 2012-03-10 19:16 cubean 阅读(729) 评论(0) 推荐(0)
摘要:使用SQL2005 Express版数据库,在通过aspnet_regsql.exe创建sql的权限数据库时,第三步的时候(选择服务器和数据库),不能选择数据库(显示连接失败),报以下错误:默认的服务器是你的电脑名字COMPUTERNAME,而我们由于使用的Express版数据库,所以只要将后面加一个 \SQLEXPRESS 即可,即Server: COMPUTERNAME \SQLEXPRESS... 阅读全文
posted @ 2009-11-04 17:22 cubean 阅读(3594) 评论(0) 推荐(0)