Rank: Seeker
Joined: 1/11/2012(UTC)
Posts: 10
|
Your docs state: Create a database and required SQL accounts used by the website (Network Service, IIS identity account, SQL user in Connection String) Can you explain this in detail? I've created lots of asp.net apps, and I have no idea what the above means. I've only ever had to create a database, generally add a login specific to the app, and put the connection string where the app can get to it. What do we have to do with Network Service and IIS identity for sueetie? Perhaps that's why my install isn't working. Thank you. Seth Edited by user Thursday, January 12, 2012 3:39:19 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Greenhorn
Joined: 1/4/2012(UTC)
Posts: 7
|
Hi
I have been stuck in the same situation as you.
It would be really appreciated if someone could go into more detail on this step.
|
|
|
|
|
|
Rank: Administration
Joined: 12/7/2008(UTC) Posts: 1,134   Thanks: 25 times
Was thanked: 53 time(s) in 53 post(s)
|
Hey Guys, This is outside the scope of Sueetie and there are a number of guides out there, but pictures are always best. I'm going to walk through two scenarios and include some. Let's start with the scenario of installing Sueetie on a Win7 machine, more specifically a laptop. We setup the site in IIS and use our user account for the IIS Application Pool. Attached is a screenshot (used in an earlier reply.) Now we create a database, on this particular machine it's "AtomoDB." If we look in the Security -> Users folder we see only the default SQL users. (attached screenshot) We're not even going to create a user here because "daveburke" has SQL Database Ownership through Windows Authentication. And finally, here's our Connection String indicating that we're using the IIS Identity User (daveburke.) Code:
There are other configuration options, of course. On your host site you'll no doubt create a SQL User Account and enter that user's Username and Password on the connection string. That connection string would look something like this.
[code=xml]
<connectionStrings>
<add name="SueetieConnectionString"
connectionString="Server=1.2.3.4;
Database=MyDatabase;Uid=SQLusername;Password=SQLpassword"
providerName="System.Data.SqlClient"/>
</connectionStrings>
The "Create a database and required SQL accounts used..." statement can seem a bit intimidating in its inclusiveness, I suppose. We should perhaps try to simplify that to remove the Fear Factor. Bottom line, if you use the first scenario for "AtomoDB" you're using the IIS Identity Account, otherwise you create a User in SQL Server and use that username and password on your Connection String and don't worry about the IIS Identity Account. Hope that helps, Dave Edited by user Thursday, January 12, 2012 8:37:34 AM(UTC)
| Reason: Not specified Dave Burke attached the following image(s):  setup0112a.png (50kb) downloaded 8 time(s). db0112b.png (22kb) downloaded 6 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Seeker
Joined: 1/11/2012(UTC)
Posts: 10
|
In other words, simply create a new database in SQL server and create an appropriate connection string for that database. That's what I did and it's not working. How do I troubleshoot it?
|
|
|
|
|
|
| Users browsing this topic |
|
Guest
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.