new server gives login error URGENT

This is on my web page from a log in:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
trusted SQL Server connection.
/admin/addconn_1.asp, line 7
I have take a new server given it the former IP of the old one, restored the
data from the old one, and done a DTS for transfer of users.
That DTS gives an error, but no details. I can see Error Occured in the
status, and nothing more
Where do I go to next?Hi
Please check out what is sql server's authentication.
Probably you have "windows only" authentication , try to change it to
"mixed"
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
> a trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored
> the data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>|||Do you call the DTS from a job ?
If you do ,an another option is that you have created a package on your
workstation , i mean the owner of the package is not the same as an acount
that SQL Server Agent running under.
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
> Thanks, correct that new box was set as Win only. that has been changed
> to mixed. DTS package still fails after stop & start of service.
> Any other ideas?
> I see the UserID in the actual db for the serve and I see the userid in
> the security login for that server for all dbs.
> Stephen
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>|||Stephen,
Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
windows group on the new server and that you have granted that windows group
appropriate windows permissions.
"__Stephen" wrote:

> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
a
> trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored t
he
> data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>
>|||Thanks Uri, I even went to the cold cellar or server room, and it failed
there as well.
The mixed authentication worked when I fixed the login/pw to be correct. I
hate an old dheap monitor for the server rack!
__Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ux1XGfgEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Do you call the DTS from a job ?
> If you do ,an another option is that you have created a package on your
> workstation , i mean the owner of the package is not the same as an
> acount that SQL Server Agent running under.
>
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
>|||"Pradeep Gharat" <PradeepGharat@.discussions.microsoft.com> wrote in message
news:63A6D7CC-98DA-4759-A39A-58CE46191F82@.microsoft.com...
> Stephen,
> Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
> windows group on the new server and that you have granted that windows
> group
> appropriate windows permissions.
Actually I don't want to do that. I added the SQL Authentication and it's
running now.

new server gives login error URGENT

This is on my web page from a log in:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
trusted SQL Server connection.
/admin/addconn_1.asp, line 7
I have take a new server given it the former IP of the old one, restored the
data from the old one, and done a DTS for transfer of users.
That DTS gives an error, but no details. I can see Error Occured in the
status, and nothing more
Where do I go to next?
Hi
Please check out what is sql server's authentication.
Probably you have "windows only" authentication , try to change it to
"mixed"
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
> a trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored
> the data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>
|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>
|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>
|||Do you call the DTS from a job ?
If you do ,an another option is that you have created a package on your
workstation , i mean the owner of the package is not the same as an acount
that SQL Server Agent running under.
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
> Thanks, correct that new box was set as Win only. that has been changed
> to mixed. DTS package still fails after stop & start of service.
> Any other ideas?
> I see the UserID in the actual db for the serve and I see the userid in
> the security login for that server for all dbs.
> Stephen
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>
|||Stephen,
Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
windows group on the new server and that you have granted that windows group
appropriate windows permissions.
"__Stephen" wrote:

> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
> trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored the
> data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more
> Where do I go to next?
>
>
>
|||Thanks Uri, I even went to the cold cellar or server room, and it failed
there as well.
The mixed authentication worked when I fixed the login/pw to be correct. I
hate an old dheap monitor for the server rack!
__Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ux1XGfgEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Do you call the DTS from a job ?
> If you do ,an another option is that you have created a package on your
> workstation , i mean the owner of the package is not the same as an
> acount that SQL Server Agent running under.
>
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
>
|||"Pradeep Gharat" <PradeepGharat@.discussions.microsoft.com> wrote in message
news:63A6D7CC-98DA-4759-A39A-58CE46191F82@.microsoft.com...
> Stephen,
> Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
> windows group on the new server and that you have granted that windows
> group
> appropriate windows permissions.
Actually I don't want to do that. I added the SQL Authentication and it's
running now.

new server gives login error URGENT

This is on my web page from a log in:
Microsoft OLE DB Provider for SQL Server error '80004005'
Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
trusted SQL Server connection.
/admin/addconn_1.asp, line 7
I have take a new server given it the former IP of the old one, restored the
data from the old one, and done a DTS for transfer of users.
That DTS gives an error, but no details. I can see Error Occured in the
status, and nothing more :(
Where do I go to next?Do you have mixed authentication mode on that server?
right click the server-->properties-->security and take a look, is
windows only checked?|||Hi
Please check out what is sql server's authentication.
Probably you have "windows only" authentication , try to change it to
"mixed"
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
> a trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored
> the data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more :(
> Where do I go to next?
>
>|||Seems that your are not using mixed authentication. Try to set the
server to mixed authentication.
HTH, jens Suessmeyer.|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
>> a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one, restored
>> the data from the old one, and done a DTS for transfer of users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in the
>> status, and nothing more :(
>> Where do I go to next?
>>
>>
>|||Thanks, correct that new box was set as Win only. that has been changed to
mixed. DTS package still fails after stop & start of service.
Any other ideas?
I see the UserID in the actual db for the serve and I see the userid in the
security login for that server for all dbs.
Stephen
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1136471412.242368.94270@.f14g2000cwb.googlegroups.com...
> Do you have mixed authentication mode on that server?
> right click the server-->properties-->security and take a look, is
> windows only checked?
>|||Thanks
I wasn't using mixed authentication as well as confusing * with " on a fuzzy
server monitor!!
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1136471757.457363.194350@.g14g2000cwa.googlegroups.com...
> Seems that your are not using mixed authentication. Try to set the
> server to mixed authentication.
> HTH, jens Suessmeyer.
>|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Hi
> Please check out what is sql server's authentication.
> Probably you have "windows only" authentication , try to change it to
> "mixed"
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with
>> a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one, restored
>> the data from the old one, and done a DTS for transfer of users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in the
>> status, and nothing more :(
>> Where do I go to next?
>>
>>
>|||I didn't see an * properly as an ending char for a PW. I thought that it
was a ".
Thanks again!
"SQL" <denis.gobo@.gmail.com> wrote in message
news:1136471412.242368.94270@.f14g2000cwb.googlegroups.com...
> Do you have mixed authentication mode on that server?
> right click the server-->properties-->security and take a look, is
> windows only checked?
>|||Do you call the DTS from a job ?
If you do ,an another option is that you have created a package on your
workstation , i mean the owner of the package is not the same as an acount
that SQL Server Agent running under.
"__Stephen" <srussell@.transactiongraphics.com> wrote in message
news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
> Thanks, correct that new box was set as Win only. that has been changed
> to mixed. DTS package still fails after stop & start of service.
> Any other ideas?
> I see the UserID in the actual db for the serve and I see the userid in
> the security login for that server for all dbs.
> Stephen
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Please check out what is sql server's authentication.
>> Probably you have "windows only" authentication , try to change it to
>> "mixed"
>>
>> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
>> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated
>> with a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one, restored
>> the data from the old one, and done a DTS for transfer of users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in the
>> status, and nothing more :(
>> Where do I go to next?
>>
>>
>>
>|||Stephen,
Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
windows group on the new server and that you have granted that windows group
appropriate windows permissions.
"__Stephen" wrote:
> This is on my web page from a log in:
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated with a
> trusted SQL Server connection.
> /admin/addconn_1.asp, line 7
>
> I have take a new server given it the former IP of the old one, restored the
> data from the old one, and done a DTS for transfer of users.
>
> That DTS gives an error, but no details. I can see Error Occured in the
> status, and nothing more :(
> Where do I go to next?
>
>
>|||Thanks Uri, I even went to the cold cellar or server room, and it failed
there as well.
The mixed authentication worked when I fixed the login/pw to be correct. I
hate an old dheap monitor for the server rack!
__Stephen
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ux1XGfgEGHA.2040@.TK2MSFTNGP14.phx.gbl...
> Do you call the DTS from a job ?
> If you do ,an another option is that you have created a package on your
> workstation , i mean the owner of the package is not the same as an
> acount that SQL Server Agent running under.
>
>
> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
> news:OV64bZgEGHA.344@.TK2MSFTNGP11.phx.gbl...
>> Thanks, correct that new box was set as Win only. that has been changed
>> to mixed. DTS package still fails after stop & start of service.
>> Any other ideas?
>> I see the UserID in the actual db for the serve and I see the userid in
>> the security login for that server for all dbs.
>> Stephen
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ed4jrSgEGHA.1032@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Please check out what is sql server's authentication.
>> Probably you have "windows only" authentication , try to change it to
>> "mixed"
>>
>> "__Stephen" <srussell@.transactiongraphics.com> wrote in message
>> news:eYzSbOgEGHA.140@.TK2MSFTNGP12.phx.gbl...
>> This is on my web page from a log in:
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> Login failed for user 'TGI_Int_Admin_Webapp'. Reason: Not associated
>> with a trusted SQL Server connection.
>> /admin/addconn_1.asp, line 7
>>
>> I have take a new server given it the former IP of the old one,
>> restored the data from the old one, and done a DTS for transfer of
>> users.
>>
>> That DTS gives an error, but no details. I can see Error Occured in
>> the status, and nothing more :(
>> Where do I go to next?
>>
>>
>>
>>
>|||"Pradeep Gharat" <PradeepGharat@.discussions.microsoft.com> wrote in message
news:63A6D7CC-98DA-4759-A39A-58CE46191F82@.microsoft.com...
> Stephen,
> Make sure that user 'TGI_Int_Admin_Webapp' is added to appropriate
> windows group on the new server and that you have granted that windows
> group
> appropriate windows permissions.
Actually I don't want to do that. I added the SQL Authentication and it's
running now.

New Instance Install

I installed another instance of SQL Server onto my
machine. I currently have a personal edition and decided
to install a second instance. It failed at MDAC
installation. When I look at the setup log, it says the
installation failed.
My dilema is that I cannot start the previous installation
I had before. When I activate Enterprise Manager, I get a
Snap-in failed to initialize : Microsoft Enterprise
Manager. I tried everything I know to start SQL - but
cannot. Can someone help please?
Mary.Mary,
Try re-installing MDAC 2.7 SP1 and try it again. Let me know if it still
doesn't work
HTH
Thank you,
Saleem@.sqlnt.com
"Mary Lou" wrote:
> I installed another instance of SQL Server onto my
> machine. I currently have a personal edition and decided
> to install a second instance. It failed at MDAC
> installation. When I look at the setup log, it says the
> installation failed.
> My dilema is that I cannot start the previous installation
> I had before. When I activate Enterprise Manager, I get a
> Snap-in failed to initialize : Microsoft Enterprise
> Manager. I tried everything I know to start SQL - but
> cannot. Can someone help please?
> Mary.
>|||Saleem,
I just got back today and tried your suggestion. Saleem,
it worked like a champ. I want to thank you for your
expert advise. Have a good one.
Mary.
>--Original Message--
>Mary,
>Try re-installing MDAC 2.7 SP1 and try it again. Let me
know if it still
>doesn't work
>HTH
>Thank you,
>Saleem@.sqlnt.com
>"Mary Lou" wrote:
>> I installed another instance of SQL Server onto my
>> machine. I currently have a personal edition and
decided
>> to install a second instance. It failed at MDAC
>> installation. When I look at the setup log, it says
the
>> installation failed.
>> My dilema is that I cannot start the previous
installation
>> I had before. When I activate Enterprise Manager, I
get a
>> Snap-in failed to initialize : Microsoft Enterprise
>> Manager. I tried everything I know to start SQL - but
>> cannot. Can someone help please?
>> Mary.
>.
>

New Instance Install

I installed another instance of SQL Server onto my
machine. I currently have a personal edition and decided
to install a second instance. It failed at MDAC
installation. When I look at the setup log, it says the
installation failed.
My dilema is that I cannot start the previous installation
I had before. When I activate Enterprise Manager, I get a
Snap-in failed to initialize : Microsoft Enterprise
Manager. I tried everything I know to start SQL - but
cannot. Can someone help please?
Mary.
Mary,
Try re-installing MDAC 2.7 SP1 and try it again. Let me know if it still
doesn't work
HTH
Thank you,
Saleem@.sqlnt.com
"Mary Lou" wrote:

> I installed another instance of SQL Server onto my
> machine. I currently have a personal edition and decided
> to install a second instance. It failed at MDAC
> installation. When I look at the setup log, it says the
> installation failed.
> My dilema is that I cannot start the previous installation
> I had before. When I activate Enterprise Manager, I get a
> Snap-in failed to initialize : Microsoft Enterprise
> Manager. I tried everything I know to start SQL - but
> cannot. Can someone help please?
> Mary.
>
|||Saleem,
I just got back today and tried your suggestion. Saleem,
it worked like a champ. I want to thank you for your
expert advise. Have a good one.
Mary.

>--Original Message--
>Mary,
>Try re-installing MDAC 2.7 SP1 and try it again. Let me
know if it still[vbcol=seagreen]
>doesn't work
>HTH
>Thank you,
>Saleem@.sqlnt.com
>"Mary Lou" wrote:
decided[vbcol=seagreen]
the[vbcol=seagreen]
installation[vbcol=seagreen]
get a
>.
>

New IBM Laptop running SQL server cannot connect to another sql server on network

I am trying to connect a new LBM Laptop to an SQL server on the
network
and I get "test connection failed because of an error in initializing
provider, [dbnetlib][connectionopren(connect()),] SQL server does not
exist or access denied. The laptom has sql server running on it
locally and I am trying to connect to an SQL server on the network.
Thanks
TomHi

You should make sure that SQL Server is at Service Pack 3a on both machines
and check the MDAC installation on the laptop with the MDAC component
checker (see microsoft download centre)?

If you can connect to the network SQL Server from other machines, then check
the network settings on the laptop.

John

"TomCullen" <cullentw2000@.yahoo.com> wrote in message
news:6ba80eaf.0410220926.6c2f4355@.posting.google.c om...
> I am trying to connect a new LBM Laptop to an SQL server on the
> network
> and I get "test connection failed because of an error in initializing
> provider, [dbnetlib][connectionopren(connect()),] SQL server does not
> exist or access denied. The laptom has sql server running on it
> locally and I am trying to connect to an SQL server on the network.
> Thanks
> Tom