surface area configuration

surface area configuration

• BigBoom

  Hey Buck,

  I've read both of those a couple times. Didn't apply to this problem though. I'm working with my hosting provider to get SQL Server re-installed. Hopefully that'll fix whatever's missing / not running. If not, I'll let you know.

  Thanks for trying.

  
  

• Giri

  1. Go to the server

  2. Open the SQL Server Configuration Management tool

  3. Ensure that the Protocols enabled include TCP/IP

  4. Open the Surface Area Configuration Tool on the server

  5. Look for the Database Engine to be enumerated. If not, there is a problem with the configuration.

  Here is some more information that might help:

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

  And

  http://msdn2.microsoft.com/en-us/library/ms345332.aspx

  
  
  

• in.the.dark

  That's odd. Let's try here first to make sure it isn't something basic:

  http://msdn2.microsoft.com/en-us/library/ms161956.aspx

  And then perhaps we're facing a SQL Server Browser issue. Check the steps here:

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

  And ensure that all your services that start SQL Server are domain or local accounts, not system accounts. Let me know if that helps.

  
  
  

• ArnsteinD

  I got my hosting provider to re-install SQL Server. That fixed the problem.

  For whatever reason, their default drive image didn't work right. Once the install completed I was able to get into SA Config and enable remote connections. Hopefully, anyone else having this problem can re-install MSSQL with similar success.

  

  
  

• RamyaP

  Yeah, I tried that...

  When I open SA Config I only see the Reporting Services node.

  If I look at the SQL Server Service Manager it shows SQL Server is running.

  This install was done by my hosting provider when I leased the server...

  I've read your two links, but they don't address situations where the engine's node is completely absent from the SA Config. I have SQL Server 05 developer edition on my in-house test server, and I can change the SA settings fine on that.

  Any ideas Thanks.

  
  

• Luxsy

  You can check the services in the Configuration Manager. The engine should not have to be running to use the tool, but I wanted to make sure it was installed. So you're saying that everything is OK now
  
  

• Yaniv75

  Is the database engine running when you open the tool Are you connecting to the local instance of the server
  
  

• Sailu

  I cannot connect to remote server using the configuration manager. However I am sure the service is installed because this is the database that we use for development. I am not saying everything is ok. I still cannot see or configure the database engine remote connection.
  

• b0bd0gz

  Did you try the steps above What were the results
  
  

• Xcel

  lol rofl lol n00b *** lol.

  I'm having the same problem. On my own local server I installed SQL Server 05 and can readily access the SA Config tool and enable remote access. On my leased dedicated server, however, I don't have the database engine node either. Maybe there was some option set during install that eliminates access to it, but we're trying to find out how to get around that.

  Anybody

  
  

• ZaijiaN

  How can I tell that the database engine is running We are conecting now remotely but I think the dbas were connected locally.
  
• surface area configuration