Relay Error Using Database Mail

SQL 2005 SP1
Windows Server 2003 SP1
Exchange 2000
I am getting this error sending a Maintenance Plans report to an email
recipient. It only happens sending to an external email address.
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 2 (2007-02-06T08:01:25). Exception
Message: Cannot send mails to mail server. (Mailbox unavailable. The server
response was: 5.7.1 Unable to relay for myaddress@.domain.com).
)This is an issue correct-able at your SMTP server; it has nothing to do with
database mail (unless you have a more open internal SMTP server available,
that you could use instead).
A
"John Oberlin" <JohnOberlin@.discussions.microsoft.com> wrote in message
news:A35C82BD-00DA-414F-8071-2DD5F11EF010@.microsoft.com...
> SQL 2005 SP1
> Windows Server 2003 SP1
> Exchange 2000
> I am getting this error sending a Maintenance Plans report to an email
> recipient. It only happens sending to an external email address.
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 2 (2007-02-06T08:01:25). Exception
> Message: Cannot send mails to mail server. (Mailbox unavailable. The
> server
> response was: 5.7.1 Unable to relay for myaddress@.domain.com).
> )|||Thanks for the reply. So what do I have to do on Exchange to correct this?|||Well, you could open up external SMTP relay from the IP address of your SQL
Server(s). I am not an Exchange administrator. So for more specific
details, if you don't get a quick enough response here, you'll ghave better
luck in an Exchange newsgroup.
If you have a simple SMTP server running on an IIS box somewhere inside your
network, that you can use for this, I can help with specific instructions
there. Database Mail does not require Exchange, and depending on your
requirements, you may not want to mix the two.
A
"John Oberlin" <JohnOberlin@.discussions.microsoft.com> wrote in message
news:D989979C-3692-4C0D-9BA9-87523863ED45@.microsoft.com...
> Thanks for the reply. So what do I have to do on Exchange to correct
> this?

Relational database

Hi

I'm using VB.NET,ADO.NET in ASP.NET .

Microsoft .Net framework 1.0

Windows 2000

Visual Studio IDE

and SQLServer.

I have to create to tables as

Table1 contains ID,Name

Table2 contains ID,Marks,Foreign Key ie Primary key of the table Table1.

Give me an information how to create these two tables in SQLServer (I know how to create a table but i don't know how to create a table which includes Foreign Key.)

Then using Dataset i want to display the records as Name,Marks which are stored in two tables.

I have studied that in ADO Join query and record set object is used but it gives a problems and it is not good when we want to transfer the data between two applications or pages but dataset solves all those problems.

Give me an information about it.

Kindly help me

Thanks in advance

Regards.

To create table with Foreign key constraint using T-SQL:

create table tbl_PK (ID int primary key,name varchar(30))
go
create table tbl_FK (ID int foreign key REFERENCES tbl_PK(ID),
Marks varchar(50))

To get the joined result:

select p.name,f.marks from tbl_PK p join tbl_FK f
on p.ID=f.ID

|||

Hi

What you have given is also a join query.but i have studied that no need of join query in case of dataset but it is required for record set.

Thanks

|||To do that, please take a look a the following short movie:

http://msdn.microsoft.com/vstudio/express/media/en/AbsoluteBeginner/vb/08VB.wvx

This is tutorial movie about VWD 2005 and SQL server EE, I believe you can also apply it to VS 2005 because the similarity.

Basically what you do is you create database diagram with right clickon 'Database Diagram' under the Database explorer of your databasefilename. Then add new diagram. After that you can add all your tables,then drag the primary key to create the foreign key.

hope this will help.

reinstalling SQL ODBC Drivers on Windows XP

Apparently one of my users lost their ODBC drivers for SQL Server.
When I try to run the program that uses those drivers obviously I get
all kind of errors.
I tried going into the ODBC administrator and when I try to edit or
delete the DSN I get a message about the drivers being missing and I
need to reinstall them.
I tried running MDAC 2.7 and everything ran, but I still get the error.
MDAC 2.8 will not run on that machine - it gives a message saying that
Windows XP already has all of the files associated with MDAC 2.8.
Any ideas on how to reinstall the drivers in a case like this?
Thanks."Matt Bateman" <mattcb@.gmail.com> wrote in message
news:1155132832.189431.183410@.n13g2000cwa.googlegroups.com...
> Apparently one of my users lost their ODBC drivers for SQL Server.
> When I try to run the program that uses those drivers obviously I get
> all kind of errors.
> I tried going into the ODBC administrator and when I try to edit or
> delete the DSN I get a message about the drivers being missing and I
> need to reinstall them.
> I tried running MDAC 2.7 and everything ran, but I still get the error.
> MDAC 2.8 will not run on that machine - it gives a message saying that
> Windows XP already has all of the files associated with MDAC 2.8.
> Any ideas on how to reinstall the drivers in a case like this?
>
Not really, but you can install the SQL Native Client, which contains a
brand-new, MDAC-independant ODBC driver for SQL Server.
Microsoft SQL Server Native Client
http://msdn.microsoft.com/data/ref/sqlnative/
David

reinstalling SQL ODBC Drivers on Windows XP

Apparently one of my users lost their ODBC drivers for SQL Server.
When I try to run the program that uses those drivers obviously I get
all kind of errors.
I tried going into the ODBC administrator and when I try to edit or
delete the DSN I get a message about the drivers being missing and I
need to reinstall them.
I tried running MDAC 2.7 and everything ran, but I still get the error.
MDAC 2.8 will not run on that machine - it gives a message saying that
Windows XP already has all of the files associated with MDAC 2.8.
Any ideas on how to reinstall the drivers in a case like this?
Thanks."Matt Bateman" <mattcb@.gmail.com> wrote in message
news:1155132832.189431.183410@.n13g2000cwa.googlegroups.com...
> Apparently one of my users lost their ODBC drivers for SQL Server.
> When I try to run the program that uses those drivers obviously I get
> all kind of errors.
> I tried going into the ODBC administrator and when I try to edit or
> delete the DSN I get a message about the drivers being missing and I
> need to reinstall them.
> I tried running MDAC 2.7 and everything ran, but I still get the error.
> MDAC 2.8 will not run on that machine - it gives a message saying that
> Windows XP already has all of the files associated with MDAC 2.8.
> Any ideas on how to reinstall the drivers in a case like this?
>
Not really, but you can install the SQL Native Client, which contains a
brand-new, MDAC-independant ODBC driver for SQL Server.
Microsoft SQL Server Native Client
http://msdn.microsoft.com/data/ref/sqlnative/
Davidsql

Reinstalling MSDTC on Windows 2003

Hello,
Does anyone know how to reinstall MSDTC on Windows 2003?
I have a 2 node SQL 2000 cluster (active/passive) which is having problems
failing over to the other node. Failing over the MSDTC Group to the other
node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
Group' failed").
I've been able to find an article explaining how to reinstall MSDTC on
Windows 2000, but not on Windows 2003. Any assistance on this would be much
appreciated. Thanks
Hi
Searching Google for "RPC raised an exception with a return code
RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
interest http://tinyurl.com/cnoqm
John
"Martin" wrote:

> Hello,
> Does anyone know how to reinstall MSDTC on Windows 2003?
> I have a 2 node SQL 2000 cluster (active/passive) which is having problems
> failing over to the other node. Failing over the MSDTC Group to the other
> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
> Group' failed").
> I've been able to find an article explaining how to reinstall MSDTC on
> Windows 2000, but not on Windows 2003. Any assistance on this would be much
> appreciated. Thanks
>
>
|||Thanks for the reply
DNS seems fine as i can connect to and from the server across the network.
No other errors are generated apart from the MSDTC and Cluster errors. SQL
fails over successful, just not the MSDTC group
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...[vbcol=seagreen]
> Hi
> Searching Google for "RPC raised an exception with a return code
> RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> interest http://tinyurl.com/cnoqm
> John
> "Martin" wrote:
|||Hi Martin
Did you see http://support.microsoft.com/default...b;en-us;294209
John
"Martin" wrote:

> Thanks for the reply
> DNS seems fine as i can connect to and from the server across the network.
> No other errors are generated apart from the MSDTC and Cluster errors. SQL
> fails over successful, just not the MSDTC group
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>
>
|||Yes, but it seems relevant to Windows 2000.
There is a note on there at the bottom, which says if you're using Windows
2003 to refer to the article http://support.microsoft.com/kb/301600/. That
only goes through setting up MSDTC on 2003 initially.
I'm not sure if the method for rebuilding MSDTC in that article applies to
Windows 2003 due to the note at the bottom, referring us to KB301600.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> Did you see http://support.microsoft.com/default...b;en-us;294209
> John
> "Martin" wrote:
|||Hi Martin
From that it looks like you can add/remove it using the Add/Remove Windows
components in Control Panel?
John
"Martin" wrote:

> Yes, but it seems relevant to Windows 2000.
> There is a note on there at the bottom, which says if you're using Windows
> 2003 to refer to the article http://support.microsoft.com/kb/301600/. That
> only goes through setting up MSDTC on 2003 initially.
> I'm not sure if the method for rebuilding MSDTC in that article applies to
> Windows 2003 due to the note at the bottom, referring us to KB301600.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
>
>
|||John, thanks for the reply. Do you know if reinstalling MSDTC using this
method will retain the current settings or will they have to be recreated
again.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> From that it looks like you can add/remove it using the Add/Remove Windows
> components in Control Panel?
> John
> "Martin" wrote:
|||Hi
I have not done this on a Windows 2003 machine, but I would expect the
settings to be lost otherwise it would not be a full un-install.
John
"Martin" wrote:

> John, thanks for the reply. Do you know if reinstalling MSDTC using this
> method will retain the current settings or will they have to be recreated
> again.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
>
>

Reinstalling MSDTC on Windows 2003

Hello,
Does anyone know how to reinstall MSDTC on Windows 2003?
I have a 2 node SQL 2000 cluster (active/passive) which is having problems
failing over to the other node. Failing over the MSDTC Group to the other
node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
Group' failed").
I've been able to find an article explaining how to reinstall MSDTC on
Windows 2000, but not on Windows 2003. Any assistance on this would be much
appreciated. ThanksHi
Searching Google for "RPC raised an exception with a return code
RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
interest http://tinyurl.com/cnoqm
John
"Martin" wrote:

> Hello,
> Does anyone know how to reinstall MSDTC on Windows 2003?
> I have a 2 node SQL 2000 cluster (active/passive) which is having problems
> failing over to the other node. Failing over the MSDTC Group to the other
> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> exception with a return code RPC_S_INVALIDA_ARG"). The System Log generat
es
> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
> Group' failed").
> I've been able to find an article explaining how to reinstall MSDTC on
> Windows 2000, but not on Windows 2003. Any assistance on this would be mu
ch
> appreciated. Thanks
>
>|||Thanks for the reply
DNS seems fine as i can connect to and from the server across the network.
No other errors are generated apart from the MSDTC and Cluster errors. SQL
fails over successful, just not the MSDTC group
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...[vbcol=seagreen]
> Hi
> Searching Google for "RPC raised an exception with a return code
> RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> interest http://tinyurl.com/cnoqm
> John
> "Martin" wrote:
>|||Hi Martin
Did you see http://support.microsoft.com/defaul...kb;en-us;294209
John
"Martin" wrote:

> Thanks for the reply
> DNS seems fine as i can connect to and from the server across the network.
> No other errors are generated apart from the MSDTC and Cluster errors. SQ
L
> fails over successful, just not the MSDTC group
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>
>|||Yes, but it seems relevant to Windows 2000.
There is a note on there at the bottom, which says if you're using Windows
2003 to refer to the article http://support.microsoft.com/kb/301600/. That
only goes through setting up MSDTC on 2003 initially.
I'm not sure if the method for rebuilding MSDTC in that article applies to
Windows 2003 due to the note at the bottom, referring us to KB301600.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> Did you see http://support.microsoft.com/defaul...kb;en-us;294209
> John
> "Martin" wrote:
>|||Hi Martin
From that it looks like you can add/remove it using the Add/Remove Windows
components in Control Panel?
John
"Martin" wrote:

> Yes, but it seems relevant to Windows 2000.
> There is a note on there at the bottom, which says if you're using Windows
> 2003 to refer to the article http://support.microsoft.com/kb/301600/. That
> only goes through setting up MSDTC on 2003 initially.
> I'm not sure if the method for rebuilding MSDTC in that article applies to
> Windows 2003 due to the note at the bottom, referring us to KB301600.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
>
>|||John, thanks for the reply. Do you know if reinstalling MSDTC using this
method will retain the current settings or will they have to be recreated
again.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...[vbcol=seagreen]
> Hi Martin
> From that it looks like you can add/remove it using the Add/Remove Windows
> components in Control Panel?
> John
> "Martin" wrote:
>|||Hi
I have not done this on a Windows 2003 machine, but I would expect the
settings to be lost otherwise it would not be a full un-install.
John
"Martin" wrote:

> John, thanks for the reply. Do you know if reinstalling MSDTC using this
> method will retain the current settings or will they have to be recreated
> again.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
>
>

Reinstalling MSDTC on Windows 2003

Hello,
Does anyone know how to reinstall MSDTC on Windows 2003?
I have a 2 node SQL 2000 cluster (active/passive) which is having problems
failing over to the other node. Failing over the MSDTC Group to the other
node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
Group' failed").
I've been able to find an article explaining how to reinstall MSDTC on
Windows 2000, but not on Windows 2003. Any assistance on this would be much
appreciated. ThanksHi
Searching Google for "RPC raised an exception with a return code
RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
interest http://tinyurl.com/cnoqm
John
"Martin" wrote:
> Hello,
> Does anyone know how to reinstall MSDTC on Windows 2003?
> I have a 2 node SQL 2000 cluster (active/passive) which is having problems
> failing over to the other node. Failing over the MSDTC Group to the other
> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> exception with a return code RPC_S_INVALIDA_ARG"). The System Log generates
> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group 'MSDTC
> Group' failed").
> I've been able to find an article explaining how to reinstall MSDTC on
> Windows 2000, but not on Windows 2003. Any assistance on this would be much
> appreciated. Thanks
>
>|||Thanks for the reply
DNS seems fine as i can connect to and from the server across the network.
No other errors are generated apart from the MSDTC and Cluster errors. SQL
fails over successful, just not the MSDTC group
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> Hi
> Searching Google for "RPC raised an exception with a return code
> RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> interest http://tinyurl.com/cnoqm
> John
> "Martin" wrote:
>> Hello,
>> Does anyone know how to reinstall MSDTC on Windows 2003?
>> I have a 2 node SQL 2000 cluster (active/passive) which is having
>> problems
>> failing over to the other node. Failing over the MSDTC Group to the
>> other
>> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
>> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
>> generates
>> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
>> 'MSDTC
>> Group' failed").
>> I've been able to find an article explaining how to reinstall MSDTC on
>> Windows 2000, but not on Windows 2003. Any assistance on this would be
>> much
>> appreciated. Thanks
>>|||Hi Martin
Did you see http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
John
"Martin" wrote:
> Thanks for the reply
> DNS seems fine as i can connect to and from the server across the network.
> No other errors are generated apart from the MSDTC and Cluster errors. SQL
> fails over successful, just not the MSDTC group
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> > Hi
> >
> > Searching Google for "RPC raised an exception with a return code
> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be of
> > interest http://tinyurl.com/cnoqm
> >
> > John
> >
> > "Martin" wrote:
> >
> >> Hello,
> >>
> >> Does anyone know how to reinstall MSDTC on Windows 2003?
> >>
> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
> >> problems
> >> failing over to the other node. Failing over the MSDTC Group to the
> >> other
> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised an
> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
> >> generates
> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
> >> 'MSDTC
> >> Group' failed").
> >>
> >> I've been able to find an article explaining how to reinstall MSDTC on
> >> Windows 2000, but not on Windows 2003. Any assistance on this would be
> >> much
> >> appreciated. Thanks
> >>
> >>
> >>
>
>|||Yes, but it seems relevant to Windows 2000.
There is a note on there at the bottom, which says if you're using Windows
2003 to refer to the article http://support.microsoft.com/kb/301600/. That
only goes through setting up MSDTC on 2003 initially.
I'm not sure if the method for rebuilding MSDTC in that article applies to
Windows 2003 due to the note at the bottom, referring us to KB301600.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
> Hi Martin
> Did you see http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
> John
> "Martin" wrote:
>> Thanks for the reply
>> DNS seems fine as i can connect to and from the server across the
>> network.
>> No other errors are generated apart from the MSDTC and Cluster errors.
>> SQL
>> fails over successful, just not the MSDTC group
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>> > Hi
>> >
>> > Searching Google for "RPC raised an exception with a return code
>> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be
>> > of
>> > interest http://tinyurl.com/cnoqm
>> >
>> > John
>> >
>> > "Martin" wrote:
>> >
>> >> Hello,
>> >>
>> >> Does anyone know how to reinstall MSDTC on Windows 2003?
>> >>
>> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
>> >> problems
>> >> failing over to the other node. Failing over the MSDTC Group to the
>> >> other
>> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised
>> >> an
>> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
>> >> generates
>> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
>> >> 'MSDTC
>> >> Group' failed").
>> >>
>> >> I've been able to find an article explaining how to reinstall MSDTC on
>> >> Windows 2000, but not on Windows 2003. Any assistance on this would
>> >> be
>> >> much
>> >> appreciated. Thanks
>> >>
>> >>
>> >>
>>
>>|||Hi Martin
From that it looks like you can add/remove it using the Add/Remove Windows
components in Control Panel?
John
"Martin" wrote:
> Yes, but it seems relevant to Windows 2000.
> There is a note on there at the bottom, which says if you're using Windows
> 2003 to refer to the article http://support.microsoft.com/kb/301600/. That
> only goes through setting up MSDTC on 2003 initially.
> I'm not sure if the method for rebuilding MSDTC in that article applies to
> Windows 2003 due to the note at the bottom, referring us to KB301600.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
> > Hi Martin
> >
> > Did you see http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
> >
> > John
> >
> > "Martin" wrote:
> >
> >> Thanks for the reply
> >>
> >> DNS seems fine as i can connect to and from the server across the
> >> network.
> >> No other errors are generated apart from the MSDTC and Cluster errors.
> >> SQL
> >> fails over successful, just not the MSDTC group
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> >> > Hi
> >> >
> >> > Searching Google for "RPC raised an exception with a return code
> >> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may be
> >> > of
> >> > interest http://tinyurl.com/cnoqm
> >> >
> >> > John
> >> >
> >> > "Martin" wrote:
> >> >
> >> >> Hello,
> >> >>
> >> >> Does anyone know how to reinstall MSDTC on Windows 2003?
> >> >>
> >> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
> >> >> problems
> >> >> failing over to the other node. Failing over the MSDTC Group to the
> >> >> other
> >> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC raised
> >> >> an
> >> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
> >> >> generates
> >> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
> >> >> 'MSDTC
> >> >> Group' failed").
> >> >>
> >> >> I've been able to find an article explaining how to reinstall MSDTC on
> >> >> Windows 2000, but not on Windows 2003. Any assistance on this would
> >> >> be
> >> >> much
> >> >> appreciated. Thanks
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
> >>
>
>|||John, thanks for the reply. Do you know if reinstalling MSDTC using this
method will retain the current settings or will they have to be recreated
again.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
> Hi Martin
> From that it looks like you can add/remove it using the Add/Remove Windows
> components in Control Panel?
> John
> "Martin" wrote:
>> Yes, but it seems relevant to Windows 2000.
>> There is a note on there at the bottom, which says if you're using
>> Windows
>> 2003 to refer to the article http://support.microsoft.com/kb/301600/.
>> That
>> only goes through setting up MSDTC on 2003 initially.
>> I'm not sure if the method for rebuilding MSDTC in that article applies
>> to
>> Windows 2003 due to the note at the bottom, referring us to KB301600.
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
>> > Hi Martin
>> >
>> > Did you see
>> > http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
>> >
>> > John
>> >
>> > "Martin" wrote:
>> >
>> >> Thanks for the reply
>> >>
>> >> DNS seems fine as i can connect to and from the server across the
>> >> network.
>> >> No other errors are generated apart from the MSDTC and Cluster errors.
>> >> SQL
>> >> fails over successful, just not the MSDTC group
>> >>
>> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> >> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
>> >> > Hi
>> >> >
>> >> > Searching Google for "RPC raised an exception with a return code
>> >> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may
>> >> > be
>> >> > of
>> >> > interest http://tinyurl.com/cnoqm
>> >> >
>> >> > John
>> >> >
>> >> > "Martin" wrote:
>> >> >
>> >> >> Hello,
>> >> >>
>> >> >> Does anyone know how to reinstall MSDTC on Windows 2003?
>> >> >>
>> >> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
>> >> >> problems
>> >> >> failing over to the other node. Failing over the MSDTC Group to
>> >> >> the
>> >> >> other
>> >> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC
>> >> >> raised
>> >> >> an
>> >> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
>> >> >> generates
>> >> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
>> >> >> 'MSDTC
>> >> >> Group' failed").
>> >> >>
>> >> >> I've been able to find an article explaining how to reinstall MSDTC
>> >> >> on
>> >> >> Windows 2000, but not on Windows 2003. Any assistance on this
>> >> >> would
>> >> >> be
>> >> >> much
>> >> >> appreciated. Thanks
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>> >>
>>|||Hi
I have not done this on a Windows 2003 machine, but I would expect the
settings to be lost otherwise it would not be a full un-install.
John
"Martin" wrote:
> John, thanks for the reply. Do you know if reinstalling MSDTC using this
> method will retain the current settings or will they have to be recreated
> again.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:13E4BCC7-2FED-476A-A2B2-6C048B8D9343@.microsoft.com...
> > Hi Martin
> >
> > From that it looks like you can add/remove it using the Add/Remove Windows
> > components in Control Panel?
> >
> > John
> >
> > "Martin" wrote:
> >
> >> Yes, but it seems relevant to Windows 2000.
> >>
> >> There is a note on there at the bottom, which says if you're using
> >> Windows
> >> 2003 to refer to the article http://support.microsoft.com/kb/301600/.
> >> That
> >> only goes through setting up MSDTC on 2003 initially.
> >>
> >> I'm not sure if the method for rebuilding MSDTC in that article applies
> >> to
> >> Windows 2003 due to the note at the bottom, referring us to KB301600.
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:3534A3D0-5647-4045-A308-1CE61E02DE61@.microsoft.com...
> >> > Hi Martin
> >> >
> >> > Did you see
> >> > http://support.microsoft.com/default.aspx?scid=kb;en-us;294209
> >> >
> >> > John
> >> >
> >> > "Martin" wrote:
> >> >
> >> >> Thanks for the reply
> >> >>
> >> >> DNS seems fine as i can connect to and from the server across the
> >> >> network.
> >> >> No other errors are generated apart from the MSDTC and Cluster errors.
> >> >> SQL
> >> >> fails over successful, just not the MSDTC group
> >> >>
> >> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> >> news:7C6CF903-9564-41AD-AEE5-F10703CB28A0@.microsoft.com...
> >> >> > Hi
> >> >> >
> >> >> > Searching Google for "RPC raised an exception with a return code
> >> >> > RPC_S_INVALIDA_ARG" turned up a few threads, of which this one may
> >> >> > be
> >> >> > of
> >> >> > interest http://tinyurl.com/cnoqm
> >> >> >
> >> >> > John
> >> >> >
> >> >> > "Martin" wrote:
> >> >> >
> >> >> >> Hello,
> >> >> >>
> >> >> >> Does anyone know how to reinstall MSDTC on Windows 2003?
> >> >> >>
> >> >> >> I have a 2 node SQL 2000 cluster (active/passive) which is having
> >> >> >> problems
> >> >> >> failing over to the other node. Failing over the MSDTC Group to
> >> >> >> the
> >> >> >> other
> >> >> >> node causes MSDTC to fail with Application EVENT ID 4156 ("RPC
> >> >> >> raised
> >> >> >> an
> >> >> >> exception with a return code RPC_S_INVALIDA_ARG"). The System Log
> >> >> >> generates
> >> >> >> EVENT ID 1069 ("Cluster resource 'MSDTC Resource' in Resource Group
> >> >> >> 'MSDTC
> >> >> >> Group' failed").
> >> >> >>
> >> >> >> I've been able to find an article explaining how to reinstall MSDTC
> >> >> >> on
> >> >> >> Windows 2000, but not on Windows 2003. Any assistance on this
> >> >> >> would
> >> >> >> be
> >> >> >> much
> >> >> >> appreciated. Thanks
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

re-install Windows, how to restore databases?

I have SQL Server 2000 running on Windows 2000 Professional, and need
to upgrade this to Windows 2000 Server. In SQL, I have 64 separate
databases used for client development work. After upgrading Windows,
and re-installing SQL Server, how can I reconnect all of the existing
databases without too much work? I'd rather not have to backup, add,
and restore each one individually.How about scripting it. Write some TSQL using a cursor to loop sysdatabases and backup each
databases using dynamic SQL. Then use a similar way to restore based on the files in that directory.
For the restore part, you can use some of the code I have at:
http://www.karaszi.com/SQLServer/util_restore_all_in_file.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<rgurganus@.citidc.com> wrote in message
news:1124991326.785503.210230@.f14g2000cwb.googlegroups.com...
>I have SQL Server 2000 running on Windows 2000 Professional, and need
> to upgrade this to Windows 2000 Server. In SQL, I have 64 separate
> databases used for client development work. After upgrading Windows,
> and re-installing SQL Server, how can I reconnect all of the existing
> databases without too much work? I'd rather not have to backup, add,
> and restore each one individually.
>|||Hi,
You can detach the databases and Copy both Data and log files.
After reinstalling win2000 you can attach it back
regards,
--
Herbert
"rgurganus@.citidc.com" wrote:
> I have SQL Server 2000 running on Windows 2000 Professional, and need
> to upgrade this to Windows 2000 Server. In SQL, I have 64 separate
> databases used for client development work. After upgrading Windows,
> and re-installing SQL Server, how can I reconnect all of the existing
> databases without too much work? I'd rather not have to backup, add,
> and restore each one individually.
>|||Yes, but with 64+ different databases, I was hoping to avoid detatching
each one, and re-attaching each one. I'm coming out of a MySQL
background, where this would be a piece of cake. You'd just copy the
whole data directory where all the database files are, and restart the
service. Oh well...|||Did you read my post?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<rgurganus@.citidc.com> wrote in message news:1125068039.740731.98460@.g49g2000cwa.googlegroups.com...
> Yes, but with 64+ different databases, I was hoping to avoid detatching
> each one, and re-attaching each one. I'm coming out of a MySQL
> background, where this would be a piece of cake. You'd just copy the
> whole data directory where all the database files are, and restart the
> service. Oh well...
>|||Yes, thanks. That may help. I'm just giving into dislike and bashing
of MS SQL in general. Systems should make things easier, not more
difficult. :(

re-install Windows, how to restore databases?

I have SQL Server 2000 running on Windows 2000 Professional, and need
to upgrade this to Windows 2000 Server. In SQL, I have 64 separate
databases used for client development work. After upgrading Windows,
and re-installing SQL Server, how can I reconnect all of the existing
databases without too much work? I'd rather not have to backup, add,
and restore each one individually.
How about scripting it. Write some TSQL using a cursor to loop sysdatabases and backup each
databases using dynamic SQL. Then use a similar way to restore based on the files in that directory.
For the restore part, you can use some of the code I have at:
http://www.karaszi.com/SQLServer/uti...ll_in_file.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<rgurganus@.citidc.com> wrote in message
news:1124991326.785503.210230@.f14g2000cwb.googlegr oups.com...
>I have SQL Server 2000 running on Windows 2000 Professional, and need
> to upgrade this to Windows 2000 Server. In SQL, I have 64 separate
> databases used for client development work. After upgrading Windows,
> and re-installing SQL Server, how can I reconnect all of the existing
> databases without too much work? I'd rather not have to backup, add,
> and restore each one individually.
>
|||Hi,
You can detach the databases and Copy both Data and log files.
After reinstalling win2000 you can attach it back
regards,
Herbert
"rgurganus@.citidc.com" wrote:

> I have SQL Server 2000 running on Windows 2000 Professional, and need
> to upgrade this to Windows 2000 Server. In SQL, I have 64 separate
> databases used for client development work. After upgrading Windows,
> and re-installing SQL Server, how can I reconnect all of the existing
> databases without too much work? I'd rather not have to backup, add,
> and restore each one individually.
>
|||Yes, but with 64+ different databases, I was hoping to avoid detatching
each one, and re-attaching each one. I'm coming out of a MySQL
background, where this would be a piece of cake. You'd just copy the
whole data directory where all the database files are, and restart the
service. Oh well...
|||Did you read my post?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<rgurganus@.citidc.com> wrote in message news:1125068039.740731.98460@.g49g2000cwa.googlegro ups.com...
> Yes, but with 64+ different databases, I was hoping to avoid detatching
> each one, and re-attaching each one. I'm coming out of a MySQL
> background, where this would be a piece of cake. You'd just copy the
> whole data directory where all the database files are, and restart the
> service. Oh well...
>
|||Yes, thanks. That may help. I'm just giving into dislike and bashing
of MS SQL in general. Systems should make things easier, not more
difficult.

re-install Windows, how to restore databases?

I have SQL Server 2000 running on Windows 2000 Professional, and need
to upgrade this to Windows 2000 Server. In SQL, I have 64 separate
databases used for client development work. After upgrading Windows,
and re-installing SQL Server, how can I reconnect all of the existing
databases without too much work? I'd rather not have to backup, add,
and restore each one individually.How about scripting it. Write some TSQL using a cursor to loop sysdatabases
and backup each
databases using dynamic SQL. Then use a similar way to restore based on the
files in that directory.
For the restore part, you can use some of the code I have at:
http://www.karaszi.com/SQLServer/ut...all_in_file.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<rgurganus@.citidc.com> wrote in message
news:1124991326.785503.210230@.f14g2000cwb.googlegroups.com...
>I have SQL Server 2000 running on Windows 2000 Professional, and need
> to upgrade this to Windows 2000 Server. In SQL, I have 64 separate
> databases used for client development work. After upgrading Windows,
> and re-installing SQL Server, how can I reconnect all of the existing
> databases without too much work? I'd rather not have to backup, add,
> and restore each one individually.
>|||Hi,
You can detach the databases and Copy both Data and log files.
After reinstalling win2000 you can attach it back
regards,
--
Herbert
"rgurganus@.citidc.com" wrote:

> I have SQL Server 2000 running on Windows 2000 Professional, and need
> to upgrade this to Windows 2000 Server. In SQL, I have 64 separate
> databases used for client development work. After upgrading Windows,
> and re-installing SQL Server, how can I reconnect all of the existing
> databases without too much work? I'd rather not have to backup, add,
> and restore each one individually.
>|||Yes, but with 64+ different databases, I was hoping to avoid detatching
each one, and re-attaching each one. I'm coming out of a MySQL
background, where this would be a piece of cake. You'd just copy the
whole data directory where all the database files are, and restart the
service. Oh well...|||Did you read my post?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<rgurganus@.citidc.com> wrote in message news:1125068039.740731.98460@.g49g2000cwa.googlegroup
s.com...
> Yes, but with 64+ different databases, I was hoping to avoid detatching
> each one, and re-attaching each one. I'm coming out of a MySQL
> background, where this would be a piece of cake. You'd just copy the
> whole data directory where all the database files are, and restart the
> service. Oh well...
>|||Yes, thanks. That may help. I'm just giving into dislike and bashing
of MS SQL in general. Systems should make things easier, not more
difficult.

Reinstall ODBC Components

I'm getting the following error on my XP machine:
The ODBC resource DLL c:\windows\system32\odbcint.dll is a different version
than the ODBC setup dll c:\windows\system32\odbccp32.dll reinstall the ODBC
components to ensure proper operation.
I've reinstalled SQL 7.0 several times, how do I reinstall the ODBC
components?
Thank youReinstall MDAC. Reinstalling SQL Server 7 won't update MDAC
as XP is on a higher version. You can also check your
current MDAC installation with component checker
You can find the MDAC downloads and component checker at:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Wed, 10 Nov 2004 16:24:01 -0800, "Michelle"
<Michelle@.discussions.microsoft.com> wrote:

>I'm getting the following error on my XP machine:
>The ODBC resource DLL c:\windows\system32\odbcint.dll is a different versio
n
>than the ODBC setup dll c:\windows\system32\odbccp32.dll reinstall the ODBC
>components to ensure proper operation.
>I've reinstalled SQL 7.0 several times, how do I reinstall the ODBC
>components?
>Thank you

Reinstall ODBC Components

I'm getting the following error on my XP machine:
The ODBC resource DLL c:\windows\system32\odbcint.dll is a different version
than the ODBC setup dll c:\windows\system32\odbccp32.dll reinstall the ODBC
components to ensure proper operation.
I've reinstalled SQL 7.0 several times, how do I reinstall the ODBC
components?
Thank you
Reinstall MDAC. Reinstalling SQL Server 7 won't update MDAC
as XP is on a higher version. You can also check your
current MDAC installation with component checker
You can find the MDAC downloads and component checker at:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Wed, 10 Nov 2004 16:24:01 -0800, "Michelle"
<Michelle@.discussions.microsoft.com> wrote:

>I'm getting the following error on my XP machine:
>The ODBC resource DLL c:\windows\system32\odbcint.dll is a different version
>than the ODBC setup dll c:\windows\system32\odbccp32.dll reinstall the ODBC
>components to ensure proper operation.
>I've reinstalled SQL 7.0 several times, how do I reinstall the ODBC
>components?
>Thank you

Re-indexing table causes Windows to re-boot !

I have a DB with multiple tables and when I attempt to index one of the
tables the whole Windows servers crashes and reboots. My understanding is
that SQLServer should run as an isolated application and so should not be
able to affect the operating system.
This server has been fine for over a year now but has just started to
exhibit this problem (no recent changes or updates to the server, apart from
regular anti-virus updates, that could account for this behaviour).
The problem in more detail:
Database - 1577MB data (518 MB free). Set to automatically grow at 10% to
an un-restricted limit (data and log)
Table in question - 900808 KB data, ~7000000 rows of data
Indexes - there are three "user" indexes that I create. One of them is a
clustered index. When any of these indexes is built the server crashes.
Exhaustive DBCC tests imply that the DB and table are in perfect health.
Nothing in the event log and no memory dumps.
SQLServer - SQLServer 2000 sp3a
Windows - Win2000 sp3, IBM XSERIES_335 with 3 GHz xeon processor and oodles
of memory.
User - at wits end
Any advice would be most welcome
Thanks
GriffGriff,
You are correct. You should focus on the operating system. Most likely SQL
Server is just taxing the IO or Processor hard and there is either a
hardware or driver issue. In the event log is it an unexpected reboot or is
there a stop error listed?
"Griff" <Howling@.The.Moon> wrote in message
news:%234bILC2vFHA.2556@.TK2MSFTNGP15.phx.gbl...
>I have a DB with multiple tables and when I attempt to index one of the
>tables the whole Windows servers crashes and reboots. My understanding is
>that SQLServer should run as an isolated application and so should not be
>able to affect the operating system.
> This server has been fine for over a year now but has just started to
> exhibit this problem (no recent changes or updates to the server, apart
> from regular anti-virus updates, that could account for this behaviour).
> The problem in more detail:
> Database - 1577MB data (518 MB free). Set to automatically grow at 10% to
> an un-restricted limit (data and log)
> Table in question - 900808 KB data, ~7000000 rows of data
> Indexes - there are three "user" indexes that I create. One of them is a
> clustered index. When any of these indexes is built the server crashes.
> Exhaustive DBCC tests imply that the DB and table are in perfect health.
> Nothing in the event log and no memory dumps.
> SQLServer - SQLServer 2000 sp3a
> Windows - Win2000 sp3, IBM XSERIES_335 with 3 GHz xeon processor and
> oodles of memory.
> User - at wits end
> Any advice would be most welcome
> Thanks
> Griff
>
>|||Having read the event logs (application, system, security & SQLServer
ones) and searched for a memory dmp file I get the impression that the
server crashed so fast that it simply didn't have the chance to log
anything. Metaphorically speaking, it had the rug pulled from under
it.
The event log simply lists the fact that it rebooted after an
unexpected system shutdown, but I can't find anything that implies what
could have caused the system shutdown.
Watching the task manager whilst the re-indexing is occuring (before it
dies), it shows no real sign of taxing the server's resources. Of
course now, running live without indexes, the server is as slow as a
lame dog, presumably because SQLServer is having to do lots of full
table scans.|||Oddly enough I've seen this scenerio with two of our 32 way servers. We and
the hardware vendor were able to reproduce the system fault but the vendor
never could tell us what was wrong or how to fix it. Basically when the
server approached 100% CPU (doing masive qeries) the system started geting
dirty memory transfers between pods. It all started after we upgraded our
SQL Server 2000 build. We switched to 64 bit HP servers and immediately
stopped experiencing the issue. Assuming a good power supply, in my opinion
any unexpected reboot on a Windows server is one of three things.
From most likely to least likely:
1. A hardware issue
2. A poorly written driver in kernal mode
3. Windows not trapping the error.
SQL Server may be pushing the system in a new way or to 100% but that would
be a performance issue not an availability issue.
Good luck.
"Griff" <griffithsj_520@.hotmail.com> wrote in message
news:1127390278.062254.254300@.g49g2000cwa.googlegroups.com...
> Having read the event logs (application, system, security & SQLServer
> ones) and searched for a memory dmp file I get the impression that the
> server crashed so fast that it simply didn't have the chance to log
> anything. Metaphorically speaking, it had the rug pulled from under
> it.
> The event log simply lists the fact that it rebooted after an
> unexpected system shutdown, but I can't find anything that implies what
> could have caused the system shutdown.
> Watching the task manager whilst the re-indexing is occuring (before it
> dies), it shows no real sign of taxing the server's resources. Of
> course now, running live without indexes, the server is as slow as a
> lame dog, presumably because SQLServer is having to do lots of full
> table scans.
>|||Well, I can't say what the problem was, but we do appear to have fixed it.
Despite nothing "appearing" to have changed on the system (we manually apply
the Microsoft critical upgrades), this problem started occuring out of the
blue.
However, it got worse throughout the day - the server started rebooting
during "normal" use, approximately ever 30 minutes. As mentioned
previously, the CPU was more or less at 100% because we couldn't rebuild the
indexes, so I was wondering whether it could be overheating or some other
symptom of the hardware being over-stressed (though it's a good spec server
so should cope).
Anyhow, that evening we clutched at straws and applied Win2000 sp4 (had been
sp3) and, would you believe it, it fixed the problem and a good nights sleep
was had by all.|||Griff wrote:
> Well, I can't say what the problem was, but we do appear to have
> fixed it.
> Despite nothing "appearing" to have changed on the system (we
> manually apply the Microsoft critical upgrades), this problem started
> occuring out of the blue.
> However, it got worse throughout the day - the server started
> rebooting during "normal" use, approximately ever 30 minutes. As
> mentioned previously, the CPU was more or less at 100% because we
> couldn't rebuild the indexes, so I was wondering whether it could be
> overheating or some other symptom of the hardware being over-stressed
> (though it's a good spec server so should cope).
> Anyhow, that evening we clutched at straws and applied Win2000 sp4
> (had been sp3) and, would you believe it, it fixed the problem and a
> good nights sleep was had by all.
Probably someone was "joking": there are some holes in some windows
versions which allow a host to be restarted / switched off or similar via
network (these are usually closed by sp4 IIRC). So it could even be
manual intervention that caused this...
Kind regards
robert|||Hi Robert
I believe that we can almost rule that one out. The server is behind a
firewall that only allows HTTP in from unknown IP addresses, everything else
is effectively blocked. The only person who can connect to it in any other
way is me.
But hey, we know that the only way to make a computer completely safe is to
switch it off.

Registry Size

I am getting the error "Windows cannot load the profile.
Please increase the registry size and restart the
computer". Can I delete the unused profiles
from "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows
NT\CurrentVersion\ProfileList" to make more space
available in the registry and maybe offset this error?Just curious, what does this have to do with SQL Server?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ron Snow" <anonymous@.discussions.microsoft.com> wrote in message
news:23f6601c45ee4$c42e0040$a401280a@.phx.gbl...
> I am getting the error "Windows cannot load the profile.
> Please increase the registry size and restart the
> computer". Can I delete the unused profiles
> from "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows
> NT\CurrentVersion\ProfileList" to make more space
> available in the registry and maybe offset this error?

Registry Size

I am getting the error "Windows cannot load the profile.
Please increase the registry size and restart the
computer". Can I delete the unused profiles
from "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows
NT\CurrentVersion\ProfileList" to make more space
available in the registry and maybe offset this error?
Just curious, what does this have to do with SQL Server?
http://www.aspfaq.com/
(Reverse address to reply.)
"Ron Snow" <anonymous@.discussions.microsoft.com> wrote in message
news:23f6601c45ee4$c42e0040$a401280a@.phx.gbl...
> I am getting the error "Windows cannot load the profile.
> Please increase the registry size and restart the
> computer". Can I delete the unused profiles
> from "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows
> NT\CurrentVersion\ProfileList" to make more space
> available in the registry and maybe offset this error?

Registry Size

I am getting the error "Windows cannot load the profile.
Please increase the registry size and restart the
computer". Can I delete the unused profiles
from " HKEY_LOCAL_MACHINE\Software\Microsoft\Wi
ndows
NT\CurrentVersion\ProfileList" to make more space
available in the registry and maybe offset this error?Just curious, what does this have to do with SQL Server?
http://www.aspfaq.com/
(Reverse address to reply.)
"Ron Snow" <anonymous@.discussions.microsoft.com> wrote in message
news:23f6601c45ee4$c42e0040$a401280a@.phx
.gbl...
> I am getting the error "Windows cannot load the profile.
> Please increase the registry size and restart the
> computer". Can I delete the unused profiles
> from " HKEY_LOCAL_MACHINE\Software\Microsoft\Wi
ndows
> NT\CurrentVersion\ProfileList" to make more space
> available in the registry and maybe offset this error?

Registration of SQL Servers missing in Enterprise manager

Hi All,
Recently a strange behaviour was seen with Enterprise manager. When we
change the Windows login password all the registrations of SQL Servers are
missing from SQL Server Enterprise Manager. Did anyone faced this situatio
n
before? Its really painful to register 20 servers each time when login
password is changed. Some of the registered servers are windows
authentication and rest of them are SQL Server authentication.
Thanks a lot in advance!
Vinod MeesalaHi,
Never aware of this issues. What is the SQL Server service pack you are usin
g?
If you are using old service packs, install SP4 for SQL 2000 (if you are
using SQL Server 2000) and see if you still have issues.
Thanks
Hari
SQL Server MVP
"VM" wrote:

> Hi All,
> Recently a strange behaviour was seen with Enterprise manager. When we
> change the Windows login password all the registrations of SQL Servers are
> missing from SQL Server Enterprise Manager. Did anyone faced this situat
ion
> before? Its really painful to register 20 servers each time when login
> password is changed. Some of the registered servers are windows
> authentication and rest of them are SQL Server authentication.
> Thanks a lot in advance!
> Vinod Meesala|||Sounds like this may be the issue you are running into:
FIX: Registered remote servers disappear from SQL Enterprise
Manager in Windows XP when user password is changed
http://support.microsoft.com/?id=323280
-Sue
On Thu, 17 Aug 2006 13:39:02 -0700, VM
<VM@.discussions.microsoft.com> wrote:

>Hi All,
>Recently a strange behaviour was seen with Enterprise manager. When we
>change the Windows login password all the registrations of SQL Servers are
>missing from SQL Server Enterprise Manager. Did anyone faced this situati
on
>before? Its really painful to register 20 servers each time when login
>password is changed. Some of the registered servers are windows
>authentication and rest of them are SQL Server authentication.
>Thanks a lot in advance!
>Vinod Meesala|||Sue,
Thats an awsome piece of information. I wasn't aware of this.
Thanks
Hari
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.
4ax.com...
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>
>|||Hey Hari,
People haven't hit the issue for quite awhile so you
probably just forgot it by now. I think it was two or three
years ago when people posted hitting the issue. I guess I'm
just wasting limited brain space with old info - your brain
is just more current than mine : )
-Sue
On Thu, 17 Aug 2006 19:00:43 -0500, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:

>Sue,
>Thats an awsome piece of information. I wasn't aware of this.
>Thanks
>Hari
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.
4ax.com...
>|||Excellent Finding!! Thanks much Sue! I will try this Fix.
Vinod Meesala
"Sue Hoegemeier" wrote:

> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>
>

Registration of SQL Servers missing in Enterprise manager

Hi All,
Recently a strange behaviour was seen with Enterprise manager. When we
change the Windows login password all the registrations of SQL Servers are
missing from SQL Server Enterprise Manager. Did anyone faced this situation
before? Its really painful to register 20 servers each time when login
password is changed. Some of the registered servers are windows
authentication and rest of them are SQL Server authentication.
Thanks a lot in advance!
Vinod MeesalaHi,
Never aware of this issues. What is the SQL Server service pack you are using?
If you are using old service packs, install SP4 for SQL 2000 (if you are
using SQL Server 2000) and see if you still have issues.
Thanks
Hari
SQL Server MVP
"VM" wrote:
> Hi All,
> Recently a strange behaviour was seen with Enterprise manager. When we
> change the Windows login password all the registrations of SQL Servers are
> missing from SQL Server Enterprise Manager. Did anyone faced this situation
> before? Its really painful to register 20 servers each time when login
> password is changed. Some of the registered servers are windows
> authentication and rest of them are SQL Server authentication.
> Thanks a lot in advance!
> Vinod Meesala|||Sounds like this may be the issue you are running into:
FIX: Registered remote servers disappear from SQL Enterprise
Manager in Windows XP when user password is changed
http://support.microsoft.com/?id=323280
-Sue
On Thu, 17 Aug 2006 13:39:02 -0700, VM
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Recently a strange behaviour was seen with Enterprise manager. When we
>change the Windows login password all the registrations of SQL Servers are
>missing from SQL Server Enterprise Manager. Did anyone faced this situation
>before? Its really painful to register 20 servers each time when login
>password is changed. Some of the registered servers are windows
>authentication and rest of them are SQL Server authentication.
>Thanks a lot in advance!
>Vinod Meesala|||Sue,
Thats an awsome piece of information. I wasn't aware of this.
Thanks
Hari
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.4ax.com...
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>>Hi All,
>>Recently a strange behaviour was seen with Enterprise manager. When we
>>change the Windows login password all the registrations of SQL Servers are
>>missing from SQL Server Enterprise Manager. Did anyone faced this
>>situation
>>before? Its really painful to register 20 servers each time when login
>>password is changed. Some of the registered servers are windows
>>authentication and rest of them are SQL Server authentication.
>>Thanks a lot in advance!
>>Vinod Meesala
>|||Hey Hari,
People haven't hit the issue for quite awhile so you
probably just forgot it by now. I think it was two or three
years ago when people posted hitting the issue. I guess I'm
just wasting limited brain space with old info - your brain
is just more current than mine : )
-Sue
On Thu, 17 Aug 2006 19:00:43 -0500, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Sue,
>Thats an awsome piece of information. I wasn't aware of this.
>Thanks
>Hari
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.4ax.com...
>> Sounds like this may be the issue you are running into:
>> FIX: Registered remote servers disappear from SQL Enterprise
>> Manager in Windows XP when user password is changed
>> http://support.microsoft.com/?id=323280
>> -Sue
>> On Thu, 17 Aug 2006 13:39:02 -0700, VM
>> <VM@.discussions.microsoft.com> wrote:
>>Hi All,
>>Recently a strange behaviour was seen with Enterprise manager. When we
>>change the Windows login password all the registrations of SQL Servers are
>>missing from SQL Server Enterprise Manager. Did anyone faced this
>>situation
>>before? Its really painful to register 20 servers each time when login
>>password is changed. Some of the registered servers are windows
>>authentication and rest of them are SQL Server authentication.
>>Thanks a lot in advance!
>>Vinod Meesala
>|||Excellent Finding!! Thanks much Sue! I will try this Fix.
Vinod Meesala
"Sue Hoegemeier" wrote:
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
> >Hi All,
> >
> >Recently a strange behaviour was seen with Enterprise manager. When we
> >change the Windows login password all the registrations of SQL Servers are
> >missing from SQL Server Enterprise Manager. Did anyone faced this situation
> >before? Its really painful to register 20 servers each time when login
> >password is changed. Some of the registered servers are windows
> >authentication and rest of them are SQL Server authentication.
> >
> >Thanks a lot in advance!
> >
> >Vinod Meesala
>

Register server wizard malfunction

Hi,
I installed sql server 2000 enterprise edition on windows 2000 advanced server undera domain account that had the sys admin privileges. However i logged in with my domain account and installed the sql server on a remote machine.The installation completed
successfully. i have also set the 'sa' p/w. Now when i go into the log lifes for sqlserveragent, i see an error like 'data area is less than...' and also it is showing that the sql server is running in single user mode. Also when i opened the enterprise
manager i am able to see the <local> server but when i try to register a new server, the wizard after the initial screen is getting disabled and is closing the entire enterprise manager window. Except for the regiser sql server wizard, all the other wizar
ds are working fine, i am able to setup replication etc.
I would hate to uninstall and reinstall, is their any way to correct the installtion?
Also, the domain a/c that is used by sql server will not allow me to do a remote destop connection(some corporate agreement), hence i have to login with my own domain a/c. Also i have done the default 1433 port installation.
1. Please check the sqlstp.log to make sure that sql server was properly
installed. You'll find this file in your WinNT folder.
2. About uninstalling SQL Server, the best would be trhough Control panel,
Add-Remove Programs. Should that fail, please refer to
290991 HOW TO: Manually remove SQL Server 2000 default, named, or virtual
http://support.microsoft.com/?id=290991
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.

Register server wizard malfunction

Hi,
I installed sql server 2000 enterprise edition on Windows 2000 advanced serv
er undera domain account that had the sys admin privileges. However i logged
in with my domain account and installed the sql server on a remote machine.
The installation completed
successfully. i have also set the 'sa' p/w. Now when i go into the log lifes
for sqlserveragent, i see an error like 'data area is less than...' and al
so it is showing that the sql server is running in single user mode. Also wh
en i opened the enterprise
manager i am able to see the <local> server but when i try to register a new
server, the wizard after the initial screen is getting disabled and is clos
ing the entire enterprise manager window. Except for the regiser sql server
wizard, all the other wizar
ds are working fine, i am able to setup replication etc.
I would hate to uninstall and reinstall, is their any way to correct the ins
talltion?
Also, the domain a/c that is used by sql server will not allow me to do a re
mote destop connection(some corporate agreement), hence i have to login with
my own domain a/c. Also i have done the default 1433 port installation.1. Please check the sqlstp.log to make sure that sql server was properly
installed. You'll find this file in your WinNT folder.
2. About uninstalling SQL Server, the best would be trhough Control panel,
Add-Remove Programs. Should that fail, please refer to
290991 HOW TO: Manually remove SQL Server 2000 default, named, or virtual
http://support.microsoft.com/?id=290991
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.