Last post Mar 06, 2007 07:41 AM by bisli777
Nov 22, 2006 04:31 AM|Joost Verdaasdonk|LINK
Hi all, [cool]
Today I've installed and tested Blinq for the first time (after seeing some great videos of the product)
From the command line I've issued the following statement:
Blinq /t:C\Inetpub\wwwroot\myblinqdemo /server:.SQLExpress /database:Northwind /vdir:MyBlinqDemo
All compiled very well but the website wasn't loaded. After some examination of the IIS properties of the Virtual Directory I figured I should use the 2.0 framework in the ASP.net tab.
After changing this the Site loaded correctly and I had the layout I'd expected from the webcasts I've seen on it! BTW Great Job!!!... all looks very nice.
On the page I pushed on the first link Customers to go to the customers.aspx file.
Here my problems start. I receive an error saying:
Server Error in '/MyBlinqDemo' Application.
Cannot open database "Northwind" requested by the login. The login failed.
Login failed for user 'IBM-LAPTOP\ASPNET'.
So I guess I have a credentials issue over here?
I can access the Northwind Db easily from VWD Express and from within the Management tool for SQLExpress so I presume these apps use different credentials then IIS?
In the web.Config file I have the following connectionstring to access the db:
connectionString="Data Source=.\SQLExpress;Initial Catalog=Northwind;Integrated Security=True"
The question of course is how can I change the connectionstring to access the db and Fullfile the Blinq experience by being able to browse a bit further in that great little website it compiled.[;)]
Or perhaps I'm able to add a user to the db so that the integrated windows security feature of IIS will work by default on compiling a site with Blinq? (just guessing sollutions over here not knowing how
Thanks in advance for helping me connecting the site to the db.
Greetings from Holland!
Nov 22, 2006 02:20 PM|phuff|LINK
By specifying 'Integrated Security=true" on the connection string, you're telling the connection to use the current identity to access the database. Therefore, the identity that ASP.NET is running under is the identity that is being used to access data.
Unfortunately, that identity (IBM-LAPTOP\ASPNET) doesn't have access to your database.
You can get around this 2 ways:
There's lots of information about security in ASP.NET available on MSDN. It's a big subject, but my guess is that the first method is probably the right way for you.
Hope this helps...
Nov 23, 2006 01:40 PM|Joost Verdaasdonk|LINK
Hi Polita, [:)]
Thank you very much that was very educational! Your app runs great now.
Both answers provided a workable sollution. And I will invest the both in more detail later when I need them to be more sollid.
Mar 06, 2007 07:41 AM|bisli777|LINK
phuff thx alot!! :)
you very help me