Unable To Connect To Analysis Server From EXCEL

May 30, 2008



Hi,

I have Installed Analysis Services on Windows 2000 Server.
There is no Active Directory and no Domain configured.
All client PCs and the server are part of Workgroup.
I have also installed MS SQL Server on this Server and
an instance of MS SQL Express edition on this server.
There is no Firewall, no Office and no IIS installed on this server.

When I use Analysis Manager on the server, I am able to connect to the Sample Database
and browse/edit the cubes. Similarly I am also able to use the Sample MDX application.

However, when I try to connect to the same database from my Laptop (Vista home premium/Office 2007)
- either using Analysis Manager or From EXCEL, I am not able to connec to it.

The Excel gives me following error:
"The following system error occurred: No Connection could be made because the target machine actively refused it"

And Analysis Manager does not register the server. It gives me a different error:
"Errors occurred while connecting to INTRANETNT. Cannot open connection to Analysis server 'INTRANETNT'.
Security error [The user could not be authenticated]'' Do you still want to register this server?"

I am able to connect the SQL Server database from EXCEL from my laptop

I checked following:
I am able to do a telnet on port 1433 on my server from my PC - and it connects.

Please advise what should I do to sort out the problem. This is my first exposure to Analysis Server

Regards
Madhup

View 5 Replies


ADVERTISEMENT

Unable To Connect To Analysis Service Using HTTP On A Different Server

May 18, 2007

Hi all,



This one has really stumped me! I set up HTTP to connect to an Analysis Services cube within an ASP .NEt application. On inititial setup it worked well and I was able to connect and view the data in my ASP application.



However, for NO reason that I can see it is now coming up with the following error:







Either a connection cannot be made to the localhost server, or Analysis Services is not running on the computer specified.



Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Either a connection cannot be made to the localhost server, or Analysis Services is not running on the computer specified.






I have tried everything I can think of to fix it but can't get it to work. I have even gone through the technet document titled "Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios" but it hasn't helped.



I am using SQL Server (Analysis Services) 2005 and ASP .NET 2.0. The application is developed in VS 2005.



I'm at a loss...can you help?



Cheers in advance!

View 1 Replies View Related

SQL 2012 :: Unable To Connect To Analysis Services

Apr 30, 2014

Currently we are unable to connect to analysis services and getting the below error

Element 'return' was not found.Line 5,position 2

What could be causing this?

View 1 Replies View Related

How To Connect To Analysis Services With Excel 2007 Data Mining Add In?

Jan 18, 2007

I downloaded a trial version of office 2007 and the data mining addin. I do not have an automatic connection to Analysis Services, so most functionality does not work. Is it possible to configure a connection with a trial version? If so, does anyone know what the server name is and how to configure it?

View 14 Replies View Related

Connect To Analysis Server

Nov 2, 2004

Helo!

Analysis manager is not able to coonect to analysis server. I can't register server -> Network error [Internal error].

Tnx, E

View 3 Replies View Related

Cannot Connect To Analysis Server

Dec 21, 2004

I have installed sql 2k and analysis service 2k including sp3a on my PC with XP professional. When I try to connect to the olap service from the olap manager I get the "cannot open connection to the analysis server". Does any one has a clue on a solution???

View 1 Replies View Related

How Can I Connect To Analysis Server In C#?

Dec 11, 2007


Hi
I want a request about mining model; I have solicitation that if every one can help me, please read this request and give a simple mining model with time series algorithm.
For example if you want to predict sale€™s of good (e.g. book )for next month, you should have a column about the number of books that is sold for every month ,and we have the values of 11 month ago and now want to predict the value of 12th month for selling books and after predicting with time series and building a model, we see the result of prediction in the mining structure in sql ,also we can use query in the mining model prediction, we see this result in this software but if we want to see in a interface that is built with c# ,so we should create a connection with analysis server and mining structure ,so I should have the codes that beget this connection, so we need a button and a combobox and a textbox that the textbox use for showing the result of prediction and a button that you click on and the value of 12th month predict then you can see it in textbox and a combobox for choosing the name of customer(because in this project, we predict €œpurchasing book€? for one by one ,for every customers)
And if every body does this simple project for me, I say thank a lot
Please if you can help me, do this project with time series algorithm and build a c# form with up conditions and connect to analysis sever and put this file for reply me.
And if data were in the excel file and we want to use in the table how can do this work without that wihch import data?


please if you want to answer ,say simple becasue i am a tenderfoot user

View 1 Replies View Related

Cannot Connect To Analysis Server Using DM

Feb 14, 2008


I was trying to get setup with DM but have issues getting it to work.
I cannot connect to the Analysis server - both using the Server Configuration Utility, and by using the Connections tab within Data Mining Tab in Excel. the error that i get is:
Test Connection Failed.
The '18441' locale is not supported.

The analysis server is on a different machine, and i have tried both the IP and Host name to connect to the server.
I have admin privelleges on the server.
I have also installed the DM tools on the server, and given myself permissions to the analysis server.
However my SQL server 2005 may not be SP2, or maynot have the hotfix applied.
Will that cause the DM to fail connection?

Can you please give me some pointers on how to resolve this issue?

View 3 Replies View Related

Cannot Connect To Analysis Server 'VMFGSRVR'

Jun 4, 2002

I am trying to register the analysis server from a w2k
client. The shortcut is executing "J:analysis
manager.msc".
I have applied analysis spsp2 to the client. Please note i
have the same setup on anothe w2k client.

View 2 Replies View Related

Connect To Remote Analysis Server

May 22, 2006

Hi,

How do I connect to a remote Analysis Server using SQL management studio on my local machine.

Thanks in advance..

View 7 Replies View Related

Analysis :: Excel 2013 Pivot-table / Grouping On Date That Comes From Analysis Service 2008?

Nov 24, 2015

I am using

SSAS: version 2008
Excel: version 2013

I am connecting to SSAS cube from Excel and I have date dimension with 4 fields (I have others but I don't use it for this case). I created 4 fields in order to test all possible scenarios that I could think of:

DateKey:
    - Type: System.Integer
    - Value: yyyyMMdd
Date:
    - Type: System.DateTime
DateStr0:
    - Type: System.String
    - Value: dd/MM/yyyy (note: I am not using US culture)
    - Example: 01/11/2015  
DateStr1:
    - Type: System.String
    - Value: %d/%M/yyyy (note: I am not using US culture) 
    - Example: 1/11/2015  

Filtering on date is working fine:

Initially, in excel, filtering on date was not working. But after changing dimensional type to time, and setting  DataType to Date, as mentioned in [URL] filter is working fine as you can see in the picture.Grouping on date is not working:

I have hierarchy in my Date dimension and I can group based on hierarchy, no problem. But user is used to pre-build grouping function of excel, and he wants to use that. Pre-build functions of Excel, Group and ungroup seems to be available as you can see in following picture:

But when user clicks 'Group', excel groups it as if it is a string, and that is the problem. User wants to group using pre-build grouping function available in Pivot table. I also find out that Power Pivot Table does not support this excel grouping functionality. And if I understood well, this pre-build grouping functionality of excel, needs to do calculation at run time, and that is not viable solution if you have millions of rows. So Power pivot table does not support pre-build grouping functionality of excel and hence we need to use dimension hierarchy to do the grouping. But I am not using Power Pivot table, I am using simple Pivot Table. So I expect grouping functionality to be working fine. Then I tried to do simple test. I created a simple data source in excel itself. And use it as source of my Pivot table. Then grouping is working fine. The only difference that I can see is (When double click the Measure value in Excel),For date values of my simple test, excel consider them as 'Date'.

For date values of my data coming from cube, excel consider them as 'General'

    2.1. But value here is same as it was in simple test.

    2.2. 'Date Filter' works just fine.

    2.3. If I just select this cell and unselect it, then excel change type to 'Date' though for that cell. 

    2.4. I have created 4 different types of fields in my date dimension thinking that values of attribute of my dimension might be the problem, but excel consider 'General' for all of them.

    2.5 This value (that can be seen when double clicking on measure) comes from 'Name Column' of the attribute. And the DataType defined is WChar. And I thought that might be the reason of issue. And I changed it to 'Date'. But SSAS does not allow it to change to 'Date' giving error : The 'Date' data type is not allowed for the 'NameColumn' property; 'WChar' should be used.

So, I don't know, what is the puzzle piece that I am missing.

1. Date filter works, group does not work

2. Excel consider it as 'General' string.

3. SSAS does not allow to change 'NameColumn' to Date.

View 2 Replies View Related

SQL Server Unable To Connect... Please Help

Jan 14, 2000

I upgraded my 6.5 server to 7.0 two days ago running into small problems with the database upgrade wizard. I had some small problems with security which took me some time but was not that difficult once I figured it out. I then proceeded to switch back to 6.5 mode to transfer all the data that had been done that day to my development machine so I could then import it to the SQL 7.0 version. When I was done with the transfer I switched back successfully, started the server successfully, but I was unable to connect. I get the error "Connection could not be established...", so after several attempts to connect and shuting the server down I now am at a loss. The server runs fine in 6.5 mode but it will not connect in 7.0?? Tonight I am going to try to reinstall SP1, if that does not work I am going to try to reinstall SQL 7.0. Any suggestions???

View 2 Replies View Related

Unable To Connect To Server

Nov 14, 2000

On a fresh installation of SQL Server 6.5, I have
opened the EM and registered the server but am unable
to connect. I get the error of 'A connection could not
be established to [ServerName]- [DB-Library] Unable
to connect: SQL Server is unavailable or does not exist.
General Network Error. Check your documentation.'

I've tried connecting with all different DB-Lib settings
to no avail. Ultimately, I want to use TCP/IP. I am,
however, able to connect to other SQL Server boxes from
this EM, just not the local server. I am able to stop
and start the services from Control Panel and from SQL
Service Manager.

Since I haven't been able to log into the local SQL Server,
I've registered the server in EM to log in with sa and a
blank password. I've already completely uninstalled SQL
and reinstalled it to see if that would help. It didn't.

Does anyone have any idea what the problem could be?

Thank you!
Toni

View 7 Replies View Related

Unable To Connect To Server

Jan 20, 2003

Hi,

I am running SQL 2000 on Windows 2000 Server. The clients are running different OS ranging from Win 98/NT/2000. Although i am able to connect to the local host, but whenever i try to connect over the network the following error pops up :

unable to connect to server <server name>
Server : Msg 11, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Socket]General network error. Check your network documentation.

I checked up the event long on the server and found the following entry:

Event Type: Warning
Event Source: MSSQL$NETSDK
Event Category: (8)
Event ID: 19011
Date: 1/20/2003
Time: 2:12:32 PM
User: N/A
Computer: <computer name>
Description:
The description for Event ID ( 19011 ) in Source ( MSSQL$NETSDK ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event:
(SpnRegister) : Error 1355.

May i further clarify that this error started today n till last week end (saturday, i am

stationed in India) there was no problem and the users were able to connect to the server

without any problem. My network engineer feels that its an sql problem and has nothing to do with network related issues.

i would appreciate if anybody could help me out. thanking in advance

- Paramesh

View 4 Replies View Related

Unable To Connect To Sql Server

Nov 20, 2003

recently i made my PC dual boot by installing windows 2000 advanced server. It already had win2000 profesional installed on it. since then i have been unable to connect to sql server running on some other server(called CONTROLS) on the LAN. I am able to access the CONTROLS server thru 'my networkplaces' and able to see all its hsared directories and access htem. but when i open Enterprise manager i cannot connect to CONTROLS.
Please help me . i have already wasted 2 days over it.

View 3 Replies View Related

Unable To Connect To SQL Server

Jun 12, 2000

I am unable to connect to SQL Server using isql_w or enterprise manager. The ODBC settings register successfull and the services show as started. I have tried starting SQL server in single-user mode with minimum config to see if memory is a problem but still cannot connect. The error logs show SQL as having started successfully with no errors. Has anyone got any ideas?

View 5 Replies View Related

Unable To Connect To Server

Aug 2, 2001

From my Win98SE box with MDAC 2.6sp1, I can't connect to SQL (win2k, sql2k).
I've tried everything I know but nothing works.

I always get the following error:
Unable to connect to server 192.168.1.2
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC Sql Server Driver] Timeout Expired

some additional info...
- both computers are in a workgroup, not in a domain.
- this is a home network and they're connected via a Linksys cable modem router
- another box on this same lan can connect to sql just fine, although it's
running win2k.
- all boxes have identical DSN, Subnet...settings
- I also installed Jet4.0sp1 just in case, but that didn't help either
- I'm primarily trying to connect via TCP, although I have tried Named Pipes
as well
- i can ping both boxes from each other just fine
- odbc ping fails

MDAC has worked beautifully for me for the last several years. Did MS
change something recently...or is there another problem?

Thanks, Andre

View 2 Replies View Related

Unable To Connect To Server

Nov 18, 2004

Hi,

I encounter (suddenly) the following error:

[ODBC SQL-Server Driver][Shared Memory] Unknown connection

by connecting either with the query analyzer or enterprise manager.
No connection possible anymore.

My configuration is:

Windows 2003 Server with
SQL Server 2000 SP3a Enterprise Edition with standard network configuration

One MSDE is still running on same machine and can connect.

I have checked with Compchecker, but no mismatches.

Any ideas ? It all sounds weired !

dajm

:(

View 3 Replies View Related

Unable To Connect To Server

Oct 25, 2005

Hello. I am very new to SQL Server. I've tried to look through other posts on the forum but did not find the solution I needed. Please help.

I have SQL Server running on Machine1 which I am able to connect to. What I want to do is connect to this server through a Machine2 that is on my network.

Both Machines run on WindowXP Professional

On the server of Machine1, I have:
1. Under the security tab, I have created a New Login using SQL Server Authentication (general tab), checked all server roles (server roles tab) and checked to permit all databases (in the database access tab)
2. On the server, went to properties -> security tab and allowed for SQL Server and Windows authentication

On Machine2 when I try to register the server of Machine1 through the Register SQL Server Wizard, I am able to see the server. However, when I use the newly created Login Name and password (from step 1 of above). I get a Login Failed for user message. When I try to connect to the server through Query Analyzer I also get an unable to connect to server message (Server: Msg 18456, Level 16, State1)

What else do I need to configure to make it work?

Thank you!

View 9 Replies View Related

UNABLE TO CONNECT TO SERVER

Jul 20, 2005

If you place an image of your server on a rebuilt server, rename it andchange the SID. You get an error message “UNABLE TO CONNECT” when youuse the SQL Query analyzer on a desktop computer to connect to theserver (hosting the image). If you add the server (hosting the image)to the Windows2000 server domain/active server and restart the server(hosting the image), you get the following error message: "YOUR SQLSERVER INSTALLATION IS EITHER CORRUPT OR HAS BEEN TAMPERED WITH (UNKNOWNPACKAGE ID). PLEASE RERUN SETUP."Wouldn't you think changing the name, the sid and adding it to a domainwould be enough to access it. I even created a new ODBC connection.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 1 Replies View Related

Unable To Connect To Server

Jan 31, 2008

i have three computers with three differnent running systems. about three days ago we were experiencing trouble getting into the game rooms at pogo.com. we thought it would be trouble with java since it affected all three computers. on the computer i am on now i have uninstalled and reinstalled java numerous times to no avail. I am at my wits end trying to fix this. does anyone have any ideas.

View 1 Replies View Related

SQL Server Is Unable To Connect

Dec 12, 2006

Hi there,

There is a SQL instance (sql2005) and I am trying to add a new distribution. Replication wazard says:

SQL
Server is unable to connect to server 'SERVER1'. (New Publication
Wizard)SQL
Server is unable to connect to server 'SERVER1'. (New Publication
Wizard)

SQL Server replication
requires the actual server name to make a connection to the server.
Connections through a server alias, IP address, or any other alternate
name are not supported. Specify the actual server name, 'SERVER1'. (Replication.Utilities)

There is the only local instance of the server on local computer and 'SERVER1' is actual name.

What is wrong?

Thank yuu

View 4 Replies View Related

Analysis :: How To Connect SSAS Cube To Server

Jun 12, 2015

How can I connect ssas cube to server. I have no SSAS SERVER INSTANCE...

View 3 Replies View Related

Unable To Connect To SQL Server Database.

Apr 6, 2007

hi,
im making a log in using the asp.net web site admin tool the probably
is when click n the security tab it says it cannt connect to the
aspnetsqlprovider. thanksdomal 

View 1 Replies View Related

Unable To Connect To Server. Tired Of This

Aug 3, 2007

The error occurs when I try to configure SQL server express.  Please help. An error has occured while establishing a connection to the server. When connectiong 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)
 
-sam

View 1 Replies View Related

Unable To Connect To SQL Server Database

Aug 13, 2007

 Hello all,I try to configure the website by using the built in tool of vs2005. When i click the  button from Website -> ASP .NET Configuration.when the main page is displayed, i clicked the security, the error shows like:---------------------------------------- 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: Unable to connect to SQL Server database.---------------------------------------How to enable connection to sql server? Thanks  

View 5 Replies View Related

SQL Server Unable To Connect On Vista

Aug 13, 2007

I have a problem that unble to connect the SQL Server2005 on Vista OS. After searching solution around but still not able to find the solution for me problem.
The Error was Error 26,
provider:SQL network interfaces, error:26 - error locating server/instance specified
 
Is any1 facing the problem on this? Any solution for this case?
 
TQ
 

View 14 Replies View Related

Please Help Me About :Unable To Connect To SQL Server Database.

Aug 21, 2007

To All Members,When I create a new project and try to use the ASP.Net web application administration :security tab, I get the following :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: Unable to connect to SQL Server database. I am using Microsoft Visual Web Developer 2005 Express Edition with a local MS SQL Server 2000.I am new to all of this so a little help would be greatThanks.please mail me to dehackers@linuxmail.orgor                        izzuan@malysia.com 

View 4 Replies View Related

Unable To Connect To SQL Server Database.

Oct 15, 2007

Hi, I am working through "Sams Teach Yourself ASP Dot NET 2.0 in 24 Hours"
I am upto hour 20 where it says
Configuring an ASP.NET Website to Support Membership
To configure our website to support membership, we must launch the ASP.NET Website Administration Tool. To accomplish this, either click the ASP.NET
Configuration icon at the top of the Solution Explorer or click the Website menu's ASP.NET Configuration option. Either way will open a web browser pointed to a page through which the ASP.NET site can be configured. Figure 20.1 shows the ASP.NET Website Administration Tool.
To add user account support, click the Security link. This will take you to the Security screen shown in Figure 20.2. From this screen, you can specify the user accounts in your system, what roles for users exist, and the access rules for users.
However when I click security I get the following error message;
"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: Unable to connect to SQL Server database."
If I test the provider I get this error;
"Provider Management""Could not establish a connection to the database.""If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider."
I am using MS VWD Express with MS SQL Express. I have run the 'aspnet_regsql' tool on my database which the book fails to mention and verified that the tables were created correctly. I have tried copying the MDF file directly into my 'app_data' directory but this made no difference. I have googled these errors and nothing seems to help. I can connect to the database through a 'SqlDataSource' and have had no trouble with the database in the previous sections of the book. I think it may have something to do with how I setup SQL Express or database permissions, I hope someone can help. Thanks in advance.
Here is a copy of my web.config; <?xml version="1.0"?><!--
Note: As an alternative to hand editing this file you can use the
web admin tool to configure settings for your application. Use
the Website->Asp.Net Configuration option in Visual Studio.
A full list of settings and comments can be found in
machine.config.comments usually located in
WindowsMicrosoft.NetFrameworkv2.xConfig
--><configuration>
<connectionStrings>
<add name="MyFirstDatabaseConnectionString" connectionString="Data Source=.;AttachDbFilename=&quot;C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMyFirstDatabase.mdf&quot;;Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" />
</connectionStrings><appSettings/>
<system.web><!--
Set compilation debug="true" to insert debugging
symbols into the compiled page. Because this
affects performance, set this value to true only
during development.
Visual Basic options:
Set strict="true" to disallow all data type conversions
where data loss can occur.
Set explicit="true" to force declaration of all variables.-->
<compilation debug="false" strict="false" explicit="true" /><pages>
<namespaces><clear />
<add namespace="System" /><add namespace="System.Collections" />
<add namespace="System.Collections.Specialized" /><add namespace="System.Configuration" />
<add namespace="System.Text" /><add namespace="System.Text.RegularExpressions" />
<add namespace="System.Web" /><add namespace="System.Web.Caching" />
<add namespace="System.Web.SessionState" /><add namespace="System.Web.Security" />
<add namespace="System.Web.Profile" /><add namespace="System.Web.UI" />
<add namespace="System.Web.UI.WebControls" /><add namespace="System.Web.UI.WebControls.WebParts" />
<add namespace="System.Web.UI.HtmlControls" /></namespaces>
</pages>
<!--
The <authentication> section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user. -->
<authentication mode="Windows" />
<!--
The <customErrors> section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>-->
</system.web></configuration>
 

View 13 Replies View Related

Unable To Connect To SQL Server From ASP.NET Web App (Using Tutorial)

Jun 2, 2008

Hello everyone, I've been using the tutorial located here.I am using Microsoft Visual Studio 8.0.50727.42, Microsoft SQL Server 2005, and Microsoft .NET Framework 2.0.50727 SP1.The tutorial uses the SQL Express version and I cannot get it to connect to the standard SQL Server 2005 version.  I have used the website ConnectionStrings.com and the whitepaper located here and I wasn't able to get my web app talking to the database through many attempts.I am using a database in Microsoft SQL Server 2005 named SecurityTutorials.  This is located on my local machine.  There is a login named SecurityTutorials and a user in the SecurityTutorials database named SecurityTutorials who has default schema dbo, who owns the db_owner schema, and has role membership to db_datareader, db_datawriter, and db_ddladmin.  The password of this user does match the password in the connection string in web.config, I have verified this multiple times.The problem comes when I open up the CreatingUserAccounts page of this tutorial.  When I hit the button 'Create the User Account,' nothing happens.  And no record is inserted into the database.Here is my web.config file (if you need any other files then please let me know and I can post them but it is my understanding that this is the only file responsible for the database connection):<?xml version="1.0"?><!--     Note: As an alternative to hand editing this file you can use the     web admin tool to configure settings for your application. Use    the Website->Asp.Net Configuration option in Visual Studio.    A full list of settings and comments can be found in     machine.config.comments usually located in     WindowsMicrosoft.NetFrameworkv2.xConfig --><configuration>    <appSettings/>    <connectionStrings>        <add name="SecurityTutorialsConnectionString"        connectionString="Server=localhost;Database=SecurityTutorials;User Id=SecurityTutorials;Password=**********;"        providerName="System.Data.SqlClient"/>    </connectionStrings>    <system.web>        <membership defaultProvider="SecurityTutorialsSqlMembershipProvider">            <providers>                <!--Add a customized SqlMembershipProvider -->                <add name="SecurityTutorialsSqlMembershipProvider"                type="System.Web.Security.SqlMembershipProvider"                connectionStringName="SecurityTutorialsConnectionString"                enablePasswordRetrieval="false"                enablePasswordReset="true"                requiresQuestionAndAnswer="true"                applicationName="SecurityTutorials"                requiresUniqueEmail="true"                passwordFormat="Hashed"                maxInvalidPasswordAttempts="5"                minRequiredPasswordLength="7"                minRequiredNonalphanumericCharacters="1"                passwordAttemptWindow="10"                passwordStrengthRegularExpression=""/>            </providers>        </membership>        <!--             Set compilation debug="true" to insert debugging             symbols into the compiled page. Because this             affects performance, set this value to true only             during development.        -->        <compilation debug="false" />        <!--            The <authentication> section enables configuration             of the security authentication mode used by             ASP.NET to identify an incoming user.         -->        <authentication mode="Forms">            <forms                                slidingExpiration="true"                                timeout="60"                            />        </authentication>        <machineKey                        decryption="AES"                        validation="SHA1"                        decryptionKey="1513F567EE75F7FB5AC0AC4D79E1D9F25430E3E2F1BCDD3370BCFC4EFC97A541"                        validationKey="32CBA563F26041EE5B5FE9581076C40618DCC1218F5F447634EDE8624508A129"                    />                <!--            The <customErrors> section enables configuration             of what to do if/when an unhandled error occurs             during the execution of a request. Specifically,             it enables developers to configure html error pages             to be displayed in place of a error stack trace.        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">            <error statusCode="403" redirect="NoAccess.htm" />            <error statusCode="404" redirect="FileNotFound.htm" />        </customErrors>        -->    </system.web></configuration>Note:  The password is an actually password.  Not sure if it'd be a good idea to post that here, even though it is a test database.Thank you all in advance for your advice! 

View 1 Replies View Related

Trying To Register New SQL Server - Unable To Connect

Feb 27, 2004

I am currently trying to connect to a SQL Server instance with my host provider. I am having issues trying to connect to it.

I am using a Linkysys router and I have opened up the ports that SQL Server needs but I am getting an error - "SQL Server does not exist or Access denied". I've contacted the support but they are telling me it is an error on my end.

Has anyone experienced this issue before?

Thanks in advance for the help.

View 5 Replies View Related

Unable To Connect To SQL Server Through Web Matrix

Jul 20, 2005

I'd be really grateful for some help.I have successfully installed the SQL server on my xp home edition machine but everytime I try to connect through the Data Matrix i get the message 'unable to connect to database sever. Log in failed for user sa.' I am entering 'local host' for server 'sa' for user and my password but I cannot connect.I saw Harish Rangathans article about this where he suggested going to the  Enterprise manager and then the properties box to fix the problem but my version of the server only has a server manager and no properties box to enter to fix the problem.Is there anyone out there with any ideas about how to fix this problem.  

View 7 Replies View Related

Unable To Connect To A New Remote SQL Server

Jul 22, 2005

My VS 2005 website project was connecting to a remote SQL Server. But after I move the database to the second SQL Server, I got the following error message from running my website project:
 
Named Pipes Provider: Logon failure: unknown user name or bad password.
 
 
I do everything same like what I did in the first SQL server:
 

Using “SQL Server and Windows� authentication and “System account�;
Create a domain account IIS_WPG;
Grant this IIS_WPG as db_owner for the database;
In web.config, add the name and password to the end of connectionstring;
Make sure the SQL Server has “Named Pipes� and “TCP/IP� protocols.
 
I have no idea what I can do else, anybody has suggestions?
 

View 3 Replies View Related







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