remote connection to SQL Server in Visual studio .NET 05

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
 
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

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.
 
G

Guest

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
 
G

Guest

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
 
G

Guest

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 -

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,787
Messages
2,569,631
Members
45,338
Latest member
41Pearline46

Latest Threads

Top