Suggestions For SQL 2005 Setup

Sep 7, 2006

OK we currently have a single SQL 2000 Server for our DW with a DR SQL 2000 Server. We are wanting to create a setup where we have a Failover Cluster of SQL 2005 here at the main office with a DR SQL 2005 system at our DR site. My question is... How would you all do the failover and stuff? How many servers would I need and what would be the job/role for each server. Some things to take note we are implimenting a SAN in our network and we are also implimenting a Virtual Server system on our network. To my understanding you do not really wish to run SQL Servers on a Virtual machine if possible. So I am already planning on making the SQL Servers Physical systems. We are also planning on putting the DB's on the SAN and have the SAN replicate all the data to DR. So... How would you all invision things to be setup? Is there any good documentation I can read about this type of setup. Thank you in advance for all the advice you can provide.

Thanks,

Billy S.

View 4 Replies


ADVERTISEMENT

Suggestions Needed - How To Setup A DB For Use With SQL 2005Express OR SQL 2005 Full?

Mar 21, 2008

Hello,
Background: I am a Software Engineer - not a DBA - with limited SQL knowledge (I know the SQL but not the configuration stuff)... I am sure others need this too - I tried but cannot find the answers online... please help me with a few questions:

Task: I need to find an way to install a database via Installshield 2008/command-line (silently), that is accessible locally and remotely regardless of what was already installed, and accessible only to our program - not users, so I am thinking use SA and a strong password since windows authentication may not apply with multiple users accessing this DB and they do not need to login on to the server - only our program does - sound right to use Mixed?).

Questions:
Can SQL 2005 Express be installed when SQL 2005 Full edition is already present?


Can SQL 2005 Express be installed without an instance name?
I think I read an instance name is required in Express, that if I do not provide it defaults to SQLEXPRESS -
So, if the prior question's answer is 'no, they cannot both exist'... prompting the next question:

If the Full version is already installed, should/can I use it - AND - can I add a New Instance silently via command line or ???

Any other ideas on why I can install 2005Express on one system, and not on two others (all 3 are development machines: VS 2005, SQL Express and that's about it)?
Currently I have figured out a command-line call to install - the command I came up with during testing is:
start /wait C: empSQLEXPR32.EXE /qb INSTANCENAME=CINST ADDLOCAL=ALL SECURITYMODE=SQL SAPWD=STR2PWD4SA SQLBROWSERACCOUNT="NT AUTHORITYNETWORK SERVICE" SQLACCOUNT="NT AUTHORITYNETWORK SERVICE" AGTACCOUNT="NT AUTHORITYNETWORK SERVICE" SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 AGTAUTOSTART=1 DISABLENETWORKPROTOCOLS=0 ERRORREPORTING=1 ADDUSERASADMIN=1
This looks like it might work for SQL Express 2005 - I do not have the full edition installed, yet - thus, this post.
The errors I got, shown in the summary.txt as 'Error 10' on one system with no other info.
My other system reports:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Fri Mar 21 16:45:25 2008

Machine : TONELSON
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_TONELSON_SQLSupport_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
...not much to go on as to why it is failing - maybe the hotfix:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE
in the directory is blocking the install?

The goal is for my application to use the same connection strings regardless of 2005 full or 2005 express.

Need to figure this out -
Thank you,
Todd

Software Engineer/Developer... learning a lot about SQL

View 6 Replies View Related

SQL Server 2005 Initialization Suggestions?

Jun 28, 2006

Greetings all,I have a SQL Server 2005 Database for a product based solution which needs to be initialized with some basic info before it get's shipped along with the product.  For example, the default admin password and assigning it to the Administrator role (Membership API).  Additionally some other application specific info.My first thought would be to create a command line utility which would be executed just once that reads a text file definining what needs to go where and blow this into an empty database.  I discovered the SSEUtil which could be handy but I understand this tool works only with SQL Express.Can someone suggest a strategy for handling  this  scenario?Thanks in advance!

View 1 Replies View Related

Sql Server 2005 And Images Suggestions???

May 24, 2006

hi,
i am working on a website that will be storing millions of images. i have read various advantages/disadvantages of saving the images on sql vs. file system.
i would like to keep all the data in one location (sql server in this case), so what i had in mind is following:i am going to save the original image data on a sql server. now, the website user can view a (multiple) thumbnail version(s) of the original image and the orig. image itself, so instead of getting the original image from sql and resizing it everytime, i was going to create a file(s) on a sep. server with the resized image(s) that would be called instead (think of it as file-cache). this would reduce the load on the sql server drastically since all the thumbnails (and orig. image) would have the file version of themselfes and would be loaded from the separate server. this way i could have all my data on a sql server, have thumbnail images on an "image server" and everything should be fine with the exception of the increased disk space. Also, i would not have to worry about having 2 backups since i have all the data on sql and each image/thumbnail would be file-cached on it's first call. if the file-cache of the image is not available for whatever reason i would just load straight from the db.
i would appreciate any suggestions on this.
thanks :)

View 2 Replies View Related

2005 Perf Much Worse Than 2000... Suggestions Please..

Nov 20, 2006

I have this SP that takes several varchar columns and concatinates them all together then inserts them into a text field. I do this with a cursor which was the quickest way to get it done when it was setup...

However when I moved the process to a 2005 server (on the same physical server) the process drastically slowed down. On 2000 the process took about 7 min to handle all 350k+ rows with the processors hanging around 20-40%... On 2005 it took over 30 min (not sure how long it would take cause I killed the process) and the processors stay above 98%...

I have rewritten the process to use a while loop instead of the cursor (I wanted to do this anyways) and it had no effect. At this rate (about 1 row a second) it will take forever and this process runs everyday.

Any ideas??

Here is the procedure...

declare @srch_field varchar(8000)

declare @row int, @productid varchar(25)

DECLARE @title varchar(150), @actors_keyname varchar(1200), @directors_name varchar(400)

Declare @genres varchar(700), @theme varchar(1500), @type varchar(1500), @studio_desc varchar(100)

DECLARE @media_format varchar(50), @artist_name varchar(100), @dev_name varchar(100)

DECLARE @flags varchar(256), @starring varchar(256), @esrb varchar(100), @esrb_desc varchar(500)

DECLARE @ptrval varbinary(16), @text varchar(max)

declare @productlist table(product_id varchar(25), IDNUM int identity)

insert into @productlist (product_id)

select product_id

from music_load..globalsearch

select @row = @@rowcount

while @row > 0

begin

select @productid = product_id

from @productlist

where idnum = @row

SELECT @title = rtrim(title) ,

@actors_keyname = actors_keyname ,

@directors_name = directors_name,

@genres = genres ,

@theme = theme ,

@type = type ,

@studio_desc = studio_desc,

@media_format = media_format ,

@artist_name = artist_name,

@dev_name = dev_name,

@flags = flags ,

@starring =starring ,

@esrb = esrb ,

@esrb_desc = esrb_desc

FROM globalsearch

where product_id = @productid

Set @srch_field = isnull(@title,'')

if @actors_keyname is not null and @actors_keyname <> 'unknown'

Set @srch_field = @srch_field + ' ~ ' + rtrim(@actors_keyname)

if @directors_name is not null and @directors_name <> 'unknown'

Set @srch_field = @srch_field + ' ~ ' + rtrim(@directors_name)

if @genres is not null

Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@genres, 0,''))))

if @theme is not null

Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@theme, 0,''))))

if @type is not null

Set @srch_field = @srch_field + ' ~ ' + (ltrim(rtrim(replace(@type, 0,''))))

if @studio_desc is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@studio_desc)

if @media_format is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@media_format)

if @artist_name is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@artist_name)

if @dev_name is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@dev_name)

if @flags is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@flags)

if @starring is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@starring)

if @esrb is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@esrb)

if @esrb_desc is not null

Set @srch_field = @srch_field + ' ~ ' + rtrim(@esrb_desc)

update globalsearch

set srch_field = @srch_field

where product_id = @productid

SELECT @ptrval = TEXTPTR(srch_field),

@text = credits

FROM globalsearch

where product_id = @productid

UPDATETEXT globalsearch.srch_field @ptrval NULL NULL @text

SELECT @ptrval = TEXTPTR(srch_field),

@text = track

FROM globalsearch

where product_id = @productid

UPDATETEXT globalsearch.srch_field @ptrval NULL NULL @text

set @row = @row - 1

end



View 5 Replies View Related

Ways/Suggestions For Increasing The Security For SQL Server 2005

Jan 14, 2007

Hi guys , is there any ways/suggestions for strengthen up the security for SQL server 2005 ? Due to several attacks from unknown places to my database's server , so I would like to get a way for increase the SQL security. Hope able to gather some info from web as well. Thx a lot guys.

Best Regards,

Hans

View 5 Replies View Related

How To Slipstream Sql Server 2005 Express SP1 Into Visual Studio 2005 Setup?

Jul 18, 2006

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?

Thanks in advance.

View 1 Replies View Related

How To Slipstream Sql Server 2005 Express SP1 Into Visual Studio 2005 Setup?

Jul 18, 2006

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?

Thanks in advance.

View 2 Replies View Related

AntiVirus Suggestions On SQL Server 2005 Box (Windows Server 2003 R2)

Oct 20, 2007

Hi all,

I know there's been quite a bit of discussion on WHETHER to run antivirus software on a SQL box(http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1764423&SiteID=1).

If I do decide to run it, does anyone have suggestions of specific antivirus software that have worked well and did not cause significant performance problems?

Thanks in advance.

--Jim

View 1 Replies View Related

How To Integrate SQL Server 2005 Express SP1 Into VS 2005 Setup?

Jul 18, 2006

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?

Thanks in advance.

View 4 Replies View Related

SQL 2005 Setup

Apr 20, 2006

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?

James

View 1 Replies View Related

Setup Of SQL 2005

Feb 10, 2007

Im about to upgrade all our SQL 2000 Servers to 2005

In your setups do you install the anlaysis services, reporting services on separate servers rather than all on the same server.

Currently we have separate servers for web IIS and was wondering if to install on three different servers

View 3 Replies View Related

SQL 2005 Database Setup

Feb 7, 2007

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.

View 1 Replies View Related

SQL 2005 Log Shipping Setup

Aug 9, 2007

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.

Thanks!
kdubb

View 1 Replies View Related

SQL 2005 Setup Configuration

Oct 5, 2007

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.

Thanks in advance for the advice.

View 20 Replies View Related

Sql 2005 SP1 Setup Failed

Apr 20, 2006

Hello I have installed Visual Web Developer 2005 Express, as well as Visual studio 2005 Standard edtion. I installed SQL 2005 express edition after installing Visual Web developer 2005 Express Edition! at least I thought I did. I most recently tried to install the SP1 of SQL 2005 express edi... and I seem to have gotten a failure to install message with (sa) in the message(I remember it from the first install but it had gone away on 2nd attempt). I have a two part question (1 Does VWD 2005 Express Edition have SQL 2005 Express Edi... included within it can this be causing the failure and, (2 how can I resolve this problem.

Thank You,

DKB

View 3 Replies View Related

MS SQL 2005 Setup Bootstrapper

Feb 18, 2008

So, here's my problem..

I've been working on getting SQL 2k5 installed for a few days now. It's been the single most trying installation I've ever attempted. Absolutely riddled with problems.. I've had to do integrate SP2 and XP and reinstall my OS... I've literally lost 15-20 hours of my life to this.

So here's my newest problem.
I've new to the techie world so try and make sense of this. Thanks.


Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Unable to load setup helper module : 87
Message displayed to user
Failed to load SqlSpars.dll
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_DSLPTP05_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0008.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_DSLPTP05_.NET Framework 2.0 LangPack.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0008.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_DSLPTP05_.NET Framework Upgrade Advisor.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0008.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_DSLPTP05_.NET Framework Upgrade Advisor LangPack.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0008.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_DSLPTP05_.NET Framework Windows Installer.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0008.cab" Error Code : 2
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_DSLPTP05_.NET Framework Windows Installer LangPack.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0008.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2006/4/29 16:4:46
Message pump returning: 87

View 1 Replies View Related

Fail In Sql 2005 Setup

Feb 5, 2008

Dears,

i have a problem when i setup workstation componant in sql 2005 it fail when the setup remove the backup file in the end of setup and give me this

if anyone no what id the problem solve it to me

thanks

View 1 Replies View Related

Setup Sql 2005 Fails On New XP-Pro

Jul 17, 2007

... Dear All,

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?

Thanks!

View 1 Replies View Related

SQL 2005 SP2 Mirror Setup

Mar 7, 2007

I'm trying to setup a SQL 2005 SP2 Mirror in between two mashines with no witness server.

I have successfully established the following:

1. Backup The Database on Principal Server: OK!

2. Copy the backup over to the mirror server: OK!

3. Restore the Database on Mirror Server: OK!

4. Establish Endpoint on Principal Server: Encyrption Disabled OK! TCP - PORT 5022


4.1 Test Script: Checks fine (values match)




SELECT e.name, e.protocol_desc, e.type_desc, e.role_desc, e.state_desc,
t.port, e.is_encryption_enabled, e.encryption_algorithm_desc,
e.connection_auth_desc
FROM sys.database_mirroring_endpoints e JOIN sys.tcp_endpoints t
ON e.endpoint_id = t.endpoint_id
5. Establish Endpoint on Mirror Server: Encyrption Disabled OK! TCP - PORT 5022



5.1 Test Script: Checks fine (values match) (same script as above)

6. Specify Principal server from Mirror server: OK! Connecting with IP

7. Specify Mirror server from Principal server: OK! Connecting with IP

8. View Mirror Information:


8.1 Test Script: Shows everything in NULL



SELECT mirroring_state_desc, mirroring_partner_name, mirroring_witness_name, mirroring_witness_state_desc, mirroring_role_desc, mirroring_safety_level_desc
FROM sys.database_mirroring

Mirror endpoints are still in red even though they initialized correctly.
Mirror monitor shows no mirrors are up.
SQL Logs shows: The Database Mirroring protocal transport is now listening for connections.
Any help would be appreciated.

View 1 Replies View Related

SQL 2005 Dev Setup Failed

Jan 8, 2008



I have downloaded SQL server 2005 dev edition from Microsoft download using MSDN licence. I selected SQL Server Studio, Integration Services, Reporting Services and Notification Services to install.



Native client, Backward Compatibility, Setup Support files, VSS writer, online help are getting install but MSXML, SQL Server Studio, Integration Services, Reporting Services and Notification Services are failed. Same setup is running fine in other system.

Error : SQLSetup0013_BTG356299_Core.log
----------------------
Microsoft SQL Server 2005 Setup beginning at Tue Jan 08 14:02:14 2008
Process ID : 2196
C:SoftMSDNSQL 2005 DevSQL Server x86Toolssetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2008/0/8 14:2:14
Complete: LoadResourcesAction at: 2008/0/8 14:2:14, returned true
Running: ParseBootstrapOptionsAction at: 2008/0/8 14:2:14
Loaded DLL:C:SoftMSDNSQL 2005 DevSQL Server x86Toolsxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2008/0/8 14:2:14, returned true
Running: ValidateWinNTAction at: 2008/0/8 14:2:14
Complete: ValidateWinNTAction at: 2008/0/8 14:2:14, returned true
Running: ValidateMinOSAction at: 2008/0/8 14:2:14
Complete: ValidateMinOSAction at: 2008/0/8 14:2:14, returned true
Running: PerformSCCAction at: 2008/0/8 14:2:14
Complete: PerformSCCAction at: 2008/0/8 14:2:14, returned true
Running: ActivateLoggingAction at: 2008/0/8 14:2:14
Complete: ActivateLoggingAction at: 2008/0/8 14:2:14, returned true
Running: DetectPatchedBootstrapAction at: 2008/0/8 14:2:14
Complete: DetectPatchedBootstrapAction at: 2008/0/8 14:2:14, returned true
Running: LaunchPatchedBootstrapAction at: 2008/0/8 14:2:14
Error: Action "LaunchPatchedBootstrapAction" threw an exception during execution. Error information reported during run:
"c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1602
Aborting queue processing as nested installer has completed
Message pump returning: 1602
----------------------
*******************************************
Setup Consistency Check Report for Machine: BTG356299
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: Warning
Description: There can be a product on higher SP level. Action: If you are attempting to upgrade an existing instance of Microsoft SQL Server to another Edition by installing the RTM version of the new Edition, you need to pass "SKUUPGRADE=1" to setup.exe on the command line.
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.3042.0
<EndFunc Name='DwLaunchMsiExec' Return='1602' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2008/0/8 14:4:23, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "PrepareForChainingStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2008/0/8 14:4:23
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1602
Error Code: 0x80070642 (1602)
Windows Error Text: User cancelled installation.
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults:erform
Source Line Number: 3416
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 "watsonFailedActionErrorCode" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.watsonFailedActionErrorCode
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
Failed to create CAB file 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 "watsonFailedActionErrorCode" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.watsonFailedActionErrorCode
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
Message pump returning: 1602
----------------------

Please help,

View 1 Replies View Related

SQL Server 2005 Setup

Oct 20, 2007



I just recently installed SQL Server 2005. I have a question about "SQL Server Management Studio".
I want my machine to act as the db server, so I can learn the basics of SQL Server 2005. Once I open
"SQL Server Management Studio" and attempt to connect to a database engine, I get the following error


Cannot connect to database engine....

I don't see any services running in the windows services console, I used to
work with SQL Server v7 awhile back and I remember within the left frame of "SQL Server Management Studio"
window, in the Registered Servers frame that the "Database Engine" icon usually had a green right arrow in it
when it was running correctly. Right now I have this "Database Engine" icon but there is a white circle with
no right green arrow signifying that it is running....

Thanks in advance for your help,
Wes

View 1 Replies View Related

Sql 2005 Replication Setup

Mar 14, 2007

I am trying to create a new transactional publication between two Sql 2005 servers.  This is my first attempt with replication in 2005, so i have obviously missed something in the setup.  Each time i try to create the new puplication i receive the following error.

 

Any help is greatly appreciated

 

 

 

TITLE: New Publication Wizard
------------------------------

SQL Server could not configure 'DTS-70P40LT2Y0A' as a Distributor.

------------------------------
ADDITIONAL INFORMATION:

Property LoginSecure cannot be changed or read after a connection string has been set. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
BUTTONS:

OK
------------------------------

View 2 Replies View Related

Setup SQL 2005 Reporting

Apr 14, 2008

Hi Room,
I am new to SQL reporting 2005 and wanted to setup SQL 2005 reporting on stand along server 2003 box.
SQL Server 2005 server and reporting services were installed.
Can anyone provide me some hints how to setup the sql 2005 reports.?
Any articles or links.?
Thanks for the help.
TJ

View 1 Replies View Related

SQL 2005 X64 Setup Fails

Jun 1, 2006

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.

View 6 Replies View Related

Error Installing SQL 2005 Setup (WMI)

Jan 18, 2007

The SQL Server System Configuration Checker Cannot be executed due to WMI configuration on the machine djones-xp Error: 2147749907 (0x80041013).

I am trying to install SQL2k5 on several developers workstations when I receive this error. I have successfully installed on a server and on my workstation...

Thanks DeWayne

View 3 Replies View Related

SQL SERVER 2005 SETUP ERROR

Apr 20, 2007

Hi all,

I'm new in this forum and id'like to post a strange error i can't solve by myself.

On a Win2003Server setted as a Stand Alone Server (without Active Directory) i installed my SQL SEERVER 2005 Workgroup edition with Management Studio and ODBC: Everything fine. a software house installed a IRP based on SQL Server: everything fine too.

They asked me to buil Dctive Directory on server. I should uninstall SQL Server, build up the AD domain and then reinstall SQL Server and from SQL Management Studio reconnect all the db.

Ok with uninstall operations, ok with AD setup but when i tryed to setup Sql Server 2005 it starts fine the DB engine but during management component setup i receive this error:

Tipo evento:Errore
Origine evento:MsiInstaller
Categoria evento:Nessuno
ID evento:11334
Data:20/04/2007
Ora:10.35.06
Utente:SERENAadministrator
Computer:SERVER
Descrizione:
Prodotto: Strumenti di Microsoft SQL Server 2005 -- Errore 1334. Impossibile installare il file "MS.AS.Oneclickcube.Resources.dll.53FCAAEE_2BA6_4556_896D_38710359E752". Impossibile trovare il file nel file CAB "Sql.cab". Questo può indicare un errore di rete, un errore di lettura dal CD-ROM o un problema con questo pacchetto.

Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico all'indirizzo http://go.microsoft.com/fwlink/events.asp.
Dati:
0000: 7b 36 41 44 31 32 42 45 {6AD12BE
0008: 35 2d 38 39 30 33 2d 34 5-8903-4
0010: 31 34 39 2d 41 32 44 42 149-A2DB
0018: 2d 30 46 41 32 39 31 31 -0FA2911
0020: 37 46 33 34 41 7d 7F34A}

sorry for Italian... hopes you can understand...

ideas? i notice that the IRP programmers setted up Visual Stuio 8 components on Server and on Analisys Components thers a OneClicCube.dll component...

On my CD there are no SQL.CAB archive...

no ideas at all..

Thanks a lot.

GAB

View 1 Replies View Related

Cannot Login To Sql Server 2005 (new Setup)

Oct 18, 2007

I just set it up on my laptop, its the express edition.
During setup I specified both auth (windows and login) and wrote down the username and password. I can connect through Management Studio with windows auth but not with the login.

I want to find the username and password. What do I need to do?

Thanks

View 3 Replies View Related

Linked Server Setup - SQL 2005 RTM

Jan 21, 2006

<<cross posted from microsoft.public.sqlserver.server>>Environment: Windows 2003 Standard Edition SP1, SQL 2005 EE RTM (bothservers)I am getting the following messages when I run this query:select * from LINKEDSERVER.databasename.dbo.tablenameOLE DB provider "SQLNCLI" for linked server "LINKEDSERVER" returnedmessage "An error has occurred while establishing a connection to theserver. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allowremote connections.".Msg 782, Level 16, State 1, Line 0SQL Network Interfaces: No credentials are available in the securitypackageOLE DB provider "SQLNCLI" for linked server "LINKEDSERVER" returnedmessage "Client unable to establish connection".Msg 782, Level 16, State 1, Line 0SQL Network Interfaces: No credentials are available in the securitypackageLINKEDSERVER is set up as a SQL Server linked server., with no loginmapping, and connections will be made using the login's currentsecurity context.Both servers allow local and remote connections via TCP/IP, and NamedPipes is disabled on both servers. Both servers are trusted fordelegation, and the service accounts for the MSSQLSERVER service onboth servers are also trusted for delegation.We are auditing successful and failed logins, and are not seeing anyactivity on the linked server.Any help would be appreciated.Randy

View 3 Replies View Related

SQL Server 2005: Setup Problem

Feb 1, 2006

Hello,(sorry for my English...)Could you help me please with installing SQL Servera 2005 ExpressEdition. I downloaded files:SQLEXPR.EXE - Microsoft SQL Server 2005 Express EditionSSEUtilSetup.EXE - SQL Server Express UtilitySqlServer2K5_BOL_Dec2005.msi - Books Online December 2005and I tried to run them sequentially. After installing SQLEXPR.EXEI had impression that I have little icons in Start menu (comparing tomy SQL Server 2000); I have a submenu:Microsoft SQL Server 2005 / Configuration ToolsSQL Server Configuration ManagerSQL Server Error and Usage ReportingSQL Server Surface Area ConfigurationI would like to have sth like Enterprise Manager (to see Northwinddatabase) and Query Analyzer (to query Northwind).So I decided to run SQLEXPR.EXE again: I see a report:System Configuration Check- WMI Service Requirement (Success)Messages* WMI Service Requirement* Check Passed- MSXML Requirement (Success)Messages* MSXML Requirement* Check Passed- Operating System Minimum Level Requirement (Success)Messages* Operating System Minimum Level Requirement* Check Passed- Operating System Service Pack Level Requirement. (Success)Messages* Operating System Service Pack Level Requirement.* Check Passed- SQL Server Edition Operating System Compatibility (Success)Messages* SQL Server Edition Operating System Compatibility* Check Passed- Minimum Hardware Requirement (Success)Messages* Minimum Hardware Requirement* Check Passed- Pending Reboot Requirement (Success)Messages* Pending Reboot Requirement* Check Passed- Default Installation Path Permission Requirement (Success)Messages* Default Installation Path Permission Requirement* Check Passed- Internet Explorer Requirement (Success)Messages* Internet Explorer Requirement* Check Passed- COM Plus Catalog Requirement (Success)Messages* COM Plus Catalog Requirement* Check Passed- ASP.Net Version Registration Requirement (Success)Messages* ASP.Net Version Registration Requirement* Check Passed- Minimum MDAC Version Requirement (Success)Messages* Minimum MDAC Version Requirement* Check Passed....and screen Feature Selection where I see Client Components notchecked. I decided to mark these components:Client Components "Will be installed on local hard drive"Connectivitiy Compenents "Will be installed on local hard drive"Software Development Kit "Will be installed on local hard drive"(I have free disk space); then I pressed "Next":Named instance: SQLExpressand "Next" again: on screen Existing compenents I see popup with amessage:"None of selected features can be installed or upgraded. Setup cannotproceed since no effective change is being made to the machine. (...)"but I had marked Client Components!Could you explain me please what I am doing wrong?Thank you very much for your help!(MP)

View 2 Replies View Related

SQL 2005 Setup Error Of 1935

Feb 13, 2007

I am trying to install the client tools on an XP machine.

I already had to run the .NET 2.0 repair to get past an earlier problem. 3 components fail, the first one being VS.

Here are the highlights of the summary.txt file. What can I do to resolve this? TIA!


Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
--------------------------------------------------------------------------------
Product : Visual Studio Integrated Development Environment 2005
Error : Error 1935.An error occurred during the installation of assembly 'Microsoft.VisualStudio.CommonIDE,Version="8.0.0.0",FileVersion="8.0.50727.42",PublicKeyToken="b03f5f7f11d50a3a",Culture="neutral",ProcessorArchitecture="MSIL"'. Please refer to Help and Support for more information. HRESULT: 0x80070020.
--------------------------------------------------------------------------------
Product : Microsoft Visual Studio 2005 Premier Partner Edition - ENU
Product Version : 8.0.50727.42
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_MACHINENAME_PPESku_1.log
Last Action : InstallFinalize
Error String :An error occurred during the installation of assembly 'Microsoft.VisualStudio.CommonIDE,Version="8.0.0.0",FileVersion="8.0.50727.42",PublicKeyToken="b03f5f7f11d50a3a",Culture="neutral",ProcessorArchitecture="MSIL"'. Please refer to Help and Support for more information. HRESULT: 0x80070020. assembly interface: IAssemblyCacheItem, function: Commit, component: {B05F61DB-39B8-4D38-A520-B5956C81BB01}
Error Number : 1935
--------------------------------------------------------------------------------
Product : SQL Server Books Online
Error : An error occurred during the installation of assembly 'Microsoft.VisualStudio.CommonIDE,Version="8.0.0.0",PublicKeyToken="b03f5f7f11d50a3a",Culture="neutral",FileVersion="8.0.50727.42",ProcessorArchitecture="MSIL"'. Please refer to Help and Support for more information. HRESULT: 0x80070020.
--------------------------------------------------------------------------------
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_MACHINENAME_BOL_1.log
Last Action : InstallFinalize
Error String : An error occurred during the installation of assembly 'Microsoft.VisualStudio.CommonIDE,Version="8.0.0.0",PublicKeyToken="b03f5f7f11d50a3a",Culture="neutral",FileVersion="8.0.50727.42",ProcessorArchitecture="MSIL"'. Please refer to Help and Support for more information. HRESULT: 0x80070020. assembly interface: IAssemblyCacheItem, function: Commit, component: {B05F61DB-39B8-4D38-A520-B5956C81BB01}
Error Number : 1935
--------------------------------------------------------------------------------

View 7 Replies View Related

Note: 1: 1708 During SQL 2005 Setup

Sep 20, 2007



Hi,

I am trying to install SQL server 2005 developer edition on Win XP SP2.

I am getting error during Database Services install throwing a log (part of it)




Property(S): FTERegRudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1
Property(S): FTEUPGRADE.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): FTEUpgrade30.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): FTEUpgradeMSSearchApp.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer
Property(S): FTEUpgradeMSSearchStandalone.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): CostingComplete = 1
Property(S): FTEInstID.68C6D15C_77E0_11D5_8528_00C04F68155C = 1
Property(S): FTEAppID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}
Property(S): FTEAdminCLSID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D37C-77E0-11D5-8528-00C04F68155C}
Property(S): FTEIFTEAdmin.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bd6f-cc0d-11d6-9a15-505054503030}
Property(S): FTEMSFTEPXY.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bdd4-cc0d-11d6-9a15-505054503030}
Property(S): FTEServiceName.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryManager = Reports
Property(S): RSVirtualDirectoryServer = ReportServer
Property(S): SqlActionManaged = 3
Property(S): SqlStateManaged = 2
Property(S): SOURCEDIR = D:Setup
Property(S): SourcedirProduct = {2373A92B-1C1C-4E71-B494-5CA97F96AA19}
Property(S): InstallNgenTicks = 20000
Property(S): SQLBROWSERSCMACCOUNT = CORPNBDQT5O
Property(S): AGTSCMACCOUNT = CORPNBDQT5O
Property(S): SQLSCMACCOUNT = CORPNBDQT5O
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {7E6E77F5-0576-4DAF-A405-B9184C5DD85A}
Property(S): ProductToBeRegistered = 1
MSI (s) (AC:94) [11:53:33:621]: Note: 1: 1708
MSI (s) (AC:94) [11:53:33:621]: Product: Microsoft SQL Server 2005 -- Installation failed.


Could somebody help, please?

Amol

904-987-7972

View 1 Replies View Related

Sql 2005 Cluster Setup Fails

Jun 2, 2006

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


Machine : NEWTPNT1
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : \M2MTPONEC$Program FilesMicrosoft SQL
Server90Setup BootstrapLOGFilesSQLSetup0004_NEWTPNT1_MSXML6_1.log
---------------------------------------------------------------------------­-----


Machine : M2MTPONE
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0004_M2MTPONE_MSXML6_1.log
---------------------------------------------------------------------------­-----


Machine : M2MTPONE
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Error Number : 67
---------------------------------------------------------------------------­-----


Machine : NEWTPNT1
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Error Number : 67
---------------------------------------------------------------------------­-----


SQL Server Setup failed. For more information, review the Setup log
file in %ProgramFiles%Microsoft SQL Server90Setup
BootstrapLOGSummary.txt.


Time : Thu Jun 01 18:18:54 2006

View 5 Replies View Related







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