remote connection to SQL Server in Visual studio .NET 05

[=?Utf-8?B?ZGF2aWQ=?=]

When I start the Visual Studio .NET 2005 on client machine, I select Tools
and database connection (Database: SQL Server, security: windows
authentication. Server: Server Machine name (not in the same domain, but in
the same local area network; even same subnet)). When test the connection, I
get error message: not associated with a trusted SQL Server connection.

Server machine is Server 2000 and SQL server 2000 with security
authentication: windows only.

Could any one give a help and hint to solve this problem.

Thanks

David

[Alexey Smirnov]

On Oct 19, 7:31 pm, david <da...@discussi ons.microsoft.c omwrote:

When I start the Visual Studio .NET 2005 on client machine, I select Tools
and database connection (Database: SQL Server, security: windows
authentication. Server: Server Machine name (not in the same domain, but in
the same local area network; even same subnet)). When test the connection, I
get error message: not associated with a trusted SQL Server connection.

Server machine is Server 2000 and SQL server 2000 with security
authentication: windows only.

Could any one give a help and hint to solve this problem.

Thanks

David

I think your user has no rights on the database. Try to login for
example, with SQL Query Analyzer, or check security settings on the
server with your DBA.

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

There are two kinds of ways to authenticate to SQL Server:
1) Windows
2) SQL Server Authentication

You are using Windows Auth (e.g., "Trusted Connection") and the remote
machine does not recognize your credentials. The best solution is to enable
the SQL Server for mixed - mode (both Windows and SQL Server) authentication,
and use a SQL Server login, e.g.
"server=yourser ver;database=yo urdatabase;uid= username;pwd=pa ssword"

-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

"david" wrote:

When I start the Visual Studio .NET 2005 on client machine, I select Tools
and database connection (Database: SQL Server, security: windows
authentication. Server: Server Machine name (not in the same domain, but in
the same local area network; even same subnet)). When test the connection, I
get error message: not associated with a trusted SQL Server connection.

Server machine is Server 2000 and SQL server 2000 with security
authentication: windows only.

Could any one give a help and hint to solve this problem.

Thanks

David

[=?Utf-8?B?ZGF2aWQ=?=]

Thank you.

I will try.

I can not even connect to the server. When I type in the server machine IP,
111.122.233.45 and my name and my password, the error message is "could not
connect to "137". If I use "111.122.233.45 ", the error message: " can not
find computer name 111.122.233.45" .

David

"Peter Bromberg [C# MVP]" wrote:

There are two kinds of ways to authenticate to SQL Server:
1) Windows
2) SQL Server Authentication

You are using Windows Auth (e.g., "Trusted Connection") and the remote
machine does not recognize your credentials. The best solution is to enable
the SQL Server for mixed - mode (both Windows and SQL Server) authentication,
and use a SQL Server login, e.g.
"server=yourser ver;database=yo urdatabase;uid= username;pwd=pa ssword"

-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

"david" wrote:

When I start the Visual Studio .NET 2005 on client machine, I select Tools
and database connection (Database: SQL Server, security: windows
authentication. Server: Server Machine name (not in the same domain, but in
the same local area network; even same subnet)). When test the connection, I
get error message: not associated with a trusted SQL Server connection.

Server machine is Server 2000 and SQL server 2000 with security
authentication: windows only.

Could any one give a help and hint to solve this problem.

Thanks

David

[Alexey Smirnov]

On Oct 19, 9:51 pm, david <da...@discussi ons.microsoft.c omwrote:

Thank you.

I will try.

I can not even connect to the server. When I type in the server machine IP,
111.122.233.45 and my name and my password, the error message is "could not
connect to "137". If I use "111.122.233.45 ", the error message: " can not
find computer name 111.122.233.45" .

David

"Peter Bromberg [C# MVP]" wrote:

There are two kinds of ways to authenticate to SQL Server:
1) Windows
2) SQL Server Authentication

You are using Windows Auth (e.g., "Trusted Connection") and the remote
machine does not recognize your credentials. The best solution is to enable
the SQL Server for mixed - mode (both Windows and SQL Server) authentication,
and use a SQL Server login, e.g.
"server=yourser ver;database=yo urdatabase;uid= username;pwd=pa ssword"

-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com

"david" wrote:

When I start the Visual Studio .NET 2005 on client machine, I select Tools
and database connection (Database: SQL Server, security: windows
authentication. Server: Server Machine name (not in the same domain, but in
the same local area network; even same subnet)). When test the connection, I
get error message: not associated with a trusted SQL Server connection.

Server machine is Server 2000 and SQL server 2000 with security
authentication: windows only.

Could any one give a help and hint to solve this problem.

Thanks

David- Hide quoted text -

- Show quoted text -

David, first of all, you need find where is your server :-)