Hi
I recently purchased Asp.net Databases using Vb
I am having difficulty connecting to MSDE keep getting login error for user.(I am using Visual Studio.net)
This is the error

Login failed for user 'FRANK\ASPNET'

[SqlException: Login failed for user 'FRANK\ASPNET'.]
   System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) +472
   System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
   System.Data.SqlClient.SqlConnection.Open() +384
   sqlconnect.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\sqlconnect\webform1.aspx.cs:28
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +73

This is what i do

String strConnection ="server=FRANK\\NETSDK;database=northwind;integrat ed security=true";
               SqlConnection objConnection = new SqlConnection(strConnection);
 objConnection.Open
objConnection.Close

Does anyone have suggestions on how to connect to MSDE(microsoft sql 2000)

Or would anyone have the database Bids that is used in chapter 12
of the book written in an Access file.

Thanks

Hi Frank,

This problem is caused by the fact that the ASP.NET account does not have permissions to access the database.

There are a few ways to solve this:

1. Don't use Integrated Security, but SQL Server authentication instead. At installation time, you had to supply a password for the SA account, so you can use that (not recommended on a production server). Take a look here for the right connection string, under Standard Security.

2. Use the Enterprise Manager for SQL Server to manage your MSDE database. Then you're able to add the ASPNET account to the database you're using. The Enterprise Manager (EM) does not come with the MSDE, but it does come with a trial version of SQL Server. I am not 100% sure, but I believe that there is no expiry date for the EM. This means you can still use it to manage MSDE databases, even after SQL Server has expired. I am not an expert on licenses, so this may violate your license agreement with Microsoft. Check first!

3. Use command line tools or Stored Procedures to add your users to your database and give them the necessary rights. This is a bit tricky at first, but it can be useful knowledge. Take a look at System Stored Procedures like sp_grantdbaccess in the SQL Server books online.

HtH,

Imar


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