Login difficulty

I have created a a web application on computer1 and I have now transferred it to computer2. I am trying to attach my database (db1) in VS but I get this error: "Cannot open user default database. Login failed for user: username1". However when I use Management Studio Express I am able to access db1. I'm a newbie on this.

If you are not using the Advanced version of Express uninstall the current one and install the Advanced because it comes with Management Studio that will help with the above problem. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/download/

|||

By default, SQL Server is 'closed' to remote connections.

You will need to configure the server to allow remote connections. These sources will guide you.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

Configuration - Guideline for Connectivity Question Posting
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

|||if you specified a non-exisiting database as the default database for the user or the user does not h ave access to his default database, then you probably will get this error message. So check if the has the appropiate permissions to access his default user database or change the default database using the GUI or using the TSQL command sp_defaultdb.

Jens K. Suessmeyer.

http://www.sqlserver2005.de