Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asptoday_discuss thread: SQL Server Access denied


Message #1 by "Sharon wan" <sharon.wan@m...> on Wed, 1 May 2002 20:26:22
Can anybody tell me what's wrong with the following connectionstrings:

  MyConnection = New SqlConnection("server
(SQLDEV);database=pubs;Trusted_Connection=yes")
or:
 sConnectionString = "integrated security=sspi;initial 
catalog=OEDBOriginal;data suroce=SQLDEV;";	

I am creating applications using .NET, and have difficulty to connect to 
the database. We use SQL Server 2000, I tried several ways to fill the 
connectionstring, and always got the error:

SqlException: SQL Server does not exist or access denied.]
   System.Data.SqlClient.SqlConnection.Open()
   testing.WebForm1.Page_Load(Object sender, EventArgs e) in 
C:\Inetpub\wwwroot\testing\WebForm1.aspx.vb:49
   System.Web.UI.Control.OnLoad(EventArgs e)
   System.Web.UI.Control.LoadRecursive()
   System.Web.UI.Page.ProcessRequestMain()

Please tell me what special thing do I need to do for this 
connectionstring.


Appreciate it. Look forward to hearing from you.

Sharon


  Return to Index