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("CONN")
Dim cnIntranet As New SqlConnection(strConnect)
Try
cnIntranet.Open()
Catch ex As SqlException
Response.Write(ex.Message & "<BR>")
Return
End Try
'Where
'Application("CONN")
= "server=servername;database=dbname;uid=loginname;p wd=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
.