Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How Do I Reinstall The SQL Server ODBC Drivers?


They are corrupt. I cannot get the odbc driver applet for sql server
to open when I click add and I cannot configure any existing ones. And
the usage of the drivers fail.

Other ODBC drivers work.

Does anyone know how to reinstall the SQL Server set of ODBC drivers?
MDAC wouldn't install, said it was already at current level.
Thanks for any ideas.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
SQL Server ODBC Drivers
I have a lot of client machines that do not have the SQL Server ODBC driver installed. Without having to install SQL Server client on their computers, I'd much prefer to just install the driver itself. Where on earth do I get it? The microsoft website is about the most confusing site when it comes to looking for driver downloads.

View Replies !   View Related
ODBC And SQL Server Drivers For 7.0
Hello,
We're upgrading to SQL Server 7.0 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell
how to update just these drivers? We tried to use the latest MDAC executable, but it broke applications on at least one client, so we were hoping
to narrow it down to just ODBC and SQL Server.
Thanks,
Dan Holland

dth@qad.com

View Replies !   View Related
Latest ODBC And SQL Server Drivers For SQL 6.5
What are the Latest ODBC and SQL Server Drivers for SQL 6.5? How can I upgrade them?

By the way, IS IT ABSOLUTELY NECESSARY to reboot the machine after application of a SQL Server service pack? (There is this dispute going on at my co.)

View Replies !   View Related
ODBC And SQL Server Drivers For 2000
Hello,

We're upgrading to SQL Server 2000 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell
after updating the ODBC driver to SQL 2000 would it support SQL Server 7.0 ?

Thanks

Sejal

View Replies !   View Related
ODBC And SQL Server Drivers For 2000
Hello,
We're upgrading to SQL Server 2000 and need to update all our clients with the latest version of the ODBC and SQL Server Drivers. Can someone tell
How do I upgrade the ODBC driver so that they can connected to SQL 2000.
The client pc's have an older version of ODBC drivers which supports Sql 7.0 Which dll do I need ? ? Where do I get it? Does it have on sql 2000 cd?

Thanks

Priti

View Replies !   View Related
ODBC Drivers, .NET Providers, OLE DB Providers, JDBC Drivers: Updated Lists
The driver and provider lists (below) have recently been updated and moved to anew web site (www.SQLSummit.com):ODBC drivershttp://www.sqlsummit.com/ODBCVend.htm..NET Providershttp://www.sqlsummit.com/DataProv.htmOLE DB Providershttp://www.sqlsummit.com/oledbven.htmJDBC drivershttp://www.sqlsummit.com/JDBCVend.htmDB2 Extendershttp://www.sqlsummit.com/extenven.htm

View Replies !   View Related
Importing Data In MS SQL Server 2005 Using Odbc Drivers From A Remote Connection


hello there! i have a problem importing data from a remote connection using Sybase ASE ODBC driver(the sybase odbc driver is the only way we can access the databasefrom theremote connection, we've already tried this in crystal reports).in the sql server import export wizard i chose the .net framework data provider for odbc. then below the wizard requires the following info: the connection string, DSN and driver. i specified the correct driver and dsn. in the connection string i specified the user id and the server name but it still produces error. the error says:

the operation could not be completed.

additional information:
ERROR[01000][SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to server.
ERROR[01000][SYBASE][ODBC Sybase driver][Sybase]ct_connect(): user api layer: internal Client Library error: HAFAILOVER: Trying to connect to server.

i need your help guys... thnx


View Replies !   View Related
ODBC Drivers
Hi,

I have an ODBC question. They say that to use SQL server 7.0 'tools', one must use ODBC 3.70 drivers. Is there anywhere where I can find a list of these 'tools' that will need these drivers?

Thanks
Sach

View Replies !   View Related
Need Help For ODBC Drivers
Experts,

Will 32-bit ODBC Drivers work in 64- bit machine? I have already installed 32-bit ODBC drivers in 64-bit machine so i wanna make sure all applications work fine.

ALSO, Where can i get to download ODBC Drivers for
1) Oracle in Orahome 92
2)Sybase SQL Anywhere 5.0
3) Informix 3.8 32 bit
4) openlink

Is there any 64-bit drivers available for above ODBC Drivers?
PLease Help.Thanks

View Replies !   View Related
ODBC Drivers
Okay, this is a weird question/problem. I have a 64 bit database server running on 64 bit Windows. This is just fine until I moved a 32 bit database over to it. My DB is trying to get some reporting to work and discovered that there are no ODBC drivers for Excel on this new 64 bit box. Are there 64 bit drivers for MS Excel? And access for that matter? If so, where are they?

Thanks.

View Replies !   View Related
Exchange ODBC Drivers?
Hi gang!

Are there any ODBC drivers or OLE DB providers for Exchange so that i can suck out data from Exchange 5.5 into SQL Server 7.0.

When i run DTS there are no drivers listed for Exchange at all.

Hope you can help.

Kyliedude :)

View Replies !   View Related
Missing ODBC Drivers - Please Help!!
Hi all

For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC.

Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS.

How does Import wizard pickup the available drivers, any registry settings...? Currently running XP SP2 with all the latest updates.

Need to get data uploaded to customer site from Excel spreadsheet. So any help / advice would be greatly appreciated!

TIA

Regan

View Replies !   View Related
Can't Locate &&"Microsoft OLE DB Provider For ODBC Drivers&&" For Win Server 2003 X86


All,

Been serahcing frantically for this provider: "Microsoft OLE DB Provider for ODBC Drivers" for Windows Server 2003 x86. However I can't seem to find it. Supposedly MDAC 2.8 has it but when I go to install MDAC 2.8, nothing happens (this is acknowledged in fact in the support area on Microsoft and the given reason is that Win2K3 Server is already MDAC 2.8-compliant. So no new stuff needs to be installed. But alas this provider isn't in my list of available drivers).

Attempts to install any part of a lesser version of MDAC that says it has it are met with "Can't do that 'cause your current version of MDAC is higher that that."

I have been searching around all day on Msoft and other sites for such a beastie but like Brigadoon vanishing in the mist, it eludes me. Msoft's main MDAC page is here:

http://msdn2.microsoft.com/en-us/data/aa937729.aspx

We need to use this kind of driver apparently with a certain Crystal Reportsreport or else it just won't run.


Thanks in advance for any advice/insights/DL links that work, etc...

Matt

View Replies !   View Related
ODBC Drivers And SQLServer 2000
Has anyone run into troubles connecting to an instance of SQLServer 2000
with older Microsoft ODBC drivers. In preparation for an upgrade, I am
trying to establish if there is a minimum ODBC version that is required for
client connectivity. I remember reading about such a minimum at one point,
but I can't relocate the reference

View Replies !   View Related
ODBC Drivers Error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''

How to fix this error...

View Replies !   View Related
ODBC Drivers Error '800040e31
Hi

I have encountered a following error:

Microsoft OLE DB Provider for ODBC Drivers error '800040e31
Microsoft ODBC SQL Server Driver timeout expired.

It is pointing to a line number in one the application's asp file.

Appreciate assistance very much. thks.
Krishna

View Replies !   View Related
Microsoft Ole Db Provider For Odbc Drivers
I'm not able to see microsoft ole db provider for odbc drivers on sql server 2005. Anyone know which driver I should install to see it?
I'm trying to create a linked server from as400 to SS2K5.




http://www.sqlserverstudy.com

View Replies !   View Related
Using SSIS To Pull From ODBC Drivers?
Hi all,

I've been tasked to do some investigation at my workplace as to the best way to move forward with changing from our SQL 2000 DTS' to SQL 2005 SSIS packages.

Our main issue at the minute seems to be that we are using ODBC drivers to pull many of the raw tables which we then manipulate into our own SQL Server tables.

I've been looking about and am I right in saying there is an issue with this in SQL 2005?

Also, I've been looking for some Tutorials to help me on this, would anyone be able to push me in the right direction of any good tutorials that would help me in fixing these issues?

Cheers

View Replies !   View Related
Reinstall Odbc Compenents
Does anyone know how I can reisntall just the odbc compenents for sql?
I get the error when opening sql query analyzer.

View Replies !   View Related
Unix Client ODBC Drivers For MSSQL
Does anyone know of a good ODBC driver that allows a Unix client to access data on an MSSQL server? I found nothing listed in the Archives.

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '
Hi guys

I wanna display the compname [in competencies tbl], firstname & surname [in users tbl], position level [in positions tbl] and userlevel [in compuser tbl] but i get the ff error msg

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'CompUser' does not match with a table name or alias name used in the query.

My code:

SELECT compname, firstname,surname ,level AS positionlevel
FROM positions, compuser, users A, comppos
INNER JOIN Competencies
ON comppos.Compid = competencies.Compid
RIGHT JOIN Users
ON CompUser.UserID = Users.UserID
WHERE Users.UserID = '999209'
OR Users.UserID = 'helpdesk1'
OR Users.UserID = '999339'
OR Users.UserID = 'helpdesk5'
ORDER BY CompName

Pls kindly help
Noks

View Replies !   View Related
MySql SSIS Hangs With ODBC Drivers
Hi, we are writting a SQL Server Integration Services package to import data from a MySql database to a Sql Database.

We are using ODBC 3.51 Drivers to connect to the MySql Database in SSIS. The package runs perfectly in design mode. When we schedule the package to run, the package seems to hang about 1/3 of the times.

What can this be. We used to the package and ran it from a Sql Server 2005 to a Sql Server 2005 database. This setup works perfectly. When i'm doing MySql to Sql Server 2005, 1/3 of the times, it does not work.

Can anyone help me with this?

Giovan Gentile
Ayuda Media Systems

View Replies !   View Related
How Do You Reinstalling ODBC Drivers In Vista Business?
How do you reinstalling ODBC drivers in vista business?

I have installed SQL 2005 Express & SQL Server management Studio Express, with SP2

However, the required driver "SQL Server" is not showing up in the list when trying to add a datasource in System DSN.

Can someone help? please.

Regards
Solway

View Replies !   View Related
Different Behaviour SQLSERVER And SQLNative ODBC Drivers
I started a thread in the security forum because when my Legacy App called sp_setApprole in an implict transaction a Begin transaction was called (approle cannot be set in transaction so fails) in SQL2005, wheras the same code succeeds against SQL2000

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1124204&SiteID=1&mode=1

Have now established in a simple test bed that this is due to the use of a different ODBC driver. We used the SQLNative driver against SQL2005 when it failed. Using the SQLServer driver against SQL2005 meant that the call to sp_setapprole succeeds (ie the transaaction begins after, when required)

1) any thoughts on this?

2) Can I use the SQLServer driver against SQL2005 ? haven't seen anything that says I can or can't. As I am simply updating datastore (SQL2000 -> SQL2005) of a legacy application I don't need to access any new SQL2005 features until its completely written. If I can use the old driver has it been certified or tested against SQL2005 ?

Any assitance / guidance most welcome  

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '80004005'
Hi everybodyMy problem with sql server is the following one:I've got my backoffice manager application done with asp technologythat works on sql server installed on Win2000 and running on IIS5.what I've done is simply doing a backup of my db and moving the aspapplication on another server: Windows 2003 with IIS6 and sql serververs.8.Then I tried to set up everything as in the beginning on the previousmachine(Win2K), but I'm getting this error:Microsoft OLE DB Provider for SQL Server error '80004005'[DBNETLIB][ConnectionOpen (Connect()).]Server SQL inesistente o accessonegato.(translated would be "SQL Server doesn't exist or access denied")/sitowebsite/bom/login.asp, line 13....where in the line 13 is set the connection to the database:Conn.Open Application("DBsource")which should be driven by what is set inside the global.asa file:Application("DBsource")="Provider=SQLOLEDB;server=127.0.0.1;database=db_nam e;uid=db_uid;pwd=db_pwd;"Application("WS_DB_TYPE") = ( "SQLSERVER" )I tried to restore the database just not losing information and nothinghappens.I tried also to create a new user and modify the properties as itshould be from the previous settings in the db(db_owner,....etc), stillnothing.any clue is appriciated.many thanks in advance.

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '80040e14'
Hi guys, it's nice to join the forum. Can someone can help me?After 2 years of using a program, i suddenly got this error. I triedre-installing SQL but im still getting the message.Microsoft OLE DB Provider for ODBC Drivers error '80040e14'[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load the DLLxplog70.dll, or one of the DLLs it references. Reason: 193(error notfound).

View Replies !   View Related
Latest Version Of ODBC Drivers For MSQL 2000
We are suffering from dropped connections to our MSSQL server which is version:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

We are getting "ERROR: Prepare failed" from the application.

We suspect the ODBC drivers on the client may be old.

The ODBC driver on the client machine is version
2000.80.194.00. as taken from the driver tab in the odbc admin window.


I installed a 2000 base version of the client tools on my desktop and got an ODBC version of 2000.85.1117

I then installed the SP3a and the ODBC driver version did not change. What is the latest version of the driver for MSSQL 2000?

thanks
JB

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '80040e07'
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Our SQL - INSERT INTO tbl_WAAGUsage (logindate,logintime,countryname,subscriberid,ipad dress) VALUES ('2/16/2004','9:50:01 AM','Albania',62,'123456789')

Hi,

I was wondering if somebody could help me... the following error message appears when I run an asp page... I did a google search and nobody appears to have had a solution to the particular problem I have... it's completely baffling but I'm hoping it's a simple setting.

Firstly, I'm sure the coding the correct as the asp page runs on two different servers correctly. I recently got a new server and the script does not appear to work with the Date function in asp on this new server. I outputted the SQL to the browser and then ran it through the Query Analyser(QA) and guess what, it worked! But when I run the asp page the above error crops up... now when I run the SQL through QA and alter the date value in the format 'dd/mm/yyyy' the above error appears in QA.. if I've lost you at this point let me know...

The way ASP passes the Date value to my SQL DB appears to be confused and it's really confusing me as it works perfectly on two servers and not the new one... the new server runs newer versions of O/S and SQL so I'm not sure that is the case... I've changed the date settings on the server so they all three servers match each other... so I have no where else to turn... any help and pointers would be much appreciated!

Regards

Steve

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '80040e4d'
hi all,

Can you please help me in following error , while connecting SQL Server and ASP



Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.

/test2.asp, line 21

Thank you so much

Graceson

View Replies !   View Related
Microsoft OLE DB Provider For ODBC Drivers Error '80004005'
Microsoft SQL Server 6.50 - 6.50.416 (Intel X86)
Jan 23 1999 14:10:24
Copyright (c) 1988-1997 Microsoft Corporation

In a SP I generate the infor RDO in a temporate tables. When i call on ASP send this :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
/asp/rdo/rdo_mty/automatico/rdoejecutivo.asp, line 10

View Replies !   View Related
Got Microsoft OLE DB Provider For ODBC Drivers Error '80004005' When Running Stored Procedures
when i am running a Stored Procedures, system always returns me error message below and Stored Procedures stops. please help

Microsoft OLE DB Provider for ODBC Drivers error
'80004005'

[Microsoft][ODBC SQL Server Driver] Received an unrecognized datatype 0 from
TDS data stream


sometime it returns error messge like, TDS Buffer Length Too Large
or
Unknown token received from SQL Server

or
Protocol error in TDS stream
or
Bad token from SQL Server: Datastream processing out of sync.
or
Invalid cursor state
or
TDS Buffer Link Too Large
or
Function sequence error

Many thanks, Please help, appreciated

View Replies !   View Related
Why I Get This Error:Microsoft OLE DB Provider For ODBC Drivers Error '80040e14'
When i run the web site in Windows 2003 Server,and I click on the "view" hyperlink to view customer infor,I got the error message as below:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '/'.
/bc/cust_info.asp, line 132
and the SQL statement in line 132 is as below:
strsql1 = "select sum(unit_price*qty) as SubTotal from dailySchedule where customer_code='" & request.QueryString("login") & _              "' and [date]=" & dbldate1
where [date] is reserved word
 
But,if I run the web in Windows 2000 Server,I don't get the error message as stated above.
Pls help.Thanks.

View Replies !   View Related
MYODBC Drivers For Sql Server 2005
SO I installed the MyOdbc drivers 5.0 and 3.51 and then went into my Data Sources(ODBC) drivers in my Administrative Control Panel
 I then proceeded to add the DSN Under System DSN and I also tried User DSN
 When I try to use the import/export tool in my SQL Server 2005 Management studio I don't get presented with the MySql drivers at all for a source
 
why is this?
 

View Replies !   View Related
Best Way To Reinstall SQL-server ?
I need to upgrade my SQL-server to Enterprise Edition of NT4 and SQL7. What is the best way to do this ? I have one database that is 30Gb in size.

1 - use DTS to transfer the database to another SQL7 server, reinstall NT and then use DTS again to restore data ?

2 - Do a full backup to tape, reinstall NT and then restore the database from tape ?


Need help regarding this.

View Replies !   View Related
HELP: SQL Server Agent (reinstall)?
Hi,

I'm hoping and praying that someone can help me here. On our production database, SQL Server Agent doesn't seem to exist on our server anymore. When I try to schedule a backup, Windows 2000 says that the Agent is an uninstalled service. I don't seen an entry for it in the SQL Service Manager or in the Windows 2000 Service applet.

Is there any way, other than reinstalling the whole database (which I'm trying to avoid), to bring the Agent service back up? Please email me at vchai@artinmotion.com.

Any help would be greatly appreciated.

Thanks in advance,
Vincent Chai
Email: vchai@artinmotion.com

View Replies !   View Related
Reinstall Sql Server 2000
I need to reinstall on one production server. What steps to be taken before uninstall and install

I am new to SQL Server, please can anyone guide me on this?

View Replies !   View Related
Is SQL Server 2000/5 Compatible With Sybase 15 OLEDB Drivers?


I have been having tremendous trouble getting OLEDB connections to Sybase that I use within SQL Server 2000 and SQL Server 2005 to work properly - they always seem to revert to the older, third party Sybasedrivers if they are installed on the machine and just generally cause problems - I have given up on using them within an SSIS package all together and gone down another route.

Can anyone confirm to me whether or not this is because the version 15 native drivers that Sybase provide are not supported by SQL Server, please?

Thank you

View Replies !   View Related
Reinstall SQL Server 2005 Express
 Since there is not a method to uninstall SP2 for SQL Server 2005 Express, it is recommended to completely uninstall and then reinstall.  I have backed up all databases as well as generated a script to recover username/passwords, is there anything else I should be taking into consideration?

View Replies !   View Related
Reinstall SQL Server Without Loosing The Data
hi Everybody,

for some reason my Sql Server has stopped and i am not able to restart it at all, do i have to reinstall the complete SQl Software or is there ne way i can start the MSSQL Server

View Replies !   View Related
No Connection For SQL 2000 After Reinstall SQL Server
Dear all,
I have uninstalled SQL 2005 from my PC and reinstall the SQL 2000. But there is no connection for port 1433 already.
What is the problem about?

Thanks.

View Replies !   View Related
Sql Server 2005 - Cannot Reinstall/uninstall
Hi,

I had to do a system restore to solve some other issues now my SQL Server 2005 doesnt work (SQL Server 2000 on the same machine [diffrent instance] does). I have tried to uninstall with add/remove programs but the instance doesnt appear there. I have tried to use the 'ARPWrapper.exe /Remove' command as described in KB909967 wich also fails.
I have also tried to reinstall with no sucess. I also tried uninstalling SQL2000 and removing as many references as I could find, again now joy.

Is there a script somewhere to remove everything (although I would like to try and keep the SQL2000 instance)?

View Replies !   View Related
Can't Uninstall Or Reinstall Nonfunctioning Sql Server
In previous post in the Getting Started section, I discussed problems trying to run queries on multiple databases:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=299240#299240&SiteID=1

Nobody could help with the problem. I eventually got a query to run after several attempts at deleting and recreating databases. Then, I was hit with the following error message:

Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)

Nobody could help with that either but based on posts with the same message, I tried uninstalling sql server. It wouldn't uninstall nor can I repair or reinstall. Uninstalling thru Add or Remove Programs only resulted in the program listingbeing removed from Add or Remove Programs. Most of the sql serverprograms are still installed. They canbe run but continue to malfunction. When I try a new installation, I get a message that the programs are already installed.

Is a complete reinstall of windows xp, programs anddatathe only solution? I hate to believe it; but, at this point, I see no other choice.

View Replies !   View Related
SQL Server 2005 Express Won't Reinstall
I had SQL Server 2005 Express installed on my computer, but was having problems with it interacting with Visual c++ 2005 Express Edition. I uninstalled both items, but now cannot get SQL Server to reinstall. Everything works fine until the installation gets to the "SQL Server Database Services" portion. At that point, I get a failure stating, "The SQL Server service failed to start. For more information see the SQL Server Books Online topics, 'How To: View SQL Server 2005 Setup Log Files' and 'Starting SQL Server Manually'." Behind this modal dialog box, in the install window, it seems to have stopped at "Running action to shutdown instance(Run As Normal User) RANU instance shutdown in progress: MSSQL$SQLEXPRESS"I have tried everything I can find online about this, including use of the Windows Install Clean Up, Aaron Stebner's blog about how to remove a beta version (http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx), Ttools, and the Visual Studio Uninstall program. I have manually deleted the folder for SQL Server from my Program Files folder, I have deleted all mention of the program from my registry, and yet I still cannot get the darned thing to reinstall.
My computer is a Pentium Duo-Core 2 6600, running at 2.4 GHz, with 2GB RAM, 129GB of 279GB hard drive space free
, with an NVIDIA GeForce 7600 GS video card. As I say, I had the program running, it just won't reinstall. I am logged on as the one and only user, and I have Administrator priveleges. There have been no changes to the PC aside from removing and trying to reinstall the C++ and SQL Server programs. Can anyone give guidance as to what the heck is going on and what to do?? The haed and tail of my error log is below. I am stuck. Thank you.

Regards,

Andy

=== Verbose logging started: 11/1/2007 11:16:13 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (1C:1C) [11:16:13:234]: Resetting cached policy values
MSI (c) (1C:1C) [11:16:13:234]: Machine policy value 'Debug' is 0
MSI (c) (1C:1C) [11:16:13:234]: ******* RunEngine:
******* Product: c:e02e41a11dc741be12SetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (c) (1C:1C) [11:16:13:234]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (1C:1C) [11:16:13:234]: Grabbed execution mutex.
MSI (c) (1C:1C) [11:16:13:250]: Cloaking enabled.
MSI (c) (1C:1C) [11:16:13:250]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (1C:1C) [11:16:13:250]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (DC:EC) [11:16:13:250]: Grabbed execution mutex.
MSI (s) (DC:F0) [11:16:13:250]: Resetting cached policy values
MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'Debug' is 0
MSI (s) (DC:F0) [11:16:13:250]: ******* RunEngine:
******* Product: c:e02e41a11dc741be12SetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'TransformsSecure' is 0
MSI (s) (DC:F0) [11:16:13:250]: User policy value 'TransformsAtSource' is 0
MSI (s) (DC:F0) [11:16:13:250]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (DC:F0) [11:16:13:250]: File will have security applied from OpCode.
MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'c:e02e41a11dc741be12SetupSqlRun_SQL.msi' against software restriction policy
MSI (s) (DC:F0) [11:16:15:781]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: c:e02e41a11dc741be12SetupSqlRun_SQL.msi is not digitally signed
MSI (s) (DC:F0) [11:16:15:781]: SOFTWARE RESTRICTION POLICY: c:e02e41a11dc741be12SetupSqlRun_SQL.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (DC:F0) [11:16:15:781]: End dialog not enabled
MSI (s) (DC:F0) [11:16:15:781]: Original package ==> c:e02e41a11dc741be12SetupSqlRun_SQL.msi
MSI (s) (DC:F0) [11:16:15:781]: Package we're running from ==> c:WINDOWSInstaller46c82d.msi
MSI (s) (DC:F0) [11:16:15:828]: APPCOMPAT: looking for appcompat database entry with ProductCode '{2B2EF9D0-3876-4021-8F44-FA294E6D3C36}'.
MSI (s) (DC:F0) [11:16:15:828]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (DC:F0) [11:16:15:828]: Detected that this product uses a multiple instance transform.
MSI (s) (DC:F0) [11:16:15:828]: MSCOREE already loaded, using loaded copy
MSI (s) (DC:F0) [11:16:15:828]: Applying multiple instance transform 'qlRun01.mst'...
MSI (s) (DC:F0) [11:16:15:828]: Looking for storage transform: SqlRun01.mst
MSI (s) (DC:F0) [11:16:15:828]: Validating transform 'SqlRun01.mst' with validation bits 0x809
MSI (s) (DC:F0) [11:16:15:828]: Transform 'SqlRun01.mst' is valid.
.
.
.
Property(S): SqlVerComBinRes1033.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = c:Program FilesMicrosoft SQL Server90COMResources1033
Property(S): SqlInstance.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
Property(S): SqlTarget.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL Server
Property(S): SqlInstanceBin.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
Property(S): Data.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL Server
Property(S): DataInstance.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
Property(S): FTDataDir.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): DataInstanceTxt.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
Property(S): DataInstanceFTData.7827AB3E_7041_406A_9591_4DB66042927F = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): ModuleID_FTSSV = 68C6D15C_77E0_11D5_8528_00C04F68155C
Property(S): SqlFullTextDefaultPath = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): FTERefPath.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): QuotedServiceGroupFTS.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = ANDYSSQLServer2005MSFTEUser$ANDYS$SQLEXPRESS
Property(S): FTEInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLEXPRESS
Property(S): FTERudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1
Property(S): FTERegRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSearch
Property(S): FTEInstanceSubDir.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1MSSQL
Property(S): FTEStartupType = 0
Property(S): FTEStatus = 3
Property(S): InstanceRegKey.7827AB3E_7041_406A_9591_4DB66042927F = Microsoft SQL ServerMSSQL.1
Property(S): InstanceName.7827AB3E_7041_406A_9591_4DB66042927F = SQLEXPRESS
Property(S): SqlVerComFT.BB43EC2E_1D73_400F_AE2F_F370407BC222 = c:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.BB43EC2E_1D73_400F_AE2F_F370407BC222 = c:Program FilesMicrosoft SQL Server90
Property(S): FTESqlInstanceBin.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
Property(S): FTESqlInstance.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
Property(S): FTESqlInstanceBinRef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef
Property(S): FTESqlInstanceDotNumber.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1
Property(S): SqlVer.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server90
Property(S): FTESharedCompRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server90
Property(S): Sql.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server
Property(S): SqlTarget.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server
Property(S): ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program Files
Property(S): CAFTERemovePerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQLEXPRESS
Property(S): CAFTEUninstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): CAFTEUpgradeFTERefFiles.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQLEXPRESS:c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef
Property(S): CAFTEUpgradeFTERefFilesRollBack.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef
Property(S): CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
Property(S): CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLEXPRESS
Property(S): CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQLEXPRESS
Property(S): CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYNetworkService
Property(S): FTERegInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLEXPRESS
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$SQLEXPRESS
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): FTEDollarInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQLEXPRESS
Property(S): FTEServiceName.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQLEXPRESS
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer$SQLEXPRESS
Property(S): SqlActionManaged = 3
Property(S): SqlNamedInstance = 1
Property(S): SqlStateManaged = 2
Property(S): RSVirtualDirectoryManager = Reports$SQLEXPRESS
Property(S): SOURCEDIR = c:e02e41a11dc741be12Setup
Property(S): SourcedirProduct = {B0F9497C-52B4-4686-8E73-74D866BBDF59}
Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITYNetworkService
Property(S): SQLSCMACCOUNT = NT AUTHORITYNetworkService
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {04F4B2AC-58A6-4ADD-98ED-84973C96062A}
Property(S): ProductToBeRegistered = 1
MSI (s) (DC:F0) [11:19:42:109]: Note: 1: 1708
MSI (s) (DC:F0) [11:19:42:109]: Product: Microsoft SQL Server 2005 -- Installation failed.

MSI (s) (DC:F0) [11:19:42:125]: Cleaning up uninstalled install packages, if any exist
MSI (s) (DC:F0) [11:19:42:125]: MainEngineThread is returning 1603
MSI (s) (DC:EC) [11:19:42:125]: Destroying RemoteAPI object.
MSI (s) (DC:38) [11:19:42:140]: Custom Action Manager thread ending.
=== Logging stopped: 11/1/2007 11:19:42 ===
MSI (c) (1C:1C) [11:19:42:140]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (1C:1C) [11:19:42:140]: MainEngineThread is returning 1603
=== Verbose logging stopped: 11/1/2007 11:19:42 ===

View Replies !   View Related
Can't Uninstall Or Reinstall SQL Server 2005 Dev
Long story short: Installed SQL Server 2005 Developers Edition along with Visual Studio 2005. Everything worked as it should.

Then there was a problem installing .NET Framework 2.0 Security Update. Fixed that by uninstall and reinstall of .NET Framework 2.0.

Now SQL Server does not work. So I figured uninstall/reinstall. Only problem is that it WILL NOT uninstall. I have tried to uninstall manually per KB article (9009967). That doesn't work either.

The error info that I'm geting is:

LinkID: 20476

Product Name: Microsoft SQL Server

Product Version: 9.00.2047.00

Message source: setup.rll

Message ID: 50000

EvtType: stateengine
esourcemodule.cpp@ScheduleActionAction@sqls::ResourceModule::LoadStringW@0x716



I get the same data during setup or uninstall. Neither of which completes.

Needless to say this is driving me nuts. I'm trying to learn VB.NET programming and many of the examples use SQL Server.

Any help would be appreciated.



View Replies !   View Related
Unable To Reinstall SQL Server 2005
Previously, I have installed SQL 2005 developer edition simplyfied chinese
successfully. But yesterday, I tried to install mobile client software
factory. The installation process create a database as following:
Create DATABASE [AdventureWorksMobileStaging] ON PRIMARY
( NAME = N'AdventureWorksMobileStaging', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging.mdf' , SIZE = 195584KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
( NAME = N'AdventureWorksMobileStaging_log', FILENAME = N'C:GotDotNetMCSF_728ReferenceImplementationsAdventureWorksToGoDBScriptsAdventureWorksMobileStaging_log.ldf' , SIZE = 265344KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
But today, when I start my notebook, SQL server could not be started.

Then I uninstalled the SQL instance by start->control panel->uninstall...The uninstall
process seems OK. Note that I only uninstalled the instance.Then I tried to reinstall
SQL 2005. However it was reported a Performance Monitor Counter registry key mismatch
error occures. I tried to fix it but failed. The problem is as following:

1, The installation process report a warning of low memory.
My notebook has 512M memory. I have reinstalled SQL 2005 once successfully. At that
time, the warning also shows, but it seems that this warning does not affect installation.

2, User type problem.
The OS of my notebook is XP professional, which is upgraded from XP home edition.
I login it using a domain user such as: "my company's domainmyaccount". I found it
curiously that although I assign myaccount as an Administrator, it will automaticly
changed to "SQL$...." account. I don't know why and when the account property is
changed. But everytime, when I found, I will assign myaccount as an Administrator
back.

3, Performance Monitor Counter registry key problem.
To fix the problem, I firstly tried to run lodctr.exe in cmd window but failed.
When I cd to c:windowssystem32 dir, I can ran lodctr.exe correctly.
I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib,
the result is:
"Last Counter"=dword:0000149c (11128)
"Last Help"=dword:0000149d (11129)
Then I check HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib09
and 004, the result is confusing. I can find counter and help key,but both keys contains
really a lot of stuff as:
(1) first page of Counter key:
1
1847
2
System
4
Memory
6
% Processor Time
10
File Read Operations/sec
12
(2) first page of Help key:
3
The System performance object consists of counters that apply to more than one instance of a component processors on the computer.
5
The Memory performance object consists of counters that describe the behavior of physical and virtual memory on the computer. Physical memory is the amount of random access memory on the computer. Virtual memory consists of the space in physical memory and on disk. Many of the memory counters monitor paging, which is the movement of pages of code and data between disk and physical memory. Excessive paging, a symptom of a memory shortage, can cause delays which interfere with all system processes.
7
% Processor Time is the percentage of elapsed time that the processor spends to execute a non-Idle thread. It is calculated by measuring the duration of the idle thread is active in the sample interval, and subtracting that time from interval duration. (Each processor has an idle thread that consumes cycles when no other threads are ready to run). This counter is the primary indicator of processor activity, and displays the average percentage of busy time observed during the sample interval. It is calculated by monitoring the time that the service is inactive, and subtracting that value from 100%.
9
% Total DPC Time is the average percentage of time that all processors spend receiving and servicing deferred procedure calls (DPCs). (DPCs are interrupts that run at a lower priority than the standard interrupts). It is the sum of Processor: % DPC Time for all processors on the computer, divided by the number of processors. System: % Total DPC Time is a component of System: % Total Privileged Time because DPCs are executed in privileged mode. DPCs are counted separately and are not a component of the interrupt count. This counter displays the average busy time as a percentage of the sample time.
11
File Read Operations/sec is the combined rate of file system read requests to all devices on the computer, including requests to read from the file system cache. It is measured in numbers of reads. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval.

I could not find the maximum value of the Counter key and help key, so I could not repair
Last Counter and Last Help key as discribed at SQL 2005 help. Which item correspond to
maximum value of the Counter key and help key?

I tried to correct Last Counter and Help key as:
"Last Counter"=dword:0000149c (5276)
"Last Help"=dword:0000149d (5277)
But it also doesn't work.

View Replies !   View Related
Can't Reinstall Sql Server 2005 Express
Hi I installed SQL server 2005 Express and it was successfully set up but I kept on getting error 26 when I try to connect to a database, so I remove all SQL programs from the control panel and reinstall SQL server 2005, but this time the set up stopped halfway saying "cannot start server". How can I successfully reinstall SQL server 2005 express?

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved