I am trying to install the professional edition of SQL Server 2005 on a new PC with xp pro. I have tried several times with several options but the installation is stalled with the error message that "The drop location is missing file(s) that allow setup to determine how a multi instance product should be installed. Setup cannot continue, please repair the drop and try again."
Does anyone know what the probelm is and how to fix this?
Below is the error message receive when installing SQL 2005 (x64) enterprise edition.
Failed to install and configure assemblies c:Program Files (x86)Microsoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501 Error description: The transaction has aborted
Has someone seen this before? Any pointer is appreciated. Thanks.
am trying to install sql 2005 with cluster option in win 2003 R2 servers and keep getting sql database setup failed error.Summary log show that it failed with error number 67. It doesn't even create a SQLSetup0004_M2MTPONE_SQL.log file. core log shows
Complete: DetectLocalBootstrapAction at: 2006/5/1 18:15:31, returned true Running: LaunchLocalBootstrapAction at: 2006/5/1 18:15:31 Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 67 Aborting queue processing as nested installer has completed Message pump returning: 67
We have two machines in running enterprises version of R2 in a cluster. I tried running the setup from both machines and got the same error.
I am trying to find a solution for more than week but no luck. Any help is appreciated.
thanks - Kailash
Part of Summary log: --------------------------------------------------------------------------------
Machine : M2MTPONE Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_M2MTPONE_BackwardsCompat_1.log --------------------------------------------------------------------------------
I am facing a problem while installing Sql server 2005 Developer edition on Windows XP Professional SP 2 , It says Cannot install native client use correct SQLCLNI.msi file and Native client installation fails also the set up for client tools fails.
I'm installing SQL 2005 Developer Edition, instalation always fails with the error "Could not find a package to install on the installation media". The summary.txt is pasted bellow:
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Mon Nov 05 10:47:30 2007
IA-PJPATRICIO : Could not find a package to install on the installation media.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
I have an instance of SQL 2000 installed on the same machine, i'm trying to install Analises Services 2005 only, but instalation fails with any of the SQL Server 2005 components.
When I try to install SQL Server 2005 evaluation edition, I keep getting the message that SQL server setup has detected beta components of SQL Server 2005 or Visual Studio 2005 which must be uninstalled for setup to continue. I have removed all beta components like sql 2005 ctp, visual studio 2005 beta, etc from my computer and yet it keeps giving me this message.
PLease help!!!! I am unable to install SQL Server 2005 evaluation edition.
I have installed SBS 2003 Premium with Exchange 2003 SP1 and now I want to install SQL server 2005 workgroup edition.
Heres what I noticed during setup, following the steps of the Server 2005 Workgroup Edition instructions, starting with Upgrading the Sharepoint instance of WMSDE.
Preparing the http://companyweb website: Step 4. I should make a backup of the data directory within program filesMicrosoft SQL ServerMSSQL$SHAREPOINT directory. However there is no data-directory there, so nothing to backup there. This is probably the reason for all the rest of the issues, however what does it mean, why is there no such directory present? I checked before doing the sql install that by going to http://companyweb I did indeed land on the sharepoint internal website.
Rest goes all normal, until : Attaching the databasefiles to the new SHAREPOINT instance of SQL server 2005.
Step 4.: go to MSSQL$SHAREPOINTdata. Not only is there no such subdirectory now, the whole MSSQL$SHAREPOINT directory has in fact now disappeared. So steps 4 till 6 cannot be performed now.
Then further to Enable full text search in Windows Sharepoint services Step 2. Remark: I get the error message as described there, however the solution would be to start the SQL server (Shareoint service. However that service is up and running
Furthermore when I go to http://companyweb now, I also get the errormessage indicating no connection can be established with the configuration database.
When I check for services, I find that the whole MSSQL$SHAREPOINT service has disappeared from the list of services.
I run setup using GUI. It upgrades all components of the existing installation w/out any problems except the last component. That is, it proceeds with the installation of SQL Server Database Serices and at the end fails to shut down the SQL Server and aborts the installation reporting the following:
"Service 'Computer_NameSQLEXPRESS' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386)".
I am running Windows XP SP2 with both .NET 2.0 and .NET 3.0 installed on it. I am logged in as a system administrator.
The most puzzling to me things are:
- the setup starts AND STOPS w/out any problems SQL Server Reporting Services and SQL Server VSS Writer (thus finding enough privileges for both).
- the setup starts the SQL Server w/out any problems (thus it finds enough privileges to START A SYSTEM SERVICE) and then fails as described above 'lucking privileges".
During installation before failing the setup displays following:
"Run as Normal User. RANU instance Shutdwon in progress: MSSQL$SQLEXPRESS". The "normal user" puzzles me too, unless the SQL Server itself is meant here.
Any suggestions would be appreciated. I can provide the installation log file as well.
When i installing SQL Server in my server then i recieve this massege can any one help me regarding :
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files".
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40xea75
We have successfully been using MSCS with MSSQL7 (SP1) running under NT4 EE (SP6a), installed in an active/active configuration using, two DELL PowerEdge 6350 machines. Recently I installed MSSQL7 (SP2), I followed the instructions that came with SP2, and unclustered the SQL nodes using the Failover Cluster Wizard, and installed SP2, this was uneventful, and appeared to install correctly. Next I tried to recluster the SQL nodes using the Failover Cluster Wizard as directed. This failed with: "Could not run setup on remote machine. SQL Cluster Setup failed." So I began the usual research using the usual resources, and have found articles that discusses this error, and the things to look for when it happens. I have exhausted all suggestions without success. I appear to have everything correctly configured. I have enabled Cluster Logging (level 3), following are the two things I have found that indicate something is wrong:
1. In the SQL Error Log the following gets logged when I run the wizard: "Attempting to initialize Distributed Transaction Coordinator." "Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE"
2. In the Cluster Log I see the following message repeatedly: "[ClRtlCopySecurityDescriptor] MakeSelfRelativeSD failed, 0x00000551"
3. In the sqlclstr.log I see the following, without an indication of which file is missing: "[reghelp.h:235] : 2 (0x2): The system cannot find the file specified." "[clushelp.cpp:166] : 259 (0x103): No more data is available." "[validate.cpp:147] DeleteTestGroup:OpenClusterResource: 5007 (0x138f): The cluster resource could not be found." "~~~ XXX InstallRemote failed"
Does anyone have any ideas about what could be causing this problem? Many thanks in advance.
I've got SQL Server 2014 Developer installed, and working.  After rebooting, the event log looks like it's working fine.  However, ever since I uninstalled Visual Studio 2013 Premier and installed Visual Studio 2015 Professional, both with SQL Server Data Tools, whenever I try to start SQL Server 2014 Management Studio, I get "Cannot find one or more components. Please reinstall the application."Is there any way I can avoid uninstalling SQL Server?
I managed to solve this, based on a recommendation (at URL...).  I ran SQL Server's setup.exe, and chose Repair, and now it appears that all is well.
In my string below, my forum setup up file, setup.asp , when run delivers an error that it is unable to connect to the database. Error: 800004005
I am running this from within IIS 5.0 aon a Windows 2000 Server, by right clicking the file in IIS and choosing "browse" I am trying to set this up so user IUSR_SERVER_NAME can "read and Write" to the database or instance I have created called rpggamerpro. The authentication in the SSSAC is set to use both Windows and SQL Authentication for the "master". I have set permissions on the folder which contains the SQL 2005 Express installation and database for IUSR_SERVER_NAME to read/write. I have created a IUSR_SERVER_NAME user in the Security/User directory for the database or instance "rpggamerpro" and gave the user read/write permissions there. So I am still at a loss as to what permissions, strings, settings, configuration or whatever the heck else needs to be done in order to get this thing to work. Please anyone willing to help a realative new commer to the SQL and DB world would be greatly appreciated.
trConnString = "Provider=SQLOLEDB;Data Source=nssqlexpress;database=rpggamerpro;uid=IUSR_NS;pwd=;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
I'll install SQL Server Express SP2 on Vista during my Setup. But the setup beaks with error 110. In other articles it sounds like an folder access problem. On a Custom Action Type 210 i start a application which execute the sqlexpress.exe. I tried some other codes to impersonate or noImersonate but without success.
But i can not use the unpacked files because size is to large(170MB)
An good Idea would be unpack the setup files during setup to an custom folder with right permissions. But I dont know how unpack files without GUI (SQLEXPRESS x always show the GUI).
Hi We have a problem installing SQL Express Edition SP1 on Vista. The installation stops during installation of setup support files with the following message:
Errors occurred during the installation:Error 2 installing Microsoft SQL Server 2005 Setup Support Files. See log file for more detailed information.Det går inte att hitta filen. (translated: File not found) The log file points to the support.log file with the following content:
=== Verbose logging started: 2007-03-13 17:34:23 Build type: SHIP UNICODE 4.00.6000.00 Calling process: C:cd nät40..SQLEXPRSetup.exe ===MSI (c) (C4:F4) [17:34:23:450]: Resetting cached policy valuesMSI (c) (C4:F4) [17:34:23:450]: Machine policy value 'Debug' is 0MSI (c) (C4:F4) [17:34:23:450]: ******* RunEngine: ******* Product: C:cd nät40..SQLEXPRSetupSqlSupport.msi ******* Action: ******* CommandLine: **********MSI (c) (C4:F4) [17:34:23:450]: Client-side and UI is none or basic: Running entire install on the server.MSI (c) (C4:F4) [17:34:23:450]: Grabbed execution mutex.MSI (c) (C4:F4) [17:34:23:591]: Cloaking enabled.MSI (c) (C4:F4) [17:34:23:591]: Attempting to enable all disabled privileges before calling Install on ServerMSI (c) (C4:F4) [17:34:23:607]: Incrementing counter to disable shutdown. Counter after increment: 0MSI (s) (00:10) [17:34:23:622]: Grabbed execution mutex.MSI (s) (00:1C) [17:34:23:622]: Resetting cached policy valuesMSI (s) (00:1C) [17:34:23:622]: Machine policy value 'Debug' is 0MSI (s) (00:1C) [17:34:23:622]: ******* RunEngine: ******* Product: C:cd nät40..SQLEXPRSetupSqlSupport.msi ******* Action: ******* CommandLine: **********MSI (s) (00:1C) [17:34:23:622]: Machine policy value 'DisableUserInstalls' is 0MSI (s) (00:1C) [17:34:23:669]: SRSetRestorePoint skipped for this transaction.MSI (s) (00:1C) [17:34:23:669]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionPoliciesExplorer 3: 2 MSI (s) (00:1C) [17:34:23:669]: Note: 1: 1324 2: .. 3: 1 MSI (s) (00:1C) [17:34:23:669]: MainEngineThread is returning 2MSI (s) (00:10) [17:34:23:669]: No System Restore sequence number for this installation.MSI (c) (C4:F4) [17:34:23:669]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1MSI (c) (C4:F4) [17:34:23:669]: MainEngineThread is returning 2=== Verbose logging stopped: 2007-03-13 17:34:23 === The funny thing here is that it works fine when the installer is run from a network share, ie \testserversetupsetup.exe but when the same folder is burned to a CD or copied to a local folder it fails. I have verified that the folders are identical.
I'm not sure what info is required to pinpoint the problem but here are some log files and a screen shot of the message.
Any help or pointers would be greatly appreciated.
I just upgraded ACT database and it needs SQL Server. I just keep getting "SQL Server Setup Failed". I downloaded SQL from Microsoft, went to install and get the same error. It then refers to a summary txt log which I have had a look at but to be quite honest means nothing to me.
Hi all, I had to uninstall SQL2005 Service, client-tools & BI studio applications on my laptop running XP SP-2. Now, I'm trying a fresh install, a simple install of >>just<< the 2005 DB service is failing. Snippet of log file------------------------- MSI (s) (F8:80) [22:35:02:484]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (F8:80) [22:35:02:484]: Warning: Local cached package 'C:WINDOWSInstaller4c483c.msi' is missing. Snippet of log file-------------------------
CSetupBootstrapWizard returned 1 <EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'> Failed to find help file for LCID :3081 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2006/10/8 22:18:10, returned true Running: SetPackageInstallStateAction at: 2006/10/8 22:18:10 Complete: SetPackageInstallStateAction at: 2006/10/8 22:18:12, returned true Running: DeterminePackageTransformsAction at: 2006/10/8 22:18:12 Complete: DeterminePackageTransformsAction at: 2006/10/8 22:18:25, returned true Running: ValidateSetupPropertiesAction at: 2006/10/8 22:18:25 Complete: ValidateSetupPropertiesAction at: 2006/10/8 22:18:25, returned true Running: OpenPipeAction at: 2006/10/8 22:18:25 Complete: OpenPipeAction at: 2006/10/8 22:18:25, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2006/10/8 22:18:25 Complete: CreatePipeAction at: 2006/10/8 22:18:25, returned false Error: Action "CreatePipeAction" failed during execution. Action "RunRemoteSetupAction" will be skipped due to the following restrictions: Condition "Action: CreatePipeAction has finished and passed." returned false.
The OWC11 setup failure is triggerring SQL DB Service installation to fail as well. Please help!!!
I currently have a SQL Server cluster setup with a Primary DB Server SERVER1 and the Standby server SERVER2. SERVER1 has been failing more than normal is the past few weeks and its takes upto 5 mins for SERVER2 realize that SERVER1 is down. I am looking for a better way to implement a backup server on production with minimum downtime. Please adivse..
I am having the same problem as Michael, with the exception that my laptop is running windows XP SP2.
BUT when I look at the SETUP LOG FILE there is NOTHING in it. This is what I get:
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Tue Apr 03 19:36:54 2007
(LAPTOP NAME HERE) : Unknown article Result.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Am running vista premium and am trying to complete the installation of Office 2007 Professional (disc 2) and keep getting an error message that SQL Service 2005 (Express) cannot install. Logfile below:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Home Edition (Build 6000) Time : Sun Mar 04 15:25:13 2007
Machine : MICHAELTODD-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : SQL Server Database Services Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : SQL Server Database Services Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. Error Number : 29513 --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
I am trying to upgrade SQL Server Express 2005 Report Server to SQL 2005 Standard and it fails with the following error:
SQL Server Setup did not have the administrator permissions required to copy a file: C:Program FilesMicrosoft SQL ServerMSSQL.8Reporting ServicesReportServer ssrvpolicy.config. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
After I click OK on the message, this whole path where the upgrade is bieng installed dissapears C:Program FilesMicrosoft SQL ServerMSSQL.8Reporting Services. The error is a bit missleading because the file that it is trying to copy rssrvpolicy.config does appear in that upgrade folder so I am not sure why it would try to copy a file that has already been copied.
I was able to upgrade the Database Engine instance fine but can't upgrade Reporting Services due to that error. I have verified that the account that ran the setup had the administrator permissions. Your prompt reply to my question would be greatly appreciatted.
HI, My computer keeps trying to download SQL Server 2005 Express Edition SP2 and fails with the error code 0x2B22. It is a new computer running with Windows XP Pro.
I have spent hours searching the forums and the internet, but I can't find anything to help, or I don't understand the solutions or whether they relate to my computer. I don't know how to find out why the update is failing either.
I am trying to upgrade SQL Server 2005 Express to SQL Server 2005 Enterprise Edition. (As a Preparation to install SQLServer2005 Service Pack 2 (CTP))
I tried to upgrade a particular Instance (OFFICESERVERS, which was based on SQL Server 2005 Express ).
During the upgrade I get a message saying that ...
.....Your upgrade is blocked because of edition upgrade rules.....
All other components I selected for Installation are propertly installed (Analysis, Reporting)
The setup log contains the following detail information:
---- Context ----------------------------------------------- Setting status of unmanaged components and removing unmanaged resources
Error Code: 29543 MSI (s) (DC!C8) [13:57:26:265]: Product: Microsoft SQL Server 2005 -- Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Edition check: Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. Edition check: Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='0'> Doing Action: ValidateUpgrade PerfTime Start: ValidateUpgrade : Fri Dec 29 13:57:26 2006 <Func Name='ValidateUpgrade'> <Func Name='updateFeatureSellection'> Error Code: 0x80077367 (29543) Windows Error Text: Source File Name: sqlcaupgradeproduct.cpp Compiler Timestamp: Mon Sep 19 01:07:45 2005 Function Name: sqls::UpgradeProduct::CanUpgrade Source Line Number: 142
The result is the same, i.e.... Your upgrade is blocked because of edition upgrade rules...
Does anybody know about this problem? Some more information about the system: W2K3 R2 Enterprise Edition WSS3.0 MOSS2007 previously installed SQL Server 2005 Express Edition (Version 9.00.2047.00)
We are using VB.NET 2005 (Winform) and the backend SQL Server Express 2005. We would like to connect the Express (.mdf) database from Remote Machine. What type of connection string we have to use?
We tried the following ConnectionString but we got the error: Provider=SQLNCLI.1;Server=.SQLEXPRESS;AttachDbFileName=S:MLJData.mdf;Database=MLJData;Trusted_Connection=Yes;
Also suggest what are all the prerequisites to run sql server express 2005 database in client machine.
We did installed the following tools in client machine:
I recently installed SQL 2005. During the setup, I didn't get the option that makes me add the licensing module I'm using. I don't want to be slapped in the wrist by microsoft. After setup, how can I check the licensing used?
I am trying get a database setup in my new install of VS 2005. I have a project on one PC where I just have VS2005 installed and i am able create a website, go to the APP_DATA folder and add a database. On another PC I have VS 2005 installed and then I installed SQL server 2005. Now I fail to connect to ??? when I try and enter the sercuity page of webconfig or try to add a database when I open the APP_DATA folder. There have been many things done on this PC between the install of the two mentioned packages and trying this database creation. However, I feel that something related to the install of SQL Server 2005 after VS 2005 has done something unexpected. Or, I need to manage something between the SQL Express version that got loaded with VS 2005 and the subsequent install of SQL Server. I just don't know what to look for at this point.
I have a SQL 2k5 log shipping setup and all copy jobs as well as restore jobs are running properly but the LS_Alert job that the wizard auto creates fails every two minutes has anyone experienced this before. After going through the wizard it creates a LS_Alert job and schedules it every two minutes and it fails constantly.
I'm a Network Administrator that has to do everything from desktop to server, to routing, and DBA so I need a bit of advice. Stretched thin for time and knowledge in the SQL area and trying to do the best I can.
I currently have a MS SQL 2000 database that is 60GB in size for MS Dynamics 8.0 and one that is 2GB that I want to move to a new server.
I've setup and tested it and it all works, now I'm looking for some Best Practices information for best performance. Currently doing about 3,000 transactions a day.
Server is HP ML350-G5 2 Xeon Dual Core 2.0GHz CPUs w/16GB RAM w/external drive bays running 72GB 15K SAS drives with SMART ARRAY P800. OS is Windows Server 2003 Enterprise w/SP2 - MS SQL 2005 Standard I have the following drive configurations setup.
C:(RAID1+0)OS - SQL 2005 D:(RAID1+0)Dynamics Application Shared dictionary files for clients G:(RAID0)BACKUPS (see note below about TEMPDB) I also have a 25GB swap file on this drive maybe better to put in on the D: volume if I put TEMPDB here H:(RAID1+0)LOGS (2 user db logs and the tempdb log) I:(RAID1+0)DATA (2 user db - [model, msdb, master]
Recently found that my G: drive (RAID0) only has space for 2 backups (poor space planning on my part) before I need to move the files. Normally I backup the DB with BackupExec 10.1d just fine in about 2 hours over the wire at night since no one is in the DB at night. Was wondering if putting my TEMPDB there on (RAID0) would be advisable or not. In SQL 2005 it gets rebuilt each time SQL is restarted so it would seem that ensuring it's on a RAID1 or RAID1+0 might not be as necessary as say the DATA files. Then if I really wanted to I could actually do backups on the I:DATA drive at night and then use TAPE to back that up, and use an automated script to move them off to offline storage once the TAPE backup is done.
For the [model, msdb, master] should they need to be on the I:DATA drive or just leave them on C:OS ? Not sure how much they're actually used.
Also doing some brief testing the Microsoft Dynamics was much slower on the new Server than it was on the original. Odd to me since the new Server is like a McLaren F1 racing a Ford Pinto. The old server is running a single P4 CPU and 6GB RAM
I've set MS SQL 2005 to use 12GB of RAM on the new server so as to leave 4GB for other Server tasks.
I ran the Maintenance Wizard and had it do checks and defrag and index rebuild etc... so not really sure why the speed would be noticeably slower. One thing I did notice is that once a screen query was ran then the next time it was a bit faster but overall I was expecting to see the screens fly by on this new hardware and SQL 2005 but it doesn't really do that.
I've read some of the white papers etc for tuning, but wow I just don't have unlimited hours to do all this analysis, there seem to be hundreds of pages to read on that type of stuff.
