{"id":18985,"date":"2022-11-02T13:42:55","date_gmt":"2022-11-02T08:12:55","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/"},"modified":"2022-11-02T13:42:55","modified_gmt":"2022-11-02T08:12:55","slug":"solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/","title":{"rendered":"[Solved] can not connect to sql in C# visual studio can not login [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-56081963\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"56081963\" data-parentid=\"56081456\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>As others have said, it&#8217;s a little difficult to guess what your problem might be. It&#8217;s probable that you are using Windows Authentication, and you are running Visual Studio (and so your program when you hit f5) as the windows user &#8220;DESKTOP-FHI3&#8221;. If this is your problem, you could grant this user access to your database. <\/p>\n<p>If you do have the required access to the database you are trying to access as another user, you can connect and grant access to users by using the interface in SQL Server Management Studio, or Visual Studio&#8217;s SQL Server Object Explorer. You could also run a SQL script using one of these tools to do the same. For example the following script would grant a windows user, DESKTOP-FH13 db_owner level access to your database.<\/p>\n<pre><code>USE [master]\nGO\nCREATE LOGIN [&lt;YourDomainName&gt;\\DESKTOP-FHI3] FROM WINDOWS WITH DEFAULT_DATABASE=[master]\nGO\nUSE &lt;YourDatabaseName&gt;\nGO\nCREATE USER [&lt;YourDomainName&gt;\\DESKTOP-FHI3] FOR LOGIN [&lt;YourDomainName&gt;\\DESKTOP-FHI3]\nGO\nUSE &lt;YourDatabaseName&gt;\nGO\nALTER ROLE [db_owner] ADD MEMBER [&lt;YourDomainName&gt;\\DESKTOP-FHI3]\nGO\n<\/code><\/pre>\n<p>An alternate solution would be to create a SQL User, and use that instead of using Windows Authentication. If you did this, you would also need to update your connection string, stating Integrated Security=FALSE, and adding &#8220;User ID=&#8230;;Password=&#8230;.&#8221;.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved can not connect to sql in C# visual studio can not login [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] As others have said, it&#8217;s a little difficult to guess what your problem might be. It&#8217;s probable that you are using Windows Authentication, and you are running Visual Studio (and so your program when you hit f5) as the windows user &#8220;DESKTOP-FHI3&#8221;. If this is your problem, you could grant this user access to &#8230; <a title=\"[Solved] can not connect to sql in C# visual studio can not login [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/\" aria-label=\"More on [Solved] can not connect to sql in C# visual studio can not login [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[324],"class_list":["post-18985","post","type-post","status-publish","format-standard","hentry","category-solved","tag-c"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] can not connect to sql in C# visual studio can not login [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] can not connect to sql in C# visual studio can not login [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] As others have said, it&#8217;s a little difficult to guess what your problem might be. It&#8217;s probable that you are using Windows Authentication, and you are running Visual Studio (and so your program when you hit f5) as the windows user &#8220;DESKTOP-FHI3&#8221;. If this is your problem, you could grant this user access to ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-02T08:12:55+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] can not connect to sql in C# visual studio can not login [closed]\",\"datePublished\":\"2022-11-02T08:12:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/\"},\"wordCount\":205,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"c++\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/\",\"name\":\"[Solved] can not connect to sql in C# visual studio can not login [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-02T08:12:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] can not connect to sql in C# visual studio can not login [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] can not connect to sql in C# visual studio can not login [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] can not connect to sql in C# visual studio can not login [closed] - JassWeb","og_description":"[ad_1] As others have said, it&#8217;s a little difficult to guess what your problem might be. It&#8217;s probable that you are using Windows Authentication, and you are running Visual Studio (and so your program when you hit f5) as the windows user &#8220;DESKTOP-FHI3&#8221;. If this is your problem, you could grant this user access to ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/","og_site_name":"JassWeb","article_published_time":"2022-11-02T08:12:55+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] can not connect to sql in C# visual studio can not login [closed]","datePublished":"2022-11-02T08:12:55+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/"},"wordCount":205,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["c++"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/","name":"[Solved] can not connect to sql in C# visual studio can not login [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-02T08:12:55+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-can-not-connect-to-sql-in-c-visual-studio-can-not-login-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] can not connect to sql in C# visual studio can not login [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/18985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=18985"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/18985\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=18985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=18985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=18985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}