Login problems while create a new SQL database within VS Basic 2005

I am working with 2 computers: a work laptop computer that runs XP Professional, and a personal desktop computer that runs XP Home. Both computers have Visual Basic 2005 Express Edition and SQL Server 2005 Express Edition installed.

Here is my problem. While I want to keep the applications and databases that I am working on stored on the home computer, I would like to be able to use the laptop to work on them when I am home. The files are stored on my desktop pc in a shared folder that I can access from my laptop via a wireless router.

However, when I am using Visual Studio (on my laptop) to work on one of the applications stored on my personal computer and I RightClick on Add... New Item... SQL Database, I get the following message:

Login failed for user 'LaptopName\UserName'

I am assuming this is because I am logged into my laptop under the login 'LaptopName\UserName', however, the database does not permit the login since no such login exists on 'DesktopName'.

Any ideas, suggestions?

[1175 byte] By [JCMARO] at [2007-12-25]
# 1

I believe you would need to specify the computername\username where SQL Server is stored - the reason is because it cannot look up your credentials since you are connecting from a different computer unless you were say, on a domain.

You also have to enable Remote connections and Sql Broker service in the SQL Express editions.

I would personally create a useraccount in SQL Server itself and login using those credentials.

To enable remote connections, follow these links:

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

Going back to the original problem....Is it possible to specify a specific login/account when adding a new SQL Database?

ahmedilyas at 2007-10-8 > top of Msdn Tech,Visual Studio Express Editions,Visual Basic 2005 Express Edition...