Need Help With MSDE(anybody)

Hi





I have visual studio .net and i recently installed MSDE specific for visual studio.





The name of my server is FRANKNETSDK.





String strConnection ="server=FRANK\NETSDK;database=Northwind;integrated security=true";


SqlConnection objConnection = new SqlConnection(strConnection);


objConnection.Open();


objConnection.Close();





I created an instance which is NETSDK


I created a password


I don't know why my server choose the name FRANK i was expecting local.


I have to use FRANKNETSDK or else i can't get my server to Start.








This is the error: Login failed for user 'FRANKASPNET'.





[SqlException: Login failed for user 'FRANKASPNET'.]


System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474


System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372


System.Data.SqlClient.SqlConnection.Open() +384


sqlconnect.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootsqlconnectwebform1.aspx.cs:27


System.Web.UI.Control.OnLoad(EventArgs e) +67


System.Web.UI.Control.LoadRecursive() +35


System.Web.UI.Page.ProcessRequestMain() +731








Any help would greatly be appreciated.