How Do I Do An Unattended Install Of MSDE 1.0 Sp4?

Jul 19, 2006

I am trying to upgrade an MSDE 1.0 db with the Service Pack 4 patch
but I need to do either a Silent or Unattended install.
Does anyone know how to do this? Does anyone know the
command-line command to do this?



I tried using...

sql70sp4.exe -a -f1 "unattend.iss"



....but that didn't work. It popped up a window asking where I
should extract the contents of the .exe (that shouldn't be appearing
either) and then after it extracted it didn't do anything else.



Any help is greatly appreciated.

View 1 Replies


ADVERTISEMENT

Unattended Install WITH SP3 Using .iss

Mar 31, 2004

Using an unattended file (.iss) is there a way to incorporate the SP3 (or any) patch within an .iss file so that there is only only install that incorporates the patch?

View 1 Replies View Related

Problem With Unattended Install

Mar 23, 2007

I am trying to do an unattended install using the following commad

Setup.EXE /settings C:/setup.ini /qn

but i am getting a messaged saying

"Please go through control panel to install and configure system component"

I already have one instance of sql server installed on the server.

Please can some one help with this

View 2 Replies View Related

Unattended Install Of Client Components

Jun 20, 2006

I'm trying to do an unattended install of the client components for SLQ2005. I have read the document on doing a install from the command prompt but when I use the "ADDLOCAL" switches I get some components that I don't require. For example, I am using the following command to run the setup - "start /wait <path>setup.exe ADDLOCAL=Client_Components,SQL_Tools90,Connectivity". When I look at the Add/Remove Programs list I can see that it has installed "MSXML 6.0 Parser", "SQL 2005 Backward Compatibilty" and "Office 2003 Web Components". The only components I require are the "SQL Support Files", "SQL Server Native Client" and " CLient Tools". If I run "start /wait <path>setup.exe REMOVE=SQLXML,TOOLS_BC_DEP" it will remove "Office 2003 Web Components" and "SQL 2005 Backward Compatibilty" but not the "MSXML 6.0 Parser". How can I get rid of this?

Thanks for any help.

View 1 Replies View Related

How To Configure TCP Port For Unattended Install

Jul 24, 2006

I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433.

Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable.

Is there a way to do this with a command-line parameter (etc)?

Thanks in advance

Josh

View 6 Replies View Related

Connecting To SQL Express After Unattended Install

Oct 13, 2007

Good afternoon,

I have written a .NET app that kicks off an unattended install of SQL Server Express Advanced. After the install, the same app tries to connect to SQL Express adn run a script that creates a database plus a few other things.

However, the problem I am having is that my app cannot connect. I get the error:

"An error has occurrred while establishing a connection to the server. This failure may be casued by the fact that under the default settings SQL Server does not allow remote connections."

However, the unattended install goes great. No problems there. I know this because I can Open SSMS, run queries, created DB's, etc. I also know that it is not the remote connections issue because the unattended install is set to allow remote connections (both names pipes and TCP/IP).

So, why can't i connect? I don't need to reboot after the install do I? Please tell me i don't...and please tell me it is something simple I am overlooking.

Thanks...

View 3 Replies View Related

Unattended Install From Commad Line W/o IIS

Mar 6, 2008

Hello SQL Knowledgeable Crowd,

I'm trying to install SQL Server 2005 from the command line without using an .ini file and without having IIS installed. I know that I need to pass all the parmeters and I think I have them all.

My .bat file will install when IIS is installed, but I can not get it to install without IIS. The GUI gives me a warning and allows me to ignore this, but I can't figure out the switch that will do the same thing.

Can someone please point out my mistakes.

Here are my command line parameters:
(Win 2k3 x64, SQL2005 Enterprise)

"P:SoftwareMicrosoftSQL Server 200564-bitEnterpriseCD1setup.exe" /qn
INSTANCENAME="MSSQLSERVER" ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_FullText,Notification_Services,NS_Engine,NS_Client,SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SDK,SQL_Documentation,SQL_BooksOnline,SQL_Samples,SQL_AdventureWorksSamples,SQL_AdventureWorksDWSamples,SQL_AnalysisServiceSamples,SQL_Samples
PIDKEY=
SAPWD="NT AUTHORITY"
SQLACCOUNT="NT AUTHORITY"
AGTACCOUNT="NT AUTHORITY"
RSACCOUNT="NT AUTHORITY"
SQLBROWSERACCOUNT="NT AUTHORITY"
SQLAUTOSTART=1
AGTAUTOSTART=1
ASAUTOSTART=1
RSAUTOSTART=1

View 2 Replies View Related

Scripting Unattended Install In A Batch-file

Nov 28, 2006

Hi!

I'm trying to do the following in a batch-file:

1) Install SQLExpress unattended providing settings in an .ini-file

2) Run an osql-command which creates a database and some tables etc.

My batch-script looks like the following:

REM Install SQLExpress

start /wait .SQLExpresssetup.exe /qb /settings %CD%mysettings.ini

osql -S (local)MyExpress -U sa -P passwd -i .createdb.sql

...

The problem is that the SQLExpress setup updates the %PATH%, but the change is not visible in my cmd-context . So, the osql-command fails.

It seems like I have to start a new cmd-window from the windows shell to get the updated environment.

Is there any way to make the environment changes visible to my script?

This might be more a sort of general batch-programming topic, but any help is appreciated. :)

Regards,

Sigurd Ringbakken

View 4 Replies View Related

SQL 2005 Unattended Install TCP Port Number

Oct 19, 2007

Hi All,

I am having an issue with SQL 2005 unattended install, I cannot see where in the template.ini file you can specify the TCP port number for SQL 2005 to listen to I want to change it to a specific port number, I know you can do this in an unattended install on SQL 2000.

Also in an unattended install of SQL 2000 and 2005 is there any way you can specify the database and transaction logs location for new databases to be installed on another drive then the system databases. I know you can change this later in SQL server properties but I wanted this to be done during the install or is there a T-SQL script which can do this after?

Any help on this will be great.

Cheers

Raxso

View 3 Replies View Related

Unattended/Silent Install - Enable TCP/IP Property

Mar 15, 2007

I'm able to install SQL 2005 Express using a template.ini, and use the option DISABLENETWORKPROTOCOLS=2 in order to enable TCP/IP. However, I then manually need to open SQL Server Config Manager > SQL Network Config > Protocols for SQL > TCP/IP > "IP Addresses" tab > change all "enabled" options to "yes".

Is there an automated way to do this?

Thanks,

James

View 1 Replies View Related

Sql Server 2005 SP2 Unattended Install For Failover Cluster

Jan 17, 2008



Hello All, I am trying the following script to upgrade SQL Server 2005 SP1 to SP2. I have an Active Passive cluster configuration. I have default instances of SQL Server. I am using the following script.

start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /allinstances /quiet.

The sql server install fails to run. When I used the above command with just

start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /quiet still the summary.txt file came with authentication success and that is all. I changed the above script and did

start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /instancename=instancename of the cluster

This worked, however the install patched the passive node (DB engine, all the cluster unaware components) but failed to patch the DB engine on the Active node. I had to run the SQL Server sp2 install manually but still it did not patch the DB engine on the primary node

1. Can someone please help me with this issue as I want the unattended install to work. so it installs both active and passive node. I will post the final output and also the ADS script to do this as a bonus if this works.

Here is the summary.txt file.

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
msftesql Database Services Service 5152
MSSQLSERVER Database Services Service 4412
ResrcMon.exe Database Services Application SHOMSCSService 4688
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2153
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to modify security permissions on file D:Microsoft SQL ServerMSSQL.1MSSQLData for user sqlservice. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29506


View 1 Replies View Related

Unattended Install Of SSMS/BIDS After SQL Server Express

Dec 19, 2006

Hi,

I'm currently trying to develop an unattended installation of the Client Tools to be distributed to developers workstations.

All is well on 'clean' machines, but the problems arise when an instance of SQL Server Express is already present. The install fails, and the reason isn't clear from the log files.

I know Express installs a couple of the Client Components (like Config Manager), and I believe this is what it blocking me.

Has anyone tried this scenario?

Would I be best to REMOVE the Client_Components first, and then re-install them with SSMS etc.? Or is there a better method?

I have to leave the Express Database instance untouched as I'm not responsible for its installation or maintenance.

Thanks,

Gordon.

View 1 Replies View Related

Unattended SQL 2005 Express Install Enabling Ad Hoc Remote Queries

Jul 6, 2006

Hi there,



I am trying to create an un-attended SQL 2005 Express install. I have successfully made my own template.ini file to install SQL the way I like but I cannot find a way to make it install with the "Ad hox remote queries" option enabled.

Is there anyway to do this? I can't seem to find any switches in the INI file to allow this.

Thanks



Joseph Beckett

View 7 Replies View Related

SQL Server 2005 Unattended Install Bootstrapper Fails On French XP System

Jan 10, 2008

The scenario I have is as follows:

Our product ships with a bootstrapper that installs SQL Server 2005 silently for our clients - basically it's a pre-req which we load for them if it's not already installed.

The bootstrapper supplies the service account identity parameters for the SQL Server install command line in English. It supplies the local system account (NT AUTHORITYSYSTEM).


The problem occurs when we tried to install the product onto a French version of XP. We got the error message "SQL Server setup could not validate the service accounts. Either the service accounts have not been provided for all the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account."


Having read the page http://msdn2.microsoft.com/en-us/library/ms143504.aspx#Localized_service_names we have discovered that the system account identity has a different name for French (AUTORITE NTSYSTEM) along with some other languages ... but we're not sure how to resolve the problem.

Can anyone out there tell me whether we ...
1) Can get the machine being installed on to tell us the local system account identity so we can substitute it into our command line in the bootstrapper?
2) Have to write a different bootstrapper for each language that names the local system account identity differently?
3) Have overlooked some other solution?


Also, does anyone know how many languages and which they are that give the local system account a name that's different to "NT AUTHORITYSYSTEM"??

Thanks,
Sara

<EDIT>

Sorry, omitted a vital bit of information. The bootstrapper is written in C++.
We know the .NET code to retrieve an NT account given a well known SID. Can we do the same in C++ somehow??
</EDIT>

View 3 Replies View Related

Unattended (Silent) Install SQL Server Express How Do I Specify A The Built In System Account???

Aug 15, 2006

When doing a unattended install of Microsoft SQL Server Express, I have a problem specifing the service to installed to be run under the as local system account.

I'm using: SQLACCOUNT & SQLPASSWORD parameters but it just won't work.

As default SQL Server is installed using the NETWORK SERVICE account, this causes the database to be read-only. What I want is to specifiy in the script that the service should run under the LOCAL SYSTEM account instead. This must also be OS-language independent.

I've tried:

SQLACCOUNT=NT AUTHORITYSYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SYSTEM
SQLACCOUNT=NT AUTHORITYLOCAL SERVICE
SQLACCOUNT=SYSTEM

SQLACCOUNT=BUILT-INSYSTEM


etc.

and even some different SID as:

S-1-5-18
S-1-5-19

All with no password with the SQLPASSWORD parameter:

SQLPASSWORD=

I still getting the same error while validating the service account.

Is there someone else who knows what I'm doing wrong?

Best regards,

Mattias

View 5 Replies View Related

Unattended Re-install Of SQL Server 2005 Express Fails To Re-create Database!

May 2, 2008

Hi,

I have a script that performs an unattended installation of SQL Server and works fine.

However, if I un-install via the control panel all the files are removed apart from the databases that are created by me when SQl server was installed. This is good and ensures data is not deleted.

The files left over are in the following directory:
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
and contains:
MyDatabase.mdf
MyDatabase_log.LDF

The problem I have is after performing the re-installtion of SQL server (unattended) I am unable to create a new database with the same name (in this instance called "myDatabase").

The actual files are physically there so this is the reason a new database with the same name cannot be creacted.

Again this is ok again because it ensures I cannot overwrite existing data. However I am unable to re-attach this database to SQl server so I can continue to use it!

The question is:

How do I make this database usable again after an unattended install? Is there a parameter I am missing?

Below are the commands I use that are passed to the installation of SQL Server as command line parameters:

#define SQL_SILENT "-q /passive /norebootchk /qn reboot=ReallySuppress"
#define SQL_USERNAME "username=MyUserName"
#define SQL_COMPANYNAME "companyname=MyCompanyName"
#define SQL_ADDLOCAL "addlocal=ALL"
#define SQL_DISABLENETWORKPROTOCOLS "disablenetworkprotocols=0"
#define SQL_INSTANCENAME "instancename=MSSQLSERVER"
#define SQL_SQLAUTOSTART "SQLAUTOSTART=1"
#define SQL_SECURITYMODE "SECURITYMODE=SQL"
#define SQL_SAPWD "SAPWD=#Password#"
#define SQL_SAVESYSDB "1"
#define SQL_USESYSDB ""
#define SQL_INSTALLSQLDIR ""
#define SQL_INSTALLDATADIR ""

#define SQL_PARAMETERS SQL_SILENT + " " + SQL_USERNAME + " " + SQL_COMPANYNAME + " " + SQL_ADDLOCAL + " " + SQL_DISABLENETWORKPROTOCOLS + " " + SQL_INSTANCENAME + " " + SQL_USESYSDB + " " + SQL_INSTALLSQLDIR + " " + SQL_INSTALLDATADIR + " " + SQL_SAVESYSDB + " " + SQL_SQLAUTOSTART + " " + SQL_SECURITYMODE + " " + SQL_SAPWD


The last four commands I have played around with but for some reason SQL Server service will not start when these are used! (This is a different issue though!).


Any advice would be gratefully accepted.

Thanks

Paul

View 3 Replies View Related

MSDE Won't Install

Mar 22, 2004

I installed MSDE and it would not let me login. I figured that I must have made a mistake when I initially installed the program so I uninstalled it and then tried to reinstall it but now an error comes up and tells me to check the "server error logs" and "setup error logs". I can find these error logs but I have no idea as to what to do with them. I have tried "system restore" but nothing seems to help. I have scowered this forum and have noted that others have had this problem but have yet to find a solution.

Can anyone help???

Thanks,
Jeff

View 3 Replies View Related

Can Not Install MSDE

May 24, 2004

Hi
I have installed .net framework 1.1 and .net web matrix from 'sams teach yourself asp.net' CD. I installed MSDE from the same CD, its not giving any error, but at the end it does not promt to restart the computer, even after restarting I can not see the MSDE icon in the system tray, also I dont see MSDE in the add/remove programs in control panel.I installed sql2kdesksp3.exe from www.asp.net/msde/, but the same thing repeats.

1. Shld I install the sql2kasp3.exe(Analysis services companents) and sql2ksp3.exe(Databasre components) also?

I am new to asp,It will be helpful if somebody can tell me how to install MSDE.

Thanks

View 7 Replies View Related

MSDE Install

Feb 21, 2001

The installation of MSDE always pop up
the error "setup.iss not found" on a
win98 se.

View 1 Replies View Related

MSDE Tries To Install After Log On.

May 1, 2006

After upgrading MSDE 7 to MSDE 2000, when you log on to the server, it keeps trying to install. I have looked for the InProgress registry key, but it is not there.

Any Ideas?

Thanks

View 1 Replies View Related

Can't Install MSDE

Jul 23, 2005

I have tried to install MSDE 2000, first the normal version, then theone for developers using Visual Studio .NET. Each time the installationappears to complete, but there is no shortcut to start the program andit's not in the Start/Programs menu. However, if I look for it in "Addand Remove Programs" it's there.The directoryC:Program FilesMicrosoft SQL ServerMSSQLBinnincludes some exe files and I have tried to start them, but nothingappears to happen. If I start sqlsrvr.exe I get a command prompt windowin which I see things like "Server Process ID is 182", "Logging SQLserver messages in file..." etc, but I have no idea how to go on fromthere.I tried installing the new 2005 Beta version but exactly the sameproblem.Why is this happening? How can I make it work?Thanks in advance.Bruno Panetta

View 4 Replies View Related

MSDE Install Problem

Dec 18, 2003

I have installed MSDE from the command prompt as instructed and get no error message - nor do I get the expected request to reboot. Since I know I must reboot to see MSDE launch, I did so, but it does not launch. It doesn't matter how many times I do this... Any ideas? I am attempting to do this on an XP machine with more than the requirements for doing so. Any help would be MOST APPRECIATED.

thanks
JSearcy

View 1 Replies View Related

MSDE Install On VS.NET 2003

Dec 18, 2003

I am trying to install MSDE according to:

http://www.siue.edu/~dbock/cmis460/msde.htm

But it says I need to go to control panel to install components, but it is not listed on the VS.NET 2003 install.

In VS.NET 2002 it worked fine as per instructions, but now i can't seem to get it to work in VS.nET 2003

View 2 Replies View Related

Unable To Install MSDE

Dec 28, 2003

Hi All,

I hope you can help.

I am reading SAMS Teach Yourself ASP.NET and have loaded the WEB Matrix and have been going through the exercises.

I have now tried to load MSDE and my first attempt seemed to load it correctly

C:sql2ksp3MSDE> setup SAPWD=****** SecurityMode=SQL

The Icon appeared in my task bar and I carried on with the Exercises.

My problem started when I tried to create my first data base.

Open Web Matrix
Clicked on Data Tab in the Workspace pane
Clicked on the new Connection Icon
Server = LocaHost
Clicked SQL Server authentication
User Name = sa
Password = ***** (As above)

However when I click on the "Create a new data base" link I get an Error

login failed for user 'sa'. Reason: Not associated with a trusted sql server connection.

I tried to look in the forum to see if I could find a reason however could not.

Decided in the end to uninstall using Start - Control panel - add & remove programs.

However now when I try and reinstall the installation fails.

Can any one help


Best wishes.


James.

View 5 Replies View Related

Problems Trying To Install MSDE

Apr 28, 2004

Hello,

I've been trying to install MSDE and I keep getting errors. The first time I ran set up command, I got an error saying the insntace name was invalid. I was using "SETUP SAPWD=[pass] SECURITYMODE=SQL" and it didn't work.

Then I uninstalled the whole thing and added the line "INSTANCE NAME=[something]" to the SETUP command, and MSDE installed "properly". But then when I clicked on the icon on the task bar to make the service active, I got an error message saying that no service could be associated to the MSDE.

Then I, again, I uninstalled the whole thing and tried to install it again. Now I'm getting the following error "Setup failed to configure the server. Refer to the server error logs and set up error logs for more information." Now, the funny thing is that when I go to "remove programs" I cannot even see the damn MSDE to uninstall it. I don't know what to do at this point: set up does't run and can't get rid of it.

PLEASE HELP!!!

View 1 Replies View Related

Failed Install Of MSDE

May 27, 2004

Hi, folks.

I have been trying to install sql2kdesksp3 and am running into some problems. The initial install seems to go okay, even up to the point of issuing the Setup sapwd=password command-line command. However, when I try to install sql2kasp3 or sql2ksp3, a message appears saying that SQL 2000 is not installed.

I am on a XPPro SP1 desktop, with IIS 5.1 and .NET 1.1 Framework installed. Can anybody point me in the right direction to get MSDE installed?

TIA,

Bob

View 4 Replies View Related

MSDE: Can I Install Onto My D: Drive?

Oct 7, 2004

When I ran the install for MSDE, it installed the DB server and the databases onto my C: drive and under program files...

The instructions I followed were listed here:

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

I'd like to be able to install it to my D: drive. I've looked through all of the docs but I can't find any information on how to change the install path. Would anyone know how to do this?



Thanks,

LD.....

View 2 Replies View Related

MSDE Hangs On Install

Jan 12, 2005

First off, let me say it took me nearly all day to get this working. When you download the sql2decksp3.exe you might think it install like any other program. No. This exe simply unpacks the setup files. The actual setup program, setup.exe must be run from a DOS command prompt.... so you've got to look up the correct command line parameters in the sp3reademe.htm file. Something like:

setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"

No problem so far, but then when I go to run the setup.exe with the correct parameters the install goes fine until the last 5 seconds. Then hangs. Again and again. The install program keep getting hung up just before the finish. Each time I had to uninstall and reinstall-- 6 times. When if it hangs you've got to break out with the Task Manager, then do an uninstall from the Control Panel... if... an entry there was created. It usually is.

I tried everything I could think of and then did a search here. There were a few messages. The only one who actually got past this problem said he deleted all references for "Microsoft SQL" in the registry. I tried that too. It didn't work for me. That setup hung in the very same place. Then instead of breaking out and starting again, I tried shutting the machine down, while the setup was hung, thinking that maybe after a restart the installation might continue AND and that point the install completed.

Hope these notes help the next person who runs into the same problem. I also tried putting the modem on standby and disabling Norton anti-virus. Alone that did help, but when I tried all this stuff together... finally at 4:34 PM, I was able to establish a connection, from both VB.NET and with a great FREE MS SQL Manager at http://sqlmanager.net/products/mssql/manager/download

Now I can start. For some reason, the way I think... I can't do any coding until the entire database spec is first set up. Then you write all the add, edit, display and sort form, windows. When designing web applications, you design the database first, then each web form preforms some unique operation or reference on the remote database. I think that's the way it works.

Hey! Hope this helps others.

Paul Townsend

View 1 Replies View Related

Can You Reverse A MSDE Install Over SQL 6.5?

May 23, 2000

I have a friend who has installed MSDE over SQL Server 6.5 - by doing so he broke some other apps that required a SQL 6.5 DB, he realises now it was a mistake on his part and would like to revert to SQL 6.5 again and recover his data, is this possible or has he lost all his old data?

BTW Backups weren't completed....

If anyone can help please let me know.

View 1 Replies View Related

MSDE Install In Win XP Fails

Nov 10, 2002

I was trying to install the MSDE 2000 from the Office XP CD in Windows XP Pro. In the middle of the installation, it rolls back, does not give any message and the installation fails. :confused: What could be the problem? Please help me with this

I am trying to build a VB6.0 application with the msde as back end

Thank you

View 1 Replies View Related

SQL Srv MSDE - Not Connected Aft Install

Oct 14, 2004

I have just installed Windows 2000 Pro, Visual Studio 2003 Academic and , MSDE 2000. I get the little icon in the Service Tray(?) showing an empty circle partially overlaying a server symbol. It says Not Connected-VSDOTNET.
If I click it and get SQL Server Service Manager and put in Server name of VSDOTNET, The drop down listbox for SERVICES is empty (no SQL Server choice)
I enabled TCP/IP for this server thru SVRNETCN.DLL. I'm a newbie to pc development. Help!

View 1 Replies View Related

MSDE Install Tangle

Nov 13, 2004

I have to yet successfully install MSDE on my machine. I suspect there is installation lint from previous attempts, however for the life of me I can't seem to get it running.

Attached is my log file from the latest attempt. I am really stumped.
Any help will be greatly appreciated.

Mike

View 1 Replies View Related

MSDE Sp3 Install Problems

Mar 22, 2004

I recently had to install 40 german NT 4 laptops with MSDE sp3.

I prepared a setup.ini file:
[Options]
DATADIR="C:ProgrammeMicrosoft SQL Server"
TARGETDIR="C:ProgrammeMicrosoft SQL Server"
SAPWD="AStrongPwd"
SECURITYMODE=SQL

and installed most of them sucessfully. Some of them I installed via network, some of them were installed from CD. I tested each installation by copying a prepared database into the data directory and tried to connect to this database using the specified sapwd and found out
When i installed from CD, I could connect to the databases.
Some of the network installs produce a logon failure. it looks like the sapwd was ignored during install - I could not figure out, which password was used, I uninstalled it and reinstalled from CD.

Does anyone know what's the reason for this behaviour?

Thanks,

clothilde

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved