.NET (Core and Framework)

1-Oct-06 10:58

i need your help please help me ,,

actually i have developed a windowd service in c#.net , this service retrieves data from a sql server installed on a work group on the same lan wherre my computer resides , but it gives an exception always " login failed for user sa reason cannot connect to a trusted sql server connection. " remote sql server is configured for both windows and sql server authentication and i have configured serverprocess installer for local system account with user name password = null ;

kindly help me
tauseef

hello

Dave Kreskowiak1-Oct-06 14:59

1-Oct-06 14:59

Your service is running under the Local System account, but in your connection string your specifying Trusted Connection. You can't do that since the Local System account is not trsuted by the SQL Server, and can't be. Remove the Trusted Connection part of your connection string, but still supply an SQL username and password to use. DO NOT USE THE 'SA' ACCOUNT! Create a seperate account to be used by the service for this database.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Tauseef A1-Oct-06 21:10

1-Oct-06 21:10

Hi thanks for your cooperation , i have created a seperate user on sql server with the name "terminal" and passowrd "abc"
i am supplying the following connection string
"Provider=sqloledb;Data Source=software-14;Initial Catalog=company071;;integrated security=SSPI;User Id=terminal;Password=abc;";

kindly tell me where i am wrong , is there any need to create a windows nt user on the pc where sql service resides .

i m getting the following exception
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

hello

Dave Kreskowiak2-Oct-06 3:10

2-Oct-06 3:10

Remove the Integrated Security junk. This is what's causing your "trusted connection".

Provider=sqloledb;Data Source=software-14;Initial Catalog=company071;User Id=terminalassword=abc;

Dave Kreskowiak
Microsoft MVP - Visual Basic

Tauseef A2-Oct-06 4:06

2-Oct-06 4:06

thaksn again
but dear this time it gives this exception
Login failed for user 'terminal'. Reason: Not associated with a trusted SQL Server connection.

my connection string is

"data source = software-12;initial catalog = company071;user id=terminal;passowrd=abc"

hello

Dave Kreskowiak2-Oct-06 5:24

2-Oct-06 5:24

Did you copy/paste this connection string or just type it into this post??

If you're using the SqlConnection object, it should be:

"Data Source=software-12;Initial Catalog=company071;User Id=terminal;Password=abc"

This will work so long as you've created a user id terminal and assigned it the appropriate permissions to the company071 database. This means, at a minimum, giving that user db_datareader and db_datawriter roles in your database.

Also, when you created the user, did you turn on SQL Server authentication for it?

Dave Kreskowiak
Microsoft MVP - Visual Basic

Tauseef A2-Oct-06 7:51

2-Oct-06 7:51

No i just typed this string here , my this service works fine of i provide my local system sql server in connection string,even i give trusted connection = true in the case of local sql server ...so connection string is working fine .
Thanks for yoru cooperation
on other side let me tell you how i crearted a user.
Enter prise manager i select my locar server , go into security >logins

>in this window >right click >i provided in the name text box "terminal"
i checked sql server authentication > i provided password>i selected master as dafault data base> lanuguage English>than Server Roll TAB>i checked only system administrator>
>than TAB database access > i selected Company071>in the window belowe for company07 roles > i checked public and db_owner>at the end a password confirmation window open and retype the passowrd for this login...

Now i am in company 07d1 databsase>i select logins> now here is a login of terminal>
i open its properties>public and dbowner fields are already checked>now i click permission button>and i select the "Employee"table >now i press columns buttons > here i check the necessery columns for htis user > click ok and finich every thing is fine, in query analyzer results are perfect, this user can access the data base company071 tables employee

hello

Dave Kreskowiak2-Oct-06 8:39