Unable to Access databases - SQL Server Forums

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

Unable to Access databases

Author

Topic

Carriolan
Starting Member

2 Posts

Posted - 2005-10-03 : 17:23:33

Hi
I hhave just recently de-installed MSDE and installed SQL Server Developer Ed 2000 and attached the two databases that were running under MSDE. SQL Server can see them with no problems. I launch the program in my browser using localhost and get the error message below. It was working perfectly under MSDE what do I do to correct it please?
Regards Carriolan
Mono Portal Engine

An error has occured while processing your request. Please contact system administrator with the following information:

Error description: System.Data.SqlClient.SqlException: Login failed for user 'ASTRALIS\ASPNET'. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText) at MonoSoftware.MonoX.Portal.Global.Global_Error(Object sender, EventArgs e)

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-10-03 : 22:47:57

your logins are most likely orphaned.

Check BOL for sp_change_users_login, or search sqlteam for discussions regarding how to use this stored procedure to fix this kind of problem.

-ec

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-10-03 : 22:49:30

if this is a domain account, then sp_change_users_login won't fix it. Just add that domain account to the Security area of sql server. You will get a message saying that this user has access to some databases (click the ok button) and then you should be set.

This problem occured because your system databases were rebuilt when you installed SQL Server dev edition.

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources