473,473 Members | 1,874 Online

Sign in
Join

Home Posts Topics Members FAQ

SQL sever 2005 express move windowns authentication choice to mixed authentication

I folks.

I Have installed sql server 2005 express and choosed windows
authentication on instalation, but i make a mistake and now i need
mixed authentication, how can i modify this whithout uninstall and
install again the application?

thanks for the help.

Aug 22 '07 #1

Subscribe Reply

2

2570

Marcin A. Guzowski

Fonseca wrote:

I folks.

I Have installed sql server 2005 express and choosed windows
authentication on instalation, but i make a mistake and now i need
mixed authentication, how can i modify this whithout uninstall and
install again the application?

thanks for the help.

Look there:
http://msdn2.microsoft.com/en-us/library/ms188670.aspx
--
Best regards,
Marcin Guzowski
http://guzowski.info

Aug 22 '07 #2

Erland Sommarskog

Fonseca (fo********@gmail.com) writes:

I Have installed sql server 2005 express and choosed windows
authentication on instalation, but i make a mistake and now i need
mixed authentication, how can i modify this whithout uninstall and
install again the application?

thanks for the help.

If you have not downloaded SQL Server Studio Management Express, do so,
and then open the server in Object Explorer. Select the Server itself
and choose Properties. You find the setting on the Securities tab. You
need to restart SQL Server for it to take effect.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Aug 22 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

Why choose SQL Express over Access?

by: ljh | last post by:

Why would you choose SQL Express (which requires an installed application to work) over the simplicity of an Access database which has no dependencies?

26 - Error Locating Server - VB Express to SQL 2005 Express

by: snowman | last post by:

I have vb and sql server express 2005 installed locally. I cannot add a data connection in vb express. I keep getting the error "An error has occured while establishing......26 - Error Locating...

Impossible to connect to SQL Server 2005 Express

by: Gabriel | last post by:

Hello, I installed SQL server 2005 SP1 on a Windows XP SP2 From Visual Studio, I'm trygin to create a connection to a database, but I receive this error but I'm creating the connection (I...

SQL Server Express Integration in VS 2005

by: pmclinn | last post by:

I have create some user accounts in a local SQL 2005 db, created by visual studio. I should note I'm developing on windows vista 64 bit ed. In order to get this database to work on my web server...

SQL server 2005 Express - Vista - Invalid object name '#spdbdesc'

by: ianforgroupuse | last post by:

I'm running Vista Business edition on 2005 Virtual PC. Installed SQL Server 2005 Express latest download, with instance of MSSQLSERVER and service accounts running under "NT AUTHORITY\SYSTEM"....

SQL Server 2005 Express Edition login problem when deploying a windows application

by: Preben Zacho | last post by:

Hi there The scenario I got is this: I have created a Windows application in VS and I want to deploy it to another machine running Windows Vista. Since I have no control over this other machine,...

Installing a database in SQL Express during VB app setup

by: Aussie Rules | last post by:

Hi, I have a vb.net application that uses a SQL Express database. The end user already has SQL Express setup on there server, but they have no skills at using it. Is there a way I can have my...

Linked Access DB to SQL 2005 Express

by: Realm Master | last post by:

I have a two computer workgroup. On my laptop I moved Access tables to SQL 2005Express and linked them. I use Access as the front end and everything works from the laptop. Both the access files...

Having a problem with connecting ASP with MSSQL SEVER 2005 EXPRESS EDITION

by: khalid galal | last post by:

Hi, i am having a problem with connecting ASP with MSSQL SEVER 2005 EXPRESS EDITION, i am writing ASP code using javascript. look at this peace of code: var myConnect = "Provider=SQLNCLI;Data...

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap

Advertise on Bytes
How to Post and Respond on Bytes
How to Promote and Link on Bytes
How to increase your Ranking on Bytes
Become a Recognized Expert on Bytes
Feedback Welcomed! Contact Us