General Sql Error Cannot Open Database Login Fails
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the cannot open database requested by the login sql server company Business Learn more about hiring developers or posting ads with us Stack Overflow cannot open database requested by the login visual studio Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 cannot open database requested by the login the login failed windows authentication million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Cannot open database “test” requested by the login. The login failed. Login failed for user 'xyz\ASPNET' up vote 31 cannot open database requested by the login. the login failed. clientconnectionid down vote favorite 3 I have created a webservice which is saving some data into to db. But i am getting this error Cannot open database "test" requested by the login. The login failed. Login failed for user 'xyz\ASPNET'. my connection string is add name="ConnectionString1" connectionString="Data Source=.\SQLExpress;Initial Catalog=IFItest;Integrated Security=True" providerName="System.Data.SqlClient" c# asp.net sql-server iis web-services share|improve this question edited Apr 4 '10 at 21:41 asked Apr 4 '10 at 21:11 coure2011 9,25144138243
Cannot Open Database Requested By The Login Entity Framework
We need a whole lot more information before we can help diagnose this. –sblom Apr 4 '10 at 21:17 add a comment| 12 Answers 12 active oldest votes up vote 20 down vote accepted Well, the error is pretty clear, no? You are trying to connect to your SQL Server with user "xyz/ASPNET" - that's the account your ASP.NET app is running under. This account is not allowed to connect to SQL Server - either create a login on SQL Server for that account, or then specify another valid SQL Server account in your connection string. Can you show us your connection string (by updating your original question)? UPDATE: Ok, you're using integrated Windows authentication --> you need to create a SQL Server login for "xyz\ASPNET" on your SQL Server - or change your connection string to something like: connectionString="Server=.\SQLExpress;Database=IFItest;User ID=xyz;pwd=top$secret" If you have a user "xyz" with a password of "top$secret" in your database. share|improve this answer edited Oct 11 at 13:59 bump 2,0811133 answered Apr 4 '10 at 21:16 marc_s 453k938651031 3 Not "is not allowed to connect to SQL Server", but "is not allowed to use database "test"". –wRAR Apr 5 '10 at 18:27 @wRAR: true - but I guess the chance the user login exists on the server,
360 games PC games
Cannot Open Database Requested By The Login The Login Failed Login Failed For User Iis Apppool
Windows games Windows phone games Entertainment All Entertainment cannot open database requested by the login sharepoint 2013 Movies & TV Music Business & Education Business Students & educators cannot open database requested by the login. the login failed java Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://stackoverflow.com/questions/2575907/cannot-open-database-test-requested-by-the-login-the-login-failed-login-fail Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/307864 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL http://www.sqlservercentral.com/Forums/Topic1423758-391-1.aspx Server 2008 » SQL Server 2008 - General » Cannot open database “” http://dba.stackexchange.com/questions/73030/cannot-open-database-user-auth-mdf-requested-by-the-login-the-login-failed-l requested by the... 11 posts,Page 1 of 212»» Cannot open database “” requested by the login. The login failed. Login failed for user 'sa' Rate Topic Display Mode Topic Options Author Message Coderx7Coderx7 Posted Monday, February 25, 2013 1:06 PM Grasshopper Group: General Forum Members Last Login: Sunday, January cannot open 18, 2015 1:19 AM Points: 10, Visits: 32 Hello I am trying to use SQL Authentication to connect to a database . I am having extreme difficulties and my searches so far couldn't help me solve the problem.I Enabled the SQL Authentication through SQL SERVER MANAGEMENT STUDIO and enabled sa and set a simple password for it.(under .\sqlexpress - i mean my server-name cannot open database is ). Now I can Successfully log in to the database by sa and its password from SQL SERVER MANAGEMENT STUDIO but when i try to do so from my application it fails with this error message :Cannot open database "dbNegin" requested by the login. The login failed. Login failed for user 'sa'.I need to say that i changed the database owner to sa as well, yet i get this error!!How can i solve this now? By the way this is the connection string used in my application to connect to the database : string sqlconstring = @"Data Source=.\sqlexpress;User ID=sa;Password=123456;Initial Catalog=dbNegin";My data base is attached by the way (its located in the address below ) " D:\TestDb\Debug\dbNegin.mdf"And this is the latest error log: quote:2013-02-25 21:51:18.59 spid51 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required. 2013-02-25 21:51:18.59 spid51 Using 'xpstar.dll' version '2007.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required. 2013-02-25 21:51:20.80 spid51 Starting up database 'C:\USERS\FRIEND\DESKTOP\RELEASE\DBNEGIN.MDF'. 2013-02-25 21:51:21.33 spid51 Starting up database 'mytestdb'. 2013-02-25 21:51:21.60
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Cannot open database “user_auth.mdf” requested by the login. The login failed. Login failed for user 'web_user' up vote 1 down vote favorite I am trying to deploy my first VB.NET application on GODADDY. I created a SQL server database and was able to create tables using SQL Server Management Studio. I created a user web_user and was able to login to the GODADDY database using that user. However when my website tries to connect with this database using the same user id and password, I get the following error: Cannot open database "user_auth.mdf" requested by the login. The login failed. Login failed for user 'web_user'. My connection string is mentioned below. It is similar to what was recommended by GODADDY: