Solved

InitializeSecurityContext failed

Posted on 2011-03-02
7
835 Views
Last Modified: 2013-12-09
I have several users of my C# .NET program that are getting this error when running gsec.exe to set the user id and password for the database.

All of them have this in common:
they are all running Windows 7 Home Premium
in all cases, when first executing the program, the user id and password were not defined
Firebird version is 2.5.2 (as shown in the properties of FirebirdSql.Data.FirebirdClient.dll

How can I fix this?
0
Comment
Question by:rmmarsh
  • 4
  • 3
7 Comments
 
LVL 19

Expert Comment

by:NickUpson
ID: 35034767
Please attempt to reproduce using gsec from the commandline so we can tell if the issue is gsec, c# or the interface between the 2
0
 

Author Comment

by:rmmarsh
ID: 35036482
Hi Nick... it doesn't fail for me... let me ask you another question:  I believe the user id and password are the issue.  Since I have created the d/b and tables here (in my office) and then just give them the .fdb file to upload, isn't there a way I can set the user id and password here so it's already in the d/b when they download it?  (the user id and password are the same for all users)
0
 
LVL 19

Accepted Solution

by:
NickUpson earned 500 total points
ID: 35036583
no you cannot "set the user id and password here so it's already in the d/b when they download it" but you could create a security database with the correct id & passwd in and have them install that as well. Note that the internals of the security db are version specific and firebird has to be shutdown while it's replaced.

Another option would be to use the embedded version of firebird, which doesn't care about the userid anyway
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:rmmarsh
ID: 35036636
I thought I was using the Embedded version... isn't FirebirdSql.Data.FirebirdClient.dll the embedded version?

0
 

Author Comment

by:rmmarsh
ID: 35036693
One more thing Nick... when I decided to use Firebird several years ago, I thought that using an embedded server would prevent users from networking to the database.  Is this not true with the embedded server?
0
 
LVL 19

Expert Comment

by:NickUpson
ID: 35036888
the embedded one is has "embedded" in the name, If I remember correctly you can network to embedded but only 1 connection at a time is permitted
0
 

Author Closing Comment

by:rmmarsh
ID: 35036965
It looks like you have to have one "regular Firebird server" which will listen for the connections...  thanks, Nick.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
postgres queries -- need opinions 1 70
What does "flush tables;" do exactly? 7 98
Need a starter for ETL protocol? 4 55
Documenting Data flow 4 37
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now