SQL Server can’t find the data

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server can’t find the data

Author

Topic

Charles Egan
Starting Member

21 Posts

Posted - 2013-05-22 : 22:18:37

I downloaded file SQLEXPRADV_x86_ENU.exe (version 10.00.1600.22), and used it to install SQL Server 2008 Express with Advanced Services, which I think has capabilities comparable to SQL Server 2008 Enterprise.

Upon install, all Prerequisite conditions were met, and installation was completed with no failures.

This version of SQL Server includes SQL Server 2008 Management Studio Express. The Management Studio doesn't show in Add or Remove Programs, and there's no icon for it on my desktop, but it does appear at Start | All Programs | Microsoft SQL Server 2008 | SQL Server Management Studio.

I then downloaded file SQL2008.AdventureWorks_All_Databases.x86.msi, and attempted to use it to install AdventureWorks Sample Databases for SQL Server 2008.

I got the following error:

"PrepInstance() failed for MSSQL$SQLEXPRESS.
The following features are missing: Full Text Search
Fix the problems and re-run setup."

When I ran the Management Studio, it said:

Server type: Database Engine
Server name: NULL\SQLEXPRESS
Authentication: Windows Authentication

and gave me the following error:

"Could not connect to NULL\SQLEXPRESS. Server not found or not accessible."

I guess this must be because NULL is not a valid directory.

Now the Server name is just coming up blank.

Any help?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-23 : 00:22:55

Try using Machinename\SQLEXPRESS

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Charles Egan
Starting Member

21 Posts

Posted - 2013-05-23 : 14:48:03

I tried server names SQLSERVER, \SQLSERVER & .\SQLSERVER, all with the same error.

Charles Egan
Starting Member

21 Posts

Posted - 2013-05-23 : 14:51:43

Sorry, I meant I tried SQLEXPRESS, \SQLEXPRESS and .\SQLEXPRESS, all resulting in the same error.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-05-23 : 15:33:22

Are you sure you installed the Database Engine ?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Charles Egan
Starting Member

21 Posts

Posted - 2013-05-23 : 16:40:01

Hi, jackv -

I successfully installed SQL Server, so I assumed the database engine was installed. How would I check that?

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2013-05-23 : 17:29:31

You can check the running services and verify that the SQL Server serivce is available and started.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-24 : 00:27:47

go to start-> programs ->Microsoft SQL Server-> Configuration tools -> SQL Server Configuration Manager
Click on SQL Server Services nodes and see if you've SQL Server services listed and is running

You can also check this by typing services.masc in start -> run and then looking for SQL Server services

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Charles Egan
Starting Member

21 Posts

Posted - 2013-05-25 : 14:58:40

Hi, Lamprey & visakh16 -

In SQL Server Configuration Manager, SQL Server (SQLEXPRESS) is shown as STOPPED. Trying to start it gives the following error:

"The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."

I can't find any logs.

In the process of downloading and installing SQL Server 2008 Express with Advanced Services, I was never assigned or informed of any account that I needed in order to use SQL Server, so maybe that's the problem.

Any suggestions?

Rasta Pickles
Posting Yak Master

174 Posts

Posted - 2013-05-26 : 02:06:45

It was probably just me but I found that if you try anything much more complicated than


SELECT * FROM

in Express then the software throws its hands in the air and protests.

Not sure why Microsoft would release such a crippled product even for free?

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-05-27 : 00:23:43

Can you post the specific error message in the application log (Start --> Control Panel --> Administrative Tools --> Event Viewer --> Windows Logs --> Application

Refer to fix above error:
http://hightechnology.in/the-request-failed-service-respond-timely-fashion-consult-event-log-applicable-error-logs-details/
http://blog.sqlauthority.com/2011/03/29/sql-server-fix-error-the-request-failed-or-the-service-did-not-respond-in-timely-fashion-consult-the-event-log-or-other-applicable-error-logs-for-details/

--
Chandu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-27 : 01:06:42

quote:
Originally posted by Rasta Pickles

It was probably just me but I found that if you try anything much more complicated than

SELECT * FROM

in Express then the software throws its hands in the air and protests.

Not sure why Microsoft would release such a crippled product even for free?

Nope...not true
Its a fully functional database with limited features but certainly most of the basic t-sql things can be done.
I'm not sure what exactly is problem in your case but explanation above is definitely a bit exaggerated IMHO!

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Rasta Pickles
Posting Yak Master

174 Posts

Posted - 2013-05-27 : 02:04:15

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=171550

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-27 : 03:44:19

quote:
Originally posted by Rasta Pickles

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=171550

Sorry I cant understand what this has to do with SQL Express. It speaks of SQL Compact edition which is different. It obviously has lots of limitations compared to tranditional sql server
The error you got during installation of Express was it missing a reference dll which might be problem with media you used for installation

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Charles Egan
Starting Member

21 Posts

Posted - 2013-05-28 : 18:58:59

I'm trying to install AdventureWorks sample databases. (I'm running under Windows XP.)

Here's what I did so far:

1. downloaded:
• SQLEXPRADV_x86_ENU.exe (version 10.00.1600.22)
• SQL2008.AdventureWorks_All_Databases.x86.msi
• Windows PowerShell (version 2)

2. logged onto PC as Administrator

3. installed PowerShell

4. ran SQLEXPRADV_x86_ENU.exe to install SQL Server 2008 Express with Advanced Services

5. enabled SQL Server:

Start | All Programs | Microsoft SQL Server 2008 | Configuration Tools | SQL Server Configuration Manager (right click, run as Administrator) | SQL Server Services | SQL Server (SQLEXPRESS) | Log On | local system account, Start

6. connected to SQL Server:

Start | All Programs | Run Microsoft SQL Server 2008 | SQL Server Management Studio

Server type: Database Engine
Server name: NULL\SQLEXPRESS <-- NULL is my machine name
Authentication: Windows Authentication

Now I want to start the SQL Server Full Text Filter Deamon Launcher (MSSQLSERVER) so I can run SQL2008.AdventureWorks_All_Databases.x86.msi in order to install the AdventureWorks sample databases.

The Deamon isn't showing up in

Start | Control Panel | Administrative Tools | Services

or

Start | All Programs | Microsoft SQL Server 2008 | Configuration Tools | SQL Server Configuration Manager | SQL Server Services

But when I click on

Start | All Programs | Microsoft SQL Server 2008 | Configuration Tools | SQL Server Installation Center | Installation | New SQL Server stand-alone installation or add features to an existing installation

in order to launch the Daemon, this brings up a "Browse for Folder" Window with the message "Browse for SQL Server 2008 Installation Media".

Selecting the folder where I downloaded SQLEXPRADV_x86_ENU.exe to doesn't work. Apparfently what's needed is to select some other folder which is a temporary folder put on the PC while SQLEXPRADV_x86_ENU.exe is running, and then this folder is deleted.

I found instructions "SQL server 2008 Installation media"for how to deal witht this at

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/6923a75d-26f4-44df-9b1b-ccb70a37a6fd

but these instructions are for Windows 7, not Windows XP.

Any help? Thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources