Hi, I am working on the project in Beginning Web Programming VB.NET and Visual Studio.NET

The database for this project was contained within a file called Friends_Data.MDF The instructions said to attach this file to the MSDE server, which I did. I am now trying to access the database via a web form to create a new entry in the database. The connection string I am using is

con = New SqlConnection("data source=(NetSdk;initial catalog=Friends;user id=sa")

However, when trying to create a new entry I get the error listed below. Does anyone have any idea on how I can correct this problem?

Thanks much,

Michael

Error Message:

I am using Windows NT Integrated security to log into the database.

How is your MSDN instance called? Are you sure it's called NetSDK?

Can you see your SQL Server using the Enterprise Manager (if you have it available)? That way, it's easy to see the instance name.

Also, you say you're using Integrated Security to log into the database. Do you mean you set your MSDN installation to Integrated only? If so, you'll need to modify your connection string. Right now you're using SQL Server Authentication because you're using a User ID. Take a look here for more info on a connection string that uses Integrated Security (Integrated Security needs to be set to SSPI, or alternatively, use Trusted_Connection=Yes.)

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

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

(I said MSDN a couple of times, but of course I meant MSDE)

Sorry it took me a while to answer you. I first had to get humiliated on the squash-court... ;)

Anyway, yes, you're getting closer. Your ASP.NET pages can now at least see your SQL Server. Now you have to make sure that the ASPNET account has sufficient rights to the database Friends.

By default, your ASPX pages will run under the context of the ASPNET account. (For "classic ASP", this was the IUSR_MachineName account).
To add this account, add it to you Login list under Security in SQL Server first, then grant it access to the Friends database.

If you have the SQL Server Enterprise Manager, this is easy to do. If you have just the MSDE, you'll need to execute some SQL statements to add the account.

Hope this helps, and if not, let me know.....

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hellaluja!

Thanks so much Imar!

You're welcome ;) Glad it worked out.

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

I got the same problem as Michael but after I followed your solution. it worked out. I just want to thank you.
Thank you so much for your helpful answer.

eaid