Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server does not exist or access denied.

Status
Not open for further replies.
mori0043

mori0043

Programmer
Oct 28, 2004
23
0
0
CA
What am I doing wrong? I am trying to connect to a web server that connects to another machine running SQL server 2K. I receive this error: SQL Server does not exist or access denied.

Here is my conn string: Provider=sqloledb;Data Source=asdas;Network Library=DBMSSOCN;Initial Catalog=Cadets;User ID=sa;Password=sa;

I have all ready checked the settings on SQL Server and mixed mode is checked....

Any ideas?????
 
Sort by date Sort by votes
pl check on which port sql server is listening to?
default is: 1433.
can you try using ipaddress,port number ?
(Ex: Data Source=190.190.200.100,1433;)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
204
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
166
pjw001
pjw001
ahmedsa2018
  • Locked
  • Question
How to give same number if it exist on table or new number if it not exist based on part value? 1
Replies
8
Views
68
Andrzejek
Andrzejek
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
119
Mike Lewis
Mike Lewis
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
184
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top