Wednesday, March 28, 2012

Login failed for user DOTNETSPIDER2\dotnetspider

i am using this free web host site (www.aspspider.net), i was able to successfully upload my ASPNETDB.mdf to their server but unfortunately this error appears preventing me from attaching the db to their server, ive asked the help of the webmaster apparently hes not also sure what causes the error... any help will be very much appreciated... thanks:)

Error attaching database. System.Data.SqlClient.SqlException: The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'c:\MemberSites\ecommunic8\database\ASPNETDB.MDF'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at HostingUtils.HostManager.AttachDatabase(String userId, String databaseName, String dataFile)
Error opening attached database. Cannot open database "ecommunic8_ASPNETDB" requested by the login. The login failed. Login failed for user 'DOTNETSPIDER2\dotnetspider'.

SQL Express does not scale in a shared hosting environment. Please see this thread for more information:http://forums.asp.net/1108647/ShowPost.aspx.|||Sounds like the upload didn't take. If you are transferring it by FTP, make sure that you are using binary instead of ascii.|||

Motley wrote:

Sounds like the upload didn't take. If you are transferring it by FTP, make sure that you are using binary instead of ascii.

actually, i was able to successfully upload the database... the error prevents me from attaching it to their server...

No comments:

Post a Comment