<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 General Discussion
»
Cannot enter Surface Area Configuration on a...
24 posts, Page 2 of 3
««
1
2
3
»»
Cannot enter Surface Area Configuration on a SQL instance
Rate Topic
Display Mode
Topic Options
Author
Message
Lynn Pettis
Lynn Pettis
Posted Wednesday, October 01, 2008 9:41 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 10:02 PM
Points: 9,728,
Visits: 9,575
Curious, is there any other software installed on the system? In particular, I am wondering if the Windows Internal Database (aka SQL Server 2005 Embedded Edition) is installed on the server as well.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #579179
jsheldon
jsheldon
Posted Wednesday, October 01, 2008 9:42 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, September 14, 2009 1:59 PM
Points: 516,
Visits: 425
I did run the script for the sqlmgmproviderxpsp2up.mof and it ran but I still have the error...
Thanks for the help if you have any other ideas send them my way..
Post #579182
jsheldon
jsheldon
Posted Wednesday, October 01, 2008 9:43 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, September 14, 2009 1:59 PM
Points: 516,
Visits: 425
Hi Lynn,
Nope we only have one instance of SQL on this server. This is our ERP server and is dedicated only to our ERP software and SQL database installation
Post #579186
David Benoit
David Benoit
Posted Wednesday, October 01, 2008 9:44 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, November 05, 2009 8:31 AM
Points: 1,473,
Visits: 1,986
See Lynn's question. Very valid.
Other than that it certainly seems like some reinstalling would be the next steps in order to get those working.
David
Post #579189
David Benoit
David Benoit
Posted Wednesday, October 01, 2008 9:49 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, November 05, 2009 8:31 AM
Points: 1,473,
Visits: 1,986
By the way, did you get the "done" message at the end of the configuration run or did it fail?
David
Post #579192
Lynn Pettis
Lynn Pettis
Posted Wednesday, October 01, 2008 9:50 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 10:02 PM
Points: 9,728,
Visits: 9,575
I just wanted to be sure. We have WSS installed on one of our development servers, and I have to shutdown the Windows Internal Database to run the Surface Area Configuration on the instance of SQL Server 2005 (default instance) when changes need to be made (which is not all that often but it is a rbitb).
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #579193
jsheldon
jsheldon
Posted Wednesday, October 01, 2008 10:06 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, September 14, 2009 1:59 PM
Points: 516,
Visits: 425
i got the done message..it ran as per the blog....
No Windows Internal Database service on this server. the WMI service is automatic and started
Post #579209
Prasanna Sridharan
Prasanna Sridharan
Posted Wednesday, October 15, 2008 10:55 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, December 04, 2008 1:27 AM
Points: 5,
Visits: 6
Hi jsheldon,
Were you able to resolve the issue, even i am facing the same. probably i need to reinstall the sql.
Post #586715
jsheldon
jsheldon
Posted Thursday, October 16, 2008 7:50 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, September 14, 2009 1:59 PM
Points: 516,
Visits: 425
Prasanna Sridharan (10/15/2008)
Hi jsheldon,
Were you able to resolve the issue, even i am facing the same. probably i need to reinstall the sql.
Unfortunately I have not...and I cannot reinstall as this is our production ERP system. I guess I will just have to use these remotely or via sp_configure proc...
I would be interested in resolving this though...it did work in the past...
Post #586979
billzini
billzini
Posted Sunday, October 19, 2008 12:33 PM
Forum Newbie
Group: General Forum Members
Last Login: Monday, June 08, 2009 3:21 PM
Points: 1,
Visits: 27
I too am seeing the same problem. THe SQL configuration manager and the Surface Area Config are not connecting. In addition to that, my mgmt studio will open and connect, however after that if you try to expand a folder or click on anything, I simply get a 'busy' error. All of these tools worked fine previously. If anyone solves this please post.
Post #588300
« Prev Topic
|
Next Topic »
24 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
