connection problems to a SQL2005 DB that I own

I am a DB owner/ creator. I have connected to the DB before through my ASP.net app in the server explorer. Now when I try to refresh the connection I get an error message that says "User does not have permission to perform this action." I cannot figure out why because my connection string has not changed and my DB is still in the same location as it was before. I have checked all of the permissions on the SQL Server management studio and I have permissions to do everything. PLEASE HELP! :(

This has nothing to do with connection string ...

You must check the priviliges granted to the user from which you have logged into your data base.

|||

tabish82:

This has nothing to do with connection string ...

You must check the priviliges granted to the user from which you have logged into your data base.

As I said in the above post...

"I have checked all of the permissions on the SQL Server management studio and I have permissions to do everything"

I have not changed any of the permissions or used a different log on to access the db. I still cannot get connected.

|||

Check out:

http://blogs.msdn.com/kaelr/archive/2005/10/28/486369.aspx

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=648224&SiteID=1

Hope it helps...

|||

There might be some changes in the network configuration (e.g. Firewall).

Try to disable your firewall on Windows and try again.

Good luck.

|||

I have all firewall settings disabled, but thanks anyway

|||

Can you register (or connect to) your database server using same UserID and Password?

|||

Do you have a linked server?

I hope this will help:

http://blogs.msdn.com/kaelr/archive/2005/10/28/486369.aspx

http://www.aspspider.com/qa/ViewQuestion.aspx?QuestionId=1032

Good luck.