Connection and permissions

Hello all,

Why can't I connect to my database which is located on another PC on a Peer to Peer Network?

I have two PCs. (Details below) of which the database is on PC 1 and is called Surveys

My connection works fine from PC1 but from PC2 it does not work.

The connection string I am using is Server=PCWillys\SQLEXPRESS;Database=Surveys;Trusted_Connection=True

Is this because I need to set up Permissions on the database for LAPTOP\Phil.

If so How does one do this?

Thanks in advance,

Phil

PC 1

UserName: PCWILLYS\Willys

ServerName: PCWILLYS\SQLEXPRESS

PC 2

UserName: LAPTOP\Phil

SQL Express is configured by default to not accept remote connections. You can configure it to allow remote connection using the following KB Article:

914277 How to configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1