HI experts..I need ur help..
VB.NET category
I need script that can be used to do settings for allowing SQL SERVER 2005 Express to allow remote connections.
The settings that we do manually after installation i.e to enable TCP/IP in remote connection in Configration Manager , start Browser service, set authentication mode,add sqlserver.exe in Windows Firewall exceptions, create a instance of SQL server express logon .... these settings I want do be done via through a SCRIPT.
I need this scrpit to get excuted during installation of my VB.NET Setup
Can anyone provide me the SCRIPT and also a way how to execute that during installation automatically?
:)
mania_comp -2 Light Poster
Recommended Answers
Jump to PostWhy don't you just install it properly to begin with?
setup.exe /qb ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,Client_Components,Connectivity,SQL_SSMSEE INSTANCENAME=@@InstanceName@@ SAVESYSDB=1 SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 AGTAUTOSTART=1 SECURITYMODE=SQL SAPWD=@@Password@@ DISABLENETWORKPROTOCOLS=0 ERRORREPORTING=1 SQMREPORTING=0 ADDUSERASADMIN=1 INSTALLSQLDIR="%ProgramFiles%\Microsoft SQL Server\"
Jump to Post....what I do is have a front-end application that lets the user defines the parameters. The application then writes that command out to a "install.bat" file and
ShellExecute()
's the file so the user doesn't have to run the command. I suggest you do the same. This is delphi/pascal …
Jump to PostYes it is but why do something wrong from the start and go back and fix it? Why not just do it properly to begin with. You can add a custom installer action and create a class in your assembly to execute which contains the script. You're adding a lot …
All 9 Replies
sknake 1,622 Senior Poster Featured Poster
mania_comp -2 Light Poster
sknake 1,622 Senior Poster Featured Poster
kvprajapati commented: cool but I don't thik OP will get it. +11
mania_comp -2 Light Poster
sknake 1,622 Senior Poster Featured Poster
mania_comp -2 Light Poster
sknake 1,622 Senior Poster Featured Poster
mania_comp -2 Light Poster
sknake 1,622 Senior Poster Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.