Can' Establish Endpoint

Feb 28, 2008



I have two servers both installed sql server.The name of the servers are A and B respectively.
The admin of sql server in A is 'domainuserA', and admin of sql server B is 'domainuserB'.


My purpose is create a mirroring for a database in server A, but i can establish endpoint in server A(network address can not be reached or does not exist), i have grant the 'connect to endpoint' permission to each login .




i past my code:

step1



Code Snippet
--Server A, principal
create database db_test
backup database db_test to disk='\sharefolderdb_test.bak' with init

create endpoint endpoint1
as tcp(listener_port=5002)
for database_mirroring
(role=partner)

alter endpoint endpoint1
state=started

create login [domainuserB] from windows
grant connect on endpoint::endpoint1 to [domainuserB]






step2



Code Snippet
--Server B, mirror
restore database db_test from disk='\sharefolderdb_test2.bak' with norecovery

create endpoint endpoint1
as tcp(listener_port=5002)
for database_mirroring
(role=partner)

alter endpoint endpoint1
state=started

create login [domainuserA] from windows
grant connect on endpoint::endpoint1 to [domainuserA]

alter database db_test set partner='TCP://A.corp.com:5002'


--step3



Code Snippet
----Server A, principal

alter database db_test set partner='TCP://B.corp.com:5002'


this step return a error message:

The server network address "TCP://B.corp.com:5002" 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.







some wrong?

any suggestions would be appreciated.

View 5 Replies


ADVERTISEMENT

Establish SQL Connection

Aug 31, 2006

Hi! (my first post)
I'm ASP.NET newbie and i´ve got an SQL connection error, i know why, i didn´t establish a connection...
my questions are: how do i establish the connection state?, and where in my project should i do it?
I added  the connection section to my web.config, is that enough to establish a connection?
 <connectionStrings>
    <add name="buscomConnectionString" connectionString="Data Source=myserver.net;Initial Catalog=mycatalog;Persist Security Info=True;User ID=myuser;Password=mypassword"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

The error i get is:
Object reference not set to an instance of an object.



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.NullReferenceException: Object reference not set to an instance of an object.

Source Error:




Line 2443:Line 2444://If connection is not open then attempt to open it.Line 2445:if (connection.State == System.Data.ConnectionState.Closed)Line 2446:{Line 2447:try







Source File: d:UseruscomApp_CodePHP.cs    Line: 2445
   Thanks and cheers! Bill Murphy (litio.net) 

View 4 Replies View Related

Re-establish Database

Mar 5, 2004

I recently upgraded my Laptops operating system to Win XP Pro, and ran into data connectivity problems with my desktop SQL Server 7. To resolve the connectivity problems I removed SQL 7 and reinstalled SQL 7. My connectivity problems have been resolved however I lost the database from my server. The data base exists but it is not recognized from the SQL Server Enterprise Manager.

Is there an easy way to re-establish the database?

Any assistance would be greatly appreciated, I have posted this thread here because there is little activity on the SQL 7 journal it seems that I am behind the curve.

View 2 Replies View Related

Not Able To Establish A Connection To My Database In C#.

May 2, 2007

Could someone help me out? I am stuck and I don't have $245.00 to pay for Microsoft Technical phone support.
Basically I am trying to establish a connection to my database using C#. When I try to connect I can step into the line of code, but an exception is thrown.
Error message in the debugger:
ServerVersion = 'myConnection.ServerVersion' threw an exception of type 'System.InvalidOperationException'
 
C# code:
SqlConnection myConnection = new SqlConnection("Data Source=BVCOMPUTER;Initial Catalog=TheMarket;User ID =bill;Password=celebrate4ever");
When the above line of code is executed, then In the IDE debugger when I do a watch on myConnection, there is a tree node labeled "ServerVersion" The following messageis displayed there:
Also there appears to be a property of "ServerVersion"  named "base".The error message stored there is the following: base {"Invalid operation. The connection is closed."} System.SystemException {System.InvalidOperationException}
----------------------------------------------------
Note that I can drag and drop a grid control on my web form and point to the database I want to connect to. But for some reason when I manually try to connect, I am not able to.

View 3 Replies View Related

How To Establish Connection To SQL Server?

Mar 31, 2004

in the Quick start, it used connection string ("server=(local)NetSDK;database=pubs;Trusted_Connection=yes") to connect to the SQL db.

Now my working environment is, Im working on my client running .NET Framework as a webserver, and the SQL Server is on another PC as a db server (IP: xxx.xxx.xx.xx, user: webuser, pwd: webuser).

1st Question:
how do I build my connection string for this??
I tried following but no luck:
"user id=webuser;password=webuser;Initial Catalog=Bei;Data Source=xxx.xxx.xx.xx;Integrated Security=SSPI;";


2nd Question:
I just happened to see that ODBC is no more recommended in ASP.NET ?? if that's the case what is the new way to connect to DB ?? by using connection string or what ??


Thanks heaps!
Bei

View 3 Replies View Related

Not Able To Establish Connecton To SQL Server DB

Mar 13, 2006

Hi ,
 
 I got the following error message while trying to establish connection SQL DB : "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. "
 
in fact i have ran the utility and added the connection successfully and from the VWD i can see the table for the connections but when i run the ASP.NET Configuration it gives me the above error
 
appreciate ur kind advise
 
tks & rdgs

View 2 Replies View Related

How To Establish Merge Replication

Feb 22, 2001

Hi there,

Can anyone help me configure merge replication between two servers with same server name (select @@servername returns same server name) . When I am trying to establish the replication I am getting error message.

I cannot change the server names because both are production servers, so reinstalling SQL Server is out of question.

Thanks, Jay

View 1 Replies View Related

Establish Relationship Between 2 Tables

Aug 23, 2007

I am running SQL Server CE on Visual Studio 2005.
I have created 2 tables and wish to establish a relationship between the two tables.
However, I could not find a proper way to establish the connection.
Anyone can provide some help on this?
thank you.

View 2 Replies View Related

Could Not Establish A Connection To The Database

Aug 8, 2007

Hi!

My name is George. I have installed Microsoft Visual Web Development 2008 Exress Edition Beta, and when I want to use the Web Site Administration Tool and test the AspNetSqlProvider it says me this:

"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 don't know what to I do? I have enabled the IP/TPC and name pipes at SQL Server Surface Area Configuration, and I have used the aspnet_regsql to setup the ASP.NET and SQL Database, but the setup field it says this:

"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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
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()"

I have enabled the IP/TPC, name pipes and remote connections at the SQL Server Express...

Anybady help me?

Thanks

View 5 Replies View Related

Could Not Establish Connection To Database

May 12, 2007

I am having a great deal of difficulty connecting my version of visual web developer 2005 express to the AspNetSqlProvider as stated in the tutorials online at the web developer center. I keep getting the error below.



"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. "



When I run the utility I still get a connection error using the hostname of my computer and windows authentication.



The setup failed message is as below also:-

"Setup failed.

Exception:
Unable to connect to SQL Server database.

----------------------------------------
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()"



I have tried some of the suggestions on the forum with no result



Please can you help

View 18 Replies View Related

The AspNetSqlProvider Could Not Establish A Connection To The Database.

Aug 8, 2007

Hi!
When I'm going to the Web Site Administration Tool at the Provider tab I click to test the AspNetSqlProvider, but it says
"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 have enabled the TCP/IP and name pipes at the SQL Server, and I have created a database using the aspnet_regsql and when I'm going to test the provider it always says me that "Could not establish a connection to the database..."
Can anybody help me?
Thanks

View 3 Replies View Related

Already Ran Aspnet_regsql But Could Not Establish A Connection To The Database.

Sep 15, 2007

i already ran  aspnet_regsql but i still get below...anyone know why? thanks in advance 
 
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.

View 4 Replies View Related

Establish Connection With SQL Server From VB.Net Application

Jun 11, 2008

I have application that is connecting to SQL Server and runs bunch of stored procedures, but I don't think that am able to connect to my database server. When it hits the line to execute the stored procedure it comes up with syntax error saying the syntax error is at the stored procedure. I know how to set up the connection string with web app from the web config, but never done it on an app. Here is the connection string pointing to my server which I pass to my SqlConnection object: "Data Source=ServerXXXX;Initial Catalog=DB;Integrated Security=True; User ID=xxxx; Password=xxxx;"  And that is the code that is using the above connection string:   Public Sub MigrateNFSData(ByVal calcTbl As DataTable, ByVal strDBConnection As String)        Dim sqlServerConn As New SqlConnection(strDBConnection)        'Define stored procedures        Dim command As New SqlCommand        Dim getAccID As New SqlCommand("GetAccountID", sqlServerConn)        Dim getActionID As New SqlCommand("GetActionID", sqlServerConn)        Dim getExchangeID As New SqlCommand("GetExchangeID", sqlServerConn)        'Dim getParrentAccID As New SqlCommand("GetParentAccID", sqlServerConn)        Dim getStatusID As New SqlCommand("GetStatusID", sqlServerConn)        Dim getTraderID As New SqlCommand("GetTraderID", sqlServerConn)        Dim getGroupID As New SqlCommand("GetGroupID", sqlServerConn)        'Define insert records stored procedures        Dim insertAcc As New SqlCommand("InsertAccount", sqlServerConn)        Dim insertAction As New SqlCommand("InsertAction", sqlServerConn)        Dim insertExchange As New SqlCommand("InsertExchange", sqlServerConn)        Dim insertGroup As New SqlCommand("InsertGroup", sqlServerConn)        Dim insertStatus As New SqlCommand("InsertStatus", sqlServerConn)        Dim insertTrader As New SqlCommand("InsertTrader", sqlServerConn)        Try            sqlServerConn.Open()        Catch ex As Exception            'Exception message goes here        End Try        'Set parameters to helper Get Stored Procedures to retreive Id's         getAccID.Parameters.Add("@AccName", SqlDbType.NVarChar)        getAccID.CommandType = CommandType.StoredProcedure        getActionID.Parameters.Add("@ActionName", SqlDbType.NVarChar)        getActionID.CommandType = CommandType.StoredProcedure        getExchangeID.Parameters.Add("@ExchName", SqlDbType.NVarChar)        getExchangeID.CommandType = CommandType.StoredProcedure        'getParrentAccID.Parameters.Add("@ParentName", SqlDbType.NVarChar)        'getParrentAccID.CommandType = CommandType.StoredProcedure        getStatusID.Parameters.Add("@StatusName", SqlDbType.NVarChar)        getStatusID.CommandType = CommandType.StoredProcedure        getTraderID.Parameters.Add("@TraderName", SqlDbType.NVarChar)        getTraderID.CommandType = CommandType.StoredProcedure        getGroupID.Parameters.Add("@GroupName", SqlDbType.NVarChar)        getGroupID.CommandType = CommandType.StoredProcedure        command = New SqlCommand("InsertTradeTransaction", sqlServerConn)        command.CommandType = CommandType.StoredProcedure        'Set Parameters for Insert stored procedures        insertAcc.Parameters.Add("@Account", SqlDbType.Text)        insertAction.Parameters.Add("@ActionName", SqlDbType.Text)        insertExchange.Parameters.Add("@Exchange", SqlDbType.Text)        insertGroup.Parameters.Add("@Group", SqlDbType.Text)        insertGroup.Parameters.Add("@ACCID", SqlDbType.Int)        insertStatus.Parameters.Add("@StatusName", SqlDbType.Text)        insertTrader.Parameters.Add("@Group", SqlDbType.UniqueIdentifier)        insertTrader.Parameters.Add("@IP", SqlDbType.Text)        insertTrader.Parameters.Add("@TraderName", SqlDbType.Text)        'Adding stored Get Stored Procedure's parameters-----------------------        command.Parameters.Add("@OrderNum", SqlDbType.Text)        command.Parameters.Add("@ACC_ID", SqlDbType.Int)        command.Parameters.Add("@Group_ID", SqlDbType.UniqueIdentifier)        command.Parameters.Add("@Trader_ID", SqlDbType.UniqueIdentifier)        command.Parameters.Add("@Exch_ID", SqlDbType.Int)        command.Parameters.Add("@Date", SqlDbType.DateTime)        command.Parameters.Add("@Time", SqlDbType.DateTime)        command.Parameters.Add("@ActionID", SqlDbType.Int)        command.Parameters.Add("@StatusID", SqlDbType.Int)        command.Parameters.Add("@TimeSent", SqlDbType.DateTime)        command.Parameters.Add("@Qty", SqlDbType.Int)        command.Parameters.Add("@Product", SqlDbType.Text)        command.Parameters.Add("@MMYYY", SqlDbType.Text)        command.Parameters.Add("@ExchOrderID", SqlDbType.Text)        command.Parameters.Add("@TimeTicks", SqlDbType.Int)        command.Parameters.Add("@W2G", SqlDbType.Int)        command.Parameters.Add("@W2Exch", SqlDbType.Int)        command.Parameters.Add("@G2ExchDerived", SqlDbType.Int)        command.Parameters.Add("@ExchDate", SqlDbType.DateTime)        'command.Parameters.Add("@ParentID", SqlDbType.Int)        'Paremeters Defenition--------------------------------------        'Write table with computed NFS data to sql server DB        For Each dr As DataRow In calcTbl.Rows            command.Parameters("@OrderNum").Value = dr.Item("OrderNo").ToString()            getAccID.Parameters("@AccName").Value = dr.Item("Acct").ToString()            If getAccID.ExecuteScalar() = 0 Then                insertAcc.Parameters("@Account").Value = dr.Item("Acct").ToString()                insertAcc.ExecuteNonQuery() //THIS IS WHERE IT FAILS and pops up with the message that there is syntax error at this procedure                getAccID.Parameters("@AccName").Value = dr.Item("Acct").ToString()                command.Parameters("@AccName").Value = getAccID.ExecuteScalar()            Else                command.Parameters("@ACC_ID").Value = getAccID.ExecuteScalar()            End If            getGroupID.Parameters("@GroupName").Value = dr.Item("GroupID").ToString()            Try                command.Parameters("@Group_ID").Value = getGroupID.ExecuteScalar()            Catch ex As Exception                'Insert new Account if given account not being found from get stored procedure            End Try            getTraderID.Parameters("@TraderName").Value = dr.Item("TrdID").ToString()            Try                command.Parameters("@Trader_ID").Value = getTraderID.ExecuteScalar()            Catch ex As Exception                'Insert new Account if given account not being found from get stored procedure            End Try            getExchangeID.Parameters("@ExchName").Value = dr.Item("Exch").ToString()            Try                command.Parameters("@Exch_ID").Value = getExchangeID.ExecuteScalar()            Catch ex As Exception                'Insert new Account if given account not being found from get stored procedure            End Try            getActionID.Parameters("@ActionName").Value = dr.Item("Action").ToString()            Try                command.Parameters("@ActionID").Value = getActionID.ExecuteScalar()            Catch ex As Exception                'Insert new Account if given account not being found from get stored procedure            End Try            getStatusID.Parameters("@StatusName").Value = dr.Item("Status").ToString()            Try                command.Parameters("@StatusID").Value = getStatusID.ExecuteScalar()            Catch ex As Exception                'Insert new Account if given account not being found from get stored procedure            End Try            'getParrentAccID.Parameters("@ParentName").Value = ""            'Try            'command.Parameters("@ParentID").Value = getParrentAccID.ExecuteScalar()            ' Catch ex As Exception            'End Try            command.Parameters("@Date").Value = DateTime.Parse(dr.Item("Exch Date").ToString())            command.Parameters("@Time").Value = DateTime.Parse(dr.Item("Time").ToString())            command.Parameters("@TimeSent").Value = DateTime.Parse(dr.Item("Time Sent").ToString())            If (dr.Item("Qty").Equals(System.DBNull.Value)) Then                command.Parameters("@Qty").Value = System.DBNull.Value            Else                command.Parameters("@Qty").Value = Int32.Parse(dr.Item("Qty").ToString())            End If            command.Parameters("@Product").Value = dr.Item("Product").ToString()            command.Parameters("@MMYYY").Value = dr.Item("MMYYYY").ToString()            command.Parameters("@ExchOrderID").Value = dr.Item("ExchOrderID").ToString()            If (dr.Item("TimeTicks").Equals(System.DBNull.Value)) Then                command.Parameters("@TimeTicks").Value = System.DBNull.Value            Else                command.Parameters("@TimeTicks").Value = Int32.Parse(dr.Item("TimeTicks").ToString())            End If            command.Parameters("@ExchDate").Value = Date.Parse(dr.Item("Exch Date").ToString())            command.Parameters("@W2G").Value = 2            command.Parameters("@W2Exch").Value = 2            command.Parameters("@G2ExchDerived").Value = 2            command.ExecuteNonQuery()            sqlServerConn.Close()        Next    End Sub Thank you guys as always being helpful. 

View 4 Replies View Related

Error 'Could Establish Connection To The Database '

Mar 16, 2006

Hi,
I encounter few errors when I try to create a login page using tool in Microsoft Visual Studio 2005, please refer to below :



'-------------------------------------------------------------------------------------
 I create a Login screen from Toolbox.
 When I try to configure the setting for Provider Configuration in the ASP.NET Website Administration Tool using Select a single provider for all site management data or Select a different provider for each feature (advanced) options, the error ‘Could not establish a connection to the database’ appear.


I have tried to run aspnet_regsql to configure the server and database and return to this tool to configure the Provider configuration but the same error ‘Could not establish a connection to the database.’ appear.
When I click the Security Configuration link in ASP.NET Configuration, the error as shown below appear :
'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 below button 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 occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact under the default settings SQL Server does not allow remote connections.(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)'
When I try to choose Data Store in the Security Configuration screen(Figure 4),  the same error(‘Could not establish a connection to the database’) appear.
 '----------------------------------------------------------------
 
I also have tried to configure the SQL Server Surface Area Configuration but the same error still appear….
Is there any other configuration I need to set before I can create this login page?
 Any advices or help is much appreciate.
 
Thank you.
 
 
Regards,
Vicky
 

View 1 Replies View Related

Client Unable To Establish Connection

Apr 7, 2000

Here are the error messages:
Enterprise Manager:
A connection could not be established to SERVERNAME - Client unable
to establish connection ConnectionOpen (CreateFile())

Query Analyzer:
Unable to connect to server ServerName
Server Msg 67, Level 16, State 1
[Microsoft][ODBC SQL Server Driver]Client unable to establish connection


I can't register any other new servers, even ones in my workgroup. I'm connecting using named pipes, but have also tried using TCP/IP setting it up using Client Network Utility.

When i log on to another machine using my network login - I can connect.

There have been no problems connecting in the past and I haven't changed anything on my machine - any ideas???

View 1 Replies View Related

Client Unable To Establish Connection

Oct 18, 2000

Hi Guys.

We have a clustered server. When i create DTS packages in the secondary server I can get all the connection. But when i create DTS package that has connection to other servers. I am getting the follwing error. So my jobs that runs the DTS packages are failing.

Error Source: Microsoft OLE DB Provider for sql server

Error Description: Client Unable to establish connection.
Connectionopen(createfile())

I deleted all the entries in the Client network utility and recreated with ip addresses and TCP/IP protocol.

Added all the ip addresses to Lmhosts and host files.

Check the Server Network Utility.

I dont have a clue now.

Anyhelp are well appreciated.

-Thanks
-MAK

View 4 Replies View Related

Long Time To Establish A Connection

Jul 23, 2005

When I login using QA to my SQL Server database, it takes 15-20 secondsto establish a connection and open a query window. Drilling into adatabase via Enterprise Manager is similar. Once the connection isestablished, the server runs plenty fast however.Can someone tell me why it could take a long time for a connection tobe established?This behavior occurs when I am local on the box.Thanks,John

View 1 Replies View Related

How To Re-establish Subscriptions DB Using Backup Of Subscriber Db?

Apr 19, 2007

BOL 2000 makes reference to recovering a subscriber DB using a backup of the subscriber DB but does not appear to say how to go about doing it. What I need is enough info on how to set-up a backup and recovery strategy that can be implemented in a production environment. Snapshot recovery is no longer acceptable and there are lots of identity columns. Push publication.



It should be rather cook-book and I am hoping you can point me to a doc that will allow me to achieve this. It should be rather cook-book and I am hoping you can point me to a doc that will allow me to achieve this.



Thanks



Michael

View 4 Replies View Related

Help Needed To Establish Foreign Key Relationship

Sep 28, 2007



Hi i have two tables

X and Y

X is the Parent table and Y is the child

X has gpikey char(14) and Record type char(1) as Primary key

y has Name as primary key and column xgpi char(14) which should be the foreignkey to table X

what approach should i take to establish relationship between these two tables.

gpikey of recordtype 5 is equal to value in xgpi in table y

ex: data
Table X
gpikey recordtype

123 1
2345 2
272626 5

Table Y
Name XGPI
dhdhd 272626

x and y are having one to many relationships

View 2 Replies View Related

How To Establish Connection Between SQL Server Database && VWD 2005

Mar 24, 2007

I just got a shared hosting plan with godaddy (economy plan) ...
I wrote a simple application with a database. it works fine on my local PC.
I tried to upload my files to the server, but i couldn't get database file on godaddy's server. I did a little research and found out they dont allow uploading database files to their server nor they allow remote access either.
so I logged in to my account and found a database links and I created one (SQL Server)




Host Name
whsql-v44.prod.mesa4.secureserver.net



Database Name
DB_43434



Database Version
2000



Description
maindb
I then logged in to the database and created a new table .. but now I dont know how to make a connection between this database and my application on my pc.
I later found that I must modify my web.config file for the database to work. http://help.godaddy.com/article.php?article_id=689&topic_id=216&prog_id=GoDaddy&isc=

<connectionStrings><add name="Personal" connectionString="Server=whsql-v04.prod.mesa1.secureserver.net;Database=DB_675;User ID=user_id;Password=password;Trusted_Connection=False" providerName="System.Data.SqlClient" /><remove name="LocalSqlServer"/><add name="LocalSqlServer" connectionString="Server=whsql-v04.prod.mesa1.secureserver.net;Database=DB_675;User ID=user_id;Password=password;Trusted_Connection=False" providerName="System.Data.SqlClient" /></connectionStrings>
Now- I am new to web developing, but I do understand that this code is not enough to create the connection to the database. I researched alot but I cant get further.
 What code/ settings/ steps do I need to do to get my gridview and other database items connect to the database on godaddy's server ?
any help would be greatly appreciated...
 

View 1 Replies View Related

Establish User Defined Table Type

Aug 18, 2015

INSERT INTO @TESTTAB SELECT * FROM dbo.UTIL_TABLE_FROM_STRING(@szDelimit)
Note....The stored function returns a table.

Why doesn't this work ?:
SET @TESTTAB = (SELECT * FROM dbo.UTIL_TABLE_FROM_STRING(@szDelimit))

I wonder if I need to establish a user-defined table type ?I really just want a pointer to the table, and not to have to create a new copy.

View 8 Replies View Related

Analysis :: Establish Relations Between Different Levels In Hierarchy

Sep 24, 2015

I am having a requirement as below. I am having a Emp_Dim dimension table which is having a Manager_Key which is dependent on again on the Emp_Key. Based on the designation I have to create a Hierarchy. I have to create a Hierarchy with 10 levels according to the Designation.

While extracting data I am giving a particular Area manager id in Emp_Key I should get the accumulated data (His and the employees working under him as well). So it's like my MDX query should be like this if I am giving any emp_key then I need all the business done by under him.

My doubt is how I can establish the relations between the different levels in my Hierarchy. I am pretty new to SSAS.

View 3 Replies View Related

Could Not Establish Trust Relationship For The SSL/TLS Secure Channel

Feb 22, 2006

 

Hi,

I am working on sql server reporting services 2005 , i got this error while deploying a report

Error 1 The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. C:TempNotificationReportdb.rds 0 0 

NB: i checked IIS no ssl required on all sites.

Any Help ?

Thanks

Tarek Ghazali

SQL Server MVP

View 14 Replies View Related

Cannot Establish A Connection In Sql Server 2005 Express

Dec 27, 2005

hi all

here is the following error, what should i do.

 

TITLE: Connect to Server
------------------------------

Cannot connect to KANGALERTSQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

View 1 Replies View Related

Endpoint (varchar(15))

Jun 6, 2007

I am trying to get my query to pull all the occurances where someone called 411 assistance. It pulls anything that has 411 in it right now, and I just need it to find where the number is just either '411' or '1411' and thats it. Here is what I have so far:

SELECT sum(PaidBalCost), sum(BonusBalCost), sum(ceiling((Cast(DurationSeconds as Decimal)/60))) as Minutes
FROM VoiceCallDetailRecord
WHERE CallDate >= '02/19/2007' and calldate < '03/19/2007'
and (Left(Endpoint,3) = '411'
or Left(Endpoint,4) = ('1411'))
UNION
SELECT sum(PaidBalCost), sum(BonusBalCost), sum(ceiling((Cast(DurationSeconds as Decimal)/60))) as Minutes
FROM ZeroChargeVCDRecord
WHERE CallDate >= '02/19/2007' and calldate < '03/19/2007'
and (Left(Endpoint,3) = '411'
or Left(Endpoint,4) = ('1411'))

View 9 Replies View Related

Can Messages Be Sent To A Wcf Endpoint From T-sql?

Aug 16, 2007

we've gotten this to work from sqlclr and understand the dependence wcf has on the framework but still feel compelled to ask if somehow t-sql can send a message to a wcf endpoint without getting sqlclr involved. I've moved this question over here from the t-sql forum.

View 1 Replies View Related

Passing XML To An Endpoint

Apr 9, 2007

Hi,

I have created an Endpoint based on a stored procedure that has a parameter of datatype XML. I have added a reference to the endpoint in a web project, I have no problems accessing but I do have a question on how to pass XML or an entire XML file to the XML datatype? How is this done in VB.net? I have loaded the XML file into a vb string but this is not compatible with the sql server xml datatype? Any examples anywhere?



Thanks!

View 5 Replies View Related

Endpoint Security ?

Jul 24, 2006

Hi There

I am trying to grasp endpoint security, or actually more security/certiicates in general, at the moment i am trying to write a distributed service broker app, all the examples i have seen use certificates for the endpoint authentication.

Why must one create a certificate at each endpoint? Why can i not create a single certificate and let all endpoints use it ?

As you can imagine of this app gets distributed to hundreds of places creating a certificate at each one is a mission?

So can i use a single certificate for all endpoints authentication?

Thanx

View 1 Replies View Related

Aspnetdb Connection Could Not Establish But Database Correctly Created.

Sep 2, 2007

I installed netframework 2.0 Visual Web developer and MSSQL 2005 express edition with SQL Server management express.I have got this configuration: 2*256 mb ram Intel Pentium 3.2Ghz Windows XP HUN SP2 latest version.server name: localhostSQLEXPRESSAuthentication: Windows AuthenticationI run aspnet_regsql.exe and the setup wizard created aspnetdb see here, Microsoft sql server management studio can see the database:But! When I run to the asp.net web application administration tool in Provider Configuration and chooseAspNetSqlProvider only 1then I click Select a single provider for all site management data link -> then testThe Tool write this: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. 

View 5 Replies View Related

Unable To Establish Connection With The Microsoft SQL Server 2005

Jun 19, 2008

Hi,   I am using Microsoft Visual Web Developer 2008 Express Edition. I wanted to add a database to the Project. When i add it, it says "An error occured while extablishing an 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: SQL Network Interfaces, error:26- Error locating server / instance specified). Please let me know what is the cause of this error. Initially i downloaded Microsoft Adventure works database and saved the file as .mdf and tried to access it through the data grid. I got the same error message as above. I changed the settings in SQl server to enable remote access and also changed firewall settings to allow SQL server exe files. Then i uninstalled works db and now have disabled remote access and still have the firewall settings to allow SQL server on. Thanks,Vidhya         

View 2 Replies View Related

The Underlying Connection Was Closed: Could Not Establish Secure Channel For SSL/TLS.

Nov 20, 2007



Help.

Today while trying to get the Windows NT security working i upgraded my reporting services IIS server to a domain controller and it screwed up all of my settings. First it changed password for ASPNET user and so I reinstalled .net framework.

Now i get the



The underlying connection was closed: Could not establish secure channel for SSL/TLS.


error message.

I do not want to use an SSL certificate for I do not have one right now. How can I configure my SQL Server 2000 Reporting services to not use SSL. I see they added something to SQL Reporting Services 2005 in the configuration tools but I cant find out how to modify the config files with SQL 2000 RS to eliminate the SSL.

Please help, my company is down waiting for me to get this back up.

Thanks a ton,

deep

View 3 Replies View Related

Unable To Establish Communication Between Two Service Broker Instances

Sep 13, 2007

Hi,
I am struggling establishing message communications between Service Broker instances setup on two SQL server machines. I used nielsb Service Broker examples scripts to setup these service brokers but messages always get stuck in sys.transmission_queue with transmission_status field with the error....

"Error: Dialog security is unavailable for this conversation because there is no security certificate bound to the database principal (Id: 5). Either create a certificate for the principal, or specify ENCRYPTION = OFF when beginning the conversation."

I setup the certificate security like this...

use [master];
go

create master key encryption by password = 'masterhello1';
go
1- create certificate TrpCertServ1
with subject = 'TrpCertServer1',
start_date = '06/01/2005',
expiry_date = '06/01/2009'
go
2- BACKUP CERTIFICATE TrpCertServ1
TO FILE = 'C:ServiceBrokerTrpCertServ1Pub.cer';
go
3-CREATE ENDPOINT SSB1
STATE = STARTED
AS TCP
(
LISTENER_PORT = 4026
)
FOR SERVICE_BROKER
(
AUTHENTICATION = CERTIFICATE TrpCertServ1,
ENCRYPTION = REQUIRED
);
go
4-create login remconnlogin1
with password = 'remserver@1';
go
5-create user remconnuser1
from login remconnlogin1;
go
6-grant connect on endpoint::ssb1 to remconnlogin1
go


7- Repeated the above steps for SQL Server 2

8-create certificate TrpCertServ2Pub
authorization remconnuser1
from file = 'C:ServiceBrokerTrpCertServ2Pub.cer';
go


I know it has do something with certficates, I also tried setting encryption=off on Begin dialogue conversation but no luck , same error.

Any help will be appreciated, thanks,
leo

View 1 Replies View Related

Why Is My SQL HTTP Endpoint So Slow?

Oct 23, 2007

I have the need to have a client application connect to a remote database server for retrieval of large datasets (~13000 rows at time) and am trying to leverage existing technologies to build my solution.

To test the difference in retrieval times I created 2 test apps - testA and testB. I created an HTTP endpoint in SQL Server (2005) that exposes one web method corresponding to a sproc that executes one select query and configured testA to execute query and bind the results to a data grid. I exposed my SQL Server so that I could connect directly to the SQL Server using a connection string and configured testB to execute the same SQL statement in an ad-hoc fashion, binding the results to a data grid.

On average, the HTTP endpoint would take ~ 34 seconds to return the 13,000 row data set whereas the direct connection returned that same result set in 4 seconds or less.

I have a bunch of questions:
* Why would I be seeing such a dramatic difference in the retrieval times?
* How is SQL Server communicating when there is a direct connection?
* What are the immediate disadvantages to connecting directly to the remote SQL Server?
* If I were to consider allowing my client application to communicate directly with the SQL Server, is there any way to secure the communication without VPN?
* In addition, is it even possible to create a SQL login that has all of these requirements?
** select and update only
** cannot view schema (cannot connect to the SQL Server using SQL Server Management Studio)
** cannot view any system tables
** cannot retrieve any information about the schema of the database whatsoever

I guess I'm wondering if there is a way to overcome the obvious serialization overhead that comes with the HTTP endpoint to get the speed of the direct connection while being secure at the same time. Is that being greedy? :P

Anyhow, what are your opinions? I'm very interested to hear experiences and/or advice.

Thanks,

Paul

View 1 Replies View Related







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