Change default path & db in Sql server

What do you mean path & db?  Do you mean the default path where databases will be created and the default Db for a user?

To change the default Db for a user:

ALTER LOGIN TheLoginName
WITH DEFAULT_DATABASE = TheDbName

I have db connect to Visual web developer 2005 express with the connection
Data Source=.\SQLEXPRESS;
AttachDbFilename=D:\ExcelAppl\WizPlan.Web\App_Data\WizPlan.V5.mdf;
Integrated Security=True;
User Instance=True

When I try to run SP from  the sub below, I have connection failure on connection open

Protected Sub DropDownList5_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)

Dim ConnString As String = "Provider=SQLOLEDB;
                                             Data Source=LepTop-3\SQLEXPRESS;
                                            AttachDbFilename=D:\ExcelAppl\WizPlan.Web\App_Data\WizPlan.V5.mdf;
                                            Integrated Security=SSPI;
                                            User Instance=True"
                     
Dim sqlConnection1 As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(ConnString)
               
Dim cmd As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand("SPweb_Load_results", sqlConnection1)

cmd.CommandText = "SPweb_Load_results"
cmd.CommandType = Data.CommandType.StoredProcedure
cmd.Connection = sqlConnection1
sqlConnection1.Open()
cmd.Parameters.Add("@prm", 3)
cmd.ExecuteNonQuery()
sqlConnection1.Close()
End Sub

when I use the connection string below, it run ok but it point to other db in
 ---> D:\ExcelAppl\WizPlan\App_Data\WizPlan.v6.mdf

        ConnString = ConnString & "Provider=SQLOLEDB;"
        ConnString = ConnString & "Data Source=LepTop-3\SQLEXPRESS;"
        ConnString = ConnString & "Initial Catalog=WizPlan;"
        ConnString = ConnString & "Integrated Security=SSPI;"
        ConnString = ConnString & "Connect Timeout=30;"
        ConnString = ConnString & "User Instance=false;"
pls advise?
Thanks

You can associate the Default Database and Path for the user associated with:

Go to security --> Users and select the particular user used for that particular application.

Set the default database for the particular user and I hope this resolves your issue.

Hi BrandonGalderisi's
This is the err, I get with the new connection string
Unable to open the physical file "D:\ExcelAppl\WizPlan.Web\App_Data\WizPlan.V5.mdf". Operating system error 32: "32(error not found)".
Ygnd

The problem, not solved.
I will work on it later.
Thanks

Interesting. Seems that the database name is "Wizplan" in the instance LepTop-3\SQLEXPRESS;"  at least that is what is seems to be to get V6 - what is the difference between V6 and V5 and how do the databases appear in SSMS ?

Gosh, that was quick to accept... Especially when problem was not solved ;)

Hi mark,
Thank you for your comment.
The question closed because technical problem with the sql setup.
I will rase it again after fixing problems & I will be glad to get your help, too.
Thanks
Ygnd