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

Connecting to SQL Server via MS Access-Issue

We have a user who can connect via link tables to sql to one database oak.
On the other database (which he has exact same permissions) he gets timeout
message (ODBC Call Failed). He can oly see one table in link tables with th
e
database in question, the other he can see all of the tables. The user can
connect via Query Analyzer aok to both databases and see all the tables.
Could any shed some light on what maybe the issue and a workaround?
ThnxsIf it doesn't appear to be an issue with SQL Server, then look at
DSN's, or any other client-side settings which may be different.
--Mary
On Thu, 7 Sep 2006 08:29:02 -0700, PDavies
<PDavies@.discussions.microsoft.com> wrote:

>We have a user who can connect via link tables to sql to one database oak.
>On the other database (which he has exact same permissions) he gets timeout
>message (ODBC Call Failed). He can oly see one table in link tables with t
he
>database in question, the other he can see all of the tables. The user can
>connect via Query Analyzer aok to both databases and see all the tables.
>Could any shed some light on what maybe the issue and a workaround?
>Thnxs

Connecting to SQL Server via MS Access-Issue

We have a user who can connect via link tables to sql to one database oak.
On the other database (which he has exact same permissions) he gets timeout
message (ODBC Call Failed). He can oly see one table in link tables with the
database in question, the other he can see all of the tables. The user can
connect via Query Analyzer aok to both databases and see all the tables.
Could any shed some light on what maybe the issue and a workaround?
ThnxsIf it doesn't appear to be an issue with SQL Server, then look at
DSN's, or any other client-side settings which may be different.
--Mary
On Thu, 7 Sep 2006 08:29:02 -0700, PDavies
<PDavies@.discussions.microsoft.com> wrote:
>We have a user who can connect via link tables to sql to one database oak.
>On the other database (which he has exact same permissions) he gets timeout
>message (ODBC Call Failed). He can oly see one table in link tables with the
>database in question, the other he can see all of the tables. The user can
>connect via Query Analyzer aok to both databases and see all the tables.
>Could any shed some light on what maybe the issue and a workaround?
>Thnxs