Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Try just;</p> <pre><code>"data source=.\\SQLEXPRESS;Integrated Security=SSPI;initial catalog=DomainTable" </code></pre> <p>I believe the user name / password are generally only required for remote connections, and you must set them up for the specified DB. The above connection string should get you going on the running instance of sqlexpress on the local machine if you have not made login credentials required.</p> <p><strong>Edit</strong></p> <p>If you are using IIS to host, here is a chunk from a recent article I did for deploying and setting up App pools to work with SQL Express 2008. Even if you are not using IIS, you will still need to do something like this to get your hosting environment set up correctly with SQL Server.</p> <p><strong>Step 1 Create a DB Logon for the IIS USER</strong></p> <p>In the security section in MS SQL SERVER, need to right click users and your IIS APPPOOL(IIS APPPOOL\apppoolname, created in Section one, Step 2).Check out dp.'s answer here for more step by steps - <a href="https://stackoverflow.com/questions/1933134/add-iis-7-apppool-identities-as-sql-server-logons">Add IIS 7 AppPool Identities as SQL Server Logons</a> </p> <p><strong>Step 2 Setting Permissions for the IIS USER on the db</strong></p> <p>Right click on the database name, and click properties. In permissions section add your APPPOOL user that you just created, be sure to give him the Execute \Select permissions needed .</p> <p>Note: Website1 needs Execute, Select, Delete, Insert permissions as well. Website2 is also using this app pool which it shouldnt be because we dont not need to alow the user to have that kind of functionality from within the trimdynamics application. We could seperate the app pools so that our trim dynamics IIS USRS is only getting Execute and Select permissions.</p> <p>If this does not help, it is hard to tell whats really going on without concrete knowledge of your hosting structure, as there are lot's of gotch-ya's when deploying from development to production environment :(</p>
    singulars
    1. This table or related slice is empty.
    1. POUnable to connect to SQL Server 2008 in .Net
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USclamchoda
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COsorry chris i tried this also but it is not working :(
      singulars
      1. PO
      1. USPirate
    2. CO@Pirate DEFINE "not working" please. e.g. add the ***actual error message*** to your question!
      singulars
      1. PO
      1. USAaron Bertrand
    3. CO@Pirate just noticed you deployed it on your development server. This causes a lot of headaches your first time through. You have to think of it like this - Now IIS / some services is hosting your website, not your local machine, things are a little different. In your development environment, everything works fine because your executing queries as the current user, which has privileges. When you host your application, for instance in IIS, you know have an IIS Pool rying to execute the queries on your db, which does not automatically have permissions. Are you receiving User permission erro
      singulars
      1. PO
      1. USclamchoda
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload