1
Answer

SQL ConnectionString Error

onder

onder

11y
1.7k
1
Hello Friends;

first of all i am sorry for my English. i am not good at learning English.

I developed a winforms application in C#. i have a database which is created in SQL. (i use sql server 2005)
my programm has some intefaceses and  and i can delete, update and insert some data to the database. the database is in my own pc.

Now i install the database to the server. Because 3 or 4 people will use the program. 
the operation system in the server is win7 and i install the sql server 2005 express edition and sql server management studio. I restore my database to the this machine.

But i have some troubles while i am conneting the database. my code is below:

(Server name is DOSYASERVER
DosyaTakip is the database name)

<configuration> 
<connectionStrings> 
    <add name="LocalSql" 
        connectionString="Data Source=192.168.0.222\DOSYASERVER;Initial Catalog=DosyaTakip; Integrated Security=true"/> 
    </connectionStrings> 
</configuration> 

when i execure the program i get error message:

Login failed for user ''. The user is not associated with a trusted SQL Server connection. 

and Server Authenticatiom mode is SQL server ve Windows Authentication Mode.

I am sorry for my English again.

Answers (1)