 | |
SQL Server does not exist or access denied
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
SQL Server does not exist or access denied -
01-16-2004
, 11:13 AM
#2
| |||
| |||
|
|
G'day I have a DTS package that has been running in production without error for several months but suddenly is failing since yesterday. The error message is: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. No changes have been made to the data schema since 2003. The package contains two tasks only one of which fails. Both tasks source data from the same databases using the same connection. Both tasks write to the same database using the same connection. The package is failing on the test server as well since yesterday. The userid in the destination connection has DB_OWNER privileges. I tried filtering out source data prior to 2004 in case the error was caused by bad data. Doesn't matter what data range I use I get the same error. I tried changing the destination to a new table but get the same error. Running SQL Server 2000 sp3 in NT5 (server) machine. Any ideas? |
#3
| |||
| |||
|
|
-----Original Message----- OK couple of things I would try 1. Start | Run | CliConfg Create a TCPIP alias to the server and specify this name in the connection details. 2. Run a Profiler trace on the other server to check for "Login Failed" events 3. Start | Run | osql -E -S<servername> -dMaster 4. Make sure the SQL Server Service is started on the other server -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Blue" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0aed01c3dc54$02032530$a601280a (AT) phx (DOT) gbl... G'day I have a DTS package that has been running in production without error for several months but suddenly is failing since yesterday. The error message is: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. No changes have been made to the data schema since 2003. The package contains two tasks only one of which fails. Both tasks source data from the same databases using the same connection. Both tasks write to the same database using the same connection. The package is failing on the test server as well since yesterday. The userid in the destination connection has DB_OWNER privileges. I tried filtering out source data prior to 2004 in case the error was caused by bad data. Doesn't matter what data range I use I get the same error. I tried changing the destination to a new table but get the same error. Running SQL Server 2000 sp3 in NT5 (server) machine. Any ideas? . |
#4
| |||
| |||
|
|
Thanks Allan TCP/IP connection works fine. SQL Server service running Problem solved! Package contained a 'hidde' lookup that used another connection. The lookup was redundent and once removed the package worked fine. Blue -----Original Message----- OK couple of things I would try 1. Start | Run | CliConfg Create a TCPIP alias to the server and specify this name in the connection details. 2. Run a Profiler trace on the other server to check for "Login Failed" events 3. Start | Run | osql -E -S<servername> -dMaster 4. Make sure the SQL Server Service is started on the other server -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Blue" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:0aed01c3dc54$02032530$a601280a (AT) phx (DOT) gbl... G'day I have a DTS package that has been running in production without error for several months but suddenly is failing since yesterday. The error message is: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. No changes have been made to the data schema since 2003. The package contains two tasks only one of which fails. Both tasks source data from the same databases using the same connection. Both tasks write to the same database using the same connection. The package is failing on the test server as well since yesterday. The userid in the destination connection has DB_OWNER privileges. I tried filtering out source data prior to 2004 in case the error was caused by bad data. Doesn't matter what data range I use I get the same error. I tried changing the destination to a new table but get the same error. Running SQL Server 2000 sp3 in NT5 (server) machine. Any ideas? . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.