Hi

I have a series of DTS packages whgich were running ok
as jobs on tyhe server. Something went wrong on friday and
now I can't open/run them from the server. I have tried from
enterprise manager a client and they run fine.

From the servewr I get
"[dbnetlib] [(Connection open())] SQL Server does not exist or access
denied"
I have changed nothing. There is no permissions issue that i can think of.

On the server (Win2003) if I create a new package I can only create a
connection
to "local" or "mydomain/myserver". Before I could do it to "myserver". The
server
will not open up or run these newly created packages, giving me the same
error.

Whatever happend also took out the native windows backup utility (VSS)
which gave an error when sql server was running but worked when it was off

Event Type: Error
Event Source: VSS
Event Category: None
Event ID: 6013
Date: 11/07/2005
Time: 11:21:49
User: N/A
Computer: myserverDescription:
Sqllib error: OLEDB Error encountered calling
IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001,
Native Error: 17
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: [DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.

I am at a loss to know what to do as as far as I can see nothing has
happened.
I have restored the msdb database and that made no difference

I would appreciate any help as I am under a lot of pressure

thanks

Jonathyan

Sounds like something is getting blocked or the protocal is out of whack.

Can you create a TCP/IP alias to MyServer in Cliconfig?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Jonathan Crawford" <jc (AT) jcrawford (DOT) co.uk> wrote

Can you create a TCP/IP alias to MyServer in Cliconfig?

I will try in the morning

thanks

jc

*** Sent via Developersdex http://www.developersdex.com ***

Perhaps i should have added, query analyzer works fine on the server


thanks

jc

*** Sent via Developersdex http://www.developersdex.com ***

Hi
I tried to create an alias but it wouldn't
pick it up in enterprise manager.
I also noticed I have lost the ability to
send messages to logged on users
in the currenmt activity\process window
and I could do that last week.

I have been informed there ar no sercurity updates
etc

thanks
jonathan

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote