I am unable to connect to sql server?

[mooniron]

Dear all. Please help me how I can connect to sql server from a client computer? When tried to connect via ADO connection, there occures an error like "not associated with trusted sql server connection.". Thanks..........

 

[miq]

hi,

1) properly configure client network utility. Create alias for the remote server with proper protocol and port number. usually tcp/namedpipes are used as protocol.

2) set sqlserver's authentication mode to integerated (sql server and winnt authentication).

Or provide valid user id and password in your ADO code instead of trusted_connections=yes / integerated security=spp1.

bye
miq

 

[miq]

hi,
one thing i miss was security. You can create winnt/2000 users with active directory users and computers then in enterprise manager ->security -> logins. Create new login in the name field click ellipses (browse) and select newly created winnt user account click ok. That all to it, you have configured winnt user account to authenticate to sqlserver. obviously, you can set propery security permissions for the newly created login.

bye
miq

 

[mooniron]

Thank miq. I did all you said. I was able to connect through visual basic using ado. But I want to connect when in asp pages.
For example I use:
conn="Provider=SQLOLEDB.1;Initial Catalog=myDatabase;Data Source=Server;UID=myLogin;pwd=" connection string and:
It returns:
---Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'myLogin'. Reason: Not associated with a trusted SQL Server connection.---
error.....................................
I am trying to connect from client computer to server computer(two computers).
Thanks again.

 

[dogramone]

Hi,
One thing to do is check the server security settings. Does the server accept windows only or windows and SQL authentication. I amm assuming that the user for the asp page is a SQL only user, not a windows user.

Mark