Databases
StackOverflow2013
Postsdbo
POConnect to SQL Server 2008 Database via C#
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConnect to SQL Server 2008 Database via C#
    primarykey
    data
    text
    <p>I am attempting to connect to a database I created in SQL Server 2008 on my computer. I have a Windows Authentication login which looks like this:</p> <pre><code>try { string sCon = @"Data Source=David-PC\SQLEXPRESS; Initial Catalog=ZarTrackDB; Integrated Security = true"; SqlConnection dbConn; dbConn = new SqlConnection(sCon); dbConn.Open(); } catch (Exception ex) { MessageBox.Show(this, "An error occurd while attemtpting to connect to DB.\n" + ex.Message, "DB Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } </code></pre> <p>however it keeps throwing an exception:</p> <blockquote> <p>Login failed for user David-PC\David</p> </blockquote> <p>I am able to connect to the Master DB though:</p> <pre><code> string sCon = @"Data Source=David-PC\SQLEXPRESS; Initial Catalog=Master; Integrated Security = true"; </code></pre> <p>So i guess the probelm might be I do not have permissions? How do I go about giving myslef permissions to access this DB though when I login via SQL Server Management Studio I can insert create query etc on the ZarTrackDB perfectly.</p> <p>I truly dont know what to do anymore please help!</p> <p>EDIT:</p> <p>here is a screen shot of my user mappings for the account I am trying to log in with:</p> <p><strong>User Mappings:</strong></p> <p><img src="https://i.stack.imgur.com/pyVC7.png" alt="enter image description here"></p> <p><strong>Server Roles</strong>:</p> <p><img src="https://i.stack.imgur.com/Ua5NL.png" alt="enter image description here"></p> <p>UPDATE:</p> <p>If I login to master and attempt to access ZarTrack :</p> <pre><code> string sCon = @"Data Source=David-PC\SQLEXPRESS; Initial Catalog=Master; Integrated Security = true"; SqlConnection dbConn; dbConn = new SqlConnection(sCon); dbConn.Open(); string sql = "USE ZarTrackDB "+ "CREATE TABLE Customers ("+ "CustomerID int IDENTITY PRIMARY KEY NOT NULL," + "CompanyName varchar(30) NOT NULL,"+ "CompanyAddress varchar(40) NOT NULL,"+ "Email varchar(40) NOT NULL,"+ "PhoneNumber varchar(15) NOT NULL"+ ");"; SqlCommand dbCmd = new SqlCommand(); dbCmd.CommandText = sql; dbCmd.Connection = dbConn; dbCmd.ExecuteNonQuery(); </code></pre> <p>I get Exception:</p> <p><img src="https://i.stack.imgur.com/Rxlgn.png" alt="enter image description here"></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDavid Kroukamp
    1. USDavid Kroukamp
    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. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POConnect to SQL Server 2008 Database via C#
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POConnect to SQL Server 2008 Database via C#
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POConnect to SQL Server 2008 Database via C#
      1. This table or related slice is empty.
      1. VTModeratorReview
    1. COUse SQL Server Management Studio and look at the `Security` nodes for the database and server. Make sure there is a login and an associated User and that this user has the right permissions on the database.
      singulars
      1. POConnect to SQL Server 2008 Database via C#
      1. USOded
    2. CO@Oded Where are the security nodes for database and server ( I only see a secruirty tree that has Logins Server Roles etc)? Im sorry for sounding noob like. And how would I associate my current Login with the permissions needed?
      singulars
      1. POConnect to SQL Server 2008 Database via C#
      1. USDavid Kroukamp
    3. COhttp://msdn.microsoft.com/en-us/library/aa337552.aspx
      singulars
      1. POConnect to SQL Server 2008 Database via C#
      1. USOded
 

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