Problems connecting to SQL server after SP3

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Problems connecting to SQL server after SP3

Author

Topic

kleinmi
Starting Member

9 Posts

Posted - 2003-01-28 : 09:40:25

Hey Guys,

I'm having a problem connecting to a remote SQL Server database after SP3. I'm getting access denied/database doesn't exist.

Could this have to do with "Enable Cross-Database ownership"?

I can ping the machine, but I can't connect via any applications OR Query analyzer

Any clues?!

kleinmi
Starting Member

9 Posts

Posted - 2003-01-28 : 09:53:38

the error is

Query analyzer:

Server: Msg 17, Level 16, State 1
[DBNETLIB]Sql Server does not exist or access denied

asp application:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Argyle
Yak Posting Veteran

53 Posts

Posted - 2003-01-28 : 10:47:16

Shouldn't have anything to do with "Enable Cross-Database ownership". I would check with your network admins to verify that they haven't blocked port 1433 in the firewalls and routers now because of the virus, even though blocking 1434 is enough.

Try log on locally on the server and open enterprise manager or query analyzer and connect.

/Argyle

Edited by - argyle on 01/28/2003 10:48:43

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources