connect website files with SQL server 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

connect website files with SQL server 2005

Author

Topic

ITpassenger
Starting Member

6 Posts

Posted - 2011-08-09 : 01:04:10

Hi all
i am trying to upload my local web site to a hosting web site so i can use it online
the problem is i get error while i am trying to access the sub pages of the web
even when i am trying to login

because there is error while trying to access the DB

this is the error:................

Server Error in '/' Application.
Cannot open database "ministry" requested by the login. The login failed.
Login failed for user 'Ahmed'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "ministry" requested by the login. The login failed.
Login failed for user 'Ahmed'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Cannot open database "ministry" requested by the login. The login failed.
Login failed for user 'Ahmed'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849015
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2394
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35

Pleaaaaaaaaaaaaaaaaaase someone help me
what i should do???

ITpassenger
Starting Member

6 Posts

Posted - 2011-08-09 : 01:05:24

ministry is my DB name
Ahmed DB user

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-08-09 : 10:55:41

Sounds like either the database is unavailable, or, more likely, the user doesn't have permission.

Make sure the db is online and check permissions.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2011-08-10 : 05:26:40

no, more like the login details are incorrect. See the stack trace error message

quote:
Cannot open database "ministry" requested by the login. The login failed.

you need to go to your web.config file and change the login details from the local computer to the remote computer and try again, goodluck

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources