Receiving Error 26 when trying to connect to DB...Some Machines

Good Day,

We have a recently developed (and in testing) VB .Net application which attaches to a specific SQL2005 DB. The issue is that when installed (or run in DEBUG mode) on the developer box it successfully connects to the appropriate db locally and to the live server. When installed on a test box (several of them) we receive error - 26 Error locating Server/Instance Specified.

The SQL Server instance is set up for remote connections and works for other dbs.

All of the boxes are running XP Pro, with all SPs applied.

Any thoughts on what may be occuring would be greatly appreciated.

This might help:
"Connection error occurs when the Database Engine service account password expires

The

following error occurs when you connect to a report server, and the

service account password has expired for the SQL Server Database Engine

instance that hosts the report server database: "The report server

cannot open a connection to the report server database. A connection to

the database is required for all requests and processing.

(rsReportServerDatabaseUnavailable)."

The error message includes

these additional statements: "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 that under the default settings SQL

Server does not allow remote connections. (provider: SQL Server Network

Interfaces, error: 26 - Error Locating Server/Instance Specified)."

To resolve this error, reset the password. For more information, see Changing Passwords and User Accounts."

http://msdn2.microsoft.com/en-us/library/ms156468.aspx

Also check out this kb:
http://support.microsoft.com/kb/905618

rebuild master question

Using SQL 2K
Say i have SQL 2K with SP3a and the latest security patch installed and now
my master goes corrupt but I have a recent master db backup someplace.
If i rebuild master using the rebuildm utility, do i have to install the
SP3a and the security patch again before i try to restore the master db or
should i just restore master next ? Just a lil confused as the restore
master article mentions to ensure that the SQL installation is at the same
version as the master backup before restoring..
btw, what does the rebuilm internally do ? Thanks
Fatima,
We would strongly advise that you reapply sp3a as well as the hotfixes.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

rebuild master question

Using SQL 2K
Say i have SQL 2K with SP3a and the latest security patch installed and now
my master goes corrupt but I have a recent master db backup someplace.
If i rebuild master using the rebuildm utility, do i have to install the
SP3a and the security patch again before i try to restore the master db or
should i just restore master next ? Just a lil confused as the restore
master article mentions to ensure that the SQL installation is at the same
version as the master backup before restoring..
btw, what does the rebuilm internally do ? ThanksFatima,
We would strongly advise that you reapply sp3a as well as the hotfixes.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

rebuild master question

Using SQL 2K
Say i have SQL 2K with SP3a and the latest security patch installed and now
my master goes corrupt but I have a recent master db backup someplace.
If i rebuild master using the rebuildm utility, do i have to install the
SP3a and the security patch again before i try to restore the master db or
should i just restore master next ? Just a lil confused as the restore
master article mentions to ensure that the SQL installation is at the same
version as the master backup before restoring..
btw, what does the rebuilm internally do ? ThanksFatima,
We would strongly advise that you reapply sp3a as well as the hotfixes.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Rebuild fulltext

Hi!
I have a problem with a 4-node cluster. It was a 2-node sql2k on w2k.
We installed new hw with w2k3 and installed the old instances there
(restore). After that we added 2 more w2k3 nodes and installed the
original 2 instances on all 4 nodes. We also set up 2 new instances to
be a total of 4.
The problem is that when we put in the new hw (node 3 and 4) we saw
that we lost the control of the fulltext resource on the first 2
instances. It started failing and then failback, sometimes it started,
sometimes not. This started before we actually joined node 3-4 to the
clustrer. Since we don't use fulltext we took away the resource from
the cluster on these 2 instances. On the new instances (3 and 4) there
has newer been a problem. All nodes can run all 4 instances. There is
no problem with any other resource.
I have seen kb 812666 and I think that I should try rebuildning
fulltext. I think it looks very complex, is there anyone that have
done this?
/Peter
Peter,
Yes, KB article 812666 "How to recover a failed full-text search resource on
a clustered instance of SQL Server 2000" at
http://support.microsoft.com/default.aspx?kbid=812666 is complex, but since
you don't use the MSSearch (Fulltext ) service, and have already removed the
fulltext (Microsoft Search) service from the cluster resource, rebuilding
this service is not necessary/
Note, you can also post FTS related questions to the newsgroup:
microsoft.public.sqlserver.fulltext
Regards,
John
"Peter Lindberg" <peter.lindbergTAKE@.AWAYmartinsson.se> wrote in message
news:415bfda4.4507871@.msnews.microsoft.com...
> Hi!
> I have a problem with a 4-node cluster. It was a 2-node sql2k on w2k.
> We installed new hw with w2k3 and installed the old instances there
> (restore). After that we added 2 more w2k3 nodes and installed the
> original 2 instances on all 4 nodes. We also set up 2 new instances to
> be a total of 4.
> The problem is that when we put in the new hw (node 3 and 4) we saw
> that we lost the control of the fulltext resource on the first 2
> instances. It started failing and then failback, sometimes it started,
> sometimes not. This started before we actually joined node 3-4 to the
> clustrer. Since we don't use fulltext we took away the resource from
> the cluster on these 2 instances. On the new instances (3 and 4) there
> has newer been a problem. All nodes can run all 4 instances. There is
> no problem with any other resource.
> I have seen kb 812666 and I think that I should try rebuildning
> fulltext. I think it looks very complex, is there anyone that have
> done this?
> /Peter
|||John,
thanks for the reply. My intention is to get all 4 nodes equal setup.
We want to be able to run new databases where it's best suitet and
don't depend on differenses between instances. That's way I want to do
this. I have to set up my test environment so I can test it before I
go in the production.
Have you done this in a cluster?
/Peter
On Thu, 30 Sep 2004 11:19:01 -0700, "John Kane" <jt-kane@.comcast.net>
wrotc:

>Peter,
>Yes, KB article 812666 "How to recover a failed full-text search resource on
>a clustered instance of SQL Server 2000" at
>http://support.microsoft.com/default.aspx?kbid=812666 is complex, but since
>you don't use the MSSearch (Fulltext ) service, and have already removed the
>fulltext (Microsoft Search) service from the cluster resource, rebuilding
>this service is not necessary/
>Note, you can also post FTS related questions to the newsgroup:
>microsoft.public.sqlserver.fulltext
>Regards,
>John
>
>
>"Peter Lindberg" <peter.lindbergTAKE@.AWAYmartinsson.se> wrote in message
>news:415bfda4.4507871@.msnews.microsoft.com...
>
|||You're welcome, Peter,
Unfortunately, I do not have a clustered environment to test this KB
article, as I have only one home server and a laptop... ;-(
If you do have a test clustered environment, even one with just two nodes,
I'd recommend that you test using that environment.
Regards,
John
"Peter Lindberg" <peter.lindbergTAKE@.AWAYmartinsson.se> wrote in message
news:415d70eb.31078308@.msnews.microsoft.com...[vbcol=seagreen]
> John,
> thanks for the reply. My intention is to get all 4 nodes equal setup.
> We want to be able to run new databases where it's best suitet and
> don't depend on differenses between instances. That's way I want to do
> this. I have to set up my test environment so I can test it before I
> go in the production.
> Have you done this in a cluster?
> /Peter
> On Thu, 30 Sep 2004 11:19:01 -0700, "John Kane" <jt-kane@.comcast.net>
> wrotc:
on[vbcol=seagreen]
since[vbcol=seagreen]
the
>
|||I'll definitive test it. It will be under vmware gsx.
/Peter
On Mon, 4 Oct 2004 10:57:02 -0700, "John Kane" <jt-kane@.comcast.net>
wrotc:

>You're welcome, Peter,
>Unfortunately, I do not have a clustered environment to test this KB
>article, as I have only one home server and a laptop... ;-(
>If you do have a test clustered environment, even one with just two nodes,
>I'd recommend that you test using that environment.
>Regards,
>John
>
>"Peter Lindberg" <peter.lindbergTAKE@.AWAYmartinsson.se> wrote in message
>news:415d70eb.31078308@.msnews.microsoft.com...
>on
>since
>the
>

reboot reboot reboot

I have installed ss2005 and now I want to change some things (add the
AdventureWorks dbs). On one machine it worked fine but on the other System
Configuration Check keeps getting a reboot required message that says...
"A previous installation required a reboot of the machine for changes to
take effect. To proceed, restart your computer and then run SQL Server
Setup again."
So, I reboot but it keeps getting the same message. What can I do?
Tinn ManI presume that there is an installation issue.
and at every reboot, Sql server starts and detect a file problem, like a
missing or worng DLL, then the installer starts a repair process.
when the reinstallation is done, the system ask for a reboot.
but this reinstallation doesn't works really fine and at every reboot the
same event occurs.
you'll see some installer event log in the windows log if the installer
starts himself.
Try to reinstall SQL server interactively to catch some installation issues.
stop any SQL services , reboot, see if the installer starts, then do a clean
install or repair process.
"Tinn Man" <tm@.nospammeexcite.com> wrote in message
news:uw8ZVLQiGHA.4512@.TK2MSFTNGP02.phx.gbl...
>I have installed ss2005 and now I want to change some things (add the
>AdventureWorks dbs). On one machine it worked fine but on the other System
>Configuration Check keeps getting a reboot required message that says...
> "A previous installation required a reboot of the machine for changes to
> take effect. To proceed, restart your computer and then run SQL Server
> Setup again."
> So, I reboot but it keeps getting the same message. What can I do?
> Tinn Man
>

reboot reboot reboot

I have installed ss2005 and now I want to change some things (add the
AdventureWorks dbs). On one machine it worked fine but on the other System
Configuration Check keeps getting a reboot required message that says...
"A previous installation required a reboot of the machine for changes to
take effect. To proceed, restart your computer and then run SQL Server
Setup again."
So, I reboot but it keeps getting the same message. What can I do?
Tinn ManI presume that there is an installation issue.
and at every reboot, Sql server starts and detect a file problem, like a
missing or worng DLL, then the installer starts a repair process.
when the reinstallation is done, the system ask for a reboot.
but this reinstallation doesn't works really fine and at every reboot the
same event occurs.
you'll see some installer event log in the windows log if the installer
starts himself.
Try to reinstall SQL server interactively to catch some installation issues.
stop any SQL services , reboot, see if the installer starts, then do a clean
install or repair process.
"Tinn Man" <tm@.nospammeexcite.com> wrote in message
news:uw8ZVLQiGHA.4512@.TK2MSFTNGP02.phx.gbl...
>I have installed ss2005 and now I want to change some things (add the
>AdventureWorks dbs). On one machine it worked fine but on the other System
>Configuration Check keeps getting a reboot required message that says...
> "A previous installation required a reboot of the machine for changes to
> take effect. To proceed, restart your computer and then run SQL Server
> Setup again."
> So, I reboot but it keeps getting the same message. What can I do?
> Tinn Man
>

Reattaching old database

I have just installed SQLExpress version 9.0.1399.

I was using an earlier version of the server before and backed up a copy of my mdf files for safety's sake. However when I now try and attach the old databases I get an error that the database files from the old non-release version (590) is not compatible.

Probably my own fault - the information was probably clearly on display deep in a file somewhere in the documentation (cough). However I would kind of like to get at the data in these files.

Is there any way of getting hold of an earlier version of SQLExpress which will handle these files? Or can they be opened in any other way?

The full error message I am getting is:

Database 'myCMS' cannot be upgraded because its non-release version (590) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database. (Microsoft SQL Server, Error: 950)

I have searched around for more information and the advice seems to be that I should open the database in an older copy of SQLExpress, dump the data with BCP and recreate the database.

So now my question is, where can I find installation files for earlier versions of SQLExpress as I don't seem to have a copy of the original executable?

|||I am afraid these are no longer available, you might be able to get them by calling Customer Support Services but this will cost money

Real problem installing SQL Server express 2005

When I first installed MS SQL Server 2005 Express Editon, I didn't I selected Windows Auth instead of mixed mode, so I uninstalled sql server and then attempted to reinstall. On the earlier installtion I did setup to instances which show in the "Control Panel/admin tool/services". Anyway, I used the unistall through the control panel, but on installing again it told me that I had instances aready running and needed to stop them. Couldn't work out how to do that. So after many different things, including using the MS's removal tool and windows installer clean up, I still failed. Now however I get the following error message:

Setup failed because Service MSSQL$SQLExpress is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property profile enabled. For more information on how to enable the hardware profile logon property refer to the product documentation.

Can someone help?

Cheers

Dave

Hello,

Did you get an answer to your questio?

I am having the same problem and I do not know how to solve it?!

So if you solved it can you please share the solution with me.

Thanks,

Eitan

|||

No, had no answers. Really *** forum, obviously noone can help and too difficult. If you get somewhere I'd really appreciate the info. Thanks

Dave

|||

It sounds like the uninstall was unsucessful leaving something behind on the machine. You might want to try the following article to clean up the machine first and then reinstall.

http://support.microsoft.com/kb/909967

Michelle