SQL SERVER DOES NOT EXIST OR ACCESS DENIED

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 2005 Forums

Other SQL Server Topics (2005)

SQL SERVER DOES NOT EXIST OR ACCESS DENIED

Author

Topic

san.kothari2002
Starting Member

1 Post

Posted - 2010-10-30 : 01:21:43

ERROR - RUN TIME ERROR - 2147467259 (80004005)
[DBNETLIB]ConnectionOpen (Connect())] SQL Server does not exist or access denied.

Description:
1)My SQL Server 2005 install in Windows Server 2003.
2)I want to connect sql server 2005 using vb application on another windows server 2003 which is in Domain.

Note : this application is working on another xp machines which is under domain.

Connection String is :
With conOffer

.Provider = "SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=mkt;Data Source=ASTSERVER"

.CursorLocation = adUseClient

.Open

frmLogin.Show

End With

How can i connection to Sql from windows server 2003 operating system ?

Kindly provide solution.
Thanks you very much
Sanjay

Sanjay

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-10-30 : 09:01:49

Can you ping the server - by name / by ip address?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources