Visual Studio :: Add Connection / Use SQL Server Authentication - Fails On Windows 7 Pro
May 5, 2010
I'm using VS 2010 RTM and SQL Server 2008 on my clean development laptop, running Windows 7 Pro.
Using Visual Studio's Server Explorer, I can easily do an Add Connection by simply right-clicking, and then completing the dialog, and choosing "Use Windows Authentication". I can then click the button "Test Connection".
However, if I wish to do an Add Connection, and then choose "Use SQL Server Authentication", I get a message "Login failed for user 'appSlir'", as shown here:
When I try the same thing on my other development machine, which is VS 2008, SQL Server 2008, and Windows XP Pro, it works fine.
There seems to be a problem/bug that prevents Add Connection with "Use SQL Server Authentication" to SQL Server 2008, when running on Windows 7 Pro.
View 5 Replies
Similar Messages:
Mar 29, 2011
I have a web application (intranet based) which uses Windows Authentication. Unfortunately there are public computers that have public logins at some company locations. My web app doesn't support these public logins because I need to know the user workingSo, even though these public users are windows authentication users, my app will fail because I have no user account setup for that particular account. I want to then try Active Directory Authentication.In my Default.aspx.cs I'd have something like this
protected void Page_Load(object sender, EventArgs e)
{try
userContext = new UserContext(); // If the authenticated user isn't a user in my system then throw an exception
}
[code]...
View 2 Replies
Sep 30, 2010
I have VS 2010 professional. I am trying to open "ASP.Net Configuration" through Project -> ASP.Net Configuration.
It pops up the Notification about the ASP.Net Development Server localhost but doesn't open ASP.Net Configuration in the default browser.I clicked on the Root Url (by double clicking on the 'development server' at the right bottom from Notification Manager).
It throws following error
"An error was encountered. Please return to the previous page and try again."
Clicking on "How do i use this tool".It opened page with error.
Tool Has Timed Out
View 2 Replies
Aug 31, 2010
I have a requirement I should connect to MS SQL server under IIS Application pool account from ASP.NET application where Windows Authentication is enabled. I cannot use user name and password in connection string.
ASP.NET application should use Entity Framework 4.0 to work with data.
View 1 Replies
Feb 22, 2010
installing visual studio 2010 pro RC in windows Xp SP3 and getting a message prompt : invalid windows installer package contact vendorlog file says
Error Message:
[02/22/10,17:09:07] Microsoft Application Error Reporting: [2] CMsiComponent::Install() expects the setup file for Microsoft Application Error Reporting, but the file failed verification.
[02/22/10,17:09:07] setup.exe: [2] ISetupComponent::Pre/Post/Install() failed in ISetupManager::InternalInstallManager() with HRESULT -2147467259.
[02/22/10,17:09:08] VS70pgui: [2] DepCheck indicates Microsoft Application Error Reporting is not installed.
View 5 Replies
Sep 13, 2010
I'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
View 3 Replies
Oct 18, 2010
Just to describe the scenario. I have a website. This lives on a webserver. On that webserver is an SQL server. The website connects to this database using windows authentication. I have written a windows form application that connects to the SQL Server on the webserver. This application is being run from a location on out intranet. The Winform application use SQL authentication to connect to the database. The SQL Server didn't have mix mode authentication enabled. So I enabled it. The winform application could now connect to the SQL Server.
This is where it starts getting a little strange.
The Website that was already connecting find using integrated authentication starts failing with:
Login failed for user 'NT AUTHORITYNETWORK SERVICE'
When you are enabling mixed mode authentication, you are adding another authentication method, why would the original Windows authentication fail?
View 1 Replies
Jan 21, 2010
I dont know my server name, username or password and what do i put in the name section??
I am trying to create it for a data entry page.
View 2 Replies
May 15, 2010
I recently installed Windows 7 in my PC.I also insyalled Visual Studio 2005 in my system.
while creating web site throgh Visual Studio 2005 IDE , it is giving error that "The Web server does not appear to have the Front page server extensions Installed".
View 4 Replies
Jan 26, 2010
I have created a web app using Visual Studio 2008 Express Edition and have come to the point where I need to publish the site onto my server (which is running window server 2008). I found that the publish function is not limited in the express edition, so published the app to a local file and FTP'd the contents across to my server. I then setup a website through the servers IIS manage and pointed it to the folder containing the FTP'd files.
My question is, how do I run the app? Do I need to point to a specific file?
I have tried to view a number of the files in browser directly from the IIS but keep getting the same standard connection error i.e. "Internet Explorer cannot display the webpage"
I have never used IIS Manager before and I can't find a resource which gives me a step by step guide to setting up a new site which has been created by Visual Studio 2008 Express Edition, are there any config changes needed.
View 3 Replies
Jul 6, 2010
I have developed one software in C# and the database used is sql server 2005. I have completed the software but now I want to provide setup in a autorun CD to my customer. I have prepare setup but I am not able to deliver my database along with my .net code. What I want to do is when user will install my project on his computer using the CD I am suppose to provide, it should install SqlServer Enterprise edition and should use this database. It may means that, setup should create database on the user computer.
View 1 Replies
Nov 11, 2010
I'm trying to deploy my MVC 2.0 web application to a Windows 2003 server with IIS6, and can't find the means to do it. I read about clicking Build/Deploy, but I don't have this showing on my menu, and I have the professional version.
View 1 Replies
Jul 29, 2010
I'm writing an ASP.Net MVC intranet application which is accessed via handhelds and a range of browsers. My users all have AD accounts and have different permission to our SQL database views/procs depending on who they area. The database also uses CURRENT_USER for horizontal partitioning.
Because of the range of devices that need to access the application I can't rely on impersonation/delegation or the trusted subsystem. I want the user to simply input username and password (same as AD) when the above mechanisms fail.
Does anyone know how I can use AD username and password in a connection string to access the database without creating a set of SQL mirror accounts? I can't login with network service or a sql proxy account because the database needs to be user aware.
View 1 Replies
Feb 2, 2010
Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.
Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.
View 2 Replies
Feb 23, 2011
Is there anything special to do with Windows 2008 R2 Server and Visual Studio 2010 to get Oracle quereis to work? I have the same DB Connnection.string I have used before and it works. I am at a loss here.
View 6 Replies
Mar 4, 2010
I've got Visual Stuido 2008 Team Suite + Team Foundation Server + TFS Power Tools running on a Windows XP laptop. Everything uses Windows Authentication.A few weeks ago I changed my Windows password per company security policy. As soon as that happened, I started getting a problem working within TFS. I would be trying to check in or check out a file, or view the history of a file, and I would get the following error: "You are not authorized to access tfs.servername.com". Whenever I get that error, my Windows account has become locked and I need to call the helpdesk to get unlocked.
This issue happens intermittantly...I could be working fine in Visual Studio for several hours and then it'll happen. Sometimes it happens several times in a row - I'll get the account unlocked, and then the next time I try to do something in Visual Studio it locks again.I realize there are a host of ways an account can become locked - believe me, I've run them all out - I don't have any services running on my machine that are tied to my WIndows account, I wasn't logged in to another computer under my old password, I don't have any mapped drives that use my old password. I'm fairly sure there's something in VS or TFS that is causing it - I can work for days without getting into Visual Studio and I don't get the issue. I use SQL Sever 2005 Express, which also uses Windows Auth, and I have no problems. The lockouts only start when I'm doing something in VS.
View 5 Replies
Jan 8, 2010
I have just installed SQL Server 2005. I selected windows mode authentication. I am not able to login in management studion. Now, I want to use mixed and server authentication option inplace of windows authentication. so, would that be possible after installation.
View 2 Replies
Apr 28, 2010
When I am working on projects I like to take my files back and forth between two machines.The machine at my office is running Windows XP Pro 32-bit.My home pc is brand new and running Windows 7 64-bit.I have not yet installed Visual Studio 2008 on the new home pc.My projects usually consist of a web site in ASP.net and C# often with a SQL Server 2008 Express Edition database backend.I am using Visual Studio 2008 Standard Edition (yes, I know I need to upgrade soon).
Before I received the new computer I was simply copying what I did at one machine onto a USB drive, taking it the other machine and overwriting the files that were previously there. Is it feasible to continue moving project files back and forth between computers now that one machine is running a 32-bit OS and one is running a 64-bit OS?
View 1 Replies
Dec 31, 2010
fter upgrade to Visual Studio 2010 my web forms targeted to .NET Framework 3.5 that using master pages aren't correctly managed by designer.For example, master pages that contain a ValidationSummary produce an error in design mode in web form that is using that master page.To reproduce, create a new ASP.NET WebSite for the .NET Framework 3.5 and add a master page like this (headers omitted):
[Code]....
then create a new Web Form that use the previous master page and switch in design mode.
In my VS 2010 Pro I see this error when ValidationSummary is rendered: Error creating control ValidationSummary1 - Failed to create designer 'System.Web.UI.WebControls.ValidationSummary, System.Web, Version=4.0.0.0,...'
View 6 Replies
Apr 27, 2010
I have a Windows Server 2008 x64 to develop applications, I installed the remote debugger rdbgsetup_x64.exe from
http://www.microsoft.com/downloads/details.aspx?displaylang=es&FamilyID=440ec902-3260-4cdc-b11a-6a9070a2aaab (spanish) Run the setup wizard, use the LocalSystem user to run the service and allows any computer to connect to the debugger.The configuration of the firewall is off.The configuration of the firewall with advanced security is:
inactive domain profile
inactive private profile
Inactive Public Profile
I found that the w3wp worker process runs on 32 and msvsmon runs 64.Now the client is a Windows XP x32 with Visual Studio 2008 SP1.either constructing a web application to check the operation of the treatment and get the following error: Unable to start debugging on the web server. The web server does not support automatic attaching This is Most Likely Because the web site is using ASP.NET version 1.0 or 1.1. Upgrade the website to ASP.NET 2.0 or manually attach to the web server process using the 'Attach to process' dialog. "
View 1 Replies
Mar 21, 2011
I'm developing an ASP page and I noticed odd behaviour when I'm trying to step through server side call backs. Specifically some of the time, when I press F10 to execute the next statement the debugger acts like I pressed F5 to continue and takes off. Some of the time stepping works and some of the time it doens't. In addition, testing the same call back I can sometime step several times before it takes off and other times as soon as I click F10 it takes off. If I set explicit breakpoints it will always hit them but as I said, stepping often results in the debugger not stoping on the next statement.
I feel like I didn't have this earlier but I'm mystified as to why it is doing this
View 4 Replies
Apr 18, 2010
When I open an ASP.NET 3.5 project using VWD2010, I get a prompt error message,"The connection property in the web.config file is missing or incorrect.The connection string from the .dbml file has been used in its place."however, my project works successfully.
View 1 Replies
Mar 21, 2011
While running an app from the server where it is deployed the website works fine, however when trying to access it from a different machine(placed in same network), using the same credentials, it shows that I am not an authenticated user.
[code]....
View 13 Replies
Feb 14, 2011
I am trying to update NuGet Package Manager from ver.1.0.11220.104 to version 1.1.229.160 using the VS extension manager, but the install fails on VS2010 Ultimate Version 10.0.31118.1 SP1Rel because of a signiture mismatch; see error below.
[Code]....
View 7 Replies
Oct 6, 2010
I just started using VWD 2010 and I used Copy Web to upload the site to the server. However, whenever I try to upload a new version of a file that I've already uploaded, the upload fails, with this error in the log (as an example):
Copy from 'C:UsersLouDocumentsVisual Studio 2010WebSitesgenusus10 ools' to 'ftp://69.67.214.24/web/tools' started at 10/6/2010 4:00:33 PM.
View 4 Replies
