Cannot find mdf files: installing

Showing posts with label installing. Show all posts

Tuesday, March 27, 2012

Cannot remotely login to SQL Express since last windows update

Since today (after installing the latest Windows Updates !on my local machine!) I cannot login to a SQLExpress instance remotely; stating that it cannot find the server/instance.

The weird thing is: it only happens when I want to login to the non-default instance (sqlexpress 2005) (<IP>\<instance>).

When i'm using the default instance (msde 2000 or sqlexpress 2005 on another machine) (<IP>) it seems to work fine.

Does this have something to do with the windows updates, or is it just a coincedence?

Thanks in advance,

Remco RosThis is probably due to the update changed your setting. Just check your firewall on the server and put sqlbrowser.exe or UDP port 1434 to exception. Also make sure your sqlbrowser is running.|||we didn't install the updates on the server (yet) only on the client, so it must be a client thing.

Server:
Win 2003 / SQL Express 2005
Tcp/ip / named pipes: yes
sqlbrowser running
firewall exception on 1434udp 1433tcp.

tested on these client(s):
Local (without latest updates): CAN connect
XP Home with SQL Server Management studio (with lates windows updates): CANNOT connect
XP Pro with SQL Server Management studio Express (with lates windows updates): CANNOT connect
Win 2003 with SQL Server Management studio Express

(WITHOUT lates windows updates): CAN connect.

I see a pattern here...|||Are you sure your SQL Express listens on TCP port 1433 since your put 1433 in exception? What's the result if you run "telnet yourserver sql_tcp_port"? Can it connect? Could it be possible that IPSEC blocked the traffic between the problem machine if the IPSEC is on?

Sunday, March 11, 2012

Cannot Load SQLSpars.dll

Hello,

I have had numerous problems installing SQL Server 2005 on various machine. Most of those problems are related to insufficient rights to various users. But I am baffled by this one:

Setup Failed: Could not load SQLSpars.dll

Why would this happen? I see this message after beginning the SQL Server 2005 Standard setup and making my installation selections and beginning the install. The process stops after about 30 seconds, and displays the above message.

My machine is running Windows XP SP2.

Any ideas?

Thank you,

Jon500

A few customers have reported this issue but we haven't tracked down the bug or a workaround yet. If you can post a link to your Setup log files, I'll try to convince a developer to look at them and offer advice.

Paul

|||

Excellent. I definitely want to cooperate because I am certain (as you suggested) that other people are experiencing this.

Do you know the name and/or location of the setup log?

Thank you,
Jon

|||SQL Server Setup log files are located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG|||

There are at least 4 log-related files in the Files folder. This is from my file called:
SQLSetup0008_DSLPTP05_Core(Local).log
I copied and pasted the top of the file to the point at which it logged the failure.

Does this help (it sure didn't help me when I looked at it)?

Thank you,
-- Jon500

Microsoft SQL Server 2005 Setup beginning at Mon May 29 16:04:39 2006
Process ID : 2464
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/4/29 16:4:39
Complete: LoadResourcesAction at: 2006/4/29 16:4:39, returned true
Running: ParseBootstrapOptionsAction at: 2006/4/29 16:4:39
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/4/29 16:4:39, returned true
Running: ValidateWinNTAction at: 2006/4/29 16:4:39
Complete: ValidateWinNTAction at: 2006/4/29 16:4:39, returned true
Running: ValidateMinOSAction at: 2006/4/29 16:4:39
Complete: ValidateMinOSAction at: 2006/4/29 16:4:39, returned true
Running: PerformSCCAction at: 2006/4/29 16:4:39
Complete: PerformSCCAction at: 2006/4/29 16:4:39, returned true
Running: ActivateLoggingAction at: 2006/4/29 16:4:39
Complete: ActivateLoggingAction at: 2006/4/29 16:4:39, returned true
Running: DetectPatchedBootstrapAction at: 2006/4/29 16:4:39
Complete: DetectPatchedBootstrapAction at: 2006/4/29 16:4:39, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2464" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2006/4/29 16:4:39
Complete: PerformDotNetCheck2 at: 2006/4/29 16:4:39, returned true
Running: InvokeSqlSetupDllAction at: 2006/4/29 16:4:39
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Unable to load setup helper module : 87
Message displayed to user
Failed to load SqlSpars.dll

|||

We'll likely need to see all the log files plus summary.txt, which is in their parent directory. The files are big enought that you shouldn't try to post them here. Instead, please provide a link.

Paul

|||

My files are here:

http://sp.dialogsw.com/temp/Files/Forms/AllItems.aspx

I will keep them there only for a few days. Kindly acknowledge when you have received/download them.

Thank you.

|||

Sorry, this thread got lost in the noise for a few days. I've retrieved the files and asked for help from a Dev to investigate.

Paul

|||Thank you very much. I still have no resolution and I am using only the CTP edition of SSMS as a result.|||Will it get any importance if this is posted in Microsoft connet?|||

Hello,

Did this ever get resolved? I am now having the same problem with katmai CTP3.

-Jamie

|||

If you are reading this thread and think you can help me, please reply and let me know.

-Jamie

|||

I'm sorry but this issue was NEVER resolved. Would you believe that I had paid $99 to open an incident with Microsoft? After spending about three weeks with them, sending megabytes of log files, etc., they gave up and said that they could only recommend that I re-baseline my Windows XP Pro SP2 installation in order to install Sql Server 2005.

I was so disgusted that I asked for a refund of the $99 (which they provided without hesitation).

It is a sad day when the author of the software can't get it to install on a state-of-the-art hardware platform and latest software service packs and mainstream operating system.

If I could use Oracle, I would, but sadly I have to use Sql Server 2005. I am going to see if Microsoft today has any additional information on this issue because I am still not running on my main development machine. I had to install a database instance on another machine on my network and use TCP/IP to access the database instance on it.

I was able to get the Community Technology Preview installation of Sql Server 2005 installed on my development machine, however. This at least gives me the ability to access a Sql Server 2005 database from my development machine. But I still cannot get the native client installed on that machine.

I hope this helps.

|||

Jon,

As you can see from above I had the same problem with katmai CTP3.

The root cause of the problem (in my case) was that DTC wasn't installed on the server. Try as I might I couldn't get it installed either (the reason escapes me right now) so I just scrapped the whole OS (which I think was Win2k3) and installed (using the same installer package) on Win XP. Worked like a dream. It was only on VPCs anyway so I didn't lose too much.

If you want to know if DTC is installed or not go to a command window and type "msdtc". If it returns without barfing at you then you know its installed.

hope that helps.

-Jamie

|||

Sorry for the delay in writing...

DTC is installed and is running successfully on the computer in question. So, on my WinXPSP2 system, DTC is not the issue...

Thursday, March 8, 2012

Cannot Load SQLSpars.dll

Hello,

I have had numerous problems installing SQL Server 2005 on various machine. Most of those problems are related to insufficient rights to various users. But I am baffled by this one:

Setup Failed: Could not load SQLSpars.dll

My machine is running Windows XP SP2.

Any ideas?

Thank you,

Jon500

Paul

|||

Excellent. I definitely want to cooperate because I am certain (as you suggested) that other people are experiencing this.

Do you know the name and/or location of the setup log?

Thank you,
Jon

|||SQL Server Setup log files are located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG|||

Does this help (it sure didn't help me when I looked at it)?

Thank you,
-- Jon500

|||

We'll likely need to see all the log files plus summary.txt, which is in their parent directory. The files are big enought that you shouldn't try to post them here. Instead, please provide a link.

Paul

|||

My files are here:

http://sp.dialogsw.com/temp/Files/Forms/AllItems.aspx

I will keep them there only for a few days. Kindly acknowledge when you have received/download them.

Thank you.

|||

Sorry, this thread got lost in the noise for a few days. I've retrieved the files and asked for help from a Dev to investigate.

Paul

|||Thank you very much. I still have no resolution and I am using only the CTP edition of SSMS as a result.|||Will it get any importance if this is posted in Microsoft connet?|||

Hello,

Did this ever get resolved? I am now having the same problem with katmai CTP3.

-Jamie

|||

If you are reading this thread and think you can help me, please reply and let me know.

-Jamie

|||

I was so disgusted that I asked for a refund of the $99 (which they provided without hesitation).

It is a sad day when the author of the software can't get it to install on a state-of-the-art hardware platform and latest software service packs and mainstream operating system.

I hope this helps.

|||

Jon,

As you can see from above I had the same problem with katmai CTP3.

If you want to know if DTC is installed or not go to a command window and type "msdtc". If it returns without barfing at you then you know its installed.

hope that helps.

-Jamie

|||

Sorry for the delay in writing...

DTC is installed and is running successfully on the computer in question. So, on my WinXPSP2 system, DTC is not the issue...

Cannot Load SQLSpars.dll

Hello,

I have had numerous problems installing SQL Server 2005 on various machine. Most of those problems are related to insufficient rights to various users. But I am baffled by this one:

Setup Failed: Could not load SQLSpars.dll

My machine is running Windows XP SP2.

Any ideas?

Thank you,

Jon500

Paul

|||

Excellent. I definitely want to cooperate because I am certain (as you suggested) that other people are experiencing this.

Do you know the name and/or location of the setup log?

Thank you,
Jon

|||SQL Server Setup log files are located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG|||

Does this help (it sure didn't help me when I looked at it)?

Thank you,
-- Jon500

|||

We'll likely need to see all the log files plus summary.txt, which is in their parent directory. The files are big enought that you shouldn't try to post them here. Instead, please provide a link.

Paul

|||

My files are here:

http://sp.dialogsw.com/temp/Files/Forms/AllItems.aspx

I will keep them there only for a few days. Kindly acknowledge when you have received/download them.

Thank you.

|||

Sorry, this thread got lost in the noise for a few days. I've retrieved the files and asked for help from a Dev to investigate.

Paul

|||Thank you very much. I still have no resolution and I am using only the CTP edition of SSMS as a result.|||Will it get any importance if this is posted in Microsoft connet?|||

Hello,

Did this ever get resolved? I am now having the same problem with katmai CTP3.

-Jamie

|||

If you are reading this thread and think you can help me, please reply and let me know.

-Jamie

|||

I was so disgusted that I asked for a refund of the $99 (which they provided without hesitation).

It is a sad day when the author of the software can't get it to install on a state-of-the-art hardware platform and latest software service packs and mainstream operating system.

I hope this helps.

|||

Jon,

As you can see from above I had the same problem with katmai CTP3.

If you want to know if DTC is installed or not go to a command window and type "msdtc". If it returns without barfing at you then you know its installed.

hope that helps.

-Jamie

|||

Sorry for the delay in writing...

DTC is installed and is running successfully on the computer in question. So, on my WinXPSP2 system, DTC is not the issue...

Cannot Load SQLSpars.dll

Hello,

I have had numerous problems installing SQL Server 2005 on various machine. Most of those problems are related to insufficient rights to various users. But I am baffled by this one:

Setup Failed: Could not load SQLSpars.dll

My machine is running Windows XP SP2.

Any ideas?

Thank you,

Jon500

Paul

|||

Excellent. I definitely want to cooperate because I am certain (as you suggested) that other people are experiencing this.

Do you know the name and/or location of the setup log?

Thank you,
Jon

|||SQL Server Setup log files are located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG|||

Does this help (it sure didn't help me when I looked at it)?

Thank you,
-- Jon500

|||

We'll likely need to see all the log files plus summary.txt, which is in their parent directory. The files are big enought that you shouldn't try to post them here. Instead, please provide a link.

Paul

|||

My files are here:

http://sp.dialogsw.com/temp/Files/Forms/AllItems.aspx

I will keep them there only for a few days. Kindly acknowledge when you have received/download them.

Thank you.

|||

Sorry, this thread got lost in the noise for a few days. I've retrieved the files and asked for help from a Dev to investigate.

Paul

|||Thank you very much. I still have no resolution and I am using only the CTP edition of SSMS as a result.|||Will it get any importance if this is posted in Microsoft connet?|||

Hello,

Did this ever get resolved? I am now having the same problem with katmai CTP3.

-Jamie

|||

If you are reading this thread and think you can help me, please reply and let me know.

-Jamie

|||

I was so disgusted that I asked for a refund of the $99 (which they provided without hesitation).

It is a sad day when the author of the software can't get it to install on a state-of-the-art hardware platform and latest software service packs and mainstream operating system.

I hope this helps.

|||

Jon,

As you can see from above I had the same problem with katmai CTP3.

If you want to know if DTC is installed or not go to a command window and type "msdtc". If it returns without barfing at you then you know its installed.

hope that helps.

-Jamie

|||

Sorry for the delay in writing...

DTC is installed and is running successfully on the computer in question. So, on my WinXPSP2 system, DTC is not the issue...

Cannot Installing SP3 on SQL Server 2000

I am trying to install sp3 on sql server 2000 and receive the message that the user cannot be validated. I have already tried both methods of fixing this error under http://support.microsoft.com/?kbid=814844. I have also updated to MDAC 2.8. I have tried
running sp3 as the sa. any other ideas other then reinstalling SQL2000
Some other ideas here:
http://www.aspfaq.com/2440
http://www.aspfaq.com/
(Reverse address to reply.)
"byouness" <byouness@.discussions.microsoft.com> wrote in message
news:49DA776E-4BE3-490E-B4D1-EE0A8CF4BB17@.microsoft.com...
> I am trying to install sp3 on sql server 2000 and receive the message that
the user cannot be validated. I have already tried both methods of fixing
this error under http://support.microsoft.com/?kbid=814844. I have also
updated to MDAC 2.8. I have tried running sp3 as the sa. any other ideas
other then reinstalling SQL2000

Cannot Installing SP3 on SQL Server 2000

I am trying to install sp3 on sql server 2000 and receive the message that the user can
not be validated. I have already tried both methods of fixing this error under p://support.microsoft.com/?kbid=814844." target="_blank">htt
p://support.microsoft.com/?kbid=814844. I have also updated to MDAC 2.8. I h
ave tried
running sp3 as the sa. any other ideas other then reinstalling SQL2000Some other ideas here:
http://www.aspfaq.com/2440
http://www.aspfaq.com/
(Reverse address to reply.)
"byouness" <byouness@.discussions.microsoft.com> wrote in message
news:49DA776E-4BE3-490E-B4D1-EE0A8CF4BB17@.microsoft.com...
> I am trying to install sp3 on sql server 2000 and receive the message that
the user cannot be validated. I have already tried both methods of fixing
this error under http://support.microsoft.com/?kbid=814844. I have also
updated to MDAC 2.8. I have tried running sp3 as the sa. any other ideas
other then reinstalling SQL2000

Cannot Installing SP3 on SQL Server 2000

I am trying to install sp3 on sql server 2000 and receive the message that the user cannot be validated. I have already tried both methods of fixing this error under http://support.microsoft.com/?kbid=814844. I have also updated to MDAC 2.8. I have tried running sp3 as the sa. any other ideas other then reinstalling SQL2000Some other ideas here:
http://www.aspfaq.com/2440
--
http://www.aspfaq.com/
(Reverse address to reply.)
"byouness" <byouness@.discussions.microsoft.com> wrote in message
news:49DA776E-4BE3-490E-B4D1-EE0A8CF4BB17@.microsoft.com...
> I am trying to install sp3 on sql server 2000 and receive the message that
the user cannot be validated. I have already tried both methods of fixing
this error under http://support.microsoft.com/?kbid=814844. I have also
updated to MDAC 2.8. I have tried running sp3 as the sa. any other ideas
other then reinstalling SQL2000

Cannot install Workstation components, fails on report server upgrade

I have hard time installing July CTP as it is failing on workstation component and fails on report server upgrade.

Any ideas for ther resolution.

Property(S): AdministratorsGroup = BUILTIN\Administrators
Property(S): PerformanceMontiorUsersGroup = BUILTIN\Performance Monitor Users
Property(S): PerformanceLogUsersGroup = BUILTIN\Performance Log Users
Property(S): UsersGroup = BUILTIN\Users
Property(S): SCMNetworkServiceAccount = NT AUTHORITY\NetworkService
Property(S): SCMLocalServiceAccount = NT AUTHORITY\LocalService
Property(S): IISCHECKED = 1
Property(S): SqlIISInstalled = 1
Property(S): SqlASPNETInstalled = 1
Property(S): SqlCOMPlusInstalled = 1
Property(S): RSPREREQUISITECHECKED = 1
Property(S): RSSqlPoolLimit = 100
Property(S): RSGUIDVALUE = {ec3b61d7-2813-485b-a55d-e0c931740946}
Property(S): RemoveFeatureList = Client_Components,Connectivity,SQL_Tools,SQL_WarehouseDevWorkbench,SDK,SQLXML,Tools_Legacy,TOOLS_BC_DEP,SQL_Documentation,SQL_Samples,SQL_BooksOnline,SQL_DatabaseSamples
Property(S): SqlOriginalMachineName = TAHITI
Property(S): Namechecksumcommon_32 = Developer Edition
Property(S): SqlSubDir = \MSSQL
Property(S): EditionTypechecksumcommon_32 = Developer Edition
Property(S): Namechecksumtools = Developer Edition
Property(S): EditionTypechecksumtools = Developer Edition
Property(S): ValidMOFInstanceName = 1
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer
Property(S): RSVirtualDirectoryManager = Reports
Property(S): SQLStatusBeforeInstall = 3
Property(S): SOURCEDIR = Z:\Tools\Setup\
Property(S): SourcedirProduct = {D6251ACA-3FD4-49D1-8FCF-182B980B19E3}
Property(S): HxDs_Tmp_3643236F_FC70_11D3_A536_0090278A1BB8 = C:\DOCUME~1\abahl\LOCALS~1\Temp\HxEA.tmp
Property(S): HxDs_Tmp_Hash_3643236F_FC70_11D3_A536_0090278A1BB8 = B40B0DC6C3C19C68E0101E0E2A647F0C3A18F6
Property(S): InstallNgenTicks = 1750000
Property(S): ProductToBeRegistered = 1
MSI (s) (38:20) [17:31:47:165]: Note: 1: 1708
MSI (s) (38:20) [17:31:47:165]: Product: Microsoft SQL Server 2008 Tools -- Installation failed.

You shouldn't be able to upgrade your report server. We don't support upgrade in the July CTP. Can you install a new instance?|||

No I am not trying to upgrade, but trying to install a clean install on windows 2003 box and I cannot.

Any thoughts, ideas.

Atul

|||What if you don't install the workstation tools? Just install the Report Server and see if you can configure it. Can you install the relational database by itself?|||

I am able to install the report server as well as the db from the looks of it.

But since management studio does not gets installed, I cannot verify or do anything with the DB.

I need to evaluate reporting services so it is very crucial to get this up and running.

Atul

|||You don't need Management Studio to use Reporting Services. But if you really need it on this machine, I would recommend you post the question over in the Katmai setup forum.

Cannot install Workstation components, fails on report server upgrade

I have hard time installing July CTP as it is failing on workstation component and fails on report server upgrade.

Any ideas for ther resolution.

You shouldn't be able to upgrade your report server. We don't support upgrade in the July CTP. Can you install a new instance?|||

No I am not trying to upgrade, but trying to install a clean install on windows 2003 box and I cannot.

Any thoughts, ideas.

Atul

|||What if you don't install the workstation tools? Just install the Report Server and see if you can configure it. Can you install the relational database by itself?|||

I am able to install the report server as well as the db from the looks of it.

But since management studio does not gets installed, I cannot verify or do anything with the DB.

I need to evaluate reporting services so it is very crucial to get this up and running.

Atul

|||You don't need Management Studio to use Reporting Services. But if you really need it on this machine, I would recommend you post the question over in the Katmai setup forum.

Cannot install Workstation components, fails on report server upgrade

I have hard time installing July CTP as it is failing on workstation component and fails on report server upgrade.

Any ideas for ther resolution.

You shouldn't be able to upgrade your report server. We don't support upgrade in the July CTP. Can you install a new instance?|||

No I am not trying to upgrade, but trying to install a clean install on windows 2003 box and I cannot.

Any thoughts, ideas.

Atul

|||What if you don't install the workstation tools? Just install the Report Server and see if you can configure it. Can you install the relational database by itself?|||

I am able to install the report server as well as the db from the looks of it.

But since management studio does not gets installed, I cannot verify or do anything with the DB.

I need to evaluate reporting services so it is very crucial to get this up and running.

Atul

|||You don't need Management Studio to use Reporting Services. But if you really need it on this machine, I would recommend you post the question over in the Katmai setup forum.

Cannot install Workstation components, fails on report server upgrade

I have hard time installing July CTP as it is failing on workstation component and fails on report server upgrade.

Any ideas for ther resolution.

You shouldn't be able to upgrade your report server. We don't support upgrade in the July CTP. Can you install a new instance?|||

No I am not trying to upgrade, but trying to install a clean install on windows 2003 box and I cannot.

Any thoughts, ideas.

Atul

|||

What if you don't install the workstation tools? Just install the Report Server and see if you can configure it. Can you install the relational database by itself?|||

I am able to install the report server as well as the db from the looks of it.

But since management studio does not gets installed, I cannot verify or do anything with the DB.

I need to evaluate reporting services so it is very crucial to get this up and running.

Atul

|||

You don't need Management Studio to use Reporting Services. But if you really need it on this machine, I would recommend you post the question over in the Katmai setup forum.

Wednesday, March 7, 2012

cannot install sql server 2005 as SSL-certificate is missing

Hi there U all,

for the third time I am installing SQL-Server 2005 express and i have an error.

Cannot install sql because .NET 2.0 framework is missing allthough I have the .NET 2.0 framework allready installed and even re-installed it too. When trying again I get the message that there isn't an SSL-certificate present.

My question is, would this probably cause the error when installing?

Anyone?

Grtz and thx,

Recloose(Thomas)

Hi Thomas,

It's hard to tell what the problem might be without an actual error message, but there are a number of questions about install errors related to IIS in the forums that you could search for. Here are a couple:

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

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

Mike

Saturday, February 25, 2012

Cannot install SP1 on SQL Server 2005 (64bit)

Hi,

I'm having problems installing SP1 on one of our servers.

If I try to install the x64 version of SP1 setup says it can not update my server and I should use x86 version. Trying to install the x86 version results in the message I should use x64 version....

Any ideas?

Regards, Jan

What version of SQL do you have on the machine? x64 or x86? And when are you getting the error?

Thanks,
Sam Lester (MSFT)

|||

Hi Sam,

version is Microsoft SQL Server Standard Edition (64-bit). I get this error after doubleclicking the service pack .exe file.

Regards,

Jan

|||

OK, just to confirm what is on the box, can you go to Add/Remove Programs, click on change, and then on Report. This will show everything that the discovery process finds associated with SQL Server. This may help us figure out why the detection is giving you the error.

Also, can you supply the package name that you're trying to run?

Thanks,
Sam

|||

Hi Sam,

here is the report:

SIAM

The following components are installed on this server

MSSQLSERVER

Analysis Services