.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Asad Ali
Post New Web Links

No Servers listed under Database Engine in SQL Server 2008 on Windows Server 2008 R2.

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
 
Where to begin. It's late so I hope I can be clear. I have installed SQL Server 2008. I am running Windows Server 2008 R2. I have installed SQL Server four times and I continue to have issues connecting to the Database Engine. Installation has gone without a problem at least to my knowledge I have not been presented with any errors. I have also created a local administrator account called "spadmin" to use to connect to the SQL Server database and to use with SharePoint 2010. Which brings me to the reason why I want to run SQL Server - I want to evaluate the latest SharePoint Server 2010 and WSS. Unfortunately, I have not been able to go beyond installing SQL Server and connecting to the database, because there is no database instance showing under the Database Engine, except under Integration Services. I have the following services installed: SQL Acitivey Directory Helper Service SQL Full-text-Filder Daemon Launcher SQL Server SQL Server Agent SQL Server Analysis Service SQL Server Browser SQL Server Integration Services 10.0 SQL Server Reporting Services SQL Server VSS Writer Am I missing something? I have been following several online instructions on how to install SQL Server 2008 and I can't seem to find where I may have gone wrong. After I install SQL Server 2008 am I supposed to see the default instance (MSSQLSERVER) listed under the Database Eng


View Complete Post


More Related Resource Links

SQL Server 2008 Windows Authentication Mode fails for Database Engine, error 18456

  
I installed SQL Server 2008 Developer Edition (10.0.1600.22.080709-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).   Since this is a development machine, I saw no need for Mixed Mode when I did the install.  The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine!Windows Authentication for the Database Engine gives the following error: EventID: 18456Login failed for user MYDOMAIN\MYLOGIN'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.  Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode).  It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Before I do so, does anyone know of a better approach?Scott D Duncan

Can SSAS 2005 run with Sql Server 2008 database engine?

  
Are there any known issues of running SSAS 2005 with SQL Server 2008 database engine?

0x80040154 error processing a cube from SQL Server 2008 R2 x64 database engine to OLAP Server 2000 x

  

I recently upgrade from SQL Server 2000 x32 to SQLServer 2008 R2 x64 but only the database engine not the Analysis Server, I used to use this code to proces the cubes.

http://weblogs.sqlteam.com/jeffs/archive/2008/10/27.aspx

but now it do not  work more with the error:
Error at create server:
Error      Source                    Description          HelpFile HelpID
---------- ------------------------- -------------------- -------- -----------
0x80040154 ODSOLE Extended Procedure  Clase no registrada NULL     0

(1 row(s) affected)

I found this article:
http://support.microsoft.com/kb/932872

It means that I can not process the cube using the same method any more ?


SQL Server 2008 R2 installation error "Could not find the Database Engine startup handle."

  

Hi,

I am unable to install SQL Server 2008 R2 Developer Edition (x86) on my Windows 2008 (32 bit) virtual machine. It fails everytime with "Could not find the Database Engine startup handle." error.

Any pointers?


SQL Server 2008 Developer Installation Error - Database Engine Failure

  

I am  trying to install SQL Server 2008 Developer Edition licensed version on my Windows XP Pro SP3 machine and Database Engine feature fails. Could anyone please help me with this issue.

From the Summary.txt

Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -2068643839
  Exit facility code:            1203
  Exit error code:               1
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:                    2010-10-13 21:53:18
  End time:         

Messenger service is not in Windows 2008 but Sql Server 2008 is asking for it to run Database Mail

  

so how do you make Database Mail work in SQL Server 2008 without messenger service

Pat M

 


PatM Reno

SQL server express 2008 R2 , Could not find the Database Engine startup handle.

  

when i set the SQL Server database engine to NT AUTHORITY\NETWORK SERVICE the install works correctly but when i set it to NT AUTHORITY\SYSTEM i get a "Could not find the Database Engine startup handle." error , The Database engine services is not installed

 

The Summary Log File

=====================================

Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Exit code (Decimal):           -2061893609
  Exit facility code:            1306
  Exit error code:               23
  Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
  Start time:               

MS SQL Server 2008 - Database Engine problem

  

Hi,

I need to create a new database for our GFI Archiver. Unfortunately, there is a problem with connection to Database Engine.

Everytime when I try to connect to DE I have these errors:

1. error:18456, severity:14, state:1

2.error:233, severity:20, state:0

I am not really sure how the SQL Server was set-up so it is difficult to say what type of passwords were set-up.

Our server is connected to our Domain and I am logged as a Domain administrator on the server.

I tried different passwords (admin, local admin) and different type of authentication without any results.

I can connect to the all services apart of database engine and I have access to the Windows 2008R2 server's "services" as well.

I can not access to the existing databases either and I can not create database even using Analysis server.

Could you help me please?

Thank you,

Regards,

Sebastian

 

 


Will SQL Server 2008 Developer Edition install on Windows 7 64-bit Professional? OS not listed on re

  
I just purchased Windows 7 Professional  for installation on an Intel 64-bit laptop. I planned on purchasing SQL Server 2008 Developer Edition but noticed that Windows 7 Professional is missing on the requirements list. 

I was hoping someone here could verify that SQL Server 2008 Developer Edition will install on the OS mentioned above. 

Here's the requirements page I was viewing:

Thanks!
Peter

Does SQL server 2000 database supported on Windows Server 2008?

  
Does SQL server 2000 database supported on Windows Server 2008 and Windows Server 2008 R2?
maifs

sql server 2008 r2 install does not create database engine, also mmc creates error "Failed to create

  

I am loading sql server 2008 r2 developer edition into Windows Vista Home Basic. Product loads correctly with no error messages; except will not create database engine. And will not create integration services. When I try to open MMC, I will get error "MMC could not initialize the snap-in. Product may not have been installed correctly."

I understand this is a known issue for SQL Server 2008 RD installing on Windows Vista? What is the workaround or fix? Hot fixes available for this issue from support.microsoft.com do not install on my Windows Vista Home Basic machine.

 


Migrating from Windows Internal Database to SQL Server Express 2008 r2

  

What's the best way to migrate my existing Windows Internal Database to SQL Server Express 2008 r2? I see tutorials for 2005 are the steps any different?

 

2005 Tutorial

http://blogs.technet.com/b/sus/archive/2008/07/15/wsus-how-to-migrate-your-wsus-windows-internal-database-to-sql-server-2005-express-edition.aspx

sql server 2008 adventureworks database

  

dear Friends


For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 


And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
WHEN NOT MATCHED BY TARGET THEN
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
WHEN NOT MATCHED BY SOURCE THEN
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	


Please help me to overcome this issue and let me know where can I download that database too.


Thanking you

happy Coding


Word Automation Issue in Windows Server 2008 Hosting

  

Hi,

The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.


With Regards,

Ashok



No ASPNET User in Windows Server 2008?

  

I have been looking everywhere online regarding this, but have not found a clear answer.

 

I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.

 

I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.

 

I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.

 

Did I set the server up wrong? or do I have to do something within ASP.Net to  create this user and then give it rights? 


Not working on Windows Server 2008

  

Hi,

 

I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.

We are using SharePoint 2007.

Is there another work thru for 64bit environment.

I notice windows server 2008 has a directory  C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???

Please help!


How can Install Office 2007 on Windows server 2008 R2 64 bit machine in WSS 3.0

  
I have  64 bit machine  and Windows server 2008 R2 has installed. i have successfully install WSS 3.0  , but  when i tried to install  office 2007 ,  one  error  has  come  "OS is not compatible "  i thought  it was asking  for 64 bit office  2007   and i go through the  google and R&d find no 64 bit office is available ,  i have used   excel .dll in my custom code  so my problem is that   how can  install office 2007  on 64 bot OS 2008 r2  machine .  if anyone can help   me  , please let me know . thanks in advance
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend