How To Add A New .mdf With ONLY Sql Authentication In SQL Express?

Jan 29, 2006

Hi all.

I am going around in circles all day on this.

I have a clean new install of win XP SP2, VS 2005 Pro RTM,
and a NAMED instance of Sql Express with mixed authentication mode specified at setup.
The sa pw is 123456

I would have liked just SQL authentication but no such option.

I am trying to add a new mdf file. If I just use the "Add New Item" in VS web app project it just adds a new .mdf file with windows authentication tied to the current profile I am logged in the os with. I am trying to avoid that as this projects is to be zipped and downloaded as a sample app. I am also trying to avoid embedding an instance of SSE as the recipients of the zip file already have SSE running iwth thei VS IDE.

So most logical is to create the file with SQL authentication.
I have to do it by the Add Connection GUI

and for data source: "Microsoft SQL Server Database File (SqlClient) "

for data file name: C:WebSitesWebsite1App_DataMyDatabase1.mdf (not yet existing file)

Use SQl server authentication:

user: sa, password: 123456 (the ones specified at set up of the SSE)

I keep getting

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

I keep getting the same error no matter what username I use or password, the current login, etc. It just does not let me use sql authentication.

Please help anyone. This is a nightmare.

View 10 Replies


ADVERTISEMENT

SQL Sever 2005 Express Move Windowns Authentication Choice To Mixed Authentication

Aug 22, 2007

I folks.I Have installed sql server 2005 express and choosed windowsauthentication on instalation, but i make a mistake and now i needmixed authentication, how can i modify this whithout uninstall andinstall again the application?thanks for the help.

View 2 Replies View Related

SQL Authentication And SQL Express

May 24, 2005

(FYI - the Search box throws a scripting error when I type in it)

View 12 Replies View Related

SQL Express Authentication Error

Apr 2, 2007

Hi Everybody,
I'm very new to .NET programing and my database is SQL Express edition.i'm using Visual Studio 2005.i'm trying to execute a simple application that basically select data from a employees table and display it to label on a webpage. when i run the application i'm getting the following error and i don't know how to fix.i'm using windows integrated authentication to logon to SQLEXPRESS instance. and the service is by default running under NT AUTHORITYNetwork Service account.I'm try to use visual studio default web server not IIS webserver, so i think i don't need an ASPNET account.but i'm not sure.could anyone help please.
Cannot open database "Dorknozzle.mdf" requested by the login. The login failed.Login failed for user 'BOND
ed.
Source Error:




Line 12: Dim comm As New SqlCommand("select employeeid,name from employees", conn)
Line 13: 'open connection
Line 14: conn.Open()
Line 15: 'execute the command
Line 16: Dim reader As SqlDataReader = comm.ExecuteReader()
Source File: C:Documents and Settings
eddyMy DocumentsVisual Studio 2005WebSitesHelpdeskDefault2.aspx    Line: 14
 i got SQL Server Mangement Studio Express Installed to manage the server.please help me
 
regards
RED
 

View 10 Replies View Related

SQL Express --Windows Authentication Problems

Apr 6, 2006

We are using a client server setup.

In testing, several people are testing on laptops.

The database on SQL Server Express is local, on the laptop. So is the client applicatioon.
When they unplug from the Network, and go home to work, we get "Cannot Find Server" problems.

Why is this?
Windows Authenentication turns off? or is it the fact that TCP / IP is open?

What can we do?
If we use the SQL Server Authentication, it works.

If we shut down, plug into the network, restart, it works.

Could anyone please throw light on this?

Thanks in advance .
Jeeves

View 1 Replies View Related

SQL Server Express Authentication Mode Change

Jul 6, 2005

Does anyone know how to change the SQL Express authentication mode from Windows Authentication to Mixed Mode after it's already been installed?   

View 4 Replies View Related

Mssql 2005 Express Sever Authentication

Jun 1, 2008

I am new to mssql
I am not sure when I should use windows authentication and when to use sql server authentication
I set it to sql server installation when sql server was installed
I am using it right now on xp-pro platform on my home computer but I also have a website where I would like also to use it
right now I do not have problem accessing the server with windows authentication but I keep getting errors when I switch to sql server authentication
Your help is appreciated
Dory

View 5 Replies View Related

Installing SQL Express From Command Line AND SQL Authentication

Aug 8, 2007

Hello,

I'm installing SQL express from command line, and using something like that:

/qb INSTANCENAME="SQLEXPRESS" ADDLOCAL="All" SECURITYMODE="SQL" AGTACCOUNT="konrad" AGTPASSWORD="*******" SQLBROWSERACCOUNT="konrad" SQLBROWSERPASSWORD="*******" SQLACCOUNT="konrad" SQLPASSWORD="*******" SAPWD="********"

but after installation process security mode is still set to windows authorization
I realy don't know what is wrong

View 4 Replies View Related

How Can I Get Connected To SQL Management Express Using Windows Authentication

Oct 19, 2007



im using windows xp pc, im new to SQL could any one provide details about how can i get connected to SQL management express using windows authentication,Im getting error CANNOT ABLE TO CONNECT TO SERVER...

View 5 Replies View Related

How Can I Get Connected To SQL Management Express Using Windows Authentication

Oct 19, 2007

im using windows xp pc, im new to SQL could any one provide details about how can i get connected to SQL management express using windows authentication,Im getting error CANNOT ABLE TO CONNECT TO SERVER...

View 1 Replies View Related

SQL Server Express Authentication Mode Greyed Out

Jul 12, 2006

Having problems connecting to SQL Server Express using 'sa' account and having read threds re problem and MS, advice is that Authenticaion mode needs to be set to both Windows and SQL. I have studio express installed and go to Security from the properties of the Server to change this option to use both authentication modes, however the options are greyed out!

Can anyone advise pse.

And will amending this option help me to enable the sa login which is refused at the moment, error as follows:

Login failed for user 'sa'.The user is not associated with a trusted SQL Server connection

Thank you in advance

View 4 Replies View Related

ASP Authentication With SQL Server 2005 - Not Express, Permanent Change

May 8, 2006

Hi all,
I've read up on the fact that if you use SQL server 2005 instead of SQL express you need to change the connection string in web.config.
Is there anyway to make this default connection type, or do I have to do it for every website I create. i.e. is there a global file that this connection can be entered into. Then whenever I start a new website I don't have to put the string in.
Just me being lazy really. But it's nice to know if it's possible.
 
Many thanks
DrB2k2

View 2 Replies View Related

Who Is The Default Owner For Sql Express In Windows Authentication Mode?

Aug 1, 2007

If i create a database in sql express in windows authentication mode, the database owner is in the format of 'MACHINENAMEUSERNAME'. If i connect this database to iis server i got login failed error message.

This is my connection string in my web.config :
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=dbsgh;Data Source=software92sqlexpress


I solved this problem by creating a login in sqlexpress called 'software92/aspnet' and creating a user for my database named aspnet under 'software92/aspnet' login. Then i changed the usrename in directory security of my iis virtual directory to 'software92/aspnet'.
This solves my problem. But i think i m solving this problem in a wrong way.
I think i should create that database under default owner. Who is the default owner?

I dont know the correct procedure to solve this.
Please help.

View 1 Replies View Related

SQL Express Resetting To Windows Authentication Only After Power Failure

May 9, 2007

Has anyone else experienced SQL Express resetting to Windows Authentication only instead of mixed mode for logins after a power failure. I only noticed it happen today as we had 2 power outages in the office and it happened both times. If anyone has seen this happen or knows of a fix please let me know.

View 1 Replies View Related

Cannot Change Server Authentication In Management Studio Express

Jul 18, 2006

I use the Mangement Studio Express to manage a MSDE 2000 instance and notice that the Server authentication area in the Security is disabled for that instance. But for an Express instance, the Server authentication area is enabled. Is this difference caused by some settings?


Thanks,

Peter

View 4 Replies View Related

Uprgade MSDE 2000 To Sql Server Express - Authentication Issue

Aug 1, 2006

I am trying to do a unattended upgrade of an MSDE 2000 named instance, say MyInstance, to a SQl Server Express Advanced edition. The set up is Mixed Mode Authentication. ( I can't use Windows Authentication for business reasons).
The error I get is

SQL Server Setup Cannot Upgrade the specified instance by using SQL Server Creditial. You must use Windows Authentication creditial for the upgrade.
Details are as follows:
OS: Windows XP Prof (SP2).
Original install: MSDE 2000
Instance name: MyInstance
Authentication: SQL
Registry Entry: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMyInstanceMSSQLServer
Key LoginMode has a value of 2 ( corresponding to Mixed Mode Auth)

Upgrade attempted to: SQL Server Express Adv.
Command Line: start /wait setup.exe /qn LOGNAME=C:setup.cab /settings E:Sql2005SqlTemplate.ini

SqlTemplate.ini Contents:
[OPTIONS]
INSTANCENAME=MyInstance
SECURITYMODE=SQL
UPGRADE=SQL_Engine
UPGRADEUSER=sa
UPGRADEPWD=My$Password

The error I get in Summary.txt:
Machine : xxxxxXP
Product : SQL Server Database Services
Error : SQL Server Setup cannot upgrade the specified instance by using SQL Server credentials. You must use Windows Authentication credentials for the upgrade.

Can't I use SQL Authentication? I could not find a definitive answer on this one. Here's one thread that seem to indicate the same issue

http://groups.google.com/group/microsoft.public.sqlserver.msde/browse_thread/thread/90fb4b7182a55d54/f3128b447585f29d%23f3128b447585f29d

My questions:
- Can I use SQL Authentication?
- Where am I going wrong?
- I know the error message says to use Windows Authentication but I don't understand why I am I forced into using that.

Any insightsopinions will be highly appreciated. I am on the verge of a breakdown :(.

Best
LW.

View 2 Replies View Related

Urgent!: Upgade MSDE 2000 To Sql Server Express - Authentication Issue

Jul 31, 2006

I am trying to do a unattended upgrade of an MSDE 2000 named instance, say MyInstance, to a SQl Server Express Advanced edition. The set up is Mixed Mode Authentication. ( I can't use Windows Authentication for business reasons).
The error I get is

SQL Server Setup Cannot Upgrade the specified instance by using SQL Server
Creditial. You must use Windows Authentication creditial for the upgrade.

Details are as follows:
OS: Windows XP Prof (SP2).
Original install: MSDE 2000
Instance name: MyInstance
Authentication: SQL
Registry Entry: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMyInstanceMSSQLServer
Key LoginMode has a value of 2 ( corresponding to Mixed Mode Auth)

Upgrade attempted to: SQL Server Express Adv.
Command Line: start /wait setup.exe /qn LOGNAME=C:setup.cab /settings E:Sql2005SqlTemplate.ini

SqlTemplate.ini Contents:
[OPTIONS]
INSTANCENAME=MyInstance
SECURITYMODE=SQL
UPGRADE=SQL_Engine
UPGRADEUSER=sa
UPGRADEPWD=My$Password

The error I get in Summary.txt:
Machine : xxxxxXP
Product : SQL Server Database Services
Error : SQL Server Setup cannot upgrade the specified instance by using SQL Server credentials. You must use Windows Authentication credentials for the upgrade.


Can't I use SQL Authentication? I could not find a definitive answer on this one. Here's one thread that seem to indicate the same issue

http://groups.google.com/group/microsoft.public.sqlserver.msde/browse_thread/thread/90fb4b7182a55d54/f3128b447585f29d%23f3128b447585f29d

My questions:
- Can I use SQL Authentication?
- Where am I going wrong?
- I know the error message says to use Windows Authentication but I don't understand why I am I forced into using that.

Any insightsopinions will be highly appreciated.

Best
LW.

View 6 Replies View Related

Set Password To Database On SQL Server 2005 Express Running In Mixed Authentication Mode

Apr 20, 2006

Just like with Access DB, can we set password for database in SQL Server 2005 Express ?

Reason to do so is, user with Login having sysadmin previliage can acess all databases in SQL server.

so just want to restrict database access to only those users who knows the password.

Is there any possible solution ? Pls comment.

Thanks.

View 4 Replies View Related

How To Give Authentication For Send Mail Task Component? [not Default Windows Authentication]

May 11, 2007

How to give authentication for Send Mail Task component?

View 4 Replies View Related

Switching SQL 2005 Authentication Mode From Windows To SQL Authentication

Apr 18, 2007

Hi there,I have installed MS SQL Server 2005 on my machine with windows authentication. But now I want to switch the authentication mode to SQL Authentication. I am unable to switch, I can’t find the proper way to do so here in 2005.Could any one help me in doing this?Thank you,-Ahsan

View 1 Replies View Related

Sql Authentication = Fast./ Windows Authentication = V.slow!

Mar 25, 2004

Hello,

(Using win2k, sqlserver2k, framework 1.1)
I have an fairly data-heavy application that uses Windows authentication (Trusted connection/aspnet account) to connect to Sql Server. The site uses IIS basic authentication.

On the dev server everything works fine but when I move to the live server things get strange and it starts to crawl along. (Pages load OK but then it just crawls as it loads the datagrids etc. Sometimes it brings back incomplete/incorrect data )

BUT When I use Sql Authentication to connect to Sql Server and there is no problem at all!

Ok, there is something obviously wrong with the live server (which is identical setup to dev)but I dont know where to start.

Any ideas??

View 2 Replies View Related

Using SQL Authentication And Windows Integrated Authentication Concurrently

May 15, 2006

Hi all,

I've got two applications which both have a database on my MS SQL 2000 server. The problem is, one application must use Windows Integrated Authentication (which it is currently using and cannot be changed) whilst the other application which I'm trying to configure must use a SQL password.

Since the server has already been configured to use Windows Integrated Authentication for the existing database and application, how do I configure the other database to use the SQL password?

Thanks.

View 1 Replies View Related

Authentication An Application Using Windows Integrated Authentication

May 12, 2006

Hi all,

My work is using a shared application
which accesses a MSSQL 2000 database. To access the application, the
folder on the Windows 2003 Server is shared and users can access the
folder through a shared drive.


For the application to access the
database, it uses an ODBC connection to the MSSQL server which
originally used the SA password.


We have recently switched to using
Windows Integrated Authentication because we believe it offers a
higher level of security. However the only way in which we have been
able to enable this is to add the windows users to the SQL server.


The problem with this is that the
application sets permissions for individual users on what records
they can see within the database. We have found that by adding the
windows users to the SQL Server, they can bypass the permissions the
set by the application by simply using any application that can use
an ODBC connection, such as Enterprise Manager, and see all the
database.

One way around this would be to set up
domains of users with access privileges to the tables which reflect
the permissions set by the application, and configuring a view of the
data so they may only see the records that they have permissions to.
However to do this would require a high administrative cost to ensure
that changes made in the application are reflected in the privileges
of the SQL server.

Instead, is there a way the SQL server
can authenticate that the ODBC connection is coming from the correct
application using Windows Integrated Authentication?

This would allow the applcation to
determine security, and stop users from connecting to the SQL server
using other applications.

Alternatively, can the SQL server,
using Windows Integrated Authentication, also ask the application to
supply a username and password?

Any help with this matter would be
greatly appreciated.

Thanks!

View 4 Replies View Related

Switching From SQL Authentication To Integrated Authentication?

Aug 25, 2006

Hi,I'm using SQL Server 2005. My Connection String looks like that at the moment: <add name="LocalSqlServer" connectionString="Data Source=xx;Initial Catalog=xx;Persist Security Info=True;User ID=xx;Password=xx" providerName="System.Data.SqlClient"/>    Now I'd like to change this kind of authentication to Integrated Windows AuthenticationI added the WorkerProcess IIS_WPG to the permitted Users but it didn't help.Changed the Connection String to this:connectionString="Server=xx;Database=xx;Trusted_Connection=True;"All I'm getting is that my NetworkService is not permitted to access DB when I try to connect to the DB in ASP.NET.How can I properly configure that? Thanks!

View 4 Replies View Related

Difference Between Sql Authentication And Windows Authentication

May 8, 2003

Hello

Can anyone tell me what is the difference between sql authentication and windows authentication.

Examples of each would be very useful

Many thanks in advance

Steve

View 2 Replies View Related

SQL Server Authentication Vs Windows Authentication

Oct 16, 2006

Would anyone please help me out here. which of the 2 modes of authentication is better and why??

View 3 Replies View Related

Using Windows Authentication V/s Mixed Authentication

Dec 18, 2006

Hi,

Say, I have configured my SQL to use Mixed Authentication. Now, I have a applicaiton which uses my SQL Server. The application just creates a database in SQL Server and uses the database to store its information.

This application also has a SYSTEM DSN under ODBC through which it accesses the database. For the application to access this database, should I only use SA (as my SQL instance is configured to use Mixed Authentication) or can I use Windows Authentcation too...

If I should only use SA, do we have a documentation which talks about this.

Thanks
Santhosh

View 1 Replies View Related

Windows Authentication Vs SQL Server Authentication

Mar 12, 2008



For using different services of SQL SERVER 2005 which is better...
Windows Authentication or SQL Server Authentication?
what are the advantages and disadvantages of both?

View 5 Replies View Related

Report Manager With Forms Authentication. Report Server With Windows Authentication.

Feb 1, 2008

Hi.

I wonder if it is possible to set forms authentication for report manager but leave report server "as it is". I need to authenticate users from external LDAP and can't use windows authentication for report manager, but I would also like to leave report server open for anonymous users. In that way authenticated administrators could create reports which anonymous users could read.

I tested the Security Extension Sample and got it working when I rewrote the authentication part with my own LDAP authentication.

If I have understood correctly, the report manager is just application inside report server so is it possible to use forms authentication with one application but still leave the report server with Windows authentication?

View 1 Replies View Related

NT Authentication / SQl Server Authentication

Aug 14, 2001

Hi,

I need to figure out what kind of Authentication , I need to use for following applicaiton

Product : -

1 ) It resides on a its Domain and has access to Database on that Domain.
2 ) We have a application level login , n based on application login id
display specific pages.

The question that bother me is this

Q ) If i use NT authentication , then a user will be required to

a ) Login to domain (with userid and password) first and then

b ) Then i would require to again login to applicaiton with application
level login and password.(different levels of login as there)
Based on the application level login i will display only specific
asp pages. They have different access rights..and roles.

Requirment is to login only once..and it should authenticate to application display specific pages and authenticate to SQl server database also..

Is there any way thru which i can map my application level login to SQl server.. and what authentication should i use..

Thanks,
Teny

View 2 Replies View Related

Sql Authentication Vs. Windows Authentication

May 31, 2007

I am in the process of rolling out a sql server 2005 enterprise install and had a question regarding authentication. We will be providing sql hosting for a number of groups on our campus, many who are not using our campus-wide active directory, though they all have an AD account.

Windows authentication via the management studio appears to use your AD authentication tokens and will not allow them to enter a username/password combo. Is there any way to configure this?

I would like to use our campus AD for obvious reasons but if there is a requirement for passing tokens this isn't going to work right? It's also going to make database mirroring more of a challenge.

Thanks

View 3 Replies View Related

If All What I Used Is The Express Version - Is It Possible To Connect And Use The Sql.s Express Form The Vs. Express

Apr 14, 2008


Hello
I got a sql server express that i am trying to connect form win or web forms(2.0) €“ express as well.

My problem:
Can not connect to the server in any way!
Even the designer cont find any sql server on my machine; for example "the data source configuration manager" (gui) in enyn way its can not find the sql server express (2005)

So my question is:
if all what i used is the express version - is it possible to connect and use the sql.s express form the vs. express

View 10 Replies View Related

NT Authentication...

Jun 8, 2001

Hi all,
My SQL Server 7.0 is now running in a mixed mode authentication. I understand
that this method of authentication is not safe. So, Ive planned to change my
server's method of authentication from mixed to NT-only mode.
Kindly tell me what are the points I should consider for doing this, so that,
the existing data and the users are not affected.

Cheers and thanx in advance

Parasuraman

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved