I have a SQL server database that I am trying to connect to from VS2005 in the Server Explorer.
I am not using the standard port for my SQL server listening port and I don't see where I can tell the Server Explorer to use a different port?
Can someone point me in the right direction for connecting to my database?
Thanks.
cant connect to sql server 2000 from c# 2003
View 1 Replies View RelatedSo, I have 2 laptops, both with standalone SQL Server 2012 Management Studio.
laptop 1 can connect to my remote server on xxx.xxx.xxx.xxx,1433
laptop 2 cannot connect through management studio - but can connect directly from the development website on this machine.
I get error 18456, cannot connect to server and login failed for 'user'
Firewall on or off has no effect.
Hi all,I'm having some trouble with connecting to SQL server instance latelywithout adding a port number. I used to be able to always connect toinstance without having to input SQLSERVER,portnumber. However nowthis is not the case. I doing this through an ADO connection object,and creating the connection string. Does anyone know if there was arecent Microsoft update or patch that would've cause this to stopallowing me to connect to a SQL instance without having to put in theport information? Thanks.
View 2 Replies View RelatedHi,
I've been running some tests with a 3rd party application during the last few days, but the ODBC doesnīt seem to be working well.
The ODBCs are configured to go through specific ports, since there's a firewall between the server (production area) and the database (which is located in the dev area). If i press the TEST CONFIGURATION button after i configured the ODBCs, the test is successful, and the log file of the firewall monitor shows that the server is connecting through the designated ports.
But when i run the 3rd party application, the queries fail, showing an error that says "The server cannot be found or you donīt have access", after this error, another one appears, saying something like "Connection().opened..." - unfortunately I don't have the actual text, I'll try to post it as soon as i get them .
Just to make sure that the 3rd party app is doing its job, dev team wrote a simple VB6 app to query the database, and it shows the same error.
Both apps are running well in the dev environment, since dev machines don't have to go through the firewall, and both apps are using the ODBC configured in the same way as the server. I could think that the problem is the firewall, but the firewall logs show that the production server is trying to use ports 1433, 1434, 445 and 139, and there isnīt a single entry showing activity for the ports specified on the ODBCs configuration.
The database server is running SQL Server 2000, the dev pcs are running Windows 2000, and the ODBC driver version is 2000.85.1117.00.
On the Production environment the server that is trying to access the database is running Windows 2003 Server Ent Ed. SP 1 , and the ODBC driver version is 2000.86.1830.00
I hope some one outthere has any ideas to solve this problem, or at least any idea of what is causing this error, because iīm running out of them.
Thanks in advance.
Efrain Morales
Version: SQL SERVER 2012 enterprise edition and SP2.
Due to one of the security reason, I have changed default port 1433 to another port number in configuration manger tools->protocols for MSSQLSERVER->TCP/IP --> IP ALL section mention another port number.
After restarted service, SQL SSMS able to connect server itself and new port number also LISTENING.
But SQL client SSMS not connected to one of the PC side after changing default port.
I'm trying to configure a named instances of SQL Server 2012 SP2 to have specific IP addresses and listen to that IP on port 1433. Alongside this, I have the default instance running on a different IP and listening to that on port 1433.I've managed to get them configured so that they are reachable using the IP, and looking at the log for each they are listening correctly on that IP on port 1433; in addition, the default instance connects fine using the SERVERNAME.However, when I try and connect to the named instance using the SERVERNAME/INSTANCENAME syntax, I receive the following:-
"Cannot connect to SERVERINSTANCE.
Instance failure. (System.Data)"
Configuration for the TCP/IP protocol for that instance is as follows:-
Protocol Tab
Enabled= Yes
Keep Alive = 30000
Listen All = No
IP addresses Tab
IP1
Active = Yes
Enabled = Yes
IP Address = 10.1.1.1
TCP Dynamic Ports = 0
TCP Port = 1433
[code]...
The SQL Browser service is running and prior to switching off Listen To All, I could connect to the instance remotely using the instance name.
In Management Studio i highlight my query and then click on 'Analyse query in Database Engine Advisor' but i get the following error message: "Failed to connect to an IPC Port: The system cannot find the file specified". Seems like if I reboot my computer it works one time then get the same error on the second time.I'm running developer edition with service pack 2.
View 8 Replies View RelatedHi all, How to package sql server database as part of our custom application (VB application) using install shield or any software. That setup should detect the presence of sql server. If sql server is not present in the client machine, then our set up should install the sql server and deploy our database. If sql server is present in the client machine, then our set up should install our database alone. How to do that. Please help me. Regards, S.Sevugan.
View 1 Replies View RelatedOS:Windows XP Professional Edition
SQLServer: 2005(DE).SP2(Have installed 2 instances of 2005 in my local system)
I am trying to do database mirroring,via SQL Server Management Studio.
1)configure security setup,(showed success).
2)when i start mirroring,i am getting the following error.
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'MIRROR_DEMO'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server network address "TCP://tp190.DELL.servers.corp:5023" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=1418&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I have followed the microsoft link and i have enabled the port numbers aswell.
I am trying to deploy a SQL Server Express database to a remote SQL Server 2005 host. I was planning to copy and paste the data from my local tables to the remote tables using Management Studio Express but my ISP (NTL) appears to be blocking port 1433 and preventing me from getting a connection to the remote database.
Will an upgrade to SQL Server 2005 Developer Edition help me? I understand that it has a Backup & Restore Wizard but how does this work? Does it rely on a remote connection and will it fall foul of the NTL port blocking? Or, can the file that the Backup stage produces be copied into the web-based MSSQL Manager, that my web host provides, to restore to the remote database?
Any help would be much appreciated.
I've mapped a sqlserver machine within vs2005, but when I attempt to set the database connection, I dont see place to stick the port number (even in the advanced area)... it continues to fail when I test the connection.. I can telnet into the machine on the sql server port, so I know its open to me...
Also - when I publish this to an IIS server, what is the syntax for placing the connection and port number in web.config? I've tried various settings, cant get it to work. <appSettings><add key="con" value="Server=12.123.123.123;PORT=1234;UID=*****;PWD=*****;database=mydb" /></appSettings>
Thanks in advance for the help,
Todd
Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
System.Data.SqlClient.SqlException: 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)
Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
Our SAP Sql server is on a cloud. I am currently able to access the SQL server from Remote Desktop Connection. I would like to know if I can connect to the Database server without the remote desktop.
Basically I am trying to develop Access Database queries on local computer and I want to pull the data from Remote Server. There is a firewall that is blocking the external ip address.
I would like to know if there is a workaround to set up the connection to first access the "Remote desktop" link and then the SQL server.
hi,
When I connect a VB6 form to an access database,I use the following code:
Dim sConDB As String
Public cnnTest As ADODB.Connection
'==
'Connect to Database
sConDB = "Provider=Microsoft.Jet.OLEDB.4.0;"
sConDB = sConDB & "Data Source="
sConDB = sConDB & App.Path & "databasename.mdb"
Debug.Print sConDB
Set cnnTest = New ADODB.Connection
cnnTest.ConnectionString = sConDB
cnnTest.Open
End Sub
Instead of using an access database,I am using SQL server database,so my question is:what's the code for connecting VB6 form to SQL server database?
Thanks for your help
HI
i have 2 computers in my home names PC1,PC2 .
i have database sql server 2000 in pc1 named Books , i want to connect to this database from pc2 .
note : i am used visual basic.net 2003
if any one have books or articales about this subject please i want help quickly
VB.NET. I'm getting this error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I don't have a username and a password setup for my server connection.
I tried changing the Security properties to Windows & SQL and Windows
authenciation and I'm still getting this error. Am I suppose to set up a username and password for my server? If so how? Thanks
Also a quick side question, how do I make the primary key auto increment through Enterprise Manager?
I am trying out a simple ASP.NET application which includes access to an SQL Server Database. It works fine on my local machine when I connect to the SQL Server and use SQL commands (via C#) to access it.
But my web hosting provider uses ODBC drivers for database access (they support the SQL database type). I would like to find out how I should connect to my SQL Server database and program the access in order for it to be ODBC compatible, so that I can deploy it to my web hosting server. I should also mention that I am using Visual Web Developer 2005 Express Edition.
Thanks for any help or pointers.
Kumar
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
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
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
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="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMyFirstDatabase.mdf";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>
Hello,I am trying to connect to a SQL SERVER 2005 database. The database file is in App_Data folder under Inetpub/[AppRoot]Here's the Connection String:"Data Source=SERVER2/YUKON;AttachDbFilename=C:/Inetpub/MyNotes/App_Data/MyNotesDB.mdf;User ID=sa;Password=****"Every time I try to connect I get a this error on my page: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."Here's the stack trace:[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +684979 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +207 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +890 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +601 System.Data.SqlClient.SqlInternalConnectionTds..ctor(SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +159 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +346 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +445 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +304 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 MyNotes.Membership.MembershipManager.CreateMember(MemberProfile objMemberProfile) in c:InetpubMyNotesApp_CodeMyNotes.Membership.cs:21 _Default.Page_Load(Object sender, EventArgs e) in c:InetpubMyNotesDefault.aspx.cs:23 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +36 System.Web.UI.Control.OnLoad(EventArgs e) +102 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1064Thanks in advance,Arnie
View 1 Replies View RelatedHI all,I have hosted my ASP.Net application to a Hostingserver.My application fails to connect to the databaseserver, and promts error "Object refrence is not set to an instance of anobject"This Error is due to Drop Down Lists which query datafrom the database. I am using the connection string "Data Source=xxx.xxx.xxx.xx; Initial Catalog=shopadvizor;User Id=user1;Password=pass"The IP address above works fine when I Register andconnect the Remote database Srever with my Enterprisemanager. I can even query the database from my Local enterprise manager to the remote machine database server. Really Lost Need some help.Regards
View 5 Replies View RelatedSystem.Web.HttpException: Unable to connect to SQL Server database.
---> System.Data.SqlClient.SqlException: 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)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean&
useFailoverPartner, Boolean& failoverDemandDone, String host,
String failoverPartner, String protocol, SqlInternalConnectionTds
connHandler, Int64 timerExpire,
The above was what I get whenever I tried connecting to SQL Server
database. I've got Windows XP Pro SP2, IIS 5.1, and is currently using
Visual Web Developer.
How do I rectify my problem of connecting to an SQL Server?
Is there a way to connect to another server in a TSQL script. I would assume that there would be but, I must be missing it somewhere. I found the ESQL CONNECT TO function but, can't seem to get that working either. Any help (even telling me it's not possible) would be appreciated.
View 1 Replies View RelatedI am trying to connect to SQL 7.0 northwind database via visual studio2005. But I can't open the connection. I get an error saying remoteaccess is not allowed. But the remote access is ok. I can used the samelogin and connect to the sql server via enterprise manage.SqlConnection conn = new SqlConnection("DataSource=(sqlserver:1433);Initial Catalog=Northwind;UserID=me;Password=mypassword");The above is the string I am trying to use.Is there a way to do this in Visual studio thanks
View 1 Replies View Relatedhi
I am trying to do create two SQLExpress connections (via sqlexpress instances) in two different machines through (ArcCatalog) a GIS software.
I am able to connect to Server B(per say) from Server A but I am not able to connect to Server A from B. A and B are in differnet machines.
Are there any setting in A which i am missing to enable so that A doesnt allow any connections to it. I checked the Protocols for SQLExpress and TCP/IP is enabled.
any help is appreciated!!
~N
Hi,
I am a beginner on using SQL Server Express. I have two different questions. Here is the first:
I've developed a simple C# application in Visual Studio 2005 that connects to a SQL Server database file. In the application I connect to the database using this connection string:
@"Data Source=.SQLEXPRESS;AttachDbFilename=C:Databasesmydatabas.mdf ;Integrated Security=True;Connect Timeout=30;User Instance=True";
and It works perfect.
But when I move the database file(and the corresponding log-file) to another computer it fails. I've changed the connection string to this
@"Data Source=.SQLEXPRESS;AttachDbFilename=\myserverDatabasesmydatabase.mdf ;Integrated Security=True;Connect Timeout=30;User Instance=True";
This is the error message I get when I try to open the database
The file \myserverDatabasesmyDatabase.mdf is on a network path that is not supported for database files.An attempt to attach an auto-named database for file \myServerDatabasesmyDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Both computer runs Windows XP SP2.
My second question is:
When I deployed my solution to my production PC(witch also runs Windows XP SP2, .NET Framwork 2.0 is installed on the computer) .When I then tried to run the application I did get this error message
An error has occured when establishing a connection to the server. When connection to a SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remomte conections.....
Appearently I cant treat SQL Server database files in the same way as Access-files, or?
Jan Olsson
Hi
I have installed SQL Express 2005 on a Windows 2003 server. I am able to connect when I use "SQL Server Management Studio Express" However when i try the command: sqlcmd -S 127.0.0.1 i got the following error message:
"C:Documents and Settingsadm>sqlcmd -S 127.0.0.1
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired."
anyone know how to fix this?
thanks!
Is it possible to have a Windows applications (based on .NET Framework 2.0) connect to a SQL Server Mobile database?
I manually added the the System.Data.SqlServerCe.dll (retrieved from C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDK\SQL ServerMobilev3.0System.Data.SqlServerCe.dll) to my Windows Form project. When I start the app, it gives me an error message:
{"Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)":"System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"}
TIA
when i click on ASP.NET Configuration and then security it opens a page that says 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. tryed doing what it sayd but didnt go.
I am using one of the "Club Web Site Starter Kit with a template named: My Club Site.
Hardware: Dell Poweredge1300
Software: Windows 2003 Server
----------------------------------------
Details of failure
System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: 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)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)
--- End of inner exception stack trace ---
at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)
at System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install)
at System.Web.Management.SqlServices.Install(String database, SqlFeatures features, String connectionString)
at System.Web.Management.ConfirmPanel.Execute()