Error: CREATE ASSEMBLY for assembly

I am trying to deploy a Database Project with Visual Studio 2005 and SQL Server 2005 Standard.

I import “System.IO” and have therefore set the permission levels to EXTERNAL_ACCESS.

I am receiving the same error message that many folks have received.

CREATE ASSEMBLY for assembly 'Images' failed because assembly 'Images' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS.

The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission. If you have restored or attached this database, make sure the database owner is mapped to the correct login on this server. If not, use sp_changedbowner to fix the problem. Images.

My CLR access is “on”

I have tried

1) From master run: GRANT EXTERNAL ACCESS ASSEMBLY to [Builtin\Administrators].

2) From master run: GRANT EXTERNAL ACCESS ASSEMBLY to “My Windows Authentication ID”.

3) Run ALTER DATABASE MYDATABASE SET TRUSTWORTHY ON

4) In Visual Studio .NET 2005 Set the permission levels to ‘external’

5) Tried Builtin\Administrators and my SQL Server Windows Authenticated Login ID for the ASSEMBLY OWNER.

I can compile BUT NOT DEPLOY

Any help would be greatly appreciated.

Regards Steve

Who is the owner of the database ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Thanks for the reply.

I am running with Windows Authentication at the present moment , under the ID Administrator1 (running under windows Vista.(still would like to get reporting services to run ) . I did read the article on "Opening up the Administrator ID in Vista and installing SQL Server 2005 under that ID."

Re my current problem....

I managed to get it to deploy. I assigned Administrator1 as an "owner" of the database and gave the ID security administrator rights. I did the same with Builtin/Administrator.

I found something very interesting. I am able to deploy CLR stored precedures from the Visual Studio environment but not CLR functions. (EXTERNAL ACCESS) In order to deply functions I must compile the Dll and create SQL to CREATE the ASSEMBLYfrom within the SQL Server Environment. Any ideas why.?

Once again thanks for the help? Very much appreciated.

Steve

|||

OK Folks this took me about 3 hours to do BUT I have resolved the problem and it WORKS!!!

BTW I am using SQL Server 2005 Standard and Visual Studio.NET Enterprise

First create a Strong key as described in“The secret of strong naming”

DO NOT DODELAY SIGNING !!!!!!

http://www.ondotnet.com/pub/a/dotnet/2003/04/28/strongnaming.html

Sn – k MyKeyFile.snk

FIND OUT WHERE THE SNK FILE WAS COMPILED.

Go into VS2005 .NET and under project / properties in the signing page click the Sign the Assembly check box and browse to find MyKeyFile.snk

The database page

Mark the assembly for external access and leave the owner blank

Now we must go to the article

http://sqljunkies.com/WebLog/ktegels/archive/2006/08/14/safetydancelite.aspx

The text below comes from this article....

A kinder, lighter Safety Dance for the SQLCLR

A few months ago, I published a step-by-step procedure for using certificate to sign an assembly so an external access or unsafe assembly could be run without having to set the hosting database to trustworthy. The major problem with that process was its weight: a lot of steps and some still requirements in terms of certificate management. Turns out that yes, there is an easier way to make it work.

Part one -- preparing the master database

1. As needed, start a series of queries against the MASTER database.

2. Create the target database (meaning execute a CREATE DATABASE query).

3. Code and compile the assembly you want to deploy. Make sure you sign the assembly with a strong name key file. This can be done with a PFX file generated by Visual Studio.

4. Create an asymmetric key from from the compiled assembly using a statement like this: create asymmetric key <key_name> from executable file = '<path_to_dll_file>'

USE Master

GO

create asymmetric key imageskeyFile from executable file = 'C:\YEAR 2007\Images\Images\bin\Debug\Images.dll'

5. Create a login based on that asymmetric key using a statement like this: create login <login_name> from asymmetric key <key_name>

Use Master

Go

create login ImageMaker from asymmetric key imageskeyFile

6. Grant that login the right to create either or both an unsafe or external access assembly (as needed) using: grant unsafe assembly to <login_name>

Use Master

Go

grant EXTERNAL ACCESS assembly to ImageMaker

Part two -- preparing the hosting database

1. As needed, start a series of queries against the desired user database.

2. Create a user in that database mapped to the login created in part, step 5. (e.g. create user <db_user> from login <login_name>)

3. Give that user the right to catalog an assembly, e.g.: grant create assembly to <db_user>

4. Catalog the desired assembly using the now trusted asymmetric key with a statement like: create assembly <assembly_name> authorization <db_user> from '<path_to_dll_file>' with permission_set = unsafe or external access as shown below

SET QUOTED_IDENTIFIER OFF

USE YEAR2007

GO

CREATE ASSEMBLY Images

AUTHORIZATION ImageMaker

FROM "C:\YEAR 2007\Images\Images\bin\Debug\Images.dll"

WITH PERMISSION_SET = EXTERNAL_ACCESS

GO

Error: Cannot display activity

TITLE: Microsoft SQL Server Management Studio Express (CTP Nov)

OS: Both XP SP2 and Win2003 SP1

Cannot display activity for database 'SomeDBName'.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ActivityMonitor, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

To reproduce:

Try to detach a database which has at least one active connection. On the Detach Database dialog click on: 1 Active connection.

Hi, this issue has already been found and resolved. You should not see this on the RTM version.|||

Hi

This is the only place in the entire world I have found reference to this problem. I have the same problem and I'm running MS SQL Server 2005 Express SP1 running on XP SP2.

Help > About on SSMSE shows:

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I found a KB article a while back about changing the registry key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb TlbPath value of %CLRVERSION% to v2.0.50727 but that didn't fix it. I've since tried repairing .Net Framework 2.0 and SSMSE but still have the problem.

Any ideas where to go next?

Mick

Error: Cannot display activity

TITLE: Microsoft SQL Server Management Studio Express (CTP Nov)

OS: Both XP SP2 and Win2003 SP1

Cannot display activity for database 'SomeDBName'.

ADDITIONAL INFORMATION:

Could not load file or assembly 'ActivityMonitor, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (mscorlib)

To reproduce:

Try to detach a database which has at least one active connection. On the Detach Database dialog click on: 1 Active connection.

Hi, this issue has already been found and resolved. You should not see this on the RTM version.|||

Hi

This is the only place in the entire world I have found reference to this problem. I have the same problem and I'm running MS SQL Server 2005 Express SP1 running on XP SP2.

Help > About on SSMSE shows:

Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

I found a KB article a while back about changing the registry key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\TlbAutoRepair\mscorlib.tlb TlbPath value of %CLRVERSION% to v2.0.50727 but that didn't fix it. I've since tried repairing .Net Framework 2.0 and SSMSE but still have the problem.

Any ideas where to go next?

Mick

Error: Application for .reportproj not installed

Getting error when try to open report project:
The application for D:\Documents and Settings\Administrator\My
Documents\Visual Studio Projects\WinfundsReports.rptproj is not installed.
Make surethe application for the project type (.rptproj) is installed.
Everything had been working fine for a year!
Note: Busuness Intelligence Projects no longer appears in the list of
available project types when setting up new project.
Is this controlled by something in the config files, or will I have to
reinstall Rptg Services?
Thanks.
AlanFollowup Question:
Is there a file that will re-register reporting services withou a complete
re-install?
Thanks.
Alan

Error: 18456, Severity: 14, State: 11 when logging in

I just installed SQL Server 2005 with SP2 on Vista. When I try to login from SQL Server Management Studio, I get the following error message in the log:

2007-09-15 18:58:02.23 Logon Error: 18456, Severity: 14, State: 11.
2007-09-15 18:58:02.23 Logon Login failed for user '<computer name>\<user account>'.[CLIENT: <local machine>]

Since I can't login, I can't try some of the stuff I have seen here, such as creating new logins etc.

I installed Analysis Server and Integration Services at the same time. Logging in to them both works fine.

I use windows authentication. I don't know if changing that helps, as I don't know how to change it without logging in in the first place...

I think you entered in Windows with an account (<computer name>\<user account>) that hasn't a SQL login.

If your windows account should have administrator privillege it should enter with SQL login named "Builtin\administrators"

To the other part reading this the builtin administrator is disabled by default in Vista.

So repair first this.

|||

Gigi is correct. You can also read about this issue here: http://msdn2.microsoft.com/en-us/library/Aa905868.aspx.

Thanks

Laurentiu

Error: 18456, Severity: 14, State: 11 when logging in

I just installed SQL Server 2005 with SP2 on Vista. When I try to login from SQL Server Management Studio, I get the following error message in the log:

2007-09-15 18:58:02.23 Logon Error: 18456, Severity: 14, State: 11.
2007-09-15 18:58:02.23 Logon Login failed for user '<computer name>\<user account>'.[CLIENT: <local machine>]

Since I can't login, I can't try some of the stuff I have seen here, such as creating new logins etc.

I installed Analysis Server and Integration Services at the same time. Logging in to them both works fine.

I use windows authentication. I don't know if changing that helps, as I don't know how to change it without logging in in the first place...

I think you entered in Windows with an account (<computer name>\<user account>) that hasn't a SQL login.

If your windows account should have administrator privillege it should enter with SQL login named "Builtin\administrators"

To the other part reading this the builtin administrator is disabled by default in Vista.

So repair first this.

|||

Gigi is correct. You can also read about this issue here: http://msdn2.microsoft.com/en-us/library/Aa905868.aspx.

Thanks

Laurentiu

error: 0 - No process is on the other end of the pipe

I can use SQL Server Management Studio Express to connect to my local database SQL 2005 database on bknji\sqlexpress.

I am also able to connect to the database from Visual Studio, and this is where I copied the following connection string to be used in my C# code

string myConnectString = "Data Source=BKFNJI\\SQLEXPRESS;" +

"Initial Catalog=cmiCompatibilityDataBase" +

"Integrated Security=True;Pooling=False";

// specify SQL Server Specific Connection string

SqlConnection cmiDBCompConnection = new SqlConnection(myConnectString);

cmiDBCompConnection.Open();

when I attempt to run the apps, I get the

"System.Data.SqlClient.SqlException was unhandled
Message="A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)".....

any idea what I am doing wrong, given that the connection string works using other means? I am using Windows authentication.

To add, the error in my log shows:

2007-03-17 21:10:55.82 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]

Thanks,

Klaus

Seems although the server is expecting Windows Authentication, either no username was passed to the server internally or you are using a different connectionstring than the one posted above. Could you descrive your environment ? Are you in a domain, is the machine you are connecting from the same machine as the development machine ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error>>"SQL Server does not exist or access denied"

I have re-installed Visual Studio and SQL Server and now i am getting this error for all applications i try to run
Error:

"

SQL Server does not exist or access denied.

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.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
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:

[SqlException: SQL Server does not exist or access denied.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36 ResNet2.top_animals.BindGrid() +64 ResNet2.top_animals.Page_Load(Object sender, EventArgs e) +525 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731

"
any suggestions?We will need to see your connection string to be able to help you.
|||

tmorton wrote:

We will need to see your connection string to be able to help you.

Connection String:

Session("ResNet_Connection_String") = "workstation id=PC_ID;packet size=4096;user id=USER_ID;data source=SAC063;persist" & _

" security info=True;initial catalog=Jo;password=PASSWORD"

The connection string was working fine before installations. I got a feeling that the application is not able to connect to sql server at all and there is some wee configurations which got to be done.

|||

Other than just trying to connect to the SQL server i was even trying to connect to the local SQL Sserver (MSDE 2000) which gives a slightly different error:

Error:
***************************************************************************************************************************************************************************************************************

Server Error in '/TestApp' Application.

---

Login failed for user '4NSQ11J\ASPNET'.

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.Data.SqlClient.SqlException: Login failed for user '4NSQ11J\ASPNET'.
Source Error:

Line 179: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.LoadLine 180: 'Put user code to initialize the page hereLine 181: Me.SqlDataAdapter1.Fill(Me.DataSet1)Line 182: Me.DataGrid1.DataSource = Me.DataSet1Line 183: Me.DataGrid1.DataBind()

Source File:c:\inetpub\wwwroot\TestApp\DbTest_App.aspx.vb Line:181
Stack Trace:

[SqlException: Login failed for user '4NSQ11J\ASPNET'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 TestApp.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\TestApp\DbTest_App.aspx.vb:181 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

***************************************************************************************************************************************************************************************************************
Where 'NSQ11J' is my local server as well as computer name.

|||Does the user who is trying to run the query have sufficient access rights on the database/table?
Tryst
|||

Tryst wrote:

Does the user who is trying to run the query have sufficient access rights on the database/table?
Tryst

Yes DB Owner rights!|||Do you have your <machinename>/ASPNET as the user in the USER accounts ? and make sure this user account has permissions on the tables/stored procs.|||

ndinakar wrote:

Do you have your <machinename>/ASPNET as the user in the USER accounts ? and make sure this user account has permissions on the tables/stored procs.

As i mentioned earlier the account i am using has got DBO rights.|||Solution Found:

Ther Alias port had to be set to a specific one to listen to TCP/IP protocols.

Steps to check the Alias settings:

1) go to 'Client Network Utility' in Microsoft SQL Server utlities

2)check if there are any protocols disabled which you going to use in the application

3)click on the tab 'Alias' to add/edit/remove currently Alias servers in the list

Thanks for you guys help anyway!

Cheers
Umer|||Hi UmerTahir,
you solved the problem by doing this, but what exactly was the problem you had with the Server Network Utility?
Tryst
|||

Tryst wrote:

Hi UmerTahir,
you solved the problem by doing this, but what exactly was the problem you had with the Server Network Utility?
Tryst

The problem was with the application and its connection to the SQL server. To access the sql server through TCP/IP protocols some empty port is required which is usualy left to be detected automatically. In my case i had to access through specific port which my company has set for some security issues so that solved the problem.
Umer

Error with SQL Server 2K5 "Cannot connect... Instance failure"

I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
CTP.
"Cannot connect to SERVER\SQLEXPRESS
Additional Information:
Instance Failure. (System.Data)"
One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
start automatically yet, it wasn't started. I tried to start it, but
kept receiving a message that the service was started and then stop for
a rerason along the lines "if a service isn't need, it stops itself".
So...
I stopped the following services and restarted them:
MSSQL$SHAREPOINT
MSSQLSERVER
SQL Server Browser
and it finally let me start "SQL Server (SQLEXPRESS)" !!
After stopping and starting the 4 services above, it let me in again.
This is the 3rd time this has happened to me. Anyone have any ideas?
Hi
This sounds like you are using a user instance?
This may help
http://msdn.microsoft.com/library/de...xpuserinst.asp
What is the exact error number and message in the SQL Server log?
John
"ATJaguarX" wrote:

> I am getting the following error when trying to connect to SQL Server
> 2005 Express through Microsoft SQL Server Management Studio Express
> CTP.
> "Cannot connect to SERVER\SQLEXPRESS
>
> Additional Information:
> Instance Failure. (System.Data)"
>
> One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
> start automatically yet, it wasn't started. I tried to start it, but
> kept receiving a message that the service was started and then stop for
> a rerason along the lines "if a service isn't need, it stops itself".
> So...
>
> I stopped the following services and restarted them:
>
> MSSQL$SHAREPOINT
> MSSQLSERVER
> SQL Server Browser
>
> and it finally let me start "SQL Server (SQLEXPRESS)" !!
>
> After stopping and starting the 4 services above, it let me in again.
> This is the 3rd time this has happened to me. Anyone have any ideas?
>
|||I am not sure if I am running a user instance. I have yet to design an
application to hit my database, I have only been logging into the
management tool.
My error logs are all empty. Is there something I need to do to turn
these on?
|||Hi
If you had a user instance the database would only be attached when it was
connected to.
You can use SSEUtil to connect to the instance.
John
"ATJaguarX" wrote:

> I am not sure if I am running a user instance. I have yet to design an
> application to hit my database, I have only been logging into the
> management tool.
> My error logs are all empty. Is there something I need to do to turn
> these on?
>

Error with SQL Server 2K5 "Cannot connect... Instance failure"

I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
CTP.
"Cannot connect to SERVER\SQLEXPRESS
Additional Information:
Instance Failure. (System.Data)"
One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
start automatically yet, it wasn't started. I tried to start it, but
kept receiving a message that the service was started and then stop for
a rerason along the lines "if a service isn't need, it stops itself".
So...
I stopped the following services and restarted them:
MSSQL$SHAREPOINT
MSSQLSERVER
SQL Server Browser
and it finally let me start "SQL Server (SQLEXPRESS)" !!
After stopping and starting the 4 services above, it let me in again.
This is the 3rd time this has happened to me. Anyone have any ideas?Hi
This sounds like you are using a user instance?
This may help
http://msdn.microsoft.com/library/d...>
userinst.asp
What is the exact error number and message in the SQL Server log?
John
"ATJaguarX" wrote:

> I am getting the following error when trying to connect to SQL Server
> 2005 Express through Microsoft SQL Server Management Studio Express
> CTP.
> "Cannot connect to SERVER\SQLEXPRESS
>
> Additional Information:
> Instance Failure. (System.Data)"
>
> One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
> start automatically yet, it wasn't started. I tried to start it, but
> kept receiving a message that the service was started and then stop for
> a rerason along the lines "if a service isn't need, it stops itself".
> So...
>
> I stopped the following services and restarted them:
>
> MSSQL$SHAREPOINT
> MSSQLSERVER
> SQL Server Browser
>
> and it finally let me start "SQL Server (SQLEXPRESS)" !!
>
> After stopping and starting the 4 services above, it let me in again.
> This is the 3rd time this has happened to me. Anyone have any ideas?
>|||I am not sure if I am running a user instance. I have yet to design an
application to hit my database, I have only been logging into the
management tool.
My error logs are all empty. Is there something I need to do to turn
these on?|||Hi
If you had a user instance the database would only be attached when it was
connected to.
You can use SSEUtil to connect to the instance.
John
"ATJaguarX" wrote:

> I am not sure if I am running a user instance. I have yet to design an
> application to hit my database, I have only been logging into the
> management tool.
> My error logs are all empty. Is there something I need to do to turn
> these on?
>

Error with SQL Server 2K5 "Cannot connect... Instance failure"

I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
CTP.
"Cannot connect to SERVER\SQLEXPRESS
Additional Information:
Instance Failure. (System.Data)"
One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
start automatically yet, it wasn't started. I tried to start it, but
kept receiving a message that the service was started and then stop for
a rerason along the lines "if a service isn't need, it stops itself".
So...
I stopped the following services and restarted them:
MSSQL$SHAREPOINT
MSSQLSERVER
SQL Server Browser
and it finally let me start "SQL Server (SQLEXPRESS)" !!
After stopping and starting the 4 services above, it let me in again.
This is the 3rd time this has happened to me. Anyone have any ideas?Hi
This sounds like you are using a user instance?
This may help
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp
What is the exact error number and message in the SQL Server log?
John
"ATJaguarX" wrote:
> I am getting the following error when trying to connect to SQL Server
> 2005 Express through Microsoft SQL Server Management Studio Express
> CTP.
> "Cannot connect to SERVER\SQLEXPRESS
>
> Additional Information:
> Instance Failure. (System.Data)"
>
> One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
> start automatically yet, it wasn't started. I tried to start it, but
> kept receiving a message that the service was started and then stop for
> a rerason along the lines "if a service isn't need, it stops itself".
> So...
>
> I stopped the following services and restarted them:
>
> MSSQL$SHAREPOINT
> MSSQLSERVER
> SQL Server Browser
>
> and it finally let me start "SQL Server (SQLEXPRESS)" !!
>
> After stopping and starting the 4 services above, it let me in again.
> This is the 3rd time this has happened to me. Anyone have any ideas?
>|||I am not sure if I am running a user instance. I have yet to design an
application to hit my database, I have only been logging into the
management tool.
My error logs are all empty. Is there something I need to do to turn
these on?|||Hi
If you had a user instance the database would only be attached when it was
connected to.
You can use SSEUtil to connect to the instance.
John
"ATJaguarX" wrote:
> I am not sure if I am running a user instance. I have yet to design an
> application to hit my database, I have only been logging into the
> management tool.
> My error logs are all empty. Is there something I need to do to turn
> these on?
>

Error with setup of SQL Server 2005 Express

I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.
I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is:
The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer name snipped]} from cache
Unable to write property into cache IsClustered
Unable to write property into cache "IsClustered"
XmlRw Error: Failure loading xmlrw.dll
CheckAllProcedures() returned: 2
It should be noted that no VS or SQL products are currently installed on my machine (I uninstalled the new Express releases), and none show up in the Add/Remove Programs list. Any help would be greatly appreciated.

I had the same thing happen. Cannot install the new SQL Server 2005 on my systems either.

Cannot install SQL Server 2005 as it says there are remaining beta/CTP products that are not compatible. Tried running the vs_uninst_betas.exe. This had errors with the one reamaining product found of SQL Server Express Edition CTP.

The setup has encountered an unexpected error in datastore. The is RestoreSetupParams. The error is :Failed to read "Installlds" {MachineConfiguration", "", "name"} FRON CACHE

Unable to write property into cache: IsClustered

XMLRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned: 2

This is the first error

Click Ok

The second error is also datastore. The action is Write_CommitFlag. The is :Unable to write property into cache:flagCommit

Unable to write property into cache: "flagCommit"

XmlRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned: 2

Matt Porter wrote:

I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.

I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is:

The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer name snipped]} from cache
Unable to write property into cache IsClustered
Unable to write property into cache "IsClustered"
XmlRw Error: Failure loading xmlrw.dll
CheckAllProcedures() returned: 2

It should be noted that no VS or SQL products are currently installed on my machine (I uninstalled the new Express releases), and none show up in the Add/Remove Programs list. Any help would be greatly appreciated.

|||Okay, I found other problems now. :) Several of the files in subdirectories of the Program Files\Microsoft SQL Server folder were not able to be deleted. I rebooted in safe mode, and voila! the entire SQL Server folder was able to be deleted from Program Files. Unfortunately, this only results in a new error message when attempting to uninstall; a dialog box entitled "Microsoft SQL Server 2005 Express CTP" pops up with the message:
0:Watson 1:1807 2:StreamSupportFiles
3:getBootStrapDirectory 4:3
5:t:\yukon\sql\setup\darwin\sqlcastub\catarget.cpp
6:93 7:sqlcastub.dll 8:sqlrun.msi
Looks like arguments of some sort. Anyway, when I hit OK, a new box informs me that "A valid destination folder for the install could not be determined." (Since I deleted it, I'm guessing that's a valid observation.)
So it's looking like the (remaining) culprits are 1) miscellaneous unknown files in some portion of the Windows folder, or 2) unknown keys scattered throughout the registry. If anyone knows which/where, I'd appreciate the help. Meanwhile, I'll be poring through my registry looking for any offending entries.
|||It looks like the problem is now solved. I downloaded and ran the Microsoft Windows Install Clean Up program ( http://support.microsoft.com/default.aspx?scid=kb;en-us;290301 ), and sure enough, it found remnants of the CTP version of SQL Server Express. I removed those through the program and retried vs_uninst_betas.exe, which found no components of beta products. I then ran the SQL Server 2005 Express installer, which also detected no components from beta products. Now I just have to reinstall all the other Express products...
|||Thanks for this! I had the exact same problem and searched and tried for several days. This thread has been extremely helpful - the MS Windows Install Clean Up utility finally did it. Thanks! |||

Whoa!!

Now i wish i had come across this thread much before i tried uninstalling and installing the previous versions again and doing a clean uninstall of those previous versions, to no avail.

Spent a week on this but the Setup Cleanup Tool did that job in seconds.. and all of it in just a 185 KB download..

Thanks!!

Sreenath H B

|||

Thanks For the super information. Unfortunately I did not read the Cleanup utility and I was only installing the routine. After I finally read the instructions and ran it did it remove the offending entries. Does any one undestand why not all of the routines installed appear on the list. Are they only problem entries?

Thanks Jerry

|||

That fixed it. SQL Server install without issue after running the utility. Thanks for the great find - I was really frustrated.

|||

I'm getting the same error of "A valid destination folder for the install could not be determined." I don't have a copy of SQL 2005 installed on this server. Has anyone run across this on a clean install?

Thanks

|||

This Cleanup program looks like a really good general tool.

Thanks,

Pat

Error with setup of SQL Server 2005 Express

I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.
I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is:
The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer name snipped]} from cache
Unable to write property into cache IsClustered
Unable to write property into cache "IsClustered"
XmlRw Error: Failure loading xmlrw.dll
CheckAllProcedures() returned: 2
It should be noted that no VS or SQL products are currently installed on my machine (I uninstalled the new Express releases), and none show up in the Add/Remove Programs list. Any help would be greatly appreciated.

I had the same thing happen. Cannot install the new SQL Server 2005 on my systems either.

Cannot install SQL Server 2005 as it says there are remaining beta/CTP products that are not compatible. Tried running the vs_uninst_betas.exe. This had errors with the one reamaining product found of SQL Server Express Edition CTP.

The setup has encountered an unexpected error in datastore. The is RestoreSetupParams. The error is :Failed to read "Installlds" {MachineConfiguration", "", "name"} FRON CACHE

Unable to write property into cache: IsClustered

XMLRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned: 2

This is the first error

Click Ok

The second error is also datastore. The action is Write_CommitFlag. The is :Unable to write property into cache:flagCommit

Unable to write property into cache: "flagCommit"

XmlRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned: 2

Matt Porter wrote:

I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.

I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is:

The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer name snipped]} from cache
Unable to write property into cache IsClustered
Unable to write property into cache "IsClustered"
XmlRw Error: Failure loading xmlrw.dll
CheckAllProcedures() returned: 2

It should be noted that no VS or SQL products are currently installed on my machine (I uninstalled the new Express releases), and none show up in the Add/Remove Programs list. Any help would be greatly appreciated.

|||Okay, I found other problems now. :) Several of the files in subdirectories of the Program Files\Microsoft SQL Server folder were not able to be deleted. I rebooted in safe mode, and voila! the entire SQL Server folder was able to be deleted from Program Files. Unfortunately, this only results in a new error message when attempting to uninstall; a dialog box entitled "Microsoft SQL Server 2005 Express CTP" pops up with the message:
0:Watson 1:1807 2:StreamSupportFiles
3:getBootStrapDirectory 4:3
5:t:\yukon\sql\setup\darwin\sqlcastub\catarget.cpp
6:93 7:sqlcastub.dll 8:sqlrun.msi
Looks like arguments of some sort. Anyway, when I hit OK, a new box informs me that "A valid destination folder for the install could not be determined." (Since I deleted it, I'm guessing that's a valid observation.)
So it's looking like the (remaining) culprits are 1) miscellaneous unknown files in some portion of the Windows folder, or 2) unknown keys scattered throughout the registry. If anyone knows which/where, I'd appreciate the help. Meanwhile, I'll be poring through my registry looking for any offending entries.|||It looks like the problem is now solved. I downloaded and ran the Microsoft Windows Install Clean Up program ( http://support.microsoft.com/default.aspx?scid=kb;en-us;290301 ), and sure enough, it found remnants of the CTP version of SQL Server Express. I removed those through the program and retried vs_uninst_betas.exe, which found no components of beta products. I then ran the SQL Server 2005 Express installer, which also detected no components from beta products. Now I just have to reinstall all the other Express products...|||Thanks for this! I had the exact same problem and searched and tried for several days. This thread has been extremely helpful - the MS Windows Install Clean Up utility finally did it. Thanks! |||

Whoa!!

Now i wish i had come across this thread much before i tried uninstalling and installing the previous versions again and doing a clean uninstall of those previous versions, to no avail.

Spent a week on this but the Setup Cleanup Tool did that job in seconds.. and all of it in just a 185 KB download..

Thanks!!

Sreenath H B

|||

Thanks For the super information. Unfortunately I did not read the Cleanup utility and I was only installing the routine. After I finally read the instructions and ran it did it remove the offending entries. Does any one undestand why not all of the routines installed appear on the list. Are they only problem entries?

Thanks Jerry

|||

That fixed it. SQL Server install without issue after running the utility. Thanks for the great find - I was really frustrated.

|||

I'm getting the same error of "A valid destination folder for the install could not be determined." I don't have a copy of SQL 2005 installed on this server. Has anyone run across this on a clean install?

Thanks

|||

This Cleanup program looks like a really good general tool.

Thanks,

Pat

Error with setup of SQL Server 2005 Express

I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.
I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is:
The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer name snipped]} from cache
Unable to write property into cache IsClustered
Unable to write property into cache "IsClustered"
XmlRw Error: Failure loading xmlrw.dll
CheckAllProcedures() returned: 2
It should be noted that no VS or SQL products are currently installed on my machine (I uninstalled the new Express releases), and none show up in the Add/Remove Programs list. Any help would be greatly appreciated.

I had the same thing happen. Cannot install the new SQL Server 2005 on my systems either.

Cannot install SQL Server 2005 as it says there are remaining beta/CTP products that are not compatible. Tried running the vs_uninst_betas.exe. This had errors with the one reamaining product found of SQL Server Express Edition CTP.

The setup has encountered an unexpected error in datastore. The is RestoreSetupParams. The error is :Failed to read "Installlds" {MachineConfiguration", "", "name"} FRON CACHE

Unable to write property into cache: IsClustered

XMLRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned: 2

This is the first error

Click Ok

The second error is also datastore. The action is Write_CommitFlag. The is :Unable to write property into cache:flagCommit

Unable to write property into cache: "flagCommit"

XmlRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned: 2

Matt Porter wrote:

I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.

I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is:

The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer name snipped]} from cache
Unable to write property into cache IsClustered
Unable to write property into cache "IsClustered"
XmlRw Error: Failure loading xmlrw.dll
CheckAllProcedures() returned: 2

It should be noted that no VS or SQL products are currently installed on my machine (I uninstalled the new Express releases), and none show up in the Add/Remove Programs list. Any help would be greatly appreciated.

|||Okay, I found other problems now. :) Several of the files in subdirectories of the Program Files\Microsoft SQL Server folder were not able to be deleted. I rebooted in safe mode, and voila! the entire SQL Server folder was able to be deleted from Program Files. Unfortunately, this only results in a new error message when attempting to uninstall; a dialog box entitled "Microsoft SQL Server 2005 Express CTP" pops up with the message:
0:Watson 1:1807 2:StreamSupportFiles
3:getBootStrapDirectory 4:3
5:t:\yukon\sql\setup\darwin\sqlcastub\catarget.cpp
6:93 7:sqlcastub.dll 8:sqlrun.msi
Looks like arguments of some sort. Anyway, when I hit OK, a new box informs me that "A valid destination folder for the install could not be determined." (Since I deleted it, I'm guessing that's a valid observation.)
So it's looking like the (remaining) culprits are 1) miscellaneous unknown files in some portion of the Windows folder, or 2) unknown keys scattered throughout the registry. If anyone knows which/where, I'd appreciate the help. Meanwhile, I'll be poring through my registry looking for any offending entries.|||It looks like the problem is now solved. I downloaded and ran the Microsoft Windows Install Clean Up program ( http://support.microsoft.com/default.aspx?scid=kb;en-us;290301 ), and sure enough, it found remnants of the CTP version of SQL Server Express. I removed those through the program and retried vs_uninst_betas.exe, which found no components of beta products. I then ran the SQL Server 2005 Express installer, which also detected no components from beta products. Now I just have to reinstall all the other Express products...|||Thanks for this! I had the exact same problem and searched and tried for several days. This thread has been extremely helpful - the MS Windows Install Clean Up utility finally did it. Thanks! |||

Whoa!!

Now i wish i had come across this thread much before i tried uninstalling and installing the previous versions again and doing a clean uninstall of those previous versions, to no avail.

Spent a week on this but the Setup Cleanup Tool did that job in seconds.. and all of it in just a 185 KB download..

Thanks!!

Sreenath H B

|||

Thanks For the super information. Unfortunately I did not read the Cleanup utility and I was only installing the routine. After I finally read the instructions and ran it did it remove the offending entries. Does any one undestand why not all of the routines installed appear on the list. Are they only problem entries?

Thanks Jerry

|||

That fixed it. SQL Server install without issue after running the utility. Thanks for the great find - I was really frustrated.

|||

I'm getting the same error of "A valid destination folder for the install could not be determined." I don't have a copy of SQL 2005 installed on this server. Has anyone run across this on a clean install?

Thanks

|||

This Cleanup program looks like a really good general tool.

Thanks,

Pat

Error with setup of SQL Server 2005 Express

I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.
I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is:
The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer name snipped]} from cache
Unable to write property into cache IsClustered
Unable to write property into cache "IsClustered"
XmlRw Error: Failure loading xmlrw.dll
CheckAllProcedures() returned: 2
It should be noted that no VS or SQL products are currently installed on my machine (I uninstalled the new Express releases), and none show up in the Add/Remove Programs list. Any help would be greatly appreciated.

I had the same thing happen. Cannot install the new SQL Server 2005 on my systems either.

Cannot install SQL Server 2005 as it says there are remaining beta/CTP products that are not compatible. Tried running the vs_uninst_betas.exe. This had errors with the one reamaining product found of SQL Server Express Edition CTP.

The setup has encountered an unexpected error in datastore. The is RestoreSetupParams. The error is :Failed to read "Installlds" {MachineConfiguration", "", "name"} FRON CACHE

Unable to write property into cache: IsClustered

XMLRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned: 2

This is the first error

Click Ok

The second error is also datastore. The action is Write_CommitFlag. The is :Unable to write property into cache:flagCommit

Unable to write property into cache: "flagCommit"

XmlRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned: 2

Matt Porter wrote:

I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.

I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is:

The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer name snipped]} from cache
Unable to write property into cache IsClustered
Unable to write property into cache "IsClustered"
XmlRw Error: Failure loading xmlrw.dll
CheckAllProcedures() returned: 2

It should be noted that no VS or SQL products are currently installed on my machine (I uninstalled the new Express releases), and none show up in the Add/Remove Programs list. Any help would be greatly appreciated.

|||Okay, I found other problems now. :) Several of the files in subdirectories of the Program Files\Microsoft SQL Server folder were not able to be deleted. I rebooted in safe mode, and voila! the entire SQL Server folder was able to be deleted from Program Files. Unfortunately, this only results in a new error message when attempting to uninstall; a dialog box entitled "Microsoft SQL Server 2005 Express CTP" pops up with the message:
0:Watson 1:1807 2:StreamSupportFiles
3:getBootStrapDirectory 4:3
5:t:\yukon\sql\setup\darwin\sqlcastub\catarget.cpp
6:93 7:sqlcastub.dll 8:sqlrun.msi
Looks like arguments of some sort. Anyway, when I hit OK, a new box informs me that "A valid destination folder for the install could not be determined." (Since I deleted it, I'm guessing that's a valid observation.)
So it's looking like the (remaining) culprits are 1) miscellaneous unknown files in some portion of the Windows folder, or 2) unknown keys scattered throughout the registry. If anyone knows which/where, I'd appreciate the help. Meanwhile, I'll be poring through my registry looking for any offending entries.|||It looks like the problem is now solved. I downloaded and ran the Microsoft Windows Install Clean Up program ( http://support.microsoft.com/default.aspx?scid=kb;en-us;290301 ), and sure enough, it found remnants of the CTP version of SQL Server Express. I removed those through the program and retried vs_uninst_betas.exe, which found no components of beta products. I then ran the SQL Server 2005 Express installer, which also detected no components from beta products. Now I just have to reinstall all the other Express products...|||Thanks for this! I had the exact same problem and searched and tried for several days. This thread has been extremely helpful - the MS Windows Install Clean Up utility finally did it. Thanks! |||

Whoa!!

Now i wish i had come across this thread much before i tried uninstalling and installing the previous versions again and doing a clean uninstall of those previous versions, to no avail.

Spent a week on this but the Setup Cleanup Tool did that job in seconds.. and all of it in just a 185 KB download..

Thanks!!

Sreenath H B

|||

Thanks For the super information. Unfortunately I did not read the Cleanup utility and I was only installing the routine. After I finally read the instructions and ran it did it remove the offending entries. Does any one undestand why not all of the routines installed appear on the list. Are they only problem entries?

Thanks Jerry

|||

That fixed it. SQL Server install without issue after running the utility. Thanks for the great find - I was really frustrated.

|||

I'm getting the same error of "A valid destination folder for the install could not be determined." I don't have a copy of SQL 2005 installed on this server. Has anyone run across this on a clean install?

Thanks

|||

This Cleanup program looks like a really good general tool.

Thanks,

Pat

Error with setup of SQL Server 2005 Express

I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.
I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is:
The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer name snipped]} from cache
Unable to write property into cache IsClustered
Unable to write property into cache "IsClustered"
XmlRw Error: Failure loading xmlrw.dll
CheckAllProcedures() returned: 2
It should be noted that no VS or SQL products are currently installed on my machine (I uninstalled the new Express releases), and none show up in the Add/Remove Programs list. Any help would be greatly appreciated.

I had the same thing happen. Cannot install the new SQL Server 2005 on my systems either.

Cannot install SQL Server 2005 as it says there are remaining beta/CTP products that are not compatible. Tried running the vs_uninst_betas.exe. This had errors with the one reamaining product found of SQL Server Express Edition CTP.

The setup has encountered an unexpected error in datastore. The is RestoreSetupParams. The error is :Failed to read "Installlds" {MachineConfiguration", "", "name"} FRON CACHE

Unable to write property into cache: IsClustered

XMLRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned: 2

This is the first error

Click Ok

The second error is also datastore. The action is Write_CommitFlag. The is :Unable to write property into cache:flagCommit

Unable to write property into cache: "flagCommit"

XmlRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned: 2

Matt Porter wrote:

I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.

I attempted to install SQL Server 2005 from a fresh download, and it indicated that there were still beta components on the computer. I downloaded and ran the VS Beta Uninstall tool, which did find one component (SQL Server 2005 Express CTP), but it has an error while trying to uninstall it. The message is:

The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "Installds" {"MachineConfiguration", "", [computer name snipped]} from cache
Unable to write property into cache IsClustered
Unable to write property into cache "IsClustered"
XmlRw Error: Failure loading xmlrw.dll
CheckAllProcedures() returned: 2

It should be noted that no VS or SQL products are currently installed on my machine (I uninstalled the new Express releases), and none show up in the Add/Remove Programs list. Any help would be greatly appreciated.

|||Okay, I found other problems now. :) Several of the files in subdirectories of the Program Files\Microsoft SQL Server folder were not able to be deleted. I rebooted in safe mode, and voila! the entire SQL Server folder was able to be deleted from Program Files. Unfortunately, this only results in a new error message when attempting to uninstall; a dialog box entitled "Microsoft SQL Server 2005 Express CTP" pops up with the message:
0:Watson 1:1807 2:StreamSupportFiles
3:getBootStrapDirectory 4:3
5:t:\yukon\sql\setup\darwin\sqlcastub\catarget.cpp
6:93 7:sqlcastub.dll 8:sqlrun.msi
Looks like arguments of some sort. Anyway, when I hit OK, a new box informs me that "A valid destination folder for the install could not be determined." (Since I deleted it, I'm guessing that's a valid observation.)
So it's looking like the (remaining) culprits are 1) miscellaneous unknown files in some portion of the Windows folder, or 2) unknown keys scattered throughout the registry. If anyone knows which/where, I'd appreciate the help. Meanwhile, I'll be poring through my registry looking for any offending entries.
|||It looks like the problem is now solved. I downloaded and ran the Microsoft Windows Install Clean Up program ( http://support.microsoft.com/default.aspx?scid=kb;en-us;290301 ), and sure enough, it found remnants of the CTP version of SQL Server Express. I removed those through the program and retried vs_uninst_betas.exe, which found no components of beta products. I then ran the SQL Server 2005 Express installer, which also detected no components from beta products. Now I just have to reinstall all the other Express products...
|||Thanks for this! I had the exact same problem and searched and tried for several days. This thread has been extremely helpful - the MS Windows Install Clean Up utility finally did it. Thanks! |||

Whoa!!

Now i wish i had come across this thread much before i tried uninstalling and installing the previous versions again and doing a clean uninstall of those previous versions, to no avail.

Spent a week on this but the Setup Cleanup Tool did that job in seconds.. and all of it in just a 185 KB download..

Thanks!!

Sreenath H B

|||

Thanks For the super information. Unfortunately I did not read the Cleanup utility and I was only installing the routine. After I finally read the instructions and ran it did it remove the offending entries. Does any one undestand why not all of the routines installed appear on the list. Are they only problem entries?

Thanks Jerry

|||

That fixed it. SQL Server install without issue after running the utility. Thanks for the great find - I was really frustrated.

|||

I'm getting the same error of "A valid destination folder for the install could not be determined." I don't have a copy of SQL 2005 installed on this server. Has anyone run across this on a clean install?

Thanks

|||

This Cleanup program looks like a really good general tool.

Thanks,

Pat

Error with Bit datatype.

I created a table called "test" with only one column of bit data type.

I opened the table using management studio and tried to enter the number "1" It is throwing the below error

Microsoft SQL Server Management Studio

Invalid value for cell (row 1, column 1).

The changed value in this cell was not recognized as valid.
.Net Framework Data Type: Boolean
Error Message: String was not recognized as a valid Boolean.

Type a value appropriate for the data type or press ESC to cancel the change.

OK Help

But when I enter true or false it accepts it as a valid value.

When I execute the query
insert into test values (1)
the insert goes fine.

I opened table via management studio I am seeing "true" "false" as values in the table.
When I do a select in the query analyzer I am getting "1" and "0" as results.

Is this the way it is indented to work?

Santhosh

Here is my take...

When SSMS (written in VS.NET) opens a table, it is using a datagrid -and the datagrid is converting to a boolean because VS.NET doesn't have a bit datatype.

If you open a query window, and execute a SQL query that returns the data from the table, you will see that the data is indeed stored as a bit datatype [ 0/1/NULL ].

|||Arnie,
Thanks for the reply. Doesnt it sound stupid?|||I agree that there could be a bit more information available about how SSMS is working behind the scenes.|||Thats because the different UIs are owned by different groups at MS. They *might* get aligned in the future.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error while trying to modify one Maintenance Plan

Hello,

I am trying to modify one of my Maintenance Plan in MS Server Management Studio, and I am getting the following error:

TITLE: Microsoft SQL Server Management Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

Value of '9/6/2007 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.
Parameter name: Value (System.Windows.Forms)

BUTTONS:

OK

INteresting that it used to work fine, but since I am not the only one who is using thise server, I do not know what has been changed. I asked around, and everybody said they did not do anything...

Please help

Check out this link for an explanation and work-around: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1483359&SiteID=1

I had the exact same error and it worked for me.

|||

I would suggest to test what has been referred on that post and if it doesn't work, you could try reinstalling the SQL tools and sp2 again in order to see whether this is not a tools glitch.

As a workaround you might try to do the same from another machine.

Error while trying to modify one Maintenance Plan

Hello,

I am trying to modify one of my Maintenance Plan in MS Server Management Studio, and I am getting the following error:

TITLE: Microsoft SQL Server Management Studio

Cannot show the editor for this task.

ADDITIONAL INFORMATION:

Value of '9/6/2007 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'.
Parameter name: Value (System.Windows.Forms)

BUTTONS:

OK

INteresting that it used to work fine, but since I am not the only one who is using thise server, I do not know what has been changed. I asked around, and everybody said they did not do anything...

Please help

Check out this link for an explanation and work-around: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1483359&SiteID=1

I had the exact same error and it worked for me.

|||

I would suggest to test what has been referred on that post and if it doesn't work, you could try reinstalling the SQL tools and sp2 again in order to see whether this is not a tools glitch.

As a workaround you might try to do the same from another machine.

Error While Scheduling the SSIS Package

Hello Everyone,
When i try to scedule a job on SQL Server Management Studio it gives the Following Error:

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectkey'.(Micorsoft.SqlServer.Smo)

Can anyone tell me why ?

MS SQL Server Details:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Hi,

Do you have this file?

C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SqlServer.Smo.dll

Regards,

Janos

|||Yes, File is there on the specified path.

|||

Well, I got the same error one time, as far as I remember, I repaired my installation of SQL Server client tool.

Try to repair it please.

regards,

Janos

|||thanks janos,

i have a local server installed on my workstation along with sp2.
Do you really think reinstalling the server will work ?
|||

Well, It worked for me

Maybe you just repair your installation will be enough.

Regards,

Janos

|||Is there any option for repairing the server ?
Coz i haven't seen any while installing.
|||Did you manage to find a solution for this problem? I get the same error when trying to create an Agent job. I've repaired the SQL Native Client but to no avail. I still get the error.
|||No, not yet !!! I am still working on it.
One of the forum member advised me to repair the server but for you if it did not work, then i am doubtful.
|||You can repair the application from "Programs and Features" (Vista) or "Add/Remove Programs" (XP) in control panel|||

Hi Vick,

I just realized something. I saw the error message contains the SQL build w/o service pack, but you wrote you have SP2 installed (but maybe just for database services and SSMS or just SSIS). Have you tried to install the SP2 to the SSIS or those, where not installed?

Regards,

Janos

|||No, Its not working even after repairing the server.

Thanks
Janos
|||Sorry Vick, I'm out of ideas. I tried to recreate the same error on a virtual machine, but no luck. I'm sorry.|||Hi Janos,

Sp2 is not specific to the service you are using. It upgrades all the services of server (EE, DE, SE, etc).

Check out the link
http://www.microsoft.com/downloads/details.aspx?familyid=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en
|||check out the post.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1793362&SiteID=1

check if you are experiencing the same.