?
Solved

Specified cast is not valid. SPS 2.0 edit or add new items

Posted on 2010-09-07
14
Medium Priority
?
732 Views
Last Modified: 2012-05-10
SBS2003 R2.  
Sharepoint services 2.0 on SQL2005 workgroup.
Companyweb displays general documents but clicking to add a new items brings an error page with
Specified cast is not valid.
at the same time an event 5586 is logged
I get the same error when accessing a certain calendar as well.
named pipes is enabled.
Unknown SQL Exception 2 occured. Additional error information from SQL Server is included below.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Open in new window

0
Comment
Question by:livegirllove
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
14 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33624407
>> A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.

Make sure Remote connections are enabled in SQL Server 2005 as per:

http://support.microsoft.com/kb/914277

And the below configurations are set correctly as per

http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
0
 
LVL 1

Author Comment

by:livegirllove
ID: 33624431
looks like the problem is a bit deeper.
I get errors when trying to connect with SSME and surface area configuration
This logged into the server and using ssme or configuration.

TITLE: Surface Area Configuration
------------------------------

Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC)

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

An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.InnerWmiException&LinkId=20476

------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

Could not load file or assembly 'Microsoft.SqlServer.SqlEnum, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The module was expected to contain an assembly manifest. (mscorlib)

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

OK
------------------------------
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33624447
>> looks like the problem is a bit deeper.
I get errors when trying to connect with SSME and surface area configuration

Yes, seems like either your .Net framework installation is corrupted or uninstalled by some other..
Try installing .Net Framework 2.0 with SP2 and .Net Framework 4.0

Also try installing SP3 for SQL Server 2005 which might help fix some of these common issues.
0
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 
LVL 1

Author Comment

by:livegirllove
ID: 33624528
ill try the .net
SQL sp3 is installed.
0
 
LVL 1

Author Comment

by:livegirllove
ID: 33624878
.net 2 sp2 says its already installed and to use add/remove to change it.
.net 4 installed no problem but didnt fix access to surface area config etc.  Rebooting the server now.
verified sp3 for sql is installed and it says cannot be removed so I cant reinstall it either.

bleh.  server hung on reboot.  I cant reconnect. Ill check it in the am and let you know.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33626803
>> .net 2 sp2 says its already installed and to use add/remove to change it.

Uninstall and install .Net Framework 2.0 along with SP2.

>> verified sp3 for sql is installed and it says cannot be removed so I cant reinstall it either.

SP3 can't be removed and that way won't work either.

>> bleh.  server hung on reboot.  I cant reconnect.

Do you have any resource contention on that server.
Or is your server suffering for resources.
0
 
LVL 1

Author Comment

by:livegirllove
ID: 33633193
server is not overloaded.
.Net2 wont uninstall via add/remove because it will affect other applications.  Im thinking of using the .net cleanup tool.
0
 
LVL 1

Author Comment

by:livegirllove
ID: 33633203
oh the resource comment was re the server hangin.  I actually found out that it didnt hang completely.  RDP locked up but all the other services were clicking along fine.  I re... rebooted it and it took this time.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33633998
>> .Net2 wont uninstall via add/remove because it will affect other applications.  Im thinking of using the .net cleanup tool.

If SQL Server services are shut down, you should be able to uninstall and reinstall without any issues.
Because .Net is a framework, if the dependent applications are closed it should be able to do.

>> RDP locked up but all the other services were clicking along fine

Make sure that both SQL Server and OS are applied the latest Service packs or patches..
0
 
LVL 1

Author Comment

by:livegirllove
ID: 33643836
i havent forgotten the question.  just havent had a chance to get to it.  will work on it tomorrow and post back.
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 33643855
Sure..
0
 
LVL 1

Author Comment

by:livegirllove
ID: 33742134
The resolution is to reinstall windows.  Core windows .net DLLs are corrupt.  repair install didnt repair them.
Thanks for the help.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33754041
Welcome..
And kindly close the question accordingly.
0
 
LVL 1

Author Closing Comment

by:livegirllove
ID: 33754726
tx
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question