?
Solved

InitializeSecurityContext failed

Posted on 2011-03-02
7
Medium Priority
?
855 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

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

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.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

777 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