.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to set only sql authentication?SQL Server authentication while attaching to another sql server?

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :ASP.Net

1. I have a SQL Server 2005 database file mdf and ldf file.
I have set sql authentication with username and password for the database.
If any body attach my databse file in their sql server, the database should not be open until the username and password which i have set is entered.
To do so , what i have to do ???
2. Even if the backup file is restored, it must check whether the username and password which i have set is matched for the database.
3. How to set only sql authentication? Windows authentication should be removed for a particular database.

1. I have a SQL Server 200

View Complete Post

More Related Resource Links

aspnet_regsql and using SQL server authentication

If Windows authentication is used in ASP.NET SQL Server Setup Wizard, database names can be retrieved, but if SQL Server authentication is used, the following error occurs:Failed to query a list of database names from the SQL server. Invalid object name 'sysdatabase'.In case you suspect the user name and passowrd are the fault, they are used in many other connections that are able to retrieve the list of database names. They can be used to continue the wizard to create a database. Could anyone shed some light on this?

How to impersonate a connection to SQL server under IIS app pool account if Windows Authentication i

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. Any ideas how to do it?    

ODBC connection to SQL Server 2005 Standard (on windows xp) with Windows authentication does NOT wor

I reviewed lots of postings, still could not find an answer. If I choose Windows authentication: - with TCP/IP and "Dynamically determine port" checked, I get the following error "The user is not associated with a trusted SQL Server connection; - with Named Pipes, Server Name & Pipe Name as "VSAXAONG", I get two errors, one after the other on the same pop-up:       Connection failed  SQL State 01000  SQL Server Error 1385 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] ConnectionOpen (Connect()).       Connection failed  SQL State 08001 SQL Server Error 17 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] SQL Server does not exist or access denied. If I choose SQL Server authentication and fill in the password - the ODBC connection works fine. I have to say that I created two different logins on the server, one for Windows authentication, and one for SQL Server authentication - both for the same Windows user name. I would appreciate any help I can get on this.  Thank you all in advance.

Using Windows Authentication for connecting sql server from web application using froms authenticati

Hi Experts, I have one web application which is configured to be use froms authentication. But, I don't want to use SQL Authentication to connect to SQL server, I want to use windows authentication. Can somebody plase give me detailed setps for how to implement this? Thanks for your help in advance. -Chintak. 

SharePoint - Report Server - Client Certificate authentication

Hi,I have a SharePoint site collection which requires client certificates. On the server I have configured Reporting Services in integration mode.I can call reports on other site collections which don't require client certificates but not on the site which does. On the site which requires client certificates the pages fail with the following error message:'An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with HTTP status 403: forbidden'The error message indicates that SharePoint doesn't call the web service with a client certificate. Does anyone know how I can configure SharePoint to use a client certificate?Any help is greatly appreciated.Adam

Unable to establish a secure connnction with server - ASP.NET AD Authentication.

Situation:IIS 6 installed on Vista (Virtual PC) not member of domain, Visual studio 2008 based website. Active Directory Membership configured in web.config.Trust level set to Full. Using Login control to authenticate.<membership defaultProvider="DomainLoginMembershipProvider"> <providers> <add name="DomainLoginMembershipProvider" type="System.Web.Security.ActiveDirectoryMembershipProvider, System.Web, Version=,Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="ADConnectionString" connectionUsername="test.bit.com\administrator" connectionPassword="myadminpassword"/> </providers><membership>Connection string is configured as following<connectionStrings> <add name="ADConnectionString" connectionString="LDAP://test.bit.com/CN=Users,DC=test,DC=bit,DC=com"/></connectionStringsEvery time after login it will state "Unable to establish a secure connnction with server"Thanks in advance for your time and support!

Client/Server Authentication

Dear All,   I have a client/server socket application that enables file transfer between the client and the server, however, i want the client to be authenticated with the server before a file is transferred. the client should prompt for a user name and password which is used for authentication with the server. The server should be configured with user name/password pairs so that it is able to authenticate client. I have been searching for related work for quite sometime now but haven't come across anything close to this yet. Please i want any1 to help me settle this issues, i would appreciate if i am directed to an article or any other resources that is helpful, or pasting sample code/ uploading sample application would be of greatest help..Thank you all in advance. Regards, Mbgreat.

SQL server authentication

while installing i only gave the windows authentication.now i want to add the SQL server authentication .how to add that to the existing server.

No support for SQL Server Authentication and SSIS !!!!

Hi I want to manage my servers from a central location and have the ability to manage my packges too.  Unfortunatley my servers are across domains which means I have to use SQL Server Login, which isn't a bad thing.  However for some bizzare reason I can't connect to Integration Services using this method, only windows authentication which is a complete pain in the butt from a management stand point as I have to copy packages to various servers rather than add them from a central point. Does anyone know if this bug/feature or what ever Microsoft is calling it will be fixed or know of any workarounds.  Thanks    

SQL Server Authentication Property

Is there a system table or view that contains the server authentication mode?  I would like to keep a history of changes to a SQL Server instance and this is one property I would like to include in the history.  I would like to retrieve the information from a table or view or function programmatically.

Client/Server Authentication with SSLStream

Hello, This is my first time using MSDN.  I have a client and server application which use SSLStream to communicate over port 80.  Both the client and the server are running as Windows Services.  Everything works in my test environment (my development computer, under the OS Windows 7 Ultimate). My problem is that when I go to deploy the client and server application to their deployment environments (the server being on Windows Server 2008, and the client being on Windows Server 2003) it does not work, and I get the error: "The client and server cannot communicate, because they do not possess a common algorithm" Please note that I have installed the same certificate using the makecert commands (listed in the "Firstly" section below) In addition, when I gave up on trying to get the client to authenticate under the Windows Server 2003 computer, I moved it to a completely new/different Windows Server 2008 computer.. and then got a new error along the lines of "credentials supplied to package not recognized." If you have any experience with this issue, please advise.  I have been working on this for the past 3 days and have burnt up over 20 hours of development time. Please remember, the problem keeps happening when the Server and Client attempt to authenticate. Firstly, I used the following commands via makece

ASP.NET Forms Authentication connecting to SQL Server with Windows Authentication

Hi everyone, I am not sure if this is the correct forum - apologies in advance - I could not identify where it should go! I have an ASP.NET Web Application that uses Forms Authentication using System.Web.Security.ActiveDirectoryMembershipProvider for signing on using Windows credentials.  This works nicely and is solid. The problem I have is connecting to SQL Server.  I need to be able to connect to SQL Server using Windows Authentication (trusted_connection=yes or Integrated Security=SSPI).  This is critical so I can record the user that created/last modified specific records and also to collect "Task-based" records that are relevant to the currently authenticated user. I have tried Google and a tonne of variations of web.config entries, using Win API to impersonate etc...  The only way that I could make it happen was to:- 1. Use the web.config entry:   (please entry at the bottom of the post.  For some reason it won't go into the right spot in this post!) 2. Log on specifically as the user specified in the above web.config entry.  If I log on as anyone else (ie Authenticate as anyone else), then SQL server simply gets the ASPNET service account as the Windows user. I have laboured over this for hours upon hours.  I really would appreciate some assistance. Thanks in Advance, Joe     "<identity

Changing SQL server Authentication method

Hi We have a SQL server (x64 standard) that is running with sharepoint on it.  Currently we have some custom s/w that need SQL server authentication also but our server is set to "window authentication mode" only.  Could someone please tell me if we can change the authentication method from "windows authentication mode" to "SQL server and Windows authentication mode" while sql is running.  Will they ask us to re-boot or it will take effect immediately?  thanks, Ted.  

how to change the web application Database connection form Windows authentication to SQL Server acco

Hi, I have a web application created and Database connection authentication was given as Windows authentication. how can i change it to a SQL server account in MOSS 2007. Thanks in advance.

Enabling Windows Authentication to SQL Server using Application Pool Credentials

I have created a WCF Service (VS2008), an application pool account which has the access to the SQL Server(in remote machine). Configured the App Pool account to the Virtual Directory in IIS (Version 6.0). Once I browse through the SVC file, I can see the WSDL file. I have the "Windows Authentication" and the 'Anonymous authentication" Checked in the Properties for the Virtual Directory. But when I access service through Client, I get "The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Negotiate,NTLM'.". Binding that is being used is HTTPBinding. I have set the Identity Impersonate to True as well. Bottom line is - I need to use the App Pool account to connect to the SQL Server. Could some one please help me in this?  

SQL Server 2008 Windows Authentication Mode fails for Database Engine, error 18456

I installed SQL Server 2008 Developer Edition (10.0.1600.22.080709-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).   Since this is a development machine, I saw no need for Mixed Mode when I did the install.  The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine!Windows Authentication for the Database Engine gives the following error: EventID: 18456Login failed for user MYDOMAIN\MYLOGIN'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.  Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode).  It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Before I do so, does anyone know of a better approach?Scott D Duncan

SQL Server SSRS 2008 R2 Authentication

We would like to expose SSRS 2008 R2 ReportServer to anonymous users and ReportManager to authenticated users via Forms Based Authentication. I tested a Security Extension in SSRS 2008 and it worked well. When I tried to deploy the same solution to SSRS 2008 R2, I am unable to browse to the reportserver and reportmanager screens. Is there a documented way to authenticate users in FBA when they want to access ReportManager and expose reports on the RepotsServer to anonymous users (or even authenticated users and pass a cookie to the reportserver). I do not want to use a windows user account if that is at all possible?   I followed the following to get it to work in SSRS 2008 : http://technet.microsoft.com/en-za/library/cc281383(en-us).aspx http://technet.microsoft.com/en-za/library/ms155029(en-us).aspx And I worked from the Microsoft Authentication Example project for SSRS. Regards, Pieter Theron    
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend