i have installed sql server express using windows authentication mode,but i have a doubt if we want to acces the data from front end we type like uid="",pwd="",servername="" but when using windows auth what credentials we have to give or there is no need of any details?
View 3 Repliesim using windows 7 home premium-64 bit,when i want to install sql server its not asking for mixed mode its directly creating windows authentication mode but i want to use sql server authentication mode,when im installing im unable to see any mode selection?
View 4 RepliesI used that Microsoft Windows installer and installed visual web developer 2008 express and sql server 2008 so I thought. visual web developer works find.
When I look at sql server 2008 all I see is import export data link.
and the configuration tools.
In the configuration tools I see the following:
sql server configuration manager.
sql server error and usage reporting
sql server installation center.
So I figure sql server 2008 was not fully installed.d
I open the installation center and went to system configuration checker but I get a dialog
box that say browse for sql server 2008 installation media.
I have vs2008 . I wat sql server and management tools .
I uninstalled all previous sql 2005 stuff and downloaded SQLEXPRWT_x86_ENU.exe for sql server express 2008.
I followed the instructions from below.
[URL]
I got an error on install when it claims I have a previous ver of vs2008 and need to install sp1 which I have. After installing sp1 I still get same error.
I had a problem login management studio (Sql server 2005) using windows authentication because it doesn't show me any server name to connect and if I put my computer name and user name (my-PCpatel) login was failed.
So, I decided to uninstall it and install it again using mixed mode authentication. After installation I select sql server authentication instead of windows authentication and put login name as "sa" and password that I had put it during installation. But the connect button is dark gray(the way I can not select it or press it on) while the other button (cancel, help, option) can be selected or pressed.So, why am i not able select or click on connect button?
This may seem simple but for some reason I am having a problem.
I am trying to install SQL Server Express 2005 on Windows XP Service Pack 2 which has not been online for a while.
Everytime I've tried it has told me that it doesn't meet the minimum requirements. I am not sure if its because I am sick and dazed out.
Can SQL Server 2010 Express Edition install on Windows 7 Home Basic Edition?
Any official links of microsoft website which states that are great.
I wanted my local iis running application to connect my database in sql authentication mode rather than windows mode,
but it is showing errors of " Cannot open database "aspnetdb" requested by the login. The login failed.
Login failed for user 'DBUser'. ". i also ublocked port from firewall,and allowed remote connection of mssql from sql manager, enabled TCP/IP and named piped protocols from SQL surface config, and with sql manager i also changed server authentication mode to sql from windows.
my datastring is <add connectionString="Data Source=PARTHIV-PCSQLEXPRESS;Initial Catalog=aspnetdb;User ID=******;Password=******/" name="LocalSqlServer" providerName="System.Data.SqlClient" />
i made a user named DBUser in database as well i don't understand where it gone wrong ???
here is error log
[Code]....
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 RepliesIs SQL Server Express supported in Windows 7 Starter edition?
View 3 RepliesI have been trying to avoid the windows login userid and password window when I use the Windows Authentication mode for a web site. I need to capture the the windows logon user name without prompting for the user id and password and display that on the web site. I had tried almost everything... changed authentication,security setups on IE and IIS etc... still not being able to avoid the window...
View 1 RepliesI am testing with windows authentication and a local express DB. My DB has users and roles tables. Following link explains this concept:[URL]
Code:
[HandleError]
public class HomeController : Controller
{
public ActionResult Index()
{
return View();
}
[Authorize(Roles = "Managers")]
public ActionResult CompanySecrets()
{
return View();
}
[Authorize(Users="redmond\swalther")]
public ActionResult StephenSecrets()
{
return View();
}
}
Above roles are coming from NTLM. Is there a way where i can map roles in my DB table so that these are then available to me like User.IsInRoles("Admin") etc?
install Visual Studio 2010 (with ASP.net framework 4.0) and when I try to install SQL Server Express 2008 I get an error message telling me that .NET framework 3.5 SP1 is required.I know in the installation of VS 2010 SQL Server Express is installed. However I need to have the management studio install. I have tried installing both the full version of SQL Server Express 2008 and the front end management studio for SQL Server 2008nly.
View 2 RepliesI have SQL server management studio express install on one machine.
I am able to connect to that machine or able to ping that machine from my computer.
I have code which return me the SQL server instances on same network. Using that I am able to get that SQL server instance. I have configured SQL express to access remote connection. i.e.
Configured SQL express to accept named / TCP IP instance connection. Started Browser service.
My machine settings My machine has been configured to set dynamic IP address using DHCP protocol
When I am trying to connect to above mentioned SQL server I am getting error that "Failed to connect SERVER NAME\SQLEXPRESS".
But if I configured my machine with manual IP address and default gateway I am able to connect to same SQL server.
I got the solution to connect to that server but I don't know why I am facing such problem. And also let me know that is the solution I am using is correct or not?
my system i am having sql server 2005 standard edition.now i installed sql server 2008 r2 express edition and i am getting error like.."the service did not respond to the start or contorl request in a timely fashion"...
is it possible to install sql server 2008 r2 express edition in a system where sql server 2005 standard edition is already installed?
Microsoft Visual Studio 2010 was being used along with SQL Express for website development on the Operating System, Windows Server 2008 R2 Enterprise Edition of Intel Xeon CPU @ 2.13 GHz (2 Processors) containing 12 GB RAM with 64-bit Operating System. Website was developed along with the databases of SQL Express with the help of Visual Studio. Whether the developed website along with the databases may be used on the Operating System, Windows 7 of 64-bit? The website will used within Intranet. Which Operating System and configuration to be used for the Intranet Website?
View 1 RepliesJust 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?
I follow the instruction of installing a new feature with the application SQLManagementStudio_x86_ENU.exe and I get to a fail telling me that VS 2008 needs to be upgraded to SP1.
This I have done several times with the final message saying successfully installed yet 'About' shows only
Microsoft Visual Studio 2008
Currently I'm in the process of deploying my ASP.net MVC 2 project on a Windows Server 2008 R2 web server. This web server already has the .net 4 Framework installed, but doesn't have any MVC dll's in the GAC.
So deployment on IIS succeeds, but when I start up the web application in the browser, it results in this message:
Could not load file or assembly 'System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
Of course I can Google myself too and it mainly:
Copying the MVC dll's (System.Web.Mvc.dll, .Routing.dll, etc) to the output directory;
Downloading an RTM version of ASP.net MVC 2 on top of .net 3.5 Framework. Neither of them I'd like to do. I just want to install ASP.net MVC 2 to the GAC of my web server. So my question is:
Which installation does actually contain ASP.net MVC 2 for installation on top of .net 4?
How to find which version of the Sql Server install into your system,I am running Windows Vista Home Premium(32 bit operating system) , when I try to install Sql Server 2005 Stand edition on my laptop ,it's shows some compatibility issue.
View 6 RepliesI 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".
I am getting ready to move my 1st website to iis on WinServ 2008.
I am reading ASP.net 3.5 book and says that iis doesnt ship with .net framework 3.5 How do i find out if 3.5 is installed and if not how do i install?
My pc running win7, vs2012 with crystal report and framework4.5
How to create a install exe file to deploy app to web server? (windows 2012)?
I have 15 .dtsx files that were edited in SQL Server 2008 BUi and I need to deploy them all to dev server that has SQL Server 2008?
How do I go about deploying all 15 at the same time?
I am getting this error when trying to connect a database from another computer in my home network:
System.Data.SqlClient.SqlException : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
this database is using windows authentication. sqlserver 2008.
What is the connectionstring that I need to use in order to get the database?