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: 18456, Severity: 14, State: 16

Hi All,
I am getting the following error in the ERRORLOG File when I am trying
to connect to SQL Server 2005 Express Edition from the command line.
2007-03-23 07:30:05.54 Logon Error: 18456, Severity: 14, State:
16.
2007-03-23 07:30:05.54 Logon Login failed for user 'sa'.
[CLIENT: xx.xx.xx.xx]
I have a fresh install of SQL Server on my local machine, which is
probably the source of my angst, but I am trying to create a database
from scratch through using a batch file that is run from the command
line, the batch file looks like this:
<snip>
SQLCMD -U %USR% -P %PWD% -S %SVR% -d %DBF% -i CreateDatabase.sql
<snip>
The values of %USR% and %PWD% are correct as I frequently log into
Management Studio with the details, %SVR% is "<ComputerName>
\SQLEXPRESS,1433" and %DBF% is <DatabaseName>. The contents of
CreateDatabase.sql when run in Management Studio successfully creates
the database that I require so I know the error doesn't lie there.
The command line error that is showing reads as the following:
Msg 4060, Level 11, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
Cannot open database "<DatabaseName>" requested by the login. The
login failed.
Msg 18456, Level 14, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
Login failed for user 'sa'.
I have a feeling that it is related to 'sa' not having the correct
permissions with regards to logging into or creating a database from
scratch, but I find it odd that I can login as 'sa' in Management
Studio and create the database from there, but when I try it from the
command-line (despite having TCP/IP enabled) it won't let me connect
to create a database.
Is there something I am missing here? I have been banging my head off
of walls for days over this and am unsure of the next steps to take.
If any of this screams "why the hell are you doing this?" then please
let me know as at the moment I am punching in the dark with this
problem, I have searched Usenet, Google Groups, the Web and although I
have found potential solutions to this particular problem I am having,
nothing I have done so far has actually managed to fix the issue.
Related articles I have followed are:
Login failed for user 'x'
http://msdn2.microsoft.com/en-us/library/ms366351.aspx
Change Server Authentication Mode
http://msdn2.microsoft.com/en-us/library/ms188670.aspx
Upgrading MSDE 2000 to SQL Server 2005 Express [Enabling network
protocols section]
http://www.microsoft.com/technet/pr...sqlexpress.mspx
NOTE: I just listed these articles to show what path I am currently
looking at with regards to this problem, but again I stress I have
found nothing yet to get round this problem, and any further articles
or direction would be much appreciated.
Yours Distressingly
AlastairDoes the password have any blank spaces or double quotes ?
Jens K. Suessmeyer.
http://www.sqlserver2005.de
--
"Alastair" <alastair_anderson@.hotmail.com> wrote in message
news:1174642161.471601.110030@.y80g2000hsf.googlegroups.com...
> Hi All,
> I am getting the following error in the ERRORLOG File when I am trying
> to connect to SQL Server 2005 Express Edition from the command line.
> 2007-03-23 07:30:05.54 Logon Error: 18456, Severity: 14, State:
> 16.
> 2007-03-23 07:30:05.54 Logon Login failed for user 'sa'.
> [CLIENT: xx.xx.xx.xx]
> I have a fresh install of SQL Server on my local machine, which is
> probably the source of my angst, but I am trying to create a database
> from scratch through using a batch file that is run from the command
> line, the batch file looks like this:
> <snip>
> SQLCMD -U %USR% -P %PWD% -S %SVR% -d %DBF% -i CreateDatabase.sql
> <snip>
> The values of %USR% and %PWD% are correct as I frequently log into
> Management Studio with the details, %SVR% is "<ComputerName>
> \SQLEXPRESS,1433" and %DBF% is <DatabaseName>. The contents of
> CreateDatabase.sql when run in Management Studio successfully creates
> the database that I require so I know the error doesn't lie there.
> The command line error that is showing reads as the following:
> Msg 4060, Level 11, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
> Cannot open database "<DatabaseName>" requested by the login. The
> login failed.
> Msg 18456, Level 14, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
> Login failed for user 'sa'.
> I have a feeling that it is related to 'sa' not having the correct
> permissions with regards to logging into or creating a database from
> scratch, but I find it odd that I can login as 'sa' in Management
> Studio and create the database from there, but when I try it from the
> command-line (despite having TCP/IP enabled) it won't let me connect
> to create a database.
> Is there something I am missing here? I have been banging my head off
> of walls for days over this and am unsure of the next steps to take.
> If any of this screams "why the hell are you doing this?" then please
> let me know as at the moment I am punching in the dark with this
> problem, I have searched Usenet, Google Groups, the Web and although I
> have found potential solutions to this particular problem I am having,
> nothing I have done so far has actually managed to fix the issue.
> Related articles I have followed are:
> Login failed for user 'x'
> http://msdn2.microsoft.com/en-us/library/ms366351.aspx
> Change Server Authentication Mode
> http://msdn2.microsoft.com/en-us/library/ms188670.aspx
> Upgrading MSDE 2000 to SQL Server 2005 Express [Enabling network
> protocols section]
> http://www.microsoft.com/technet/pr...sqlexpress.mspx
> NOTE: I just listed these articles to show what path I am currently
> looking at with regards to this problem, but again I stress I have
> found nothing yet to get round this problem, and any further articles
> or direction would be much appreciated.
> Yours Distressingly
> Alastair
>|||On 23 Mar, 13:00, "Jens K. Suessmeyer" <J...@.NoSpamhere-
sqlserver2005.de> wrote:
> Does the password have any blank spaces or double quotes ?
> Jens K. Suessmeyer.
> --http://www.sqlserver2005.de
> --
> "Alastair" <alastair_ander...@.hotmail.com> wrote in message
> news:1174642161.471601.110030@.y80g2000hsf.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
The only double quotes that it contains are those that surround the
password in the .bat file.
Should these be single quotes?|||Normally this should work, did you try conencting with the same syntax that
you are using in the batch file via an interactive commandprompt ? Did you
try to leave out the quotes ?
Jens K. Suessmeyer.
http://www.sqlserver2005.de
--
"Alastair" <alastair_anderson@.hotmail.com> wrote in message
news:1174655306.297982.325260@.b75g2000hsg.googlegroups.com...
> On 23 Mar, 13:00, "Jens K. Suessmeyer" <J...@.NoSpamhere-
> sqlserver2005.de> wrote:
> The only double quotes that it contains are those that surround the
> password in the .bat file.
> Should these be single quotes?
>|||On 23 Mar, 21:26, "Jens K. Suessmeyer" <J...@.NoSpamhere-
sqlserver2005.de> wrote:
> Normally this should work, did you try conencting with the same syntax tha
t
> you are using in the batch file via an interactive commandprompt ? Did you
> try to leave out the quotes ?
> Jens K. Suessmeyer.
> --http://www.sqlserver2005.de
> --
> "Alastair" <alastair_ander...@.hotmail.com> wrote in message
> news:1174655306.297982.325260@.b75g2000hsg.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
Hi Jens,
Thanks for the input on this it is very much appreciated,
I tried running the batch file without quotations around the strings
and I still get the same error, I also tried single quotes, but the
command-line processor was interpreting them as part of the strings.
I took your advice and tried running it straight from the command-line
without using the .bat file, and still the same error came screaming
back at me.
Alastair|||On 23 Mar, 21:26, "Jens K. Suessmeyer" <J...@.NoSpamhere-
sqlserver2005.de> wrote:
> Normally this should work, did you try conencting with the same syntax tha
t
> you are using in the batch file via an interactive commandprompt ? Did you
> try to leave out the quotes ?
> Jens K. Suessmeyer.
> --http://www.sqlserver2005.de
> --
> "Alastair" <alastair_ander...@.hotmail.com> wrote in message
> news:1174655306.297982.325260@.b75g2000hsg.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
I've done some further hunting around for solutions, could it
potentially be related to "sa" not having any permissions in the
SYS.DATABASE_PERMISSIONS table?|||No, sa has by default access to everything, including the internal data.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
--
"Alastair" <alastair_anderson@.hotmail.com> wrote in message
news:1174779869.212689.303860@.o5g2000hsb.googlegroups.com...
> On 23 Mar, 21:26, "Jens K. Suessmeyer" <J...@.NoSpamhere-
> sqlserver2005.de> wrote:
> I've done some further hunting around for solutions, could it
> potentially be related to "sa" not having any permissions in the
> SYS.DATABASE_PERMISSIONS table?
>

Error: 18456, Severity: 14, State: 11.

i am new to sql server 2005 express. I am trying to set up xp embedded database. I am trying to allow remote access to a central xp embedded database. i have the database on the sql server machine.

i am using the component database manager toll on a remote machine so that i can connect to the remote xp embedded database. when i try to connect to the db through sql server i get the following error in the log file.

2006-09-12 17:15:10.18 Logon Error: 18456, Severity: 14, State: 11.
2006-09-12 17:15:10.18 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]

where HOSTNAME is the hostname of the pc that sql server 2005 is running.

XX.XX.XX.XX is the ip address of the client which is running component database manager tool.

what am i doing wrong here.

YOu will have to disable simple filesharing at the WIndows box, because the user will be otherwise authenticated by the Guest user.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

that did it.

i dont have any clue why it works. but that did it.

thanks a million.

we should call you Mr. Geniusmeyer!!!

|||

i have another problem.

i can connect to the sql server 2005 express from one laptop.

however, if i try from another laptop i get the above error.

what is wrong with the second pc.

thanks,

jeff

|||

Do you have stored user credentials on that machine ? is the error message the same as the one mentioned in the first post ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

no the first post was state 11. This error is state 16.

im not sure what stored user credentials are.

are you talking about on the db client machine?

|||Stored credentials can be found navigating to the to the Control Panel > User Accounts > Choose the User > manage you network accounts. You might have a fixed stored credential enetered there ?

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de
|||Simple file sharing is not at all enables on my machine. I still have this problem when I tried to connect from a sql server 2000 machine to any other version of sql server using linked server. Please advice

Thanks in advance,
Venkat
|||

Hi, have you ever received an answer or solution to this one? I am experiencing the same problem, went through all the same steps. Windows has no info on their website that I could find....

Thanks,

Regards

JD

Error: 18456, Severity: 14, State: 11.

i am new to sql server 2005 express. I am trying to set up xp embedded database. I am trying to allow remote access to a central xp embedded database. i have the database on the sql server machine.

i am using the component database manager toll on a remote machine so that i can connect to the remote xp embedded database. when i try to connect to the db through sql server i get the following error in the log file.

2006-09-12 17:15:10.18 Logon Error: 18456, Severity: 14, State: 11.
2006-09-12 17:15:10.18 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]

where HOSTNAME is the hostname of the pc that sql server 2005 is running.

XX.XX.XX.XX is the ip address of the client which is running component database manager tool.

what am i doing wrong here.

YOu will have to disable simple filesharing at the WIndows box, because the user will be otherwise authenticated by the Guest user.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

that did it.

i dont have any clue why it works. but that did it.

thanks a million.

we should call you Mr. Geniusmeyer!!!

|||

i have another problem.

i can connect to the sql server 2005 express from one laptop.

however, if i try from another laptop i get the above error.

what is wrong with the second pc.

thanks,

jeff

|||

Do you have stored user credentials on that machine ? is the error message the same as the one mentioned in the first post ?

HTH, Jens Suessmeyer.

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

no the first post was state 11. This error is state 16.

im not sure what stored user credentials are.

are you talking about on the db client machine?

|||Stored credentials can be found navigating to the to the Control Panel > User Accounts > Choose the User > manage you network accounts. You might have a fixed stored credential enetered there ?

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de
|||Simple file sharing is not at all enables on my machine. I still have this problem when I tried to connect from a sql server 2000 machine to any other version of sql server using linked server. Please advice

Thanks in advance,
Venkat
|||

Hi, have you ever received an answer or solution to this one? I am experiencing the same problem, went through all the same steps. Windows has no info on their website that I could find....

Thanks,

Regards

JD

Error: 18456, Severity: 14, State: 11.

i am new to sql server 2005 express. I am trying to set up xp embedded database. I am trying to allow remote access to a central xp embedded database. i have the database on the sql server machine.

i am using the component database manager toll on a remote machine so that i can connect to the remote xp embedded database. when i try to connect to the db through sql server i get the following error in the log file.

2006-09-12 17:15:10.18 Logon Error: 18456, Severity: 14, State: 11.
2006-09-12 17:15:10.18 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]

where HOSTNAME is the hostname of the pc that sql server 2005 is running.

XX.XX.XX.XX is the ip address of the client which is running component database manager tool.

what am i doing wrong here.

YOu will have to disable simple filesharing at the WIndows box, because the user will be otherwise authenticated by the Guest user.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

that did it.

i dont have any clue why it works. but that did it.

thanks a million.

we should call you Mr. Geniusmeyer!!!

|||

i have another problem.

i can connect to the sql server 2005 express from one laptop.

however, if i try from another laptop i get the above error.

what is wrong with the second pc.

thanks,

jeff

|||

Do you have stored user credentials on that machine ? is the error message the same as the one mentioned in the first post ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

no the first post was state 11. This error is state 16.

im not sure what stored user credentials are.

are you talking about on the db client machine?

|||Stored credentials can be found navigating to the to the Control Panel > User Accounts > Choose the User > manage you network accounts. You might have a fixed stored credential enetered there ?

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de
|||Simple file sharing is not at all enables on my machine. I still have this problem when I tried to connect from a sql server 2000 machine to any other version of sql server using linked server. Please advice

Thanks in advance,
Venkat
|||

Hi, have you ever received an answer or solution to this one? I am experiencing the same problem, went through all the same steps. Windows has no info on their website that I could find....

Thanks,

Regards

JD

sql

Error: 18456, Severity: 14, State: 11 Valid login but server access failure

Hi

I am new to SQL server and I have been trying hard to make a client computer to remote connect to a SQL express database on host computer

I have a VB6 application that can connect to SQL server database LOCALLY without problem:

Connection String is:

my_connection.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyMushroom;Data Source=LAPTOP\SQLEXPRESS"

I have followed instruction on enabling remote connection function from this blog:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

I then try to run the same app from the client computer, it gives me:

Login failed for user 'LAPTOP\Guest'.

After looking up the web for solution, I found that I can test the connection from the HOST computer in this way:

C:\Documents and Settings\kit>sqlcmd -E -S laptop\sqlexpress
1>
2>

The test is successful

Now I run the same command on the CLIENT computer

C:\Documents and Settings\Kit>sqlcmd -E -S laptop\sqlexpress
Msg 18456, Level 14, State 1, Server LAPTOP\SQLEXPRESS, Line 1
Login failed for user 'LAPTOP\Guest'.

Now I can sure that from the client computer it cannot make a connection to it, then I look at the errorLog from my host computer

2006-08-13 21:41:00.34 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:41:00.34 Logon Login failed for user 'LAPTOP\Guest'. [CLIENT: 192.168.0.5]
2006-08-13 21:45:10.64 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:45:10.64 Logon Login failed for user 'LAPTOP\Guest'. [CLIENT: 192.168.0.5]
2006-08-13 21:48:41.80 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:48:41.80 Logon Login failed for user 'LAPTOP\Guest'. [CLIENT: 192.168.0.5]

Now I know it is actually Error: 18456, Severity: 14, State: 11.

From this site : http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

11 and 12

Valid login but server access failure

It tells the connection string and SQL Express seem to be set up properly but the server access failed the remote connection

I have previously had SQL Server 2000 installed. I uninstalled SQL 2000 before I install SQL express but somehow the SQL Server Service Manager is still running at startup, and C:\Program Files\Microsoft SQL Server\80 and its files are still exist after uninstallation..... Could this be a problem?

The Knowledge base suggestion on "enabling remote connection" is very simple and I do not understand why it is so difficult to me just to make a remote connection test work..... please, I need your help.

If you want to use Windows Authentication you have to disable the "Simple File and printer sharing" at the "server" (even if its only WIndows XP). With this option enabled, it normally simplifies the logon process as the requestor does not have to give a user name and a password, because he will be logged on with the Guest user.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||I did try to disable the file sharing, and also have firewall disabled. But it still gives me the same error..... |||

OK, did you disable that on the "server" (Whereever SQL Server is running on) ?

-Jens.

|||

Yes, to make sure file sharing is disabled , I unlick the Simple File Sharing from Folder Option on both computers.

Both computer have file sharing disabled

filewall disabled

But I am still getting the same error.

Anything to do with MSDE 2000 instance? I have uninstalled MSDE2000 before I install SQL expresss.

What is wrong still?

|||

By the way, I restarted both computer and still got the same error on the client computer while the hosting computer is connecting to the KIT\SQLExpress alright :

C:\Documents and Settings\Kit>sqlcmd -E -S kit\sqlexpress
1>
2>
3>
4>
5>

Here is the current setting of my SQLexpress instance

SQL Server Config. Manager
Protoal: Shared Memory, TCP/IP enabled (Name Pipes and VIA disabled)
SQL server (SQLExpress) and SQL server Browser are running , startmode: automatic
For SQL Server Browser: Log on as : Bulit-in account: Network Service
For SQL Server (SQLExpress): Log on as : Bulit-in account: Network Service
Under Service - General -
Host Name: KIT
Name: SQL Server (SQLExpress)

SQL Native Config. - Client Protocols - Shard Memory 1, TCP/IP 2

SQL Server Surface Area Config.
Service Name: MSSQL$SQLEXPRESS
Display Name: SQL Server (SQLEXPRESS)
Remote COnnection: Local and Remote connection clicked - Using TCP/IP Only clicked

The client computer do not have any SQL express installed, could that be the reason?

Frankly, on the server computer , it can connect to the database on TCP/IP using SQL Management Studio

Here I attached the screen shots

http://www.megaupload.com/?d=JWN349QL

|||

I have a few questions about your setup:

- on the client machine, what account is your application running under?
- when you tried connecting to SQL Express locally, using sqlcmd, what was the account you actually connected as? (you can execute "select suser_name()" to find this out)

Thanks
Laurentiu

|||

Client is running Win XP Professional SP2

Server is running Win XP pro SP2

Client machine is logged in as Admin , without password (so it goes straight into the OS when you start up the machine and bypass the log in screen)

Server machine is also logged in as Admin, with passowrd (log-in: Kit, password: Kit) , TweakUI is setup to log in automatically using the log-in/password pair.

- when you tried connecting to SQL Express locally, using sqlcmd, what was the account you actually connected as? (you can execute "select suser_name()" to find this out) :

C:\Documents and Settings\Kit>sqlcmd -E -S kit\sqlexpress
1> select suser_name()
2> go

--
KIT\Kit

(1 rows affected)
1>

Hope this will give you idea of what has gone wrong with my SQL express setting

Thank you for your response.

|||

On the Server Computer , under Control Panel -> User Accounts , there are 3 accounts: Kit (myself), SQLDebugger and Guest

Guest account is not password protected and is set to off. (I've tried to turn this account on and off but the client computer still give me the same error)

I really havae no idea what I have gone it wrong...

|||

I just realize what you meant by "on the client machine, what account is your application running under?"

It is running under Network Service

|||

Locally, you connect as Kit, which seems to have server access. Remotely, you appear to execute as Network Service and when you get on the server machine, you are actually running as Guest, which does not have server access.

If you execute

CREATE LOGIN [Laptop\Guest] FROM WINDOWS

then you will grant server access to the Guest account.

But if you want your application to connect as Kit, you should run it as Kit or it should internally impersonate Kit before connecting to the server.

Thanks
Laurentiu

|||

To Laurentiu and Jens:

Thank you for your great help and now the client can connect to the server SQL express. I have been myself studying the SQL server and exploring how SQL server work. This SQL express is very interesting and I have a lot more to learn about this "toy".

I am very appreciated to your helps.

Kit

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/Failure Audit in Event Logs (SQL 2005 Express) [Advanced Services]

Q1: Any way to control which db loads when, and perhaps stop this error from happening? Again- when all is said and done, the report server functions, and I am able to access just fine.

Q2: What kind of recovery is being referred to? Given the message type- I assume it's nothing of concern- probably more to do with a system that doesn't run all the time.

Okay- so I get these two event messages each time I boot.

Below are two error message I see daily with each system boot- the services mentioned do "actually" function, and are running- as not 10 seconds after these messages are logged, the successfully loaded messages appear. It's almost as if report services tries to connect before the databases are up and running.

Basically the sequence (today) was:

1. 05:49:01 Failure Audit (MSSQL$SQLEXPRESS)

2. 05:49:01 Error (Report Server Windows Service (SQLEXPRESS)

3. 05:49:02 Recovery is complete. (EventID 3408 MSSQL$SQLEXPRESS)

4. 05:49:06 Starting up database 'ReportServer'

5. 05:49:09 Server Resumed execution (MSSQL$SQLEXPRESS)

I'm assuming based on the events that Report Server Service attempts to connect to the ReportServer database before it's actually started. Doesn't really explain the failure audit-

1. Failure Audit:

Event Type: Failure Audit
Event Source: MSSQL$SQLEXPRESS
Event Category: (4)
Event ID: 18456
Date: 8/9/2007
Time: 05:49:01
User: <MACHINENAME>\<LOCALUSER>
Computer: <MACHINENAME>
Description:
Login failed for user '<MACHINENAME>\<LOCALUSER>'.

[CLIENT: <local machine>]

This is almost immediately followed by this (which I consider a no-brainer, considering the above):

2. Error:

Event Type: Error
Event Source: Report Server Windows Service (SQLEXPRESS)
Event Category: Management
Event ID: 107
Date: 8/9/2007
Time: 05:49:01
User: N/A
Computer: <MACHINENAME>
Description:
Report Server Windows Service (SQLEXPRESS) cannot connect to the report server database.

The master database is started first, you cannot control the order in which the database are started up. if the users tries to connect to the database he will be authenticated by SQL Server and directly tries to change the default database or if explicitly mentioned in the connection string connect to the database. if the database is not yet started he will get a login failed (although authenticated but he was not able to change the database context). if you have these problems, try to set the dependency of Report Server to the SQL Service to make sure that Reporting Server will only be started if the SQL Server Service has been. This might help you getting some additional time for the server to make a regular recovery (which is normal if the database / server was not shutdown properly)

Jens K. Suessmeyer

http://www.sqlserver2005.de

Error, while connecting with SQL Server 2005 express edition

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact under the default settings of SQL SERver does not allow remote connections.
(provider:Named Pipes Provider, error: 40-Could not open a connection to SQL Server)

Hi,

Did you enabled setting to allow remote connection? Please see the blog for setup Remote connection

http://blogs.msdn.com/sqlexpress/

Hope that helps,

Lan

|||abrahampackiaraj
thank you, I already verified the tick mark in the check box of"allow remote connections" and I restarted the system. but this errorfollows up|||

did you manage to solve this problem as i have the same issue

Thanks

|||but while installing asp.net 2.0 , it doesn't even ask for that option. where from i can get that...|||whre from you got the option to tick the check box of "allow remote connections", i dont find that..|||

You can find it in SQL Server Surface Area Configuration. You may take a look at this post:

http://forums.asp.net/thread/1347652.aspx

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 while trying to create a new connection in Visual C# Express 2005

Hi, the other day i decided to download and install C# Express and SQL Server Express 2005. I created a new project in C# Express then I decided to practice with database connectivity so I tried to create a new connection, in the wizard I specified SQL Server Authentication, typed the user name and password and when I pushed the button "Test Connection" I recieve this error message "Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed". I also have tried Windows Autentication, but it displays a more complex error that says something about the database file being used by other process. I have been trying to solve this problem, but nothing works. I think I need some help.

While adding a Data Source in VB2005EE I also got this error which you received:

"Failed to generate a user instance of SQL server. Only an integrated connection can generate a user instance. The connection will be closed."

Solution that worked for me:

On the "Add Connection" Dialog, click the "Advanced" Button. Go to the Property "User Instance" under "Source". Change the value to "False" & you are done.

Error while trying to create a new connection in Visual C# Express 2005

Hi, the other day i decided to download and install C# Express and SQL Server Express 2005. I created a new project in C# Express then I decided to practice with database connectivity so I tried to create a new connection, in the wizard I specified SQL Server Authentication, typed the user name and password and when I pushed the button "Test Connection" I recieve this error message "Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed". I also have tried Windows Autentication, but it displays a more complex error that says something about the database file being used by other process. I have been trying to solve this problem, but nothing works. I think I need some help.

While adding a Data Source in VB2005EE I also got this error which you received:

"Failed

to generate a user instance of SQL server. Only an integrated

connection can generate a user instance. The connection will be closed."

Solution that worked for me:

On

the "Add Connection" Dialog, click the "Advanced" Button. Go to the

Property "User Instance" under "Source". Change the value to "False"

& you are done.