By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,143 Members | 865 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,143 IT Pros & Developers. It's quick & easy.

SQL Server does not exist or access denied

P: n/a
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("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
.

Nov 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 17 '05 #2

P: n/a
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

Nov 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.