Allowing Administrators To Change SQL Server Connection?

Apr 7, 2010

What is your opinion on allowing administrators to update the SQL Server Connection string dynamically from the application versus just showing them the connection details in the application? Because the database connection is so important and on a heavily used system the abrupt change to the connection seems like it could cause problems. However I would think displaying the server and catalog and whether the connection is using SSPI or SQL Auth could be helpful for administrators who don't like playing with .NET config files.

View 4 Replies


Similar Messages:

SQL Server :: How Can Sysadmin Change The Connection Manager For A DTS Package

Nov 3, 2010

I am sysadmin user on a database server for SQL Server 2005.

I need to change the connection string that use 'sa' to another account. But I don't know how to change the data manager connection for the package 'XYZ'.

View 3 Replies

Web Forms :: Menu Control Not Allowing Data Source Change?

Apr 23, 2010

I have a ASp:Menu control in my Master Page . I want to change DataSource of my Asp:Menu on Login depending upon the role of the user (as if admin/user/staff etc) so when i tried to change the data source of asp:menu by

menu1.DataSource= ds_director;
menu1.DataBind();

it is giving error like u can't user two dataSources..

View 2 Replies

SQL Server :: Connection To Sql Server / Error "A Network-related Or Instance-specific Error Occurred While Establishing A Connection To SQL Server

Nov 23, 2010

I just installed sql server 2008 R2 on my computer. I am trying to connect to sql server throught my C# code and everytime I run the C# program,

I get this error "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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "

The connection string that I used in my web.config file is

[Code]....

I am not sure what am I doing wrong, but I followed this article below step by step and still I am getting the same error

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

My instance name is MSSQLSERVER and the server that I am using is on my local machine and it has my computer name in it.

View 10 Replies

Registration - Email Sent To Administrators For Activation

Jan 21, 2010

I found a tutorial on how to setup a user will be emailed an activation link when registering [URL]. What I want is modify it so that the email is sent to the administrators for activation.

View 9 Replies

Web Forms :: WebPart Feature For Administrators Only

Mar 5, 2010

I need to set the webpart to administrators only. How can I allow only shared scope. User scope is not allowed even for administrators.

View 1 Replies

Security :: Notify Administrators About New User Registration

Jan 29, 2010

I want to enable newly registered users on a site. I have figured out to put "DisableCreatedUser="True"" on the CreateUserWizard. What I have no idea about is how to have an email sent to the administrators email to notify them that a new user has registered.

View 1 Replies

Visual Studio :: Error Adding Connection In Server Explorer - Unable To Add Data Connection. ExecuteScalar Require

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

Access :: Change DSN Var Connection To DSN Less

Jan 17, 2011

I need help with changing this DSN to a DSN less var connection .whenever i use the dsnless connection i get an error since the String connTaftPrjPic is reused in the code.The Objective is to change to a DSN Less connection without affecting the connTaftPrjPic.

<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO" [code]....

View 2 Replies

ADO.NET :: Change Connection String Of EDM?

Mar 22, 2011

I have a entity data model generated from a database schema. Now that database is no more physically available, I want to generate a new database with the same schema model. I'm able to generate the tables from the script that the Entity Frame work generates for me.

I have two problems. I'm not able to generate the stored procedures from EDM. Second, I'm not able to change the connection string to the new database. Do I have to re-generate the edm from the new database that I'm trying to create?

View 1 Replies

How To Change Connection String For Mdf Database

Dec 31, 2010

i have create users and rolls and all thing work very good on my computer but after upload view exception

Code:

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: 26 - Error Locating Server/Instance Specified) how can i change connection string for mdf database

View 1 Replies

Configuration :: How To Change Connection Settings

Feb 8, 2011

Right now, when I am copying the website to host server, I am changing the connection string in webconfig file and at each location of a sqldatasource or a query .. thats like more than 30 places where I am doing this.

When I am done copying the website, I have to change all the connection strings back to dev server for me to keep working on the dev copy....

View 1 Replies

Configuration :: Use To Copy/publish Websites To Web Server Is Not Allowing Us Access To Push Websites?

Oct 15, 2010

the account we use to copy/publish websites to our web server is not allowing us access to push websites. I've added this account to the permissions in the links listed in the below link, but i don't have success when trying to push remotely. When the account is in the local admins account, everything works flawlessly, but we are not allowed to have it in there. http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/31be047e-4716-4974-b8a1-be0111b50199 I've googled and searched a lot for this particular error, but am not finding an answer that helps. We get this error, 'Unable to create the Web 'http://edea01/test/planning'. You are not authorized to perform the current operation', and the above link is the scenario that matches mine the most. I don't do develompment work, but am asked to figure out this connection problem.

View 3 Replies

How To Change Configuration Tool Connection String

Jan 10, 2011

how can I change ASP.NET Configuration tool-s connection string name? (Which connection string will ASP.NET Configuration tool will use)

I'm learning ASP.NET and everywhere and in book that I'm reading now theres connection string named: LocalSqlServer.

I want to use my local sql server database instead of sql express to store Roles, Membership and other data.

I have used aspnet_regsql.exe to create needed data structures in my database. after that I changed my web.config to look like:

[code]....

View 1 Replies

Change SqlDataSource Connection String In C# Dynamically

Jun 1, 2010

I have a page in asp.net (web forms) that up until now only had one database for data.

So all the controls that require something from the database use a datasource and the same connection string.

<asp:SqlDataSource id="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DefaultConnectionString %>"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT ... ">
</asp:SqlDataSource>

Up until now I only needed one connection string since I had only one database but this has changed since I want some users to connect to database A and others to database B What would be the correct way to go about it?

View 1 Replies

C# - Setup The Connection String Where Only Change It One Place?

Aug 5, 2010

How can I make the code string connStr = ConfigurationManager.ConnectionStrings "staceys_cakesConnectionString"].ConnectionString;

work generically and not need the staceys_cakesConnectionString? Or how can I set it somewhere else so I only have to change it one place when I change it?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

[Code]....

View 3 Replies

ADO.NET :: Change Connection String Of Linq To Sql Entities?

Sep 9, 2010

I have a solution which uses Linq to SQL Data Classes to acced the db. I have a project for my domain objects in my solution, which is a class library and has the dbml file. When I set up the dmbl using the wizard, Visual Studio created anapp.config file on that project with the connection string. It also creatting asettings file with the same info. I've noticed that if I change the connection string in the settings file, the app.config gets updated, which is the expected behaviour.

However, I'm having a problem when I deploy my web site to the production server. I already set the app.config file's Build Action to "Content", and also set Copy to ouput directory to "Always". Nevertheless, when I install the web site and change the connection string in the app.config file, it still takes the old connection string, so obviously I get an error. I've found that it only works if I change it with in Visual Studio and then compile, but of course that's not an optimal solution, because any change in the production db server would mean I have to change my project's assembly, thus generating a new version.

What do I have to configure so that the assembly takes the connection string form my app.config file directly after I deploy?

View 9 Replies

From One ASP Page To Other With Variable And Change Connection String?

Nov 22, 2010

i have 2 ASP pages in first page the user choose the database name and in other page take the database name and change the connection string to other databasehow i can pass a variable from one page to other by button click and how i receive this variable in other page and how to change the connection stringthe connection string is in web.config like this:

<connectionStrings>
<add name="Northwind" connectionString="Provider=sqloledb;Data Source=.;Initial Catalog=Northwind;User Id=sa;Password=sa; Connect Timeout=10"/>
</connectionStrings>

View 1 Replies

Visual Studio :: Error Unable To Add Data Connection. ExecuteScalar Requires An Open And Available Connection. The Connection's Current State Is Closed?

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

Web Forms :: How To Change Database Connection Name In Appconfig File

May 25, 2010

how can I change my database connection name in appconfig file....what is the tag name to it?

View 2 Replies

Web Forms :: Webparts Change The Sql Connection String At Runtime?

Feb 27, 2010

Does anyone has an idea on how to change the connection string of the webparts at runtime. i have a multitenant app, and would like to store each accounts users settings in their respective DB's i tried changing the connstring in the webpartsmanager init, and the page load event

Dim myConfiguration As System.Configuration.Configuration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~")

View 1 Replies

Configuration :: How To Change Connection String To Entity Model

Sep 11, 2010

I developed MVC application. Then successfully import my local database which was stored in App_Data folder to the hosting provider (thanks
ScottGu). But now I don't realize how can I painlessly change my Entity models which was using local database in order they use database which was imported.Here is some of the connection strings

[Code]....

View 8 Replies

Change Driver In Connection String To Data Source Vb.net?

Jan 25, 2010

i have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes"

i need to change that to -

"data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30"

when i just change the text it gives this error -

"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" how do i declare the datasource?

View 2 Replies

Crystal Reports :: Change Table Connection String

Feb 12, 2011

I have serveral databases with same tables. I created a crystal report to show the report for respective logins from the database. I have a problem in it. In crystal report when i changing the database it should not change the respective table. It loads only the table what we give in the connection string first time.

View 1 Replies

VS 2010 - Change Connection String For Registration Form

Jun 20, 2011

I am trying to change the connection string for the registration form in VS 2010.

This is because it links to the local database in the App_Data which I need it to link to another database. I have changed the connection string in the webconig file and this works file for other forms I have created but does not allow me to create new users.

I have used the ASP.net 4.0 template when creating this website.

View 5 Replies







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