remote connection to SQL Server in Visual studio .NET 05

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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.
 
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=yourserver;database=yourdatabase;uid=username;pwd=password"

-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com
 
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
 
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

:







- Show quoted text -
Click to expand...

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