Cannot Connect To SQL Server 2005 DB From ASP.NET Configuration Tool

Sep 25, 2006

Hello,
I am trying to connect to a DB, which is hosted on an SQL Server 2005 by a provider, using ASP.NET Configuration Tool. The result is the following error when I click on the Security Tab:
---
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---

The hosting provider checked that my connection string is correct. They do not know why I get the error, though. Here is a relevant snippet from my web.config:
<connectionStrings>
 
<remove name="LocalSqlServer" />
 
<add name="LocalSqlServer"
connectionString="Data Source=ABC;Integrated Security=false;Initial Catalog=ABC;User ID=ABC;Password=ABC"
providerName="System.Data.SqlClient" />
</connectionStrings>
ABC is a mock :)
Could anyone pls help? It is much appreciated.

View 4 Replies


ADVERTISEMENT

SQL 2005 RS Configuration Tool - Encryption Key Error

Mar 9, 2007

I have SQL 2005, and Reporting Service has been uninstalled and reinstalled,
go through each step of confiugration until Encryption Key, for some reason,
the backup button is grayed out, only "restore" button is clickable, as well
as Delete, but we never backup the key before, so this is really strange
since we do not have backupkey, so we cannot restore.

we tried "Delete", then we got the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted
value for the "LogonCred" configuration setting cannot be decrypted.
(rsFailedToDecryptConfigInformation)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()

Browse report manager and reportserver also got the same error, run
rskeymgmt -d, does not help either

Any suggestion?

Thanks
Don

View 10 Replies View Related

Error Received In Sql Server Reporting Services Configuration Tool When Changing Encryption Key.

Nov 6, 2007

I've SQL Server Reporting Services 2005 configured on my system, but now I'm NOT Able to start the report server. I get this error on http://<serverurl>/Reports/Home.aspx:

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)

I don't want to loose any data. Please help me resolving this error.

FYI, I've modified the SQL Reporting Services account LogOnAs info, in Properties of "SQL Server Reporting Services (MSSQLSERVER)" Service, in Windows Service Managment.

Earlier I had .useraccount as username, I modified it to domainnameuseraccount. And then suddenlt everything broke for reporting server.

View 4 Replies View Related

Web Administrator Tool - Unable To Connect To SQL Server Database.

Apr 30, 2008

I would like to setup the membership and role in web administrator tool, however, under Security section, I got the error message of "Unable to connect to SQL database".
I tried to run aspnet_regsql.exe to edit the config(C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql.exe), however, it still shows this error message.
 I am using web developer 2008 and SQL Server 2005.
Please advice me how to tackle this problem.
 
Thank you.
 
 
 

View 4 Replies View Related

SQL 2005 Express Setup Issue (The SQL Server System Configuration Checker Cannot Be Executed Due To WMI Configuration )

Sep 22, 2007

I am getting following error when trying to install SQL express 2005 on XPSP2.


TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342


I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.


Do i need IIS installed? Its not installed on this box...

please suggest something... i am stuck...

Thanks,

View 3 Replies View Related

ASP.NET Configuration Tool

Apr 4, 2008

Hi Guys
Got this problem, ive setup some new roles and users through asp.net configuration and it creates ASPNETDB.MDF in the App_Data folder when ive got a DB in SQL server 2005 express.
Basically how do i change it so the tables created for the users and roles are created in the SQL Server 2005 Db? p.s I'm very new to sql server 2005
Thanks

View 5 Replies View Related

Configuration Tool

May 17, 2007

In SSRS 2005, where do I find Reporting Services Configuration tool ?
Thanks

View 1 Replies View Related

Asp.net Configuration Tool

Jul 22, 2006

I deployed a web site, and converted SQL Server Express to a single SQL Server 2005 database. I created all of the tables required for memberships and roles with aspnet_regsql.exe.

Real simple question - how can I populate the membership and role tables out on the server? When I attach VWD to it, the ASP.NET Configuration tool is gone. How do you maintain memberships and roles without the tool?

Thanks for any help you will share :)

It's been a long journey but I am finally here!

View 5 Replies View Related

Configuration Management Tool

Dec 19, 2007

Dear All,
Where to find configuration management tool in sql server 2005???

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 4 Replies View Related

Configuration Management Tool

Dec 19, 2007

Dear Experts,
where can i find configuration management tool

actually i'm trying to change my MSDB mode from suspect to normal...

Vinod
Even you learn 1%, Learn it with 100% confidence.

View 1 Replies View Related

Reporting Configuration Tool

Aug 29, 2007

I installed 2005 advance... install said all OK. I go to Reporting Configuration tool, try to set Report Server Virtual Directory,
set new to default... says number of errors 0 but the crashes with the "... and has to close" No details as to what the error is
and when I retry I cannot click on Report Manager Virtual Directory. Any Ideas?

View 1 Replies View Related

Only Configuration Tool Downloaded, Why?

Mar 22, 2007

Hi,

First of all, I am very new on SQL server express.

Today I downloaded and installed the SQL server express (from www.microsoft.com/downloads), but what I got is only: Configuration tool, (I can see from: Start -> Programms -> Microsoft SQL server 2005->Configuration tool).

I didn't get SQL Server management Studio express, SAL Server Business Intelligence Development Studio, and Documentation and Tutorials.

I don't know where I did wrong, please help.

Thank you.

James

View 1 Replies View Related

Reporting Services Configuration Tool

Jul 11, 2007

Hello all

I am trying to configure reporting services using the Configuration Tool. I get all checks green except for Encryption Keys (Blue), Initialization (Grey), and Email Settings and Execution Account (both Yellow). I am not too worried about the yellow and blue ones because I have read that other people have the same, but I was wondering how to make Initialization available to configure. I am running SQL Server 2005 - Standard Edition.

Thanks for the help,



S.R.

View 39 Replies View Related

Reporting Services Configuration Tool

Jul 12, 2007

we just got the new server windows 2003 server, sql server 2005

- i use remote desktop connect to the server.

- i made the report services for testing,

the problem is I can't not published report.

i check the report services configuration tool.

(the page is gray. also warning come "no report server were found on
the specified machine" detail invalid namespace)

what shoul i do?

View 2 Replies View Related

Sql Server Setup Could Not Connect To The Database Service For Server Configuration

Jan 2, 2008

hi all
i get the following message error when installing sql server 2005 express :
<< sql server setup could not connect to the database service for server configuration the error was :[microsoft][gestionnaire de pilotes odbc] source de données introuvable et nom de pilote non spécifié >>
is there any help
thanks and best regards

View 6 Replies View Related

SQL Server Setup Could Not Connect To The Database Service For Server Configuration

Jun 4, 2006

OS: XP-SP2

Not able to install SQL Express 2005.
------------------------------

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x80090325

Needles to say, above link is useless..



I had managed to install previously, but ran into problems while trying to upsize an MS-Access database, I've tried everything from creating certificate to hacking away at the registry...Log-on with a different account, etc...Anybody knows how to get around this?

Here's part of the log file:




Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Sat Jun 03 20:09:53 2006

Machine : YANICK
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------

View 3 Replies View Related

Error Trying To Open Reporting Configuration Tool

Aug 3, 2007

I just installed SQL Server 2005 Express Edition and reporting services (followed the video tutorial). Whenever I try to open the Reporting Configuration Tool, it gives me the following error:

SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close. We are sorry for the inconvience.

My only options are to Debug or Close.

I'm not sure why I am getting this error. Can anyone help?

Thanks,
Amanda

View 9 Replies View Related

I Wrote My Own Configuration Tool To Maintain The Connection Strings In A SQL Table

Mar 29, 2006

I wrote my own VB app to maintain all of my connection strings and link them to packages. I then grab them at run time and set them as variables in memory.

View 1 Replies View Related

Cannot Connect W/ Java App But Can Connect W/ .Net App - SQL Server Express 2005

Dec 12, 2006

I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).

The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.

SQL Server Express 2005 is installed in mixed mode.

Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.

These are my values in my Java app web.xml -

<init-param>
<param-name>DBDriver</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
</init-param>
<init-param>
<param-name>DBURL</param-name> <param-value>jdbc:sqlserver://localhostsqlexpress:1055;databaseName=CORNERS</param-value>
</init-param>
<init-param>
<param-name>DBUser</param-name>
<param-value>sa</param-value>
</init-param>
<init-param>
<param-name>DBPwd</param-name>
<param-value>myPasswd</param-value>
</init-param>.

And yes, the port is 1055 - I checked to find it.

I am using Microsoft SQL Server 2005 JDBC Driver 1.0 (sqljdbc_1.0.809.102).

Does anyone have any idea what is wrong so that the login fails in the Java application but works in the .Net application?

View 7 Replies View Related

Where Is SQL Server 2005 Diagramming Tool?

May 19, 2005

I currently install SQL server 2005 CTP and I couldn't find the diagramming tool which used to view the conceptual model of the database structure, relationships and entities visually. This diagramming tool feature is available in SQL server 2000, however I couldn't find in SQL server 2005. Anyone would like to give me some recommendations or show me where this feature is hidden?  

View 1 Replies View Related

32 Bit BI-tool Connecting A 64 Bit SQL Server 2005

Mar 28, 2007

Hi,



I have Cognos 8 as BI-tool installed on a Windows 2003 Server, both 32 bit. We are thinking of using a 64 bit SQL Server 2005 with 64 bit Windows 2003 Server as database server for a new data warehouse.

Can I use the 32 bit SQL Native Client on the Cognos server for connecting to the 64 bit database server? If not, how should I set this up?



Thanks in advance for your help.



Kind regards,



Albert de Ruiter.



View 3 Replies View Related

Cannot Connect To Sql Database Using Config App Tool.

Oct 15, 2007

hi All

I'm new comer , the first time to work with Ent lib , I try to use modify sql connection string using configuration application tool integrated in Visual Studio against sql server 200 , I got this error .  _http://imagesshared.com/images/jdv1192388741v.JPG I don't know how to solve my problem , someone please help me to overcome this problem .

Thanks in advance .
sorry for my poor English , I'm a Vietnamese student .

View 4 Replies View Related

SQL Server 2005 && 2000 Tool Compatibility

Jan 31, 2006

Can someone tell me if I can use the Gui tools which come with SQL Server 2005 against 2000 databases ?

View 1 Replies View Related

Online Query Tool SQL Server 2005

Feb 18, 2008

Hi,I was wondering if someone could help advise me.Basically i have a client who wants to upgrade from a desktop msaccess solution to a web based system using MS SQL Server 2005.Basically their main concern is in losing the ability to write ad-hocqueries using the MS Access query manager. I can obviously writestatic reports etc but whats the best way to give them someflexibility ??Can anyone advise me if there is any product that can do this for SQLServer 2005 (which im sure there is) but will work in a webenvironment.Or does anyone have any helpful ideas ???all help / advice greatly appreciatedCG

View 1 Replies View Related

Web Admin Tool Can't Connect To Default Aspnetdb

Aug 21, 2007

I ran the command line tool C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspnet_regsql.exe.  Then I ran the web config tool and tried to test the default provider and it keeps saying it couldn't connect to the database.  The database exists in sqlExpress instance.  Any ideas?

View 18 Replies View Related

What Is A Good Tool For Modeling A SQL Server 2005 Database?

Nov 20, 2006

Hello,

I need a tool that will let me model a SQL Server 2005 database and then generate the tables, constraints, etc. from the model. I've never used a modeling tool so my knowledge is quite limited. I don't need to model or reverse engineer an application - my sole concern is on the SQL Server database side. I'm not concerned if the tool integrates with Visual Studio. And, of course, price is one consideration.

Are there any good tools that I should look at?

Thanks,

BCB

View 3 Replies View Related

Query Tracer Tool For SQL Server Express 2005

Dec 3, 2007

Hi guys,
I am using DLinq with SQL Server Express 2005 and I need to install some kind of user interface which shows me a trace of the SQL statements sent. I would like to see them in real time (I won't like to inspect a log after :-).
I remember that there was something similar in SQL Server 2000 full edition, but I requiere the same functionality in the Express version now.

Could you tell me if there is some tool to do that?
Thanks in advance,
Erich.

View 1 Replies View Related

SQL Server Service Broker Admin Tool For SQL Server 2005 RTM

Dec 27, 2005

Back in July I released the (then) latest version of SsbAdmin. For you who
don'r know what it is; it's a tool which allows you to graphically administer
SQL Server Service Broker.

I have now uploaded a new version which is compiled against the released
versions of SQL Server 2005 and .NET 2.0.

You can download it from here: [0].

After download, un-zip to some directory and read the README.doc file.

[0]: http://staff.develop.com/nielsb/code/ssbadmin.zip

View 2 Replies View Related

To Include Image In SQL Server 2005 Express Reporting Tool

Mar 13, 2007

Hi, I have a field in database that keep the image location. How to display the image in the report ?
Any idea.
Thanks.

View 2 Replies View Related

SQL Server 2005 Express And ASP.NET Web Site Administration Tool Problem.

Mar 31, 2006

I installed SQL Server 2005 Express Edition, I can login to it just fine using SQL Server Management Studio Express.  I ran the aspnet_regsql and it created the aspnetdb database.  But when I try to test the AspNetMembershipProvider or go to the Security tab in the ASP.NET Web Site Administration Tool it does not work.  I have tried messing with the connectionString of the LocalSqlServer in the machine.config, but to no avail.  My SQL Server is installed on the Default Instance.  Can someone help me get ASP.NET Web Site Administrator to work with my SQL Server 2005 Express Edition?

View 1 Replies View Related

Needed To Connect Remote DB By Client Tool (Enterprise Manager)

Dec 28, 2005

Here is what I knew: usr/pwd, Domain, Server and Database.
How to set Enterprise Manager, then can I connect to DB ?

View 1 Replies View Related

SQL Server 2005 Configuration Database

May 31, 2007



I am working on creating a configeration database based on the information pulled from a large number (over 40) of servers. I am newly out of college and don't have a lot of experience with things like this, but I am trying to create a configuration database. I need to know the best way to create a connection to all of the SQL servers on my network and then automate the pulling of data from these SQL servers. The types of data I would need are things like Instance ID, DBMS Version, Database Properties, Database Name, Modification Date, Last full backup, last transaction log backup, etc. I have been pointed towards either working with OSQL/SQL CMD, in which case could someone please point me towards a guide, and SSIS, I am reposting this thread in the SSIS area. I need to take all of the gathered data and place it into a central repository database after formatting it. Any help is greatly appreciated.



-Kyle Schlapkohl

View 3 Replies View Related

SQL Server 2005 Connection And Configuration

Feb 27, 2006

Hi,

A couple of small questions for anyone who can help. I am writing an application and am a newbie with SQL Server 2005 Express Edition and Visual C# (using Visual Studio 2005 pro).

My application will need to run on 6 different PC's at one time with our office server hosting the database. Since the server is hosting the database, is it necessary for the individual PC's to have SQL Server 2005 Express Edition installed on their hard drives also to communiucate back to the server?

Also, where can I find some nice example code for connecting and performing some simple tasks under C#?

View 1 Replies View Related







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