Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mbegnu
Starting Member
2 Posts |
 Posted - 2007-09-06 : 10:58:48
|
| Hi, I developped an asp.net 2.0 application in which i had my own database and the aspnetdb database.I have created the two scripts for deploying the 2 databases.After deploying my website my 2 databases has been created without any problem.Now my problem is with the connection string.I use something like that :<add name="MyConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=myCat;User Id=username;password=pass" providerName="System.Data.SqlClient" />and im having the following problem:Cannot open user default database. Login failed.Login failed for user 'DELL4\ASPNET'.File activation failure. The physical file name "C:\inetpub\wwwroot\AssetRegister\App_Data\aspnetdb_log.ldf" may be incorrect. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.Login failed for user 'DELL4\ASPNET'.File activation failure. The physical file name "C:\inetpub\wwwroot\AssetRegister\App_Data\aspnetdb_log.ldf" may be incorrect.can someone help. I did try lof of things but it still not working |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-06 : 11:00:19
|
| Data Source=.\SQLEXPRESSmust contain the full sql server name that the db resides on.http://www.connectionstrings.com/?carrier=sqlserver2005_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
mbegnu
Starting Member
2 Posts |
|
|
|
|
|
connection string problem