SQL Server does not exist or access denied

[Ravikanth[MVP]]

Hi

Are you using named instances of SQL Server?
First check whether u r able to connect to SQL Server to
SQL Enterpraise manager
HTH
Ravikanth

-----Original Message-----
I am running an asp.net application on my development
machine (Win2K, .NET framework). This prog connects to aSQL Server (on another machine).
When I run the following code it errors with the followingmessage: "SQL Server does not exist or access denied"

Dim strConnect As String = Application("CO NN")
Dim cnIntranet As New SqlConnection(s trConnect)
Try
cnIntranet.Open ()
Catch ex As SqlException
Response.Write( ex.Message & "<BR>")
Return
End Try

'Where
'Application(" CONN")
= "server=servern ame;database=db name;uid=loginn ame;pwd=ab cdefg"

However if I copy the project up to the production
Intranet server (Win2k) it works fine (pointing at the
same sql server as when it doesn't work).
I haven't done anything on the SQL server to allow accessfrom the production Intranet server but it works from
there, but not my local IIS.

I know this is probably a basic security problem but
having searched the internet I can't find a soln.

Regards
.

[Fiona Wallace]

Thanks for reply. I am able to connect to this sql server
by many others means (query analyzer, enterprise mgr and
also the same .net app when running from production
server). It's only when I run it from LOCAL iis it doesn't
work.
If by "named instance" you mean using the actual name as
opposed to IP address? then yes, I'm using the actual name
of the server.

-----Original Message-----
Hi

Are you using named instances of SQL Server?
First check whether u r able to connect to SQL Server to
SQL Enterpraise manager
HTH
Ravikanth

[Fiona Wallace]

Thanks for reply. I am able to connect to this sql server
by many others means (query analyzer, enterprise mgr and
also the same .net app when running from production
server). It's only when I run it from LOCAL iis it doesn't
work.
If by "named instance" you mean using the actual name as
opposed to IP address? then yes, I'm using the actual name
of the server.

-----Original Message-----
Hi

Are you using named instances of SQL Server?
First check whether u r able to connect to SQL Server to
SQL Enterpraise manager
HTH
Ravikanth