SQL Server Connection with C# program
-
Hi everybody I have a sort of strange problem . On my computer I have VS2003 and MSSQL server 2000 . for a long period I have been running my application under development with no problem . I had to format my PC , reinstall SQL server and VS2003 with same application when database connection start to fail . I am using SQLdataconnection with connection string and using windows authentication for the SQL server . the strange part is that when I log in as administrator at starting the computer , the connection will work only once . then start failing all the time . Any one having an Idea about this situation . UnitecSoft We will either find a way or make one .
-
Hi everybody I have a sort of strange problem . On my computer I have VS2003 and MSSQL server 2000 . for a long period I have been running my application under development with no problem . I had to format my PC , reinstall SQL server and VS2003 with same application when database connection start to fail . I am using SQLdataconnection with connection string and using windows authentication for the SQL server . the strange part is that when I log in as administrator at starting the computer , the connection will work only once . then start failing all the time . Any one having an Idea about this situation . UnitecSoft We will either find a way or make one .
Sounds like some kind of user privilege problem. Does it work if you are not using Windows Authentication?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
-
Sounds like some kind of user privilege problem. Does it work if you are not using Windows Authentication?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
I Don't think its a user privilege problem , no reason to have a successful connection in the first run then a failure connection in the second run while no changes in anything between the two runs . could it be a setup parameters problem for the .NET framework or SQL server . I will try to change windows Authentication to sqlserver security . UnitecSoft We will Either Find A Way Or Make One .
-
I Don't think its a user privilege problem , no reason to have a successful connection in the first run then a failure connection in the second run while no changes in anything between the two runs . could it be a setup parameters problem for the .NET framework or SQL server . I will try to change windows Authentication to sqlserver security . UnitecSoft We will Either Find A Way Or Make One .
hi everyone Just to share the information , The reson of being unable to connect to sql server database via C# application was due to the anti virus protection I am useing ( Kaspersky ) . Disabling this program will solve the problem . maybe there is a certain setting within Kaspersky to allow or deny this access . :-D UnitecSoft We will Either Find A Way Or Make One .