View Single Post
  #6 (permalink)  
Old October 21st, 2006, 03:11 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,038, Level: 100
Points: 72,038, Level: 100 Points: 72,038, Level: 100 Points: 72,038, Level: 100
Activity: 50%
Activity: 50% Activity: 50% Activity: 50%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,080
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi VictorVictor,

I don't think the URL has anything to do with this. It looks like a configuration /security issue to me.

If you want to use SQL Server Express, why don't you just add a database to the App_Data folder and then use a connectionstring like this:
Code:
<connectionStrings>
  <add name="YourName" connectionString="Data Source=(local)\SqlExpress;
    AttachDbFilename=|DataDirectory|\YourDatabase.mdf;Integrated Security=True;
    User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings>
That should work much better than trying to set up SA accounts on the database.

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.