Thread: SQL server...
View Single Post
  #3 (permalink)  
Old February 3rd, 2004, 12:44 PM
Michael Randall Michael Randall is offline
Authorized User
 
Join Date: Jan 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the help, Imar.

My MSDN instance is not called NetSDK. I think it is just my computer name. I can see my SQL Server in Enterpirise manager, but I am not sure where to look to confimr the instance name.

Based on the information on the link you sent, I changed my connection string to:

"data source=MRANDALL;" & "Initial Catalog=Friends;" & "Integrated Security=SSPI"

There template was:

"Data Source=(local);" & "Initial Catalog=mySQLServerDBName;" & "Integrated Security=SSPI"

This seem to take care of the error message I was receiving, but now I have a new one:

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'MRANDALL\ASPNET'.

Source Error:


Line 102:
Line 103: cmd = New SqlCommand(sql, con)
Line 104: con.Open()
Line 105:
Line 106: Try


Source File: c:\inetpub\wwwroot\FriendsReunionUI\secure\NewUser .aspx.vb Line: 104

Stack Trace:


[SqlException: Login failed for user 'MRANDALL\ASPNET'.]
   System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
   System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
   System.Data.SqlClient.SqlConnection.Open()
   FriendsReunionUI.NewUser.btnAccept_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\FriendsReunionUI\secure\NewUser .aspx.vb:104
   System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
   System.Web.UI.Page.ProcessRequestMain()


Any thoughts? Am I moving in the right direction?

-Michael