EM + QA Installs Corrupted

Mar 19, 2007

this may well be the wrong place for my post, if so please move it.

I have a variety of boxes with SQL tools installed on them. For some reason last week several of them seem to have gone a bit squif.

Server 1. Enterprise manager fails to run, giving message MMC could not create the snap-in. QA runs fine.

Server 2. Load EM click on a database and try Tools --> QA it comes back with File Not Found. Add isqlw as an external tool and you can run that ok, but still File Not found on the QA tab.

I know its not data corruption, but I hope someone can give me a clue on this!

Cheers!

View 2 Replies


ADVERTISEMENT

ODBC Installs

Jan 28, 2000

Hi,

Do we have to manually install the ODBC 3.70 drivers for SQL server 7.0, or do they get automatically installed during the SQL server 7.0 installation. I did not see anything when I installed. So I am thinking that the drivers have to be installed separately

Thanks
Sach

View 2 Replies View Related

SP3a Installs SP1

Oct 20, 2005

I really don't understand this, in an attempt to upgrade/install SP3a, I download the file sql2kdesksp3.exe, which from the documentation, you can either use for upgrading or new installs. I run a new install; in the new instance, I execute "select @@version" and get "Service Pack 1"??

View 8 Replies View Related

Trouble With Installs...

Jul 27, 2006

I am currently attempting to install SQL Server 2005. I had to install once due to a faulty install now when I try re-install it says all components are installed and won't continue install procedure and shuts itself down. Anyone else have this issue and know the work around or fix?

View 5 Replies View Related

Sqlexpr32.exe Only Installs At 2nd Try

Nov 22, 2007

Hi everyone,

I can't figure out what this problem may be:

At my application I'm installing sqlexpr32.exe by doing this:





Code Block


System.Diagnostics.Process proc1 = System.Diagnostics.Process.Start(
Environment.ExpandEnvironmentVariables("%SQLHome%")+ @" sqlexpr32.exe", "/norebootchk /qb reboot=ReallySuppress addlocal=all " + "instancename=SQLEXPRESS SQLAUTOSTART=1");
proc1.WaitForExit();
proc1.Close();
when I do this for the first time the sql setup runs but gives me an error saying that the file sqlncli.msi (Native Client) was not found

but if I go to the temp directory the msi is there..

when I run the app for the second time the sqlexpr32.exe detects the Native Client setup file and does the installation perfectly..

What could it be? Some thread issues?

Thanx in advance

View 1 Replies View Related

SQL 2k5 Installs To The Incorrect Drive??

Mar 27, 2007

I had a working SQL 2005 that I had to uninstall. I tried to verify things were cleaned up appropriately after the uninstall and rebooted afterwards.



When I went to reinstall I choose to install on another logical drive under raid 5 (lets say H:) in the EXACT same configuration as it was previously installed sans some of the services. Post-installation the data, Install etc folders you would expect to be under H:Program FilesSQL Server are actually under C:Program FilesSQL Server and the only thing installed under the H: selection was the 90/ folder. We uninstalled again and went back through the process and confirmed the selection of drive H: and AGAIN it installed it all to C:.





Please help!!!!!!!

View 1 Replies View Related

Third Party Installs With Sql 2005

Feb 10, 2008



I completed an install of SQL 2005 SP2 on Windows Server 2003. Everything worked fine I can connect while logged into the box, while connected thru RDP. I can create databases add users without any issue. Until!!!!

I have a third party application (Tririga) which I run the install and indicate the SQL database (in this case local) The application begins to install but when I get to the point of adding the SA password the install fails.
"login fails for sa) 18456 sev 8 (wrong password) but it is the same password I use to connect to the DB. So I change the sa assword and try again and it still fails.
any suggestions would be nice. by the way on machines on which I have run an upgrade from 2000 (sql) to 2005 (sql) the install does not fail.

View 2 Replies View Related

Different Behavior Between 2 Installs Of SQL Server 2000 !

Jul 19, 2005

Hi,anyone could explain this : I have installed the same asp.net application on 2 distinct hosts, each with its own SQL Server 2000 database.However, in some SQL queries in Stored Procedures, the results do not come out the same.For example, on one server the query "select @value = (select ....)-(select ...)" works and on the other one it returns a null valueAny hint ?Thanks for your helpJohann

View 2 Replies View Related

Unattended SQL Server 2005 Installs

Sep 10, 2007

Hello,

I have a quick question about automating installation of SQL 2005. This question doesn't relate as much to SQL 2005 as it does setting up a database server.

I know that it's usually standard practice to allow SQL to "lock pages in memory". What I am trying to do is find a command line utility that will allow me to add this step to the SQL install script. Any help is appreciated. Thank you.

View 3 Replies View Related

SQL Installs, But Not Found In All Programs (vista)

Dec 17, 2007

I am trying to install SQL 2005 that came with my Visual Studio 2008 on my Vista Machine, it will install successfully, but when I want to get to say, the Management Studio, or the Configuration Manager, there is no "Microsoft SQL 2005" node in my All Programs. what gives? you kind of need those. thanks.

View 1 Replies View Related

Vista Installs SQL Server 2005 SP1 Every Night!!

Jan 12, 2007

With Vista Ultimate (release), I installed SQL server 2005 Developer edition. I installed SP1, apparently successfully. But my Windows update history shows the SP being installed successfully every night. I have automatic updating turned on (via AD policy).

Has anyone seen this, and does anyone know how to fix it?

Thanks in advance.

Peter

View 1 Replies View Related

SQL 2012 :: How Useful Are Saved Configuration INI Files For Automating Installs

Jul 17, 2014

I nabbed a couple from some recent installs I did, and, assuming I can get my SAN guy to always give drives the same letter assignment, it looks fairly useful.

There's still a bunch of additional stuff to do, like turn on instant file initialization, size/create additional tempdb files, and set up alerts and database mail, etc.

Can the configuration file be expanded to handle any of that? Do you use something else to template/automate your SQL installs? The more I do it, the less I want to keep doing it.

View 4 Replies View Related

Sql Server Express Setup Installs The Silent Instattion, Can This Be Customized

May 25, 2007

Hi!



I have created a setup in visual studio and set the sql server as a pre-requsites.



now when the setup is run from

setup.exe

it checks whether sql server is installed... if installed then continues otherwise install sql server express edition, now this installation is silent,



I need to set the sa password during installation of sql server . i have no option to set the password during installation, can any one help



View 1 Replies View Related

SQL 2005 Failover Cluster Installs But Sql Server Service Will Not Start

Nov 26, 2007

Hello all,

I am intsalling SQL 2005 in an activepassive cluster. The OS is Windows 2003 with SP1. Everything installs OK but the sql server service cannot start afterwards. There are many access errors in the Security Event log - see example below - and numerous "SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. " errors in both the SQL and Application event logs. I have tried installing SQL in both mixed mode and under Windows Authentication and get the same errors. I can install SQL 2005 outside of the cluster on both nodes. Other items of note: This was a SQL 2000 cluster. I uninstalled SQL 2K, the virtual name was changed (IP remained the same) and the DNS entry was updated to reflect the new name. Early in the installation process - 3 or 4 days ago - I got a few errors about the Server Principal Name had to be updated but when I do a setspn -l the both nodes are listed and the entries look fine, though there are no entries for the sql service (MSSQLSvc). Not sure if there should be entries for the virtual name, but there aren't any for either the old or new name. Does the new virtual name need to be added to AD? Here is the security error - Event ID is 560 and it looks like there's a problem with Remote Access and is generated when trying to access either node:
Category: Object Access
Type: Failure Audit
Event_ID: 560
User: NT AuthorityNetwork Service
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: RemoteAccess
Handle ID: -
Operation ID: {0,134558507}
Process ID: 1516
Image File Name: C:WINDOWSsystem32services.exe
Primary User Name: CM-OHCO-DS006B$
Primary Domain: SWNA
Primary Logon ID: (0x0,0x3E7)
Client User Name: NETWORK SERVICE
Client Domain: NT AUTHORITY
Client Logon ID: (0x0,0x3E4)
Accesses: Query status of service

Privileges: -
Restricted Sid Count: 0
Access Mask: 0x4

One other informational message that may be of use - looks like there's a problem with dll's for remote access, though this isn't pertaining to SQL:
The description for Event ID ( 0 ) in Source ( srmservice ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: srmservice error: 0, Started the agent (srmagent.exe)..

View 5 Replies View Related

SQL Server 2005 SP1 Installs Successfully But Microsoft Update Still Showing It As Needed?

Jun 3, 2006

I have successfully installed SQL Server 2005 SP1 but when I go to the "Microsoft Update" site it is still shown as required. I have tried going back to an old image of the PC and installing SQL Server 2005 and SP1 again but still the "Microsoft Update" page is not picking up the fact that SP1 has installed successfully. Anyone had the same problem or know of a fix?

Steve



View 3 Replies View Related

Error Connecting To Report Server Database After Several Installs And Uninstalls Of SSRS.

Mar 20, 2008



















I've had some problems with Reporting Services and getting connected to the database server after configuration. I am now getting the following error message:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError)


In my Database Setup everything runs fine when I click apply except for the Setting Connection Info for Reporting Server this has a yellow triangle with a ! and says that the report server cannot access internal information.

I also have not been able to Initialize as there are no instances to initialize and none are created when I go through setup. Is there something I need to delete from the registry or the file system that does not get removed upon uninstall?

Thanks.

Emily

View 11 Replies View Related

Corrupted Mdf

Jul 31, 2007

Hi Everyone,

when i am trying to attach a 'xxx.mdf' file it is showing message 'xxx.mdf' is not a primary database file.

Please suggest me what could be the reasons and what are the possible ways to recover my database.

I have lot of important data in the database.

Thanks and Regards,
Shashidhar

View 7 Replies View Related

Corrupted Ndf

Jun 27, 2007

how can i attach my database without the ndf file, i still have the mdf and ldf. my ndf file contains only 2 tables which are not that very impt. unfortunately my ndf was corrupted and my backup files was deleted when the network admin formatted the harddisk where the backups were stored.. is it possible? kindly help..

View 5 Replies View Related

Express Will Not Load. Insurmountable Difficulties With Order Of Uninstalls/order Of Installs/ Suggestions Plz

Jan 7, 2007

Finding the "pieces of information" I need to successfully install the SQL Server Express edition is so complex. Uninstalls do "not" really uninstall completely, leading to failure of SQL install. Can you suggest a thorough, one-stop site for directions for the order of app uninstalls and then the order for app installs for the following...

SQL Server Express edition

Visual Studios 2005

Jet 4.0 newest upgrade

.Net Framework 2.0 (or should I use 3.0)

VS2005 Security upgrade

Anything else I need for just creating a database for my VS2005 Visual Basic project?

I was trying to use MS Access as my backend db but would like to try SQL Express



Thank you, Mark





View 7 Replies View Related

Corrupted Index

Sep 16, 1999

Hi,
I have a question on sqlserver 6.5 with sp5a.

I execute a query like the following

select * from eps_analysis_cm (INDEX = index2)
where ....

the query gets 32 rows.

If I use another index

select * from eps_analysis_cm (INDEX = index1)
where ....

the query gets 0 rows.

Are my indexes corrupted ?
Note: running DBCC CHECKDB I get no error messages

Thanks in advance

View 9 Replies View Related

LOG File Corrupted

Nov 14, 2007

We have one database of 5 GB of which when we take the backup and restore in another location, it says "Device Activation Error. The Physical file name e:databaseike_log.ldf may be incorrect".
The database has more than one log file.
Now when we use another procedure to create new database and stop the sql, then replace the old mdf file and REBUILDLOG. (Ie dbcc rebuildlog(nike,1,0)). It says incorrect DBCC Statment.

Pl. suggest us what to do?

View 3 Replies View Related

Table Corrupted?

Aug 27, 2001

SQL Server 6.5.
Hi!
When I try to create PK, Clustered index on the column in the table I have got error message: 1105 Couldn't not allocate space for object table1......
But it is a big amount of free space in the database. And actually I can create any indexes, exsept clustered with no problem.
DBCC CHECKALLOCK for this table shows: extent not ih the segment.
Does it mean the table structure is corupted? What Can I do to resolve the problem?

Thank you,
Elena.

View 1 Replies View Related

Master Db Corrupted

Jun 7, 2001

Hi, Folks !

What happens with all jobs after rebuilding master db if it got corrupted. Will they be working correctly ? If no, then why ?

Thanx in advance,

serg

View 2 Replies View Related

Database Corrupted?

Jan 25, 2005

Hi all,

Had a disk problem here, and all apps connected to our database hung. Nothing was responding, rebooted, and mssqlserver hangs on startup.

If i move the mdf and ldf files of the database in question to another folder, mssqlserver starts up ok, with the db marked as suspect.

It would seem the the mdf and ldf are corrupted.

I am restoring a backup from yesterday, but this will take hours.

Any suggestions trying to recover it as it sits?

Thanks in advance for any ideas.

View 7 Replies View Related

Corrupted Log Backup

Apr 5, 2007

Hi..!

Is it possible to recover data from corrupted log backup ?

Suppose we have 10 log files and 8th is corrupted then how can we recover database.

I am not facing such problem right now, but it's a question raised in my mind.

I would like to have your help, suggestions & comments. :rolleyes:

Thanks...

View 2 Replies View Related

Corrupted Backup

Aug 2, 2007

Hi Everyone,

When I am trying to restore the backup it is giving an error message "An internal consistency error occurred. Contact Technical Support for assistance".

Please suggest me on this issue.

Is there any way to restore the backup or recover the backup.

Thanks,
Shashidhar

View 4 Replies View Related

Corrupted Database?

Dec 15, 2005

I have a SQL 2000 database whose MDF is approx. 105 GB. Everything has been working fine for months until this past weekend when the database server dropped offline. I restarted the services and SQL server looks to have started up okay. However, trying to access it via Enterprise Manager causes EM to hang. Checking the Windows event log, there are a whole series of messages stating ...

3455 : Analysis of database 'ptportal' (7) is XX% complete (approximately 61 more seconds)

This 'analysis' ran for over 12 hours ... I have never seen this run before, much less this long. Now, there are a new series of messages stating ...

3450 : Recovery of database 'ptportal' (7) is XX% complete (approximately 56526 more seconds) (Phase 2 of 3).

This 'recovery' has been running for 9 hours now. Does anybody have any idea what has happened here or what is going on? My guess is that this database has been corrupted and SQL Server is trying to do a repair? Anybody know how long this usually takes and what the success liklihood would be?

Thanks
-- Jeff Chastain

View 1 Replies View Related

Master Db Is Got Corrupted

Aug 20, 2007

Hi ALL,

My sql server is not starting becasue master db got corrupted.
I have tried to rebuild the master db with rebuild utility.Now the process of rebuilding taken 6 hours but still the process of rebuild master is going on.
Can any body faced this problem why it is not rebuilding the simple master database.

Thanks you.
BPG

EDIT by tkizer: moved to Data Corruption Issues forum

View 5 Replies View Related

Database Corrupted

Oct 4, 2007

Hi,

I have a database corrupted showing on the Object Explorer the name of the database and showing near (6.5). Deleted not accepted any other function not allow. Is there any way to take off from the Object Explorer?

Best regards

View 3 Replies View Related

Help - Corrupted SQL Server 2K Log. Is This Serious

Jul 23, 2005

Hello,I have a SS2K (SP3) that is appending very wierd looking error messagesto the SQL Server Log (Current). The messages are not formatted asother log entries. The messages suggest some kinda dump information.The messages have the following characteristics:Date Information is invalidSource information is invalidMessage information is strangeThe following is a message that appear in my current SQL Server LogDATE:78008454SOURCE: Module(MSVCRT+Message (_endthread+000000C1)There are many messages like this in the log.Is this serious?Thanks - Covi

View 1 Replies View Related

Sql 7 Password Has Been Corrupted...HELP.

Jul 20, 2005

Hey Hey everyone. It's me again asking for help.I have an NT sp6 box with SQL 7. It seems the password for SA hasbeen corrupted, so it won't allow me to log in to it.As an NT admin, is there anyway to reset the SA password?Or, can I create another SA account in SQL 7?Can't find anything in Microsoft because..... SQL7 is not longersupported.Thanks in advance for any help.Jinev

View 3 Replies View Related

Corrupted Log File

Jul 20, 2005

Need to recover from a corrupted log file. The database in EnterpriseManager shows the database as corrupt.Using sp_Attach_db produces a corrupt log message.Any way to recover the data?Thanks

View 2 Replies View Related

Why Corrupted My Sdf File?

Nov 1, 2007



hello,
i am using sql server ce 2.0 on windows ce 4.2.sometimes my sdf file gets corrupted but i cant understand why?i know how this file repair.but for me it is not a solution.please somebody help me!

View 1 Replies View Related







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