|
I am trying to package SQL Express with my application and am having some trouble with the installation. I keep getting an error in the error log that says "credentials not valid" in reference to the supplied account (Which is NT Authority\System). Which is an issue I have researched and found no solid answer for. Maybe because it is Windows 7, I am not sure.
Anyways, rather than supplying the account via command line can I supply it the same way it is supplied in the SQL Express setup, with a drop down list?
If so, does anyone have a pointer to code for something like this? I am not sure how to get the information from AD to begin with (a combobox with a LDAP datasource?). And then, what that information should like like in code? (e.g. cboAcct.text?)
Right now the code looks like this:
strCommandLine.Append(" /Timestamp=" + timeStamp);
strCommandLine.Append(" /Action=Install");
strCommandLine.Append(" /AddCurrentUserAsSQLAdmin");
strCommandLine.Append(" /Features=SQL,SSMS");
strCommandLine.Append(" /InstanceName=pcExpress");
strCommandLine.Append(" /q");
strCommandLine.Append(" /SQLSVCACCOUNT=NT AUTHORITY\\SYSTEM");
strCommandLine.Append(" /SQLSYSADMINACCOUNTS=BUILTIN\\ADMINISTRATORS");
strCommandLine.Append(" /SQLSVCSTARTUPTYPE=Automatic");
strCommandLine.Append(" /AGTSVCACCOUNT=NT AUTHORITY\\SYSTEM");
strCommandLine.Append(" /AGTSVCSTARTUPTYPE=Automatic");
strCommandLine.Append(" /RSSVCACCOUNT=NT AUTHORITY\\SYSTEM");
strCommandLine.Append(" /RSSVCSTARTUPTYPE=Automatic");
strCommandLine.Append(" /ASSVCACCOUNT=NT AUTHORITY\\SYSTEM");
strCommandLine.Append(" /ASSVCSTARTUPTYPE=Disabled");
strCommandLine.Append(" /ASSYSADMINACCOUNTS=BUILTIN\\ADMINISTRATORS");
strCommandLine.Append(" /ISSVCACCOUNT=NT AUTHORITY\\SYSTEM");
strCommandLine.Append(" /ISSVCSTARTUPTYPE=Disabled");
Any help would be appreciated.
|
|
|
|
|
Have you looked over this[^] ?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
I have looked at that, at great length I might add. The problem is when packaging the application I can't use a <domain\useracct> because I have no idea if the machine will be standalone, or on a domain, nor will I have any idea of what the proper user name might be. Some of the examples I have seen site NT AUTHORITY\Network Service as a possible account to use. This works fine in the GUI installation, but I am having trouble getting it to run in the unattended install.
|
|
|
|
|
You may need to create a custom action for the installer to ask for the proper information then
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
That was my thought process. The installer itself is not a setup project, but rather a small executable program that wraps the installer with a custom class. It runs the SQL setup in a shell and waits for the process to finish and then launches the setup MSI. That setup has a custom action that collects information and runs a SQL script.
So my idea was to embed a form in the installer wrapper application to prompt for username information for the SQL account, but the average user would be dumbfounded. I guess the bigger issue here is whether anyone has gotten an unattended SQL install to work, and if so using what user for the SQL service account?
|
|
|
|
|
I am trying to figure out how to get a path string to the public directory in Windows 7. On my system the path is C:\Users\Public. Since someone may move this directory to another location, I would like to be able to locate it through code instead of hard coding a path string.
I have looked into using "Environment.GetFolderPath(Environment.SpecialFolder.#####)" but I can't find a SpecialFolder enumeration for the public directory. Does anyone have any suggestions?
Thanks for considering my question,
CraigCraig
|
|
|
|
|
I don't know about .NET 4.0, but there is no enum value that returns the path to the Public folder in any version of .NET up to and including 3.5.
You'll have to resolve the Public environment variable to get that path.
string PublicFolderPath = Environment.GetEnvironmentVariable(@"Public");
|
|
|
|
|
Dave,
Thanks for taking the time to help me. It confirms what I suspected about using that enumeration. Your suggestion will work fine.
CraigCraig
|
|
|
|
|
![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
Hi.
I have program with SQLSERVER 2000.My Server Name is saved in text file in 'C:\Server.txt';and when program is started , program will read Server Name from text file.
But when i start my program from (Remote computer in my network) it's not working.And an exception is shown
"The Timeout period elapsed prior to completion of the operation or the server is not responding";
Is the problem in my network?
or in program?
And this is my Connection String:
"Data Source=" + Program.serverName + ";Initial Catalog=Nicco;Integrated Security=True";
Thank you.
CanI
|
|
|
|
|
Is the server name correct? Have you tried using TCP/IP address instead of server name?
|
|
|
|
|
Hi.
Server Name is Correct.And my network is working well because when i write in 'Run' for example '\\Server' it respond and i can copy any file from client to server and also from Server to client.
CanI
|
|
|
|
|
But if you have a different network (different than TCP/IP) the \\Server will work, but the TCP/IP will not.
Try using ping to see if it is working.
|
|
|
|
|
Ok, let me start off by saying that this is my first post ever, so be gentle.
I am having an issue with a web service where I am randomly getting the following error:
System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.
The error stems from the same object all of the time. So after investigating the issue I believe it is happening because I am using a static TableAdapter for one particular sql server database table. This is a surrogates table which is used to track keys to all of the other tables within the database (Not my design and I cannot change it). 
Here is my question:
Would it be better to implement the static TableAdapter and lock that or to create a generic object to lock and create a new TableAdapter every time I would like a new key. This Surrogate table has roughly 30 different tables that it manages keys for and it probably will create between 100 and 200 keys per call. So creating a TableAdapter every time that method is called seems like wasted resources but I am not sure if having a static TableAdapter is the best way to go either. Also, any better way to handle it would be greatly appreciated.
Example Code:
This Way
public class SurrogateClass
{
public SurrogateClass(){}
private static SurrogateTableAdapter SurrogateAdapter = new SurrogateTableAdapter();
public static int GetSurrogateByTableName(String tableName)
{
int result = 0;
lock (SurrogateAdapter)
{
SurrogateRow row = SurrogateAdapter.GetSurrogateByTableName(tableName).FindByTABLENAME(tableName);
if (row != null)
{
int.TryParse(row.SURROGATE.ToString(), out result);
result += 1;
row.SURROGATE = result;
SurrogateAdapter.Update(row);
}
else
{
result = -1;
}
}
return result;
}
}
Or this way
public class SurrogateClass
{
public SurrogateClass(){}
private static object lockerOjbect = new object;
public static int GetSurrogateByTableName(String tableName)
{
int result = 0;
lock (lockerObject)
{
using (SurrogateTableAdapter SurrogateAdapter = new SurrogateTableAdapter())
{
SurrogateRow row = SurrogateAdapter.GetSurrogateByTableName(tableName).FindByTABLENAME(tableName);
if (row != null)
{
int.TryParse(row.SURROGATE.ToString(), out result);
result += 1;
row.SURROGATE = result;
SurrogateAdapter.Update(row);
}
else
{
result = -1;
}
}
}
return result;
}
}
|
|
|
|
|
Uuuuh... dunno. 
I use DataReaders all the time (and never TableAdapters). I also haven't done much with Web Services. And I use GUIDs as keys. So quite likely I would never run up against what you have.
You might try locking the Connection instead of the TableAdapter; just a shot in the dark.
P.S. Oh, and this may be a case where you need two Connections.
|
|
|
|
|
Thanks for your reply but I really cannot change the keys to use GUIDs and even if I could, I probably would not use them because I do not believe them to be better for our particular scenario. There are certain times where using GUIDs are advantageous but since I do not need to merge records, create keys outside the db or application, and I am not using replication or an ORM, I really do not need deal with the extra data not to mention that integer keys are faster. As far as locking the connection or needing two connections I do not believe either are necessary. Both of my code posts solve my problem there is just a difference in how many objects are created and when they are destroyed and I was wondering if there is either a better way of fixing my problem or someones opinion on which one is better and why.
Thanks for the help.
|
|
|
|
|
hi
i have 3 panels and 2 buttons.
in panel1 i have a few controls along with 2 buttons.
when i click on button2(which is inside the panel1)
only i need to show the panel2, if i click the same button2 i need to imvisible the panel2..(Here i am providing two up and down images to hide and show the panels).
by default in form_load i need only panel1 and panel3
|
|
|
|
|
|
Hi everyone,
I currently have a gridview on my .aspx webpage and i want my page to reload by itself every 5 minutes. I have added a Timer Control in order to do this. However, does anyone have any idea what is the coding that i should write in my Timer_Tick method? I need to do this in c# language.
thank you.modified on Friday, February 19, 2010 11:35 AM
|
|
|
|
|
I would say you are better off implementnig this in JavaScript or use the refresh meta tag
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
How do i implement the refresh meta tag?
|
|
|
|
|
Like this[^]."WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
however, instead of reloading the whole page, my goal is to just refresh the grid at a particular interval. i implemented an UpdatePanel with timer. however, i am unsure of the c# code to implement inside my Timer_Tick method.
protected void Timer1_Tick(object sender, EventArgs e)
{
}
|
|
|
|
|
Hi everyone,
Does anyone know how i can retrieve the IP address of the host PC, and then compare that IP Address with a list of IP Address which is stored in a MS Access database to verify that the host PC is able to view the webpage. I need to do this in C# language.
thank you.
|
|
|
|
|
That may not work very well when the client uses DHCP.
|
|
|
|
|
currently, i am already able to retrieve the ip address of the host PC. right now, i just need to compare it with a list of IP Addresses in my database to search for a matching IP Address. then, if that IP Address is valid, i would allow the user to view the webpage. I am unsure of how this could be done? does anyone have any idea to guide me through?
thank you!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
