Question

无法打开用户默认数据库。登录失败。

前几天还可以通过局域网来访问，今天忽然不行了，好像是没有改过里面的设置，今天只能通过VS2005来本地访问。。。。。
[SqlException (0x80131904): 无法打开用户默认数据库。登录失败。
用户 'ADMIN\ASPNET' 登录失败。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735027
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
officeDAL.DBHelper.Getconn(String sql) in D:\huarun\officeDAL\DBHelper.cs:17
officeDAL.officeService.GetAllTiankong() in D:\huarun\officeDAL\officeService.cs:32
officeBLL.officeManager.GetAllTiankong() in D:\huarun\officeBLL\officeManager.cs:14
test.Page_Load(Object sender, EventArgs e) +88
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint
IIS应该没有问题，因为从局域网可以访问首页，通过首页输入用户名和密码访问数据库就不行了.
这个方法我一开始试过了，结果还是一样的，感觉好像就是通过IIS连不上数据库。

Answer 1

在sql server2005中展开“安全性”－“登录名”，右键点击ADMIN\ASPNET，打开其登录属性对话框，在左侧选择“用户映射”，勾选需要映射到的数据库名字，并设置数据库角色成员身份为db_owner和public。