Showing posts with label sp2. Show all posts
Showing posts with label sp2. Show all posts

Tuesday, March 20, 2012

"The system cannot find the file specified" upon login

I recently upgraded my WinXP Pro SP2 PC from SQL Server 2000 to SQL Server 2005. After a subsequent reboot and login, I saw a generic error message:

Error
The system cannot find the file specified.
OK

I didn't think much of it the first time, but it appears each time I reboot.

Sysinternals' Process Explorer identified the error dialog with C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe. I just realized today that upon pressing the OK button, SQL Server Service Manager appears in my system tray, with a solid white circle. Upon opening Service Manager, the Services list is empty. The status bar says it is "Not Connected". I figured the entire ..\80 directory had been removed as part of the 2000-to-2005 upgrade; however, the directory and .exe do exist. Is this normal?

Any suggestions on how to proceed?

I think your problem was caused by the SQL 2000 install. I had an old Beta 2 copy of SQL 2000 on my development system, which had long since expired, and I ran into the same problem trying to install SQL 2005 Express. I suspect you have found a solution by now, but in case someone else runs into the same problem just uninstall SQL 2005, uninstall SQL 2000 and then install SQL 2005.

I had to uninstall SQL 2000 manually by following the instructions at the following link.

http://support.microsoft.com/kb/290991/en-us

sql

"The system cannot find the file specified" upon login

I recently upgraded my WinXP Pro SP2 PC from SQL Server 2000 to SQL Server 2005. After a subsequent reboot and login, I saw a generic error message:

Error
The system cannot find the file specified.
OK

I didn't think much of it the first time, but it appears each time I reboot.

Sysinternals' Process Explorer identified the error dialog with C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe. I just realized today that upon pressing the OK button, SQL Server Service Manager appears in my system tray, with a solid white circle. Upon opening Service Manager, the Services list is empty. The status bar says it is "Not Connected". I figured the entire ..\80 directory had been removed as part of the 2000-to-2005 upgrade; however, the directory and .exe do exist. Is this normal?

Any suggestions on how to proceed?

I think your problem was caused by the SQL 2000 install. I had an old Beta 2 copy of SQL 2000 on my development system, which had long since expired, and I ran into the same problem trying to install SQL 2005 Express. I suspect you have found a solution by now, but in case someone else runs into the same problem just uninstall SQL 2005, uninstall SQL 2000 and then install SQL 2005.

I had to uninstall SQL 2000 manually by following the instructions at the following link.

http://support.microsoft.com/kb/290991/en-us

Sunday, February 19, 2012

"A transport-level error has occurred..." When linking a server.

I just installed Microsoft SQL Server Express SP2. I setup a linked server to an Oracle database using the followings commands:

EXEC sp_addlinkedserver 'Oracle_DEV', 'Oracle', 'MSDAORA', 'DEV'

EXEC sp_addlinkedsrvlogin 'Oracle_DEV ', false, NULL, 'oracledbuser', 'dbuserpassword'

When I try and query the linked database I get the following error message:

Msg 109, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

I've been searching the web and have gotten a lot of hits on the error message but have yet to uncover anything specifically related to linked servers or anything closely related enough to help me resolve this problem. Any advice would be appreciated. Thanks.I am having the exact same problem as you.. I am still trying to find a solution.. I will let you know if I do.. also if you find a solution could you post it here. Thanks|||

This is more of a general engine issue so I'm going to move it to that forum.

Mike

|||

I seem to have solved the problem.. I changed the registry settings for

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI

OracleSqlLib = orasql10.dll

OracleXaLib = oraclient10.dll

then in Admin tools / services. I stopped and started SQL server Express & SQL Server browser (not sure if this did anything - but just letting you know what worked for me)

I am now able to query the oracle database.

One thing though - it is a lot slower than using MS Access and an ODBC passthrough query

Thursday, February 16, 2012

<HTMLViewerStyleSheet> - where in config file?

I need to make use of the HTMLViewerStyleSheet parameter in SP2. I
have applied SP2 and the Hotfix, but still do not see
<HTMLViewerStyleSheet> in the RSReportServer.config file.
Am I looking in the wrong place? If not, can someone please tell me
exactly where and in what format the parameter needs to be?
Thanks
DaveForgot to mention this is for SQL 2000.
dacdev wrote:
> I need to make use of the HTMLViewerStyleSheet parameter in SP2. I
> have applied SP2 and the Hotfix, but still do not see
> <HTMLViewerStyleSheet> in the RSReportServer.config file.
> Am I looking in the wrong place? If not, can someone please tell me
> exactly where and in what format the parameter needs to be?
> Thanks
> Dave|||I added this before the final </Configuration> :
<HTMLViewerStyleSheet>MyStyleSheetName</HTMLViewerStyleSheet>
Needed to restart the ReportServer service. Works fine now.