Problem Running Sql Server 2005 Express on Vista

I have been trying to get Sql Server 2005 Express Advanced with SP2 installed and operating on my Vista machine. It seems to install ok but when I open Management Studio Express and try to create a new db or attach an existing one, I get error messages. So although it seems to be installed, I can't really use it.

When I try to create a new database I get:

TITLE: Microsoft SQL ServerManagement Studio Express

----------

Create failed for Database'practice'. (Microsoft.SqlServer.Express.Smo)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

----------

ADDITIONAL INFORMATION:

An exception occurred whileexecuting a Transact-SQL statement or batch.(Microsoft.SqlServer.Express.ConnectionInfo)

----------

CREATE DATABASE permission denied indatabase 'master'. (Microsoft SQL Server, Error: 262)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

----------

BUTTONS:

OK

----------

When I try to attach an existing database I get:

TITLE: Microsoft SQL ServerManagement Studio Express

----------

Failed to retrieve data for thisrequest. (Microsoft.SqlServer.Express.SmoEnum)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

----------

ADDITIONAL INFORMATION:

An exception occurred whileexecuting a Transact-SQL statement or batch.(Microsoft.SqlServer.Express.ConnectionInfo)

----------

The server principal"Dave-PC\Dave" is not able to access the database "model"under the current security context. (Microsoft SQL Server, Error: 916)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

----------

BUTTONS:

OK

----------

I have tried following the links in the error messages but the result is: "We're sorryThereis no additional information about this issue in the Error and EventLog Messages or Knowledge Base databases at this time. You can use thelinks in the Support area to determine whether any additionalinformation might be available elsewhere."

I am successfully using both programs on my XP SP2 machines, so I know how to install and run them on XP, just not on Vista (yet). Any suggestions on how to proceed?

I had alot of VS issues when I switched to Vista. Are you running the management studio as an admin? As a test you may want to turn off UAC and see if that fixes your issue. If it does then you just need to change the permissions that you are running with.

|||

Thanks for the suggestion. It worked and I am able to run Sql Server 2005 Express via Management Studio to create and attached databases.

Question: Do I have to toggle the UAC on and off every time I want to use SQL Server Express (or leave it off always if I am willing to accept the security issues)? Or do I have other options?

|||

I personally turned mine off just because I am the only user of the PC and I'm fairly certain that if I was going to do something harmful to my own PC I'd just turn UAC off at the time I was doing it anyway. There is however a way to set the program to always run in admin mode. I'm on an XP machine right now so I can't post instructions myself but step 3 in the below article should be what you need.

http://4sysops.com/archives/vista%E2%80%99s-uac-8-ways-how-to-elevate-an-application-to-run-it-with-administrator-rights/

|||

Thanks for help. I hope I get equally good advice as I sort out some of my other Vista problems!

problem running MS SQL Web Data Admin

Hi:
My client machine is XP Pro with SP1 with IIS 5.1 My server machine is
Windows 2000 server SP4 with IIS 5.0. Server has the latest MSDE 2000(SP3a,
in mixed mode) as well as MS SQL Web Data Admin (webadmin) installed on it.
I can use webadmin on the server to access data in MSDE using windows auth
as well as SQL login.
I then installed webadmin on the Client machine but can't get it to connect
to the MSDE on the server machine. I looked at KB article: 319930 and
ensured that test.udl on client XP machine can connect fine using TCP/IP and
sa userid to the MSDE on the server machine. But webadmin won't connect.
Here's the error message:
Server Error in '/webadmin' Application.
COM object with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not
valid or not registered.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: COM object
with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not
registered.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[COMException (0x80040154): COM object with CLSID
{10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not
registered.]
SqlAdmin.SqlServer.Connect()
SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e) +28
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
Other ASP.NET starter kit apps (like Commerce and Portal) work fine from
Client machine using MSDE on the server. The problem seems to be with
webadmin. Any suggestions would be appreciated.
Vamsee Lakamsani
lakamsani AT gmail.com
The web data admin package needs a dll called SQLDMO.dll that is a com object that is only installed from the full version of SQL server, not with MSDE. That is the com object error message you are receiving.
"vl" wrote:

> Hi:
> My client machine is XP Pro with SP1 with IIS 5.1 My server machine is
> Windows 2000 server SP4 with IIS 5.0. Server has the latest MSDE 2000(SP3a,
> in mixed mode) as well as MS SQL Web Data Admin (webadmin) installed on it.
> I can use webadmin on the server to access data in MSDE using windows auth
> as well as SQL login.
> I then installed webadmin on the Client machine but can't get it to connect
> to the MSDE on the server machine. I looked at KB article: 319930 and
> ensured that test.udl on client XP machine can connect fine using TCP/IP and
> sa userid to the MSDE on the server machine. But webadmin won't connect.
> Here's the error message:
> --
> Server Error in '/webadmin' Application.
> ----
> --
> COM object with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not
> valid or not registered.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Exception Details: System.Runtime.InteropServices.COMException: COM object
> with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not
> registered.
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> Stack Trace:
>
> [COMException (0x80040154): COM object with CLSID
> {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not
> registered.]
> SqlAdmin.SqlServer.Connect()
> SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e) +28
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +731
>
>
> ----
> --
> Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
> Version:1.1.4322.573
> Other ASP.NET starter kit apps (like Commerce and Portal) work fine from
> Client machine using MSDE on the server. The problem seems to be with
> webadmin. Any suggestions would be appreciated.
> --
> Vamsee Lakamsani
> lakamsani AT gmail.com
>
>

Problem restoring backup

I am running SQL 7...

I had a database on a Sql Server on a WinXP machine but I needed to reinstall that machine and I installed Win2k...

Before I format the machine I have made a backup from my database. Now, on the Win2k, I cant restore this backup. Sql Server shows the following error message:

The volume on device 'c:\backup.bak' is not a member of the media family.

Plz, help me on this... I dont know much about Sqlserver and this is the ONLY backup I have... The backup file seems fine... There was no errors during the backup proccess...

If u dont know whats happening, could u tell if exists some program that can read the backup file and extracts its data to another format?What I do is...
i create a backup device that is the same name as the old backup.
i then put the backup file where u set up the backup device to be. at this point the server should see it and use it as a lagit device
Jim

Originally posted by trojahn
I am running SQL 7...

I had a database on a Sql Server on a WinXP machine but I needed to reinstall that machine and I installed Win2k...

Before I format the machine I have made a backup from my database. Now, on the Win2k, I cant restore this backup. Sql Server shows the following error message:

The volume on device 'c:\backup.bak' is not a member of the media family.

Plz, help me on this... I dont know much about Sqlserver and this is the ONLY backup I have... The backup file seems fine... There was no errors during the backup proccess...

If u dont know whats happening, could u tell if exists some program that can read the backup file and extracts its data to another format?|||JDionne,

I need to ask u for a little more favor... Could u give me more details on how to do that? I really dont know much about Sql Server... I just follow the setup procedure of my so called technical support that now says that I did something wrong...

Edit -=-=-=-=-=-
I just figure out how to do what u said but theres a major problem... I dont know where the backup device was on the first machine... I there a way to figure that out?|||The location of the first back up dosent mater. I would create the backup device in eh mssql\backups directory just to stick to a standard.
Once u have created that device with the same name as the old backup file and move it to that dir, the server will use the file.

the following code will tell u whats in the backup when u go to restore.
run this in query analizer substituting your backup device name

RESTORE FILELISTONLY
FROM [Maersk Data Warehouse Full Backup]

after u know whats in the device u can use the following code to restore it. u will need to change the database name, backup device and mdf,ldf, (and if u have a ndf) file names
the To line indicates wehre u want it to restore to and again i would follow the standard just so u know where they are. If u have any questions just post it and ill see if i can help
Regards Jim

RESTORE DATABASE [Maersk Data Warehouse]
FROM [Maersk Data Warehouse Full Backup]
with recovery
, move 'Maersk Data Warehouse_Data'to 'E:\MSSQL\Data\Maersk Data Warehouse_Data.MDF'
, move 'Maersk Data Warehouse_Log' to 'F:\MSSQL\Data\Maersk Data Warehouse_Log.LDF'
, move 'Maersk Data Warehouse User Tables'to 'E:\MSSQL\Data\Maersk Data Warehouse_Data.NDF'

Originally posted by trojahn
JDionne,

I need to ask u for a little more favor... Could u give me more details on how to do that? I really dont know much about Sql Server... I just follow the setup procedure of my so called technical support that now says that I did something wrong...

Edit -=-=-=-=-=-
I just figure out how to do what u said but theres a major problem... I dont know where the backup device was on the first machine... I there a way to figure that out?

problem on restore database from one machine to another machine

Hi,

I got big problem on restore the database from one machine to another machine .

It complaint about the unicode .

WHat are the steps that I need to follow while restoring ?

pls advise.

Thank you very much in advanced .

Best Regards,
weiyinThe two machines are installed with different collation/sort order (how data is physically sorted on disk).

1. If the machine on witch you are trying to restore the database to is empty (no other running databases) you could rebuid the master database to match the collation on your first machine (only if no other databases exists!!).

2. If you dont want to change collation o machine 2 (because it exists other databases) you could transfer the database from one machine to the another.

Hope it helps!

Problem moving Report Server catalog to different machine

Books On Line makes breaking out the report server databases on to a separate machine from the report server itself sound very easy. I have tried it and it is but I can't get the report server to connect to the databases once they are on the other machine.

Everything was done by the book(s). We use SSRS only for intranet use so all inside firewall. The SQL Server 2005 services on both machines (including the RS Windows service) all run as the same domain administrator account, this account was used to log in to RS Config Tool and it was told to use this account under Windows Authentication to connect to the database server. The two machines are in the same domain, even on the same switch. The only difference is the one with report server on is Windows 2000 Server SP4 and the one to which the rs databases are moving is Windows Server 2003 SP1. The account mentioned above has sysadmin rights on both SQL Servers, as well as having all the RSExecRole rights as specified in BOL. And it has rights to logon as a service in group policy on both machines. Its password hasn't been changed.

The RS Config Tool completed fine and reported no errors.

But when you try to connect to the report server you get the error:

"The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed)" The log shows that a privilege required by the client is missing but doesn't specify what! I thought this was all taken care of when the RS Config Tool told it which account to connect with.

This is driving me daft. It should be so easy!! Does anyone have any idea what might be wrong? Nothing says I need to do anything with the encryption key when I am keeping the report server itself exactly as it was and just moving the catalog - or have I missed something here?

Grateful for any ideas.

IP Logged

Try using the Configuration Utility to generate a database script and apply that script manually in SSMS. In addition, the following posts may help (http://prologika.com/CS/blogs/blog/archive/2004/08/20/161.aspx and http://prologika.com/CS/blogs/blog/archive/2006/07/18/Swapping-the-RS-Catalog.aspx).|||

I have finally fixed this problem.

The "privilege required by the client" turned out to be "Act as part of operating system" for the ASPNET user (under which the RS web service runs) on its own native machine which is Windows 2000 Server.

Since it did not require this privilege when the report server catalog was also on this machine then I can only assume it became necessary either in principle when that catalog was moved, in which case you would think Books On Line would tell you, or because they had been moved to a Windows 2003 server machine and there then appeared some obscure (to me anyway!) conflict.

I don't suppose this would be much of a fix if either of the servers involved faced the internet but they are entirely internal so I am going with it.

Problem installing SQL Server 2005 Express Edition

I have downloaded a free set of SQL Server 2005 Express edition. This set up has been installed successfully on my machine but it is showing me following links.

SQL Server Instance=SQLExpress

User Id=sa

Password=admin12

Start --> Microsoft Sql Server 2005 -->Configuration Tools --->SQL Server Configuration Manager

--->SQL Server Eroor and Usage Reporting

---->SQL Server Surface Area Configuration

But I don't find any option to start SQL Server 2005 express edition. Please help me out how to start SQL Server 2005 express edition?

dineshpatil:

But I don't find any option to start SQL Server 2005 express edition. Please help me out how to start SQL Server 2005 express edition?

You can use the SQL Server Surface area configuration to start/stop services like your SQL instance.

If you want a GUI interface then you need to install SQL Server Management Studio.

|||

Dear Jimmy,

Thanks for your reply. I have started SQL Server instance service. Is SQL Server Management Studio is free?
If it is free, Please provide me URL path from where I can download?

Is there any other way with which I can run or access Microsoft SQL Server 2005 Express Edition?

|||

http://msdn2.microsoft.com/nl-nl/express/bb410792(en-us).aspx

|||

dineshpatil:

Thanks for your reply. I have started SQL Server instance service. Is SQL Server Management Studio is free?
If it is free, Please provide me URL path from where I can download?

Yes it is free and you can download it here

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

dineshpatil:

Is there any other way with which I can run or access Microsoft SQL Server 2005 Express Edition?

Your Express database is already installed so you can use it right away. You can either connect from the VS IDE, but if you want a GUI to the database then you need to use the SQL Management tool another 3rd party tool or rely on Visual Studio's server explorer.

|||

Thanks guys. Now it is working fine.

Problem installing setup support files

Hi,
trying to install Reporting Services Enterprise Ed. on a server machine with
configuration:
- Win 2003 Enterprise with SP1
- MS SQL 2000 Server with SP4
- IIS 6 with ASP.NET 1.1
Problem is that when I execute Setup.exe I receive an message: "Error!"
after only 2-3 seconds and thats it! No more info on what the error is or so.
Only option for me is to click Cancel and the installation ends.
This happens when setup tries to install Microsoft SQL Server Reporting
Services Setup Support Files which is the first to happen.
Please, anyone have an idea what this can be or even how to track down the
error?
No errors are reported in Event Viewer.
I have rerun aspnet_regiis just in case, witout any result.
Thanks.Found the problem!
I was running the installation from my local DVD logged in to the server via
Remote Desktop and my local disks shared.
Copied the installationfiles to server harddisk and it installed!
"Gizmo Gizmo" wrote:
> Hi,
> trying to install Reporting Services Enterprise Ed. on a server machine with
> configuration:
> - Win 2003 Enterprise with SP1
> - MS SQL 2000 Server with SP4
> - IIS 6 with ASP.NET 1.1
> Problem is that when I execute Setup.exe I receive an message: "Error!"
> after only 2-3 seconds and thats it! No more info on what the error is or so.
> Only option for me is to click Cancel and the installation ends.
> This happens when setup tries to install Microsoft SQL Server Reporting
> Services Setup Support Files which is the first to happen.
> Please, anyone have an idea what this can be or even how to track down the
> error?
> No errors are reported in Event Viewer.
> I have rerun aspnet_regiis just in case, witout any result.
> Thanks.

Problem installing server instance on windows xp sp2

Hello all,

I have a problem installing a SQL Server 2005 (developper edition) on my windows XP SP2 machine.

When I launch the setup, all the requirements are ok, but I'm just allowed to install client components and documentations. I can't install the database server instance.

The Sql Server is downloaded from MSDN (2 iso files extracted to my HD)

My machine is a P4 2.8Ghz HT with 1Gig of RAM.

Thanks for your help

FYI, here's the Report for the system configuration check:

System Configuration Check

- WMI Service Requirement (Success)

Messages

WMI Service Requirement

Check Passed

- MSXML Requirement (Success)

Messages

MSXML Requirement

Check Passed

- Operating System Minimum Level Requirement (Success)

Messages

Operating System Minimum Level Requirement

Check Passed

- Operating System Service Pack Level Requirement. (Success)

Messages

Operating System Service Pack Level Requirement.

Check Passed

- SQL Server Edition Operating System Compatibility (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Success)

Messages

Minimum Hardware Requirement

Check Passed

- IIS Feature Requirement (Success)

Messages

IIS Feature Requirement

Check Passed

- Pending Reboot Requirement (Success)

Messages

Pending Reboot Requirement

Check Passed

- Performance Monitor Counter Requirement (Success)

Messages

Performance Monitor Counter Requirement

Check Passed

- Default Installation Path Permission Requirement (Success)

Messages

Default Installation Path Permission Requirement

Check Passed

- Internet Explorer Requirement (Success)

Messages

Internet Explorer Requirement

Check Passed

- COM Plus Catalog Requirement (Success)

Messages

COM Plus Catalog Requirement

Check Passed

- ASP.Net Version Registration Requirement (Success)

Messages

ASP.Net Version Registration Requirement

Check Passed

- Minimum MDAC Version Requirement (Success)

Messages

Minimum MDAC Version Requirement

Check Passed

What Edition are you trying to install? Only the Express and Developer Editions can be installed on a Windows XP SP2 box (haven't tried the Workgroup edition yet)|||

This is the developer edition of SQL server 2005 (not beta).

Thanks,

Pat

|||Just in addition, Workgroup edition as well as Standard edition will work on Windows XP SP2 machines.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Are you using SQL Server professional or Home ? Home is not supported by Developer Edition and therefore only will allow you to install the client components.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Problem Installing FTS

Hi there,
I have SQL Server SP3 (DEV Ed) Installed on my machine.
Select @.@.Version:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
I have popped in the SQL Server CD and ticked the FTS box and installed FTS.
After install i started the search service but FTS is still not enabled in
EM. I looked under Support Services in EM but FTS is not listed there.
Have I missed something? Do I need to re-install SP3 after I installed FTS
from the original SQL Server CD?
Cheers
Ash Moollan
www.moollan.net
what happens when you issue a select serverproperty('isfulltextinstalled')
If 1 is returned, SQL FTS is installed.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ash Moollan" <ashraf@.moollan.net> wrote in message
news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
> Hi there,
> I have SQL Server SP3 (DEV Ed) Installed on my machine.
> Select @.@.Version:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows
> NT 5.1 (Build 2600: Service Pack 2)
> I have popped in the SQL Server CD and ticked the FTS box and installed
FTS.
> After install i started the search service but FTS is still not enabled in
> EM. I looked under Support Services in EM but FTS is not listed there.
> Have I missed something? Do I need to re-install SP3 after I installed FTS
> from the original SQL Server CD?
> Cheers
> Ash Moollan
> www.moollan.net
>
|||Hi Hilary,
Thanks for prompt reply.
Statement returns 0 (zero).
However the SQL Server CD shows the full text search as ticked (installed).
Thanks
Ash Moollan
www.moollan.net
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ObOlu85zFHA.736@.tk2msftngp13.phx.gbl...
> what happens when you issue a select serverproperty('isfulltextinstalled')
> If 1 is returned, SQL FTS is installed.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Ash Moollan" <ashraf*NOSPAM@.moollan.net> wrote in message
> news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
> Windows
> FTS.
>
|||Ash,
Under what account do you have the SQL Server (MSSQLServer) service started
& running? The "system account" (LocalSystem), a DOMAIN\Account or a "Local
Windows account"? If the latter, you may want to review this KB article:
Q270671 (Q270671) PRB: Full Text Search Menus Are Not Enabled for Local
Windows NT Accounts
http://support.microsoft.com/default...;en-us;q270671
Also, confirm that the FTS components are installed via the following sql
code (1 = installed)
SELECT FullTextServiceProperty('IsFulltextInstalled')
Finally, if you installed the FTS components AFTER you applied SP3, then yes
you should re-apply SP3 to get the SP3 fixes for the FTS and MSSearch
components.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Ash Moollan" <ashraf@.moollan.net> wrote in message
news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
> Hi there,
> I have SQL Server SP3 (DEV Ed) Installed on my machine.
> Select @.@.Version:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
> Windows NT 5.1 (Build 2600: Service Pack 2)
> I have popped in the SQL Server CD and ticked the FTS box and installed
> FTS. After install i started the search service but FTS is still not
> enabled in EM. I looked under Support Services in EM but FTS is not listed
> there.
> Have I missed something? Do I need to re-install SP3 after I installed FTS
> from the original SQL Server CD?
> Cheers
> Ash Moollan
> www.moollan.net
>
|||Ash,
You can remove (or un-tick) the checkmark via deleting or renaming this
registry key (remove <Instance_Name>, if this is not an named instance
installation of SQL Server 2000)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Ash Moollan" <ashraf@.moollan.net> wrote in message
news:unQVhB6zFHA.3780@.TK2MSFTNGP12.phx.gbl...
> Hi Hilary,
> Thanks for prompt reply.
> Statement returns 0 (zero).
> However the SQL Server CD shows the full text search as ticked
> (installed).
> Thanks
> Ash Moollan
> www.moollan.net
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ObOlu85zFHA.736@.tk2msftngp13.phx.gbl...
>
|||John,
Worked Great!
Thanks
Ash Moollan
www.moollan.net
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OgaJFF6zFHA.2880@.TK2MSFTNGP12.phx.gbl...
> Ash,
> Under what account do you have the SQL Server (MSSQLServer) service
> started & running? The "system account" (LocalSystem), a DOMAIN\Account or
> a "Local Windows account"? If the latter, you may want to review this KB
> article:
> Q270671 (Q270671) PRB: Full Text Search Menus Are Not Enabled for Local
> Windows NT Accounts
> http://support.microsoft.com/default...;en-us;q270671
> Also, confirm that the FTS components are installed via the following sql
> code (1 = installed)
> SELECT FullTextServiceProperty('IsFulltextInstalled')
> Finally, if you installed the FTS components AFTER you applied SP3, then
> yes you should re-apply SP3 to get the SP3 fixes for the FTS and MSSearch
> components.
> Hope that helps!
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Ash Moollan" <ashraf@.moollan.net> wrote in message
> news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
>

Problem Installing AdventureWorksDB.msi

I'm running on a stand alone machine. No network connections. I get the following error message when running this script:

"Error 1316. A network error occurred while attempting to read from the file C:\Program Files\Microsoft SQL Server\AdventureWorksDB[1].msi"

So how do I resolve this problem, so I can get the Adventure Works DB installed?

This often has to do with a failed installation from an earlier attempt. You may have to clean registry entries or edit the .msi file, but try this tool first:

http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

Buck

|||

Dan,

Did you get this problem solved?

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||The previous response was of minimal value. There were no previous versions that could have failed and fouled up the registry. Any other ideas!|||

The inclusion of the [1] in the file name from the error suggests to me that the file was in a temporary directory, which would be the result of clicking Run directly from the Download page.

If this was the case, then I'd suggest trying to Save the file to your local hard drive and then run the saved file. If that is not the case, it would be worth downloading a fresh copy of the sample database from the download center. It is rare, but occationally files can be damaged during the download process.

If neither of those solve the problem, I can get the folks from the Setup group involved to see if they have better ideas than I do.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||I think this will work. But unfortunately while uninstalling that install I have corrupted the system. I will be rebuilding the system for a couple of days, and then I will be able to give it a try. Thank You DLM.|||

OK Dan,

Be sure to respond back to the forum with your results as I'm sure others will be interested.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

>This often has to do with a failed installation from an earlier attempt. You may have to clean registry entries or edit the .msi file, but try this tool first:

>http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

Thankyou this worked for me winxp sp2 with the error.

Problem Installing AdventureWorksDB.msi

I'm running on a stand alone machine. No network connections. I get the following error message when running this script:

"Error 1316. A network error occurred while attempting to read from the file C:\Program Files\Microsoft SQL Server\AdventureWorksDB[1].msi"

So how do I resolve this problem, so I can get the Adventure Works DB installed?

This often has to do with a failed installation from an earlier attempt. You may have to clean registry entries or edit the .msi file, but try this tool first:

http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

Buck

|||

Dan,

Did you get this problem solved?

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||The previous response was of minimal value. There were no previous versions that could have failed and fouled up the registry. Any other ideas!|||

The inclusion of the [1] in the file name from the error suggests to me that the file was in a temporary directory, which would be the result of clicking Run directly from the Download page.

If this was the case, then I'd suggest trying to Save the file to your local hard drive and then run the saved file. If that is not the case, it would be worth downloading a fresh copy of the sample database from the download center. It is rare, but occationally files can be damaged during the download process.

If neither of those solve the problem, I can get the folks from the Setup group involved to see if they have better ideas than I do.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||I think this will work. But unfortunately while uninstalling that install I have corrupted the system. I will be rebuilding the system for a couple of days, and then I will be able to give it a try. Thank You DLM.|||

OK Dan,

Be sure to respond back to the forum with your results as I'm sure others will be interested.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

>This often has to do with a failed installation from an earlier attempt. You may have to clean registry entries or edit the .msi file, but try this tool first:

>http://support.microsoft.com/default.aspx?scid=kb;en-us;290301

Thankyou this worked for me winxp sp2 with the error.