[MSDE] Silent Install, Not Associated With Trusted....

May 24, 2002

Hi all,

After doing a silent install of the MSDE, my application cannot access the database that is loaded on the local machine -

I am getting an error stating - 'login failed for user 'sa'. Reason: Not associated witha trusted SQL server connection'

Is there are parameter or something that i need to change in my UDL??

or is there a way to tell the server to work in non-trusted inviroment via the OSQL program???

thanks
tony

View 1 Replies


ADVERTISEMENT

Silent Install Of Sql Server CE

May 29, 2007

I have a desktop application in which I use Sql Server CE.

It all works well on my development machine.

It also works on other machines if I copy the sql dll files in the same path as the .exe

I'm trying to avoid all kinds of user interaction. They don't need to know that I'm about to install Sql Server CE really

So I'm hoping to avoid writing in the manual that the user should install SQLServerCE31-EN.msi, which I think is the correct install package.



So my question is: How do you silently/unattended install Sql Server CE on the desktop?

View 1 Replies View Related

Silent Install Using VBScript

Mar 19, 2007

Hi,

how do Silent Installation with VBscript ? because I have some step for user interactive.

please anyone put an example about this or put a link to.

thank you very much.

View 6 Replies View Related

When Try To Install SQLEXP32.EXE Silent And Have The Log Files?

Feb 22, 2008

Try to install SQL server Express
download from Microsoft site SQLEXP32.EXE version 9.0.3042.0
Expand this file using command line install "start /wait setup.exe /qn ADDLOCAL=All LOGNAME="c: empInst_SQLEXP.cab"

at installed computer just have C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGsummary.txt

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Feb 22 10:58:50 2008

and C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DC7660_TEST2_Core.log

Microsoft SQL Server 2005 Setup beginning at Fri Feb 22 10:58:50 2008
Process ID : 3884
C: empSQLEXPsetup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2008/1/22 10:58:50
Complete: LoadResourcesAction at: 2008/1/22 10:58:50, returned true
Running: ParseBootstrapOptionsAction at: 2008/1/22 10:58:50
Loaded DLL:C: empSQLEXPxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2008/1/22 10:58:50, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "3884"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2008/1/22 10:58:50
Complete: ValidateWinNTAction at: 2008/1/22 10:58:50, returned true
Running: ValidateMinOSAction at: 2008/1/22 10:58:50
Complete: ValidateMinOSAction at: 2008/1/22 10:58:50, returned true
Running: PerformSCCAction at: 2008/1/22 10:58:50
Complete: PerformSCCAction at: 2008/1/22 10:58:50, returned true
Running: ActivateLoggingAction at: 2008/1/22 10:58:50
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00DBCFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.


have a Unexpect error?
any advice welcome.

View 1 Replies View Related

Silent Install With SQL Server 2005 SP2

Aug 25, 2007

I can't get SQL Server 2005 to update to SP2 in either silent or unattended mode. None of the standard switches work. I've used -s, -m, /q, /qb, and /qn all with no favorable result. I am still prompted for user input at every screen. Suprisingly I've had no such problems with the express edition, just the server itself. Is there a way to make this thing work? Here is the line I've been feeding to the installer.

"<SERVER_PATH>SQL Serversql2005SP2.exe" start /wait setup.exe /qb /settings "C:SQLSettings.ini" /L*v "C:SQLInstall.log" /norestart

I have also tried the following since it looks like the file that is unpacked by the SP2 install is actually hotfix.exe

"<SERVER_PATH>SQL Serversql2005SP2.exe" start /wait hotfix.exe /qb /settings "C:SQLSettings.ini" /L*v "C:SQLInstall.log" /norestart

I also have tried the following generics:

"<SERVER_PATH>SQL Serversql2005SP2.exe" -s

"<SERVER_PATH>SQL Serversql2005SP2.exe" -m

"<SERVER_PATH>SQL Serversql2005SP2.exe" /q

View 3 Replies View Related

Silent Install With Fixed Tcp Port

Sep 12, 2007

Hi,

I'm doing a silent install of SQLServer Express 2005 as explained in http://msdn2.microsoft.com/en-us/library/ms144259.aspx .

I am setting DISABLENETWORKPROTOCOLS=2 because I want to enable TCP/IP protocol at install time.

However it seems that per default SQLServer is configured to use dynamic TCP/IP ports, forcing me to contact the SQLBrowser.

How can I switch to a fixed port, say 1433, at install time?

Thanks, in advance,
Dirk.

View 11 Replies View Related

SqlExpress &&amp; Silent Install As A Prereq???

May 18, 2007

I'm still doing some research but I thought I'd slap a quick post up here anyway. I'm trying to create a small 'setup and deployment' project in studio 2005 that includes a prerequisite (sqlexpress). The one thing I've noticed is that there is not an option to install this silently by providing the executable with the appropriate switches. I could easily write my own small utility to do the work or I could use a third-party component like NSIS, however, I'm quite simply amazed that this feature was left out of studio 2005. It's quite possible I'm missing something...any feedback is appreciated 100 times over!



Thanks



Corey

View 3 Replies View Related

Silent Install New SQL Express Instance Via MSI

Aug 4, 2006

I'm currently building an MSI to install SQL Express and want to install as a new instance, not the default instance, and not into the SQLEXPRESS instance either.

I saw the package.xml for Express in my VS Studio install. How would I go about using this? Or would I have to modify the MSI via Orca or something? I hope not. Wouldn't have a clue where to start.

In short, regardless if there is already an SQL Express instance on the machine or not, I need to silently install a fresh new instance of the server engine only, no client tools except sqlcmd.exe

I have seen that MS would advise that everyone use the SQLEXPRESS instance but I don't agree with it. I don't want other application installs trampling over my server settings and I don't want to trample over others. For example, expose others to TCPIP and CLR when they don't need it, and conversely others swithing them off in a shared server instance when I do need them.

View 7 Replies View Related

Silent SQL SE 2005 Install Headaches...

Aug 17, 2006

Yet another roadblock: Does the standard SQL SE 2005 not install any of the query commands? (isql, isqlw, or osql.exe's). I could have sworn that they were, but every time I go to test the install on my VM none of them are ever installed. If it doesn't is it included in the advanced version of it (which I'd really rather not do)? If still no what's the easiest option I still have open? Can I have my app connect to the master db and run a restore script from the app? I've been arm wrestling with this install for over a week and it's just about brow-beaten me completely.

TIA,

Jayyde

View 3 Replies View Related

SQL2005 Silent Install Collation Options?

May 26, 2008



I am setting up a template.ini for my SQL2005 installs. The documentation on the INI file is great up until the "SQLCOLLATION" section.

How do I choose the SQL Collation: "Dictionary order, case-insensitive, uppercase preference, for use with 1250 Character Set" ?

SQLCOLLATION=???????

View 1 Replies View Related

SQL 2005 Express SP2 Silent Install Fails

May 16, 2007

Hello,
I'm using the latest version of SQLEXPR32.EXE found here :
http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&DisplayLang=en

Here is the command line that fails :

"sqlexpr32.exe -q /norebootchk /qn reboot=ReallySuppress
INSTANCENAME=MYINSTANCE SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"

Interrestingly, when the following command line is used to launch the setup,
it completes successfully :

"sqlexpr32.exe /norebootchk reboot=ReallySuppress INSTANCENAME=MYINSTANCE
SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"

The only difference between the two is the quiet switches used in the first
case : "-q" and "/qn"

After spending some time to understand what is going wrong, it seems that in
quied mode, Setup Prerequisite 'SQL Native Client' is not installed. Then
the remaining part of the setup fails because of this.

Any help appreciated.

View 7 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

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

Replacing A Cluster Node: SQL Silent Install Setup Installshield Error

Sep 10, 2007

Can anyone tell me how to get around this? Installing SQL- no issues, just when applying the sp



I have tried numerous things, including rebuilding the 2nd node again



Trying to install a service pack on SQL 2000 node, and Install shield keeps returning this error, .



[InstallShield Silent]
Version=v5.00.000
File=Log File
[ResponseResult]
ResultCode=-8



I have reset temp directories on both nodes,

I have made user permissions and profiles exist

I have copied install files to both local and remote locations


I know the response €“ Installshield cannot find the silent response file, but SQL setup creates this on its own.
Short of bringing this production system down and re-installing on both nodes ( I did test this on a non-prod box by the way, no issues), I am at a loss

View 1 Replies View Related

Installing SQL Server 2005 Express Via Command Prompt (silent / Basic GUI Install)

Feb 20, 2008

Hi,

I would be very grateful if someone could take a look at my command line install and offer advice on if I am doing it correctly.

The reason I am asking is because I cannot seem to get the server installed without having errors during the installation:
"The SQL Server (MSSQLSERVER) service terminated with service-specific error 17113 (0x42D9)"

Looking at the server error log indicates that master.mdf was not in the data directory (I have however specified a different data directory for ease of backup by our software and this is created during the install but does not have this database in the data directory - it is however in the template data directory!

I also get this error when the SQL Server service is started:
"The SQL Server (SQLEXPRESS) service terminated with service-specific error 3417 (0xD59)."


All advice is welcome. Please see below my batch file. Also, if you think I should do this in a different way then please let me know. I basically want to install SQL server on a customer computer and automate the install so the custoemr does not need to enter any information.

The goal of this install is:
[1] Deply a custom .Net application and SQL server at the same time on the same computer without user input.
[2] Allow remote .Net applications (designed by myself also) to connect over a LAN (and later maybe over a WAN) to the database to the above database.

The command line is this (I have also included the batch file I am usign below). For ease of reading I have put the parameters on a new line below:

setup.exe /qb
username="CustomerUsername"
companyname="OurCompany"
addlocal="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
disablenetworkprotocols="0"
instancename="MSSQLSERVER"
INSTALLSQLDATADIR="c:SqlData"
USESYSDB="c:SqlData"
SAVESYSDB="1"
SQLAUTOSTART="1"
SECURITYMODE="SQL"
SAPWD="#StrongPaSSword#"



======= Batch file Start ======

SET MODE=/qb
SET SETUP_EXE=sqlfilessetup.exe %MODE%
SET SQLDATADIR=c:SqlData


SET SET_USERNAME=username="CustomerUsername"
SET SET_COMPANYNAME=companyname="OurCompany"
SET SET_ADDLOCAL=addlocal="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
SET SET_DISABLENETWORKPROTOCOLS=disablenetworkprotocols="0"
SET SET_INSTANCENAME=instancename="MSSQLSERVER"

SET SET_INSTALLSQLDATADIR=INSTALLSQLDATADIR="%SQLDATADIR%"

SET SET_SAVESYSDB=SAVESYSDB="1"
SET SET_USESYSDB=USESYSDB="%SQLDATADIR%"

SET SET_SQLAUTOSTART=SQLAUTOSTART="1"
SET SET_SECURITYMODE=SECURITYMODE="SQL"

@REM === RE-INSTALL PARAMS - NOT CURRENTLY BEING USED?? SHOULD I ADD THESE ALSO? ===
SET SET_REINSTALLMODE=REINSTALLMODE="omus"
SET SET_REINSTALL=REINSTALL="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
SET SET_REBUILDDATABASE=REBUILDDATABASE="1"

SET SET_SAPWD=SAPWD="#StrongPaSSword#"


@REM === START THE SETUP / RE-INSTALL ===

START %SETUP_EXE% %SET_USERNAME% %SET_COMPANYNAME% %SET_ADDLOCAL% %SET_DISABLENETWORKPROTOCOLS% %SET_INSTANCENAME% %SET_INSTALLSQLDATADIR% %SET_USESYSDB% %SET_SAVESYSDB% %SET_SQLAUTOSTART% %SET_SECURITYMODE% %SET_SAPWD%

======= Batch file End ======


Your advice is kindly welcome.

Thank you

Kind regards

Paul

View 2 Replies View Related

Configuring SQL Express During Installation And Attaching Smart Client DB / Silent Install For One Click?

Oct 9, 2006



Hey all,

Cool place! Has anyone deployed SQL Express silently using one click and an attached a smart client DB from within the app ... would love to see some of the best practices or horror stories! Just kidding... :) I'm about to deploy a smart client using SQL Express and could use some tips from someone who has been there.

Thanks in advance,

Bill

View 7 Replies View Related

Apparent BUG With SQL Server 2005 Express Silent Install /qb Command Line ( SQLEXPR.EXE/qb ) And Displaying Errors.

Dec 12, 2005

I am using installshield to distribute SQL Server 2005 Express. I have the SQLEXPR.EXE file and I want to run it in /qb mode so the user can see the pretty dialogs pop up but not have to click anything.

View 6 Replies View Related

Install SQL Server 2005 Express - The Certificate Chain Was Issued By An Authority That Is Not Trusted

Sep 6, 2006

Hi
I am trying to install SQL Server 2005 Express on my machine, which has Windows Server 2003 with Service Pack 1. I could not able to install properly and i am getting error always.
Here is the Error I am getting always "The certificate chain was issued by an authority that is not trusted" . I am trying for past few days i could not able to resolve.

Please help
Thanks
Here is the Error message from Summary.txt

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 1 (Build 3790)
Time : Tue Sep 05 12:31:18 2006

--------------------------------------------------------------------------------
Machine : SERVIDORCC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Archivos de programaMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_SERVIDORCC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Sep 05 17:12:41 2006

View 1 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







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