SQL Alert: engine

tHi
I want to build a trigger to modify data in a table in a database that is
running on another Database Engine in may LAN. I don' t know if that is
possible. If it is, how will I make the connection to that database?
Thanks in advance - WaldoYou would have to set up the other instance as a "linked server". But what you want to do requires a
distributed transaction (with DTC running and all that jazz) so I would re-think the approach if
possible.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"wvandenbroeck" <wvandenbroeck@.discussions.microsoft.com> wrote in message
news:2A416FD1-02F9-427D-9748-7F2CE4E08CDD@.microsoft.com...
> tHi
> I want to build a trigger to modify data in a table in a database that is
> running on another Database Engine in may LAN. I don' t know if that is
> possible. If it is, how will I make the connection to that database?
> Thanks in advance - Waldo|||I concur. Consider some form of asynchronous mechanism where by you put the
requisite information in a queing table and pull from the other db engine to
do the updates.
You can get DTC to do what you need however, but it is often a PITA. :)
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eh02e1bLIHA.4684@.TK2MSFTNGP06.phx.gbl...
> You would have to set up the other instance as a "linked server". But what
> you want to do requires a distributed transaction (with DTC running and
> all that jazz) so I would re-think the approach if possible.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "wvandenbroeck" <wvandenbroeck@.discussions.microsoft.com> wrote in message
> news:2A416FD1-02F9-427D-9748-7F2CE4E08CDD@.microsoft.com...
>> tHi
>> I want to build a trigger to modify data in a table in a database that is
>> running on another Database Engine in may LAN. I don' t know if that is
>> possible. If it is, how will I make the connection to that database?
>> Thanks in advance - Waldo
>

I have a MSDE instance running on a server. I am able to start the services
for the
engine. But when I try to access the instance through "SQL Enterprise
Manager" I
get an error message.
"[server name] - SQL Server does not exist or access is denied."
I tried to access the instance through "Windows Authentication" and "SQL
Server Login" and I get the same error message.
I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to start
the SQL services and I can restore a few databases from backup to the
instance.
Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
password
using the SAPWD switch.
Questions:
Is there somthing that I am forgetting to do?
How can I access the instance through SQL Enterprise Manager?
Thanks in advanceGreg,
Instance? Have you tried servername\instancename?
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>I have a MSDE instance running on a server. I am able to start the services
> for the
> engine. But when I try to access the instance through "SQL Enterprise
> Manager" I
> get an error message.
> "[server name] - SQL Server does not exist or access is denied."
> I tried to access the instance through "Windows Authentication" and "SQL
> Server Login" and I get the same error message.
> I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> start
> the SQL services and I can restore a few databases from backup to the
> instance.
> Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> password
> using the SAPWD switch.
>
> Questions:
> Is there somthing that I am forgetting to do?
> How can I access the instance through SQL Enterprise Manager?
> Thanks in advance|||What do you mean servername\instancename?
There is no place to enter that info in SQL Enterprise Manager.
Is there anywhere else I can enter that info?
"Jerry Spivey" wrote:
> Greg,
> Instance? Have you tried servername\instancename?
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >I have a MSDE instance running on a server. I am able to start the services
> > for the
> > engine. But when I try to access the instance through "SQL Enterprise
> > Manager" I
> > get an error message.
> >
> > "[server name] - SQL Server does not exist or access is denied."
> >
> > I tried to access the instance through "Windows Authentication" and "SQL
> > Server Login" and I get the same error message.
> >
> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> > start
> > the SQL services and I can restore a few databases from backup to the
> > instance.
> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> > password
> > using the SAPWD switch.
> >
> >
> > Questions:
> > Is there somthing that I am forgetting to do?
> > How can I access the instance through SQL Enterprise Manager?
> >
> > Thanks in advance
>
>|||Greg,
I don't use MSDE but if EM sees it as another SQL Server and not the default
install then it probably sees it as a named instance. When you're
registering MSDE. For more information on named instances see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> What do you mean servername\instancename?
> There is no place to enter that info in SQL Enterprise Manager.
> Is there anywhere else I can enter that info?
> "Jerry Spivey" wrote:
>> Greg,
>> Instance? Have you tried servername\instancename?
>> HTH
>> Jerry
>> "Greg" <gregkh@.hotmail.com> wrote in message
>> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>> >I have a MSDE instance running on a server. I am able to start the
>> >services
>> > for the
>> > engine. But when I try to access the instance through "SQL Enterprise
>> > Manager" I
>> > get an error message.
>> >
>> > "[server name] - SQL Server does not exist or access is denied."
>> >
>> > I tried to access the instance through "Windows Authentication" and
>> > "SQL
>> > Server Login" and I get the same error message.
>> >
>> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
>> > start
>> > the SQL services and I can restore a few databases from backup to the
>> > instance.
>> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
>> > password
>> > using the SAPWD switch.
>> >
>> >
>> > Questions:
>> > Is there somthing that I am forgetting to do?
>> > How can I access the instance through SQL Enterprise Manager?
>> >
>> > Thanks in advance
>>|||Unfortunatly that did not help. I do not have SQL Server installed. Just an
MSDE instance. I need to access thaat instance from SQL Enterprise Manager. I
only installed EM from the SQL 2000 CD so that I can access the MSDE instance.
How about this, How do I put the MSDE instance in single-user mode?
"Jerry Spivey" wrote:
> Greg,
> I don't use MSDE but if EM sees it as another SQL Server and not the default
> install then it probably sees it as a named instance. When you're
> registering MSDE. For more information on named instances see:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> HTH
> Jerry
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> > What do you mean servername\instancename?
> > There is no place to enter that info in SQL Enterprise Manager.
> >
> > Is there anywhere else I can enter that info?
> >
> > "Jerry Spivey" wrote:
> >
> >> Greg,
> >>
> >> Instance? Have you tried servername\instancename?
> >>
> >> HTH
> >>
> >> Jerry
> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >> >I have a MSDE instance running on a server. I am able to start the
> >> >services
> >> > for the
> >> > engine. But when I try to access the instance through "SQL Enterprise
> >> > Manager" I
> >> > get an error message.
> >> >
> >> > "[server name] - SQL Server does not exist or access is denied."
> >> >
> >> > I tried to access the instance through "Windows Authentication" and
> >> > "SQL
> >> > Server Login" and I get the same error message.
> >> >
> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able to
> >> > start
> >> > the SQL services and I can restore a few databases from backup to the
> >> > instance.
> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the sa
> >> > password
> >> > using the SAPWD switch.
> >> >
> >> >
> >> > Questions:
> >> > Is there somthing that I am forgetting to do?
> >> > How can I access the instance through SQL Enterprise Manager?
> >> >
> >> > Thanks in advance
> >>
> >>
> >>
>
>|||Greg,
So MSDE is the only SQL Server installed? Try registering with the machine
IP address. Or if that doesn't work try:
(local)
HTH
Jerry
"Greg" <gregkh@.hotmail.com> wrote in message
news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> Unfortunatly that did not help. I do not have SQL Server installed. Just
> an
> MSDE instance. I need to access thaat instance from SQL Enterprise
> Manager. I
> only installed EM from the SQL 2000 CD so that I can access the MSDE
> instance.
> How about this, How do I put the MSDE instance in single-user mode?
>
> "Jerry Spivey" wrote:
>> Greg,
>> I don't use MSDE but if EM sees it as another SQL Server and not the
>> default
>> install then it probably sees it as a named instance. When you're
>> registering MSDE. For more information on named instances see:
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
>> HTH
>> Jerry
>> "Greg" <gregkh@.hotmail.com> wrote in message
>> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
>> > What do you mean servername\instancename?
>> > There is no place to enter that info in SQL Enterprise Manager.
>> >
>> > Is there anywhere else I can enter that info?
>> >
>> > "Jerry Spivey" wrote:
>> >
>> >> Greg,
>> >>
>> >> Instance? Have you tried servername\instancename?
>> >>
>> >> HTH
>> >>
>> >> Jerry
>> >> "Greg" <gregkh@.hotmail.com> wrote in message
>> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
>> >> >I have a MSDE instance running on a server. I am able to start the
>> >> >services
>> >> > for the
>> >> > engine. But when I try to access the instance through "SQL
>> >> > Enterprise
>> >> > Manager" I
>> >> > get an error message.
>> >> >
>> >> > "[server name] - SQL Server does not exist or access is denied."
>> >> >
>> >> > I tried to access the instance through "Windows Authentication" and
>> >> > "SQL
>> >> > Server Login" and I get the same error message.
>> >> >
>> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
>> >> > to
>> >> > start
>> >> > the SQL services and I can restore a few databases from backup to
>> >> > the
>> >> > instance.
>> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
>> >> > sa
>> >> > password
>> >> > using the SAPWD switch.
>> >> >
>> >> >
>> >> > Questions:
>> >> > Is there somthing that I am forgetting to do?
>> >> > How can I access the instance through SQL Enterprise Manager?
>> >> >
>> >> > Thanks in advance
>> >>
>> >>
>> >>
>>|||EM and the MSDE instance are on the same machine. I tried local and IP
address and I still get the same error. Is there anything that I am
forgetting to do?
"Jerry Spivey" wrote:
> Greg,
> So MSDE is the only SQL Server installed? Try registering with the machine
> IP address. Or if that doesn't work try:
> (local)
> HTH
> Jerry
>
> "Greg" <gregkh@.hotmail.com> wrote in message
> news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> > Unfortunatly that did not help. I do not have SQL Server installed. Just
> > an
> > MSDE instance. I need to access thaat instance from SQL Enterprise
> > Manager. I
> > only installed EM from the SQL 2000 CD so that I can access the MSDE
> > instance.
> >
> > How about this, How do I put the MSDE instance in single-user mode?
> >
> >
> > "Jerry Spivey" wrote:
> >
> >> Greg,
> >>
> >> I don't use MSDE but if EM sees it as another SQL Server and not the
> >> default
> >> install then it probably sees it as a named instance. When you're
> >> registering MSDE. For more information on named instances see:
> >>
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> >>
> >> HTH
> >>
> >> Jerry
> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> >> > What do you mean servername\instancename?
> >> > There is no place to enter that info in SQL Enterprise Manager.
> >> >
> >> > Is there anywhere else I can enter that info?
> >> >
> >> > "Jerry Spivey" wrote:
> >> >
> >> >> Greg,
> >> >>
> >> >> Instance? Have you tried servername\instancename?
> >> >>
> >> >> HTH
> >> >>
> >> >> Jerry
> >> >> "Greg" <gregkh@.hotmail.com> wrote in message
> >> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> >> >> >I have a MSDE instance running on a server. I am able to start the
> >> >> >services
> >> >> > for the
> >> >> > engine. But when I try to access the instance through "SQL
> >> >> > Enterprise
> >> >> > Manager" I
> >> >> > get an error message.
> >> >> >
> >> >> > "[server name] - SQL Server does not exist or access is denied."
> >> >> >
> >> >> > I tried to access the instance through "Windows Authentication" and
> >> >> > "SQL
> >> >> > Server Login" and I get the same error message.
> >> >> >
> >> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
> >> >> > to
> >> >> > start
> >> >> > the SQL services and I can restore a few databases from backup to
> >> >> > the
> >> >> > instance.
> >> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
> >> >> > sa
> >> >> > password
> >> >> > using the SAPWD switch.
> >> >> >
> >> >> >
> >> >> > Questions:
> >> >> > Is there somthing that I am forgetting to do?
> >> >> > How can I access the instance through SQL Enterprise Manager?
> >> >> >
> >> >> > Thanks in advance
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Oh and yes MSDE is the only SQL Server that is installed.
"Greg" wrote:
> EM and the MSDE instance are on the same machine. I tried local and IP
> address and I still get the same error. Is there anything that I am
> forgetting to do?
> "Jerry Spivey" wrote:
> > Greg,
> >
> > So MSDE is the only SQL Server installed? Try registering with the machine
> > IP address. Or if that doesn't work try:
> >
> > (local)
> >
> > HTH
> >
> > Jerry
> >
> >
> > "Greg" <gregkh@.hotmail.com> wrote in message
> > news:A8E51772-6107-439F-A415-BB13EA4B1B31@.microsoft.com...
> > > Unfortunatly that did not help. I do not have SQL Server installed. Just
> > > an
> > > MSDE instance. I need to access thaat instance from SQL Enterprise
> > > Manager. I
> > > only installed EM from the SQL 2000 CD so that I can access the MSDE
> > > instance.
> > >
> > > How about this, How do I put the MSDE instance in single-user mode?
> > >
> > >
> > > "Jerry Spivey" wrote:
> > >
> > >> Greg,
> > >>
> > >> I don't use MSDE but if EM sees it as another SQL Server and not the
> > >> default
> > >> install then it probably sees it as a named instance. When you're
> > >> registering MSDE. For more information on named instances see:
> > >>
> > >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp
> > >>
> > >> HTH
> > >>
> > >> Jerry
> > >> "Greg" <gregkh@.hotmail.com> wrote in message
> > >> news:CC7BA23C-241A-46A8-94E5-BA01B2D02722@.microsoft.com...
> > >> > What do you mean servername\instancename?
> > >> > There is no place to enter that info in SQL Enterprise Manager.
> > >> >
> > >> > Is there anywhere else I can enter that info?
> > >> >
> > >> > "Jerry Spivey" wrote:
> > >> >
> > >> >> Greg,
> > >> >>
> > >> >> Instance? Have you tried servername\instancename?
> > >> >>
> > >> >> HTH
> > >> >>
> > >> >> Jerry
> > >> >> "Greg" <gregkh@.hotmail.com> wrote in message
> > >> >> news:40B1ACCA-63E6-4F99-9B0F-6FC8CBE54598@.microsoft.com...
> > >> >> >I have a MSDE instance running on a server. I am able to start the
> > >> >> >services
> > >> >> > for the
> > >> >> > engine. But when I try to access the instance through "SQL
> > >> >> > Enterprise
> > >> >> > Manager" I
> > >> >> > get an error message.
> > >> >> >
> > >> >> > "[server name] - SQL Server does not exist or access is denied."
> > >> >> >
> > >> >> > I tried to access the instance through "Windows Authentication" and
> > >> >> > "SQL
> > >> >> > Server Login" and I get the same error message.
> > >> >> >
> > >> >> > I tried reinstalling "MSDE 2000A Desktop Engine" and SP4. I am able
> > >> >> > to
> > >> >> > start
> > >> >> > the SQL services and I can restore a few databases from backup to
> > >> >> > the
> > >> >> > instance.
> > >> >> > Also during reinstallation of "MSDE 2000A Desktop Engine" I set the
> > >> >> > sa
> > >> >> > password
> > >> >> > using the SAPWD switch.
> > >> >> >
> > >> >> >
> > >> >> > Questions:
> > >> >> > Is there somthing that I am forgetting to do?
> > >> >> > How can I access the instance through SQL Enterprise Manager?
> > >> >> >
> > >> >> > Thanks in advance
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >

Tuesday, March 27, 2012

accessing from T-SQL a database on another DBMS

accessing from T-SQL a database on another DBMS

accessing from T-SQL a database on another DBMS

Saturday, February 25, 2012

access SQL instance issue

SQL Alert

Blog Archive

About Me