Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > SQL Server does not exists or access denided

Reply
Thread Tools

SQL Server does not exists or access denided

 
 
SOS
Guest
Posts: n/a
 
      02-27-2004
hi guys ,
i want to coonnect to a sql server on an other machine in a LAN network.
i use of this connection string : "data source=TargetMachine;initial
catalog=mydatabase;password=1;persist security info=True;user id=a;packet
size=4096"
but when i trying to get some data, i get this error : "SQL Server doesn't
exists or access denided"
but i can connect to this database and get data with "Enterprise Manager" or
"Query Analyzer".
what's the problem ?

Thanx


 
Reply With Quote
 
 
 
 
Martin Dechev
Guest
Posts: n/a
 
      02-27-2004
Hi, SOS,

Try some of the connection strings listed in this site:

http://www.connectionstrings.com/

Greetings
Martin
"SOS" <(E-Mail Removed)> wrote in message
news:#DgWTrQ$(E-Mail Removed)...
> hi guys ,
> i want to coonnect to a sql server on an other machine in a LAN network.
> i use of this connection string : "data source=TargetMachine;initial
> catalog=mydatabase;password=1;persist security info=True;user id=a;packet
> size=4096"
> but when i trying to get some data, i get this error : "SQL Server doesn't
> exists or access denided"
> but i can connect to this database and get data with "Enterprise Manager"

or
> "Query Analyzer".
> what's the problem ?
>
> Thanx
>
>



 
Reply With Quote
 
 
 
 
Cowboy \(Gregory A. Beamer\)
Guest
Posts: n/a
 
      02-27-2004
Most likely, the SQL Server is not set up with mixed mode and you are
connecting with the SQL tools using Windows authentication. This is the most
common reason people have problems, esp. with MSDE.

It could also be the client library being used by the web server.

Or, it could be user based (long shot with a connection string using SQL
security). The easiest way to check the second is try to get data using that
connection string in a Windows App. If it works, then try turning off anon
access in your web app and see if you can get in.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"SOS" <(E-Mail Removed)> wrote in message
news:%23DgWTrQ$(E-Mail Removed)...
> hi guys ,
> i want to coonnect to a sql server on an other machine in a LAN network.
> i use of this connection string : "data source=TargetMachine;initial
> catalog=mydatabase;password=1;persist security info=True;user id=a;packet
> size=4096"
> but when i trying to get some data, i get this error : "SQL Server doesn't
> exists or access denided"
> but i can connect to this database and get data with "Enterprise Manager"

or
> "Query Analyzer".
> what's the problem ?
>
> Thanx
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to check if a directory exists? folder.exists() does not work! Ulf Meinhardt Java 8 08-28-2009 12:26 PM
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote aboutjav.com@gmail.com ASP .Net 0 05-03-2008 12:43 PM
System.ComponentModel.Win32Exception Access denided Shahin ASP .Net Web Services 0 08-31-2007 07:38 AM
System.ComponentModel.Win32Exception: Access is denided shahin ASP .Net 0 08-30-2007 02:54 PM
finding if file exists or not in apache webdav server and if exists what is the mime type of it.... Totan Java 0 04-17-2006 05:13 AM



Advertisments