named server failed logon after installing MS04-011 patch

Need help urgently.
I have on win 2000 machine a default SQL Server (local) & a named SQL Server
instance (for separate web machine).
After installing the MS04-011 Patch last nite, the named SQL Server fails to
startup on reboot or manual. The default server on the other hand is runnin
g. But I cannot use the default server as it requires access within the loca
l machine only.
I tried uninstalling the patch, but it still cannot get the SQL server runni
ng again.
HOW CAN I RECOVER THE SQL Server Instance?
Additional info: On logon, following error massage:
"NtUninstall Q8877565\WinSys.cer" not found
before and after the uninstall of the patch.What error do you get when you start it? Is there anything in he SQL Server
errorlog when it fails?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thank Rand for responding.
The Error is simply Login Failed. Service Manager shows the instance is stop
ped, while the Default Instance (Local) is started. Click start, and return
Login Failure again.
Any idea what's wrong and how I may recover the Instance?
Almon|||Error listing end at the last restart after patch install. That is, never re
start again.
Almon

named server failed logon after installing MS04-011 patch

Need help urgently
I have on win 2000 machine a default SQL Server (local) & a named SQL Server instance (for separate web machine)
After installing the MS04-011 Patch last nite, the named SQL Server fails to startup on reboot or manual. The default server on the other hand is running. But I cannot use the default server as it requires access within the local machine only
I tried uninstalling the patch, but it still cannot get the SQL server running again.
HOW CAN I RECOVER THE SQL Server Instance'
Additional info: On logon, following error massage
"NtUninstall Q8877565\WinSys.cer" not foun
before and after the uninstall of the patch.What error do you get when you start it? Is there anything in he SQL Server
errorlog when it fails?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thank Rand for responding
The Error is simply Login Failed. Service Manager shows the instance is stopped, while the Default Instance (Local) is started. Click start, and return Login Failure again
Any idea what's wrong and how I may recover the Instance
Almo|||Error listing end at the last restart after patch install. That is, never restart again
Almo

named server failed logon after installing MS04-011 patch

Need help urgently.
I have on win 2000 machine a default SQL Server (local) & a named SQL Server instance (for separate web machine).
After installing the MS04-011 Patch last nite, the named SQL Server fails to startup on reboot or manual. The default server on the other hand is running. But I cannot use the default server as it requires access within the local machine only.
I tried uninstalling the patch, but it still cannot get the SQL server running again.
HOW CAN I RECOVER THE SQL Server Instance?
Additional info: On logon, following error massage:
"NtUninstall Q8877565\WinSys.cer" not found
before and after the uninstall of the patch.
What error do you get when you start it? Is there anything in he SQL Server
errorlog when it fails?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Thank Rand for responding.
The Error is simply Login Failed. Service Manager shows the instance is stopped, while the Default Instance (Local) is started. Click start, and return Login Failure again.
Any idea what's wrong and how I may recover the Instance?
Almon
|||Error listing end at the last restart after patch install. That is, never restart again.
Almon
sql

Named Instances

Is there any limit for installing named instances on a server?Hi
Yes, maximum supported on SQL Server 2000 is 16.
If you have per server licensing, you need a licence for each instance (per
processor licence covers all instances).
Memory. They all need to share the same RAM. If you have 16 instances, with
each needing 1Gb, you need at least 16Gb of RAM on the box.
Regards
Mike
"SB138" wrote:
> Is there any limit for installing named instances on a server?|||Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Yes, maximum supported on SQL Server 2000 is 16.
> If you have per server licensing, you need a licence for each instance (per
> processor licence covers all instances).
> Memory. They all need to share the same RAM. If you have 16 instances, with
> each needing 1Gb, you need at least 16Gb of RAM on the box.
> Regards
> Mike
> "SB138" wrote:
> > Is there any limit for installing named instances on a server?

Named Instances

Is there any limit for installing named instances on a server?Hi
Yes, maximum supported on SQL Server 2000 is 16.
If you have per server licensing, you need a licence for each instance (per
processor licence covers all instances).
Memory. They all need to share the same RAM. If you have 16 instances, with
each needing 1Gb, you need at least 16Gb of RAM on the box.
Regards
Mike
"SB138" wrote:

> Is there any limit for installing named instances on a server?|||Thanks
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Yes, maximum supported on SQL Server 2000 is 16.
> If you have per server licensing, you need a licence for each instance (pe
r
> processor licence covers all instances).
> Memory. They all need to share the same RAM. If you have 16 instances, wit
h
> each needing 1Gb, you need at least 16Gb of RAM on the box.
> Regards
> Mike
> "SB138" wrote:
>sql

Named Instances

Is there any limit for installing named instances on a server?
Hi
Yes, maximum supported on SQL Server 2000 is 16.
If you have per server licensing, you need a licence for each instance (per
processor licence covers all instances).
Memory. They all need to share the same RAM. If you have 16 instances, with
each needing 1Gb, you need at least 16Gb of RAM on the box.
Regards
Mike
"SB138" wrote:

> Is there any limit for installing named instances on a server?
|||Thanks
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> Yes, maximum supported on SQL Server 2000 is 16.
> If you have per server licensing, you need a licence for each instance (per
> processor licence covers all instances).
> Memory. They all need to share the same RAM. If you have 16 instances, with
> each needing 1Gb, you need at least 16Gb of RAM on the box.
> Regards
> Mike
> "SB138" wrote:

Name of database

I am currently installing SQL Server and need a name for my database. Is there a naming convention to follow.no there is not. but use whole meaningful words.|||The only naming convention I've seen, which works well in quite some cases, is having table names that are plural form of nouns, eg Customers, Contracts, Addresses etc.|||Use Cyrillic characters, and substitute the ascii value 160 for spaces. This will ensure long-term job security.|||if you use brackets, you can name each of your tables and columns a varying number of blank spaces. that makes for fun times.

select * from [ ] a join [ ] b on a.[ ]=b.[ ]

or, just read the bible: http://mindprod.com/jgloss/unmain.html|||Use Cyrillic characters, and substitute the ascii value 160 for spaces. This will ensure long-term job security.

Where do you work again...?

:D|||I have always been fond of the name Allison. If you have a female database, I heartily suggest Allison.

Sorry. Been a long day.|||Allison is OK, but "Brynn" makes my heart flutter. I'm sure all Brynns have brown eyes. I could fall in love with a database named Brynn.|||Allison is OK, but "Brynn" makes my heart flutter. I'm sure all Brynns have brown eyes. I could fall in love with a database named Brynn.

Wow :shocked: ... gettin' a little punchy on the forums, eh?

Regards,

hmscott|||Its Spring.
I can see it out the window across from my cubicle.|||I am currently installing SQL Server and need a name for my database. Is there a naming convention to follow.

Foobar ... I've always wanted to see a database named Foobar ... or Plugh ... or Y2 ... or Plover ... or XYZZY|||... or Plover ... or XYZZY

I actually remember that game. Does that make me old?

Regards,

hmscott|||Database? After installing SS you'll have 4 system databases: master, tempdb, model, and msdb.
Then you create new databases for the data you want to work with. Choose a logical, descriptive name. If its for payroll data, "Payroll" might be a good name.
Maybe you're talking about the Server and Instance names. I kept the default workstation name when I installed my OS (Win 2K). I also accepted the default instance name when I installed Sql Server with VS.Net. So now I have to type "HOME-76yvI250x/VSdotNet" to specify my server. I'd suggest something easier!|||We used to have a database called "Live" *sigh*|||I never knew database is feminine or musculine... LOL what do you mean Female database...|||It's just like cars.
All cars are female.
Mine is embarrasingly called Ethel :o|||How about applying the suffix "isthenameofthis[objecttype]" to each object?
Create database 'PayrollIsTheNameOfThisDatabase'
Create table PayrollDateIsTheNameOfThisTable
(PayrollIDIsTheNameOfThisIntegerColumn int,
PayrollAmountIsTheNameOfThisMoneyColumn money,
PayrollNoteIsTheNameOfThisVarchar500Column varchar(500))
That should drive the developers mad.|||Ah! Obsucatory naming conventions. This query has soul:


EXEC sp_addtype '[[[][[]]][]', 'varchar(24)', 'NOT NULL'
EXEC sp_addtype '[[[][[][]', 'Int'

DROP TABLE []][]]]

CREATE TABLE []][]]]
(
[]][] [[[[]][[]]]]]][]]],
[[[]][]][] [[[[]][[]][]]]
)

INSERT INTO []][]]]
(
[[[]][]][],
[]][]
)
SELECT 1, '[[]][]' UNION ALL
SELECT 2, '[[]][]]]' UNION ALL
SELECT 3, '[[]][[[[]' UNION ALL
SELECT 4, '[[]][[]]' UNION ALL
SELECT 5, '[[[]][]][[]' UNION ALL
SELECT 6, '][[[]]]][]' UNION ALL
SELECT 7, '[[]][][' UNION ALL
SELECT 8, '][]]][]'

SELECT []]].[]][],
MAX([]][].[[[]][]][]) AS [[[[]][]
FROM []][]]] []]]
INNER JOIN []][]]] []][] ON
[]]].[]][] >= []][].[]][]
GROUP BY
[]]].[]][]|||pootle, you get a gold star for that one. It's beautiful!

there ought to be a sql version of this site, it's one of my favorites: http://www.ioccc.org

:)|||How about applying the suffix "isthenameofthis[objecttype]" to each object?
Create database 'PayrollIsTheNameOfThisDatabase'
Create table PayrollDateIsTheNameOfThisTable
(PayrollIDIsTheNameOfThisIntegerColumn int,
PayrollAmountIsTheNameOfThisMoneyColumn money,
PayrollNoteIsTheNameOfThisVarchar500Column varchar(500))
That should drive the developers mad.

You forgot to prefix the objects with tbl, etc. it should be:

tblPayrollDateIsTheNameOfThisTable,
colPayrollNoteIsTheNameOfThisVarchar500Column|||I actually remember that game. Does that make me old?

Regards,

hmscott

How about playing that game on the mainframe?|||How about playing that game on the mainframe?

Nope. Just an IBM 8086 with no hard drive and about 32KB (?) of memory.

I'm not that old. :D

Regards,

hmscott|||http://www.rickadams.org/adventure/

MYSQL error

While installing mysql server on a windows 2000 machine without a
firewall, I get an error numbered 1045. Access is denied for user
'root'@.'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
RB
This is a newsgroup for Microsoft SQL Server support. I am not trying to
chase you off or flame you, but you may not find te assistance you are
looking for here. You may want to look at http://forums.mysql.com/ for help
with your problem.
Of course, you could try SQL Express.
http://www.microsoft.com/downloads/d...displaylang=en
Don't forget the SQL Express manager:
http://www.microsoft.com/downloads/d...displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB
|||www.mysql.com
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB

MYSQL error

While installing mysql server on a Windows 2000 machine without a
firewall, I get an error numbered 1045. Access is denied for user
'root'@.'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
RBThis is a newsgroup for Microsoft SQL Server support. I am not trying to
chase you off or flame you, but you may not find te assistance you are
looking for here. You may want to look at http://forums.mysql.com/ for help
with your problem.
Of course, you could try SQL Express.
http://www.microsoft.com/downloads/...&displaylang=en
Don't forget the SQL Express manager:
http://www.microsoft.com/downloads/...&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.
4ax.com...
> While installing mysql server on a Windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB|||www.mysql.com
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.
4ax.com...
> While installing mysql server on a Windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB

MYSQL error

While installing mysql server on a windows 2000 machine without a
firewall, I get an error numbered 1045. Access is denied for user
'root'@.'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
RBThis is a newsgroup for Microsoft SQL Server support. I am not trying to
chase you off or flame you, but you may not find te assistance you are
looking for here. You may want to look at http://forums.mysql.com/ for help
with your problem.
Of course, you could try SQL Express.
http://www.microsoft.com/downloads/details.aspx?FamilyId=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en
Don't forget the SQL Express manager:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C7A5CC62-EC54-4299-85FC-BA05C181ED55&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB|||www.mysql.com
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB

my sql server not listed in pull down list of 3rd party tool

hi there,
I am installing a network managing tool in a test environment that relies on
sql database. when opening the pull down list I can see all sql and msde
server from my colleagues but mine.
When introducing it manually with all credentials and domain info and hit
"test logon", it returns: "There was an error testing the windows logon
credentials. windows reports the error as Logon failure: uknown user name or
bad password. Latter are all correct.
- Why can I not see the server in the pull down menu?
- What could be the connection issue?
Dominique
1. It probably uses some flavor of SQLBrowseConnect and not
all servers are guaranteed to be listed due to network
issues, if services are running, protocols, etc. You can
find more information in the following article:
http://www.sqldev.net/misc/ListSQLSvr.htm
2. I'm not sure what tool you are using or what you mean
exactly by introducing it manually, but if windows gives you
an error of unknown user name or bad password, then you
likely have not used the correct user and password. You can
test by logging into the domain with the user name and
password. If it works and the tool doesn't, you should
contact the vendor of the network tool.
-Sue
On Mon, 31 Jan 2005 14:20:47 +0100, "ITspecialist"
<hotspare@.hotmail.com> wrote:

>hi there,
>I am installing a network managing tool in a test environment that relies on
>sql database. when opening the pull down list I can see all sql and msde
>server from my colleagues but mine.
>When introducing it manually with all credentials and domain info and hit
>"test logon", it returns: "There was an error testing the windows logon
>credentials. windows reports the error as Logon failure: uknown user name or
>bad password. Latter are all correct.
>- Why can I not see the server in the pull down menu?
>- What could be the connection issue?
>Dominique
>

my sql server not listed in pull down list of 3rd party tool

hi there,
I am installing a network managing tool in a test environment that relies on
sql database. when opening the pull down list I can see all sql and msde
server from my colleagues but mine.
When introducing it manually with all credentials and domain info and hit
"test logon", it returns: "There was an error testing the windows logon
credentials. windows reports the error as Logon failure: uknown user name or
bad password. Latter are all correct.
- Why can I not see the server in the pull down menu?
- What could be the connection issue?
Dominique1. It probably uses some flavor of SQLBrowseConnect and not
all servers are guaranteed to be listed due to network
issues, if services are running, protocols, etc. You can
find more information in the following article:
http://www.sqldev.net/misc/ListSQLSvr.htm
2. I'm not sure what tool you are using or what you mean
exactly by introducing it manually, but if windows gives you
an error of unknown user name or bad password, then you
likely have not used the correct user and password. You can
test by logging into the domain with the user name and
password. If it works and the tool doesn't, you should
contact the vendor of the network tool.
-Sue
On Mon, 31 Jan 2005 14:20:47 +0100, "ITspecialist"
<hotspare@.hotmail.com> wrote:

>hi there,
>I am installing a network managing tool in a test environment that relies o
n
>sql database. when opening the pull down list I can see all sql and msde
>server from my colleagues but mine.
>When introducing it manually with all credentials and domain info and hit
>"test logon", it returns: "There was an error testing the windows logon
>credentials. windows reports the error as Logon failure: uknown user name o
r
>bad password. Latter are all correct.
>- Why can I not see the server in the pull down menu?
>- What could be the connection issue?
>Dominique
>