Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Upgrading a Database SQL 2000 to SQL 2005 Expand / Collapse
Author
Message
Posted Thursday, May 3, 2007 11:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:08 AM
Points: 48, Visits: 3,646
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/ssamuel/2987.asp
Post #363077
Posted Monday, May 7, 2007 6:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 17, 2009 2:50 AM
Points: 1, Visits: 21

Perfect article..... Simple and easy to understand even for someone like me with little or no idea about SQL

Good Going Sachin

GK

Post #363615
Posted Tuesday, May 8, 2007 7:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 30, 2014 12:11 PM
Points: 3, Visits: 87

Excellent Article! Step by step details with snapshot that makes it easy for the first time user. Including all the details.

Keep it up!

Deepa

Post #363980
Posted Wednesday, May 16, 2007 1:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 30, 2008 5:50 AM
Points: 6, Visits: 2

We carried out an inplace upgrade and the database works fine, BUT, when we run the Surface Area Configurator the database is not found! Any ideas please?

Thanks

M

Post #366219
Posted Wednesday, May 16, 2007 1:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:08 AM
Points: 48, Visits: 3,646

Hi Mark,

Surface area never displays your database. But the services installed on your box. It provides interface for enabling or disabling many Database Engine, Analysis Services, and Reporting Services features. Disabling unused features helps to secure your Microsoft SQL Server installations by reducing the SQL Server surface area.

Hope I answered your query.

Regards

Sachin

Post #366225
Posted Wednesday, May 16, 2007 2:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 30, 2008 5:50 AM
Points: 6, Visits: 2

Thanks Sachin

Sorry maybe I did not make myself quite clear. The surface area configurator does not find my sqlserver service, so I am unable to configure the service particularly email notifications.

How can I get it to find my sqlserver service?

Thanks

M

Post #366228
Posted Wednesday, May 16, 2007 4:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:08 AM
Points: 48, Visits: 3,646

Mark,

On clicking Surface area configuration link, a small window appears with the following links

1) Surface Area configuration for Service and connections.

2) Surface Area configuration for features.

Seems like you clicking only on second link to check for the services.

You can manage Sql Server 2005 services as well as remote connections from the first link.

Please let me know incase you have any query or need further clarifications.

Best Regards

Sachin

 

 

 

Post #366260
Posted Wednesday, May 16, 2007 5:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 30, 2008 5:50 AM
Points: 6, Visits: 2

Sachin

No, I can only see my BackupExec service and not my SQL2005 service via option 1!!

Any ideas?

Thanks.

Mark

 

Post #366269
Posted Wednesday, May 16, 2007 5:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:08 AM
Points: 48, Visits: 3,646

Mark,

Which Edition of SQL server 2005, you have upgraded to?

Regards

Sachin

Post #366279
Posted Wednesday, May 16, 2007 5:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 30, 2008 5:50 AM
Points: 6, Visits: 2

Hi

Standard Edition + latest service pack.

Thanks

Post #366280
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse