CREATE ENDPOINT To Expose A Single DB Instance

Feb 27, 2007

I have been looking at this statement for allowing access from a remote location to a specific database on my SQL Server (2005) from a client application.

Is it possible to do this using this method? I see lots of examples using this to expose Web Services of DB objects, however I need the client application to be able to authenticate to and access all objects in the database. If so, could some one provide a simple example of the arguments to use? For example, which protocol arguments are valid for this? I would like to use SQL Server Authentication. Is this possible?

 Regards,

 -Troy

View 1 Replies


ADVERTISEMENT

Single Endpoint Multiple Databases

Apr 17, 2007

I'm building an app that will data stored in multiple databases. I have an endpoint with a single webmethod like so:



CREATE ENDPOINT [Rosters_Endpoint]

AUTHORIZATION [ADHEadministrator]

STATE=STARTED

AS HTTP (PATH=N'/SQL/Rosters', PORTS = (CLEAR), AUTHENTICATION = (DIGEST, NTLM, KERBEROS, INTEGRATED), SITE=N'10.0.1.116', CLEAR_PORT = 8080, COMPRESSION=DISABLED)

FOR SOAP (

WEBMETHOD 'GetACSStudents'( NAME=N'[fadb].[dbo].[GetACSStudents]'

, SCHEMA=DEFAULT

, FORMAT=ALL_RESULTS), BATCHES=DISABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=N'fadb', NAMESPACE=N'http://tempUri.org/', SCHEMA=STANDARD, CHARACTER_SET=XML)



Each webmethod will be accessed thru a multiview on the page.



It would seem to me that I can describe the webmethods using a fully qualified stored proc name and that wouldn't cause a big problem. But, my question is what does that DATABASE=N'fadb' clause do?



Does anybody see a problem with using a single endpoint to access multiple databases?



Any advice would be greatly appreciated as this is my first web app using this data access method.



Thanks.

View 1 Replies View Related

How To Move A Single Database From SQL Server Instance To New SQL Instance

Jan 13, 2007

Hi,

I want to move one database from the source SQL Server 2000 instance to a new SQL 2000 instance in another machine. I have five user databases in this source SQL instance. How should be my approach to move this single database out of this ? My understanding is restoring this database in the new instance, copying all logins to the new instance and then copying the jobs, DTS packages, alerts, operators only specific to this database will do it. Please let me know if this is exactly what I should do ..

Thanks in advance..

Regards,
Himansu

View 1 Replies View Related

How To Move A Single Database From SQL Server Instance To New SQL Instance

Jan 13, 2007

Hi,

I want to move one database from the source SQL Server 2000 instance to a new SQL 2000 instance in another machine. I have five user databases in this source SQL instance. How should be my approach to move this single database out of this ? My understanding is restoring this database in the new instance, copying all logins to the new instance and then copying the jobs, DTS packages, alerts, operators only specific to this database will do it. Please let me know if this is exactly what I should do ..

Thanks in advance..

Regards,
Himansu

View 4 Replies View Related

Single Instance/Multiple Instance/Virtualization Q

May 17, 2007

I work for a mid size company with the usual collection of enterprise applications. We are trying to consolidate our SQL environment consisting of around 100 databases none of which are over 100GB with the average database size around 5GB. Recently a large server was purchased as the "Big Daddy" SQL box. Obviously not all the databases will be moved to this one box but within reason a number can.

My question: What is the best way to configure the box?

1 OS & 1 Default Instance - How do we isolate loops memory leaks etc...
1 OS & Multiple instances, ie:Dedicated instance for each application. - How do you allocate CPU & memory, allow for optimum performance without putting others at risk from a rouge process?
Virtualized OS for each application with a default instance - Too much overhead impacts performance?

Future plans include offsite replication, perhaps mirroring with failover.

I'd appreciate anyone else's thoughts ideas? How have you tackled this problem in your environment?

Thanks
Scott

View 1 Replies View Related

CREATE ENDPOINT (Transact-SQL)

Jun 3, 2007

hello all i am new here,



my question is how i can activate http in sql server 2005

i want to run a helpdesk application but i cant make a new database.

it has something to do with create endpoint, i have no knowlege off sql server 2005 its not my field



can someone help me please?

View 3 Replies View Related

Create Endpoint Permission Fails

Feb 27, 2008

When I attempt to create the endpoint in "Programming SQL Server 2005", I get the error message: "

the user does not have permission to register endpoint. Any assistance in troubleshooting will be appreciated. Thanks.

Dan

View 5 Replies View Related

Failure To Create Endpoint, Error 15145

Oct 26, 2007



Hi,
I have system with SQL Server 2K5 SE 3042 SP2 . I was able to set up mirroring with primary-mirror-witness arrangement through GUI.
In this company I replaced another DBA who left, and the way our sys admin arranged our logins co-existed in domain for a while. Then sys admin, after mirroring was done, removed my login, renamed other DBA's login with mine, and removed his.
Now I cannot create endpoint, either by t-sql or through GUI: "An implicit login creation has failed. Reason: the login may have been dropped or its name may already be in use, error 1545".

After pressing Start Mirroring the following shows: "Database Mirroring Transport is disabled in the endpoint configuratin, error 1486". The 2nd error understandable in view of the 1st one.
I checked sys.database_mirroring_endpoints, it is empty. Anyone has an idea what this implicit login is, and where to look for it?

Vladimir Kievsky

View 6 Replies View Related

Create Endpoint Fails With Error 0x800704be

Mar 21, 2007

I am trying to create an endpoint with the code below and get the following error

An error ('0x800704be') occurred while attempting to register the endpoint 'getFormsEP'.


Anyone any ideas on what this error means?

Please help if you can.

Regards, Major (that is my Christian name ;-)



Code

create endpoint getFormsEP
state = started
as http
(
site='ictdwt10mt',
path='/EndPoints',
authentication=(integrated),
ports=(clear),
clear_port=84
)
for soap
(
webmethod 'getForms'
(
name='EForms21.dbo.getForms',
schema=standard,
format=rowsets_only
),
wsdl=default,
login_type=windows,
database='EForms21',
schema=none
)

View 3 Replies View Related

XML Sample Gets Error: CREATE ENDPOINT Not Supported

Jul 14, 2006

I installed the latest version of SQLX and tried to run the XML sample.

C:Program FilesMicrosoft SQL Server90SamplesEnginexmlXmlManuInstructionsReadMe_OnlineManuInstr.htm

The first part of the install.sql ran ok, but it chokes on the CREATE ENDPOINT line: is this really a limitation on the Express edition or did I miss something on installation or configuration?

Msg 7878, Level 16, State 1, Line 3

This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.

View 3 Replies View Related

Create A Named Instance On Top Of A Default Instance

Apr 13, 2007

Hi

I've never had to do this, but when I downloaded the Web Workflow Approvals Starter Kit, it requested that I install the database into a User Instance of .SQLEXPRESS.

Now the problem is, I've installed it onto a default instance, so I was wondering whether you can create a named instance on top of a default instance... and if so, how would you do that?

Cheers

Chris

View 3 Replies View Related

Expose SQL Meta Data Via ASP

Jul 20, 2005

Hi,Apologies if this is better posted in an ASP group, but here goesanyway ...Is it possible to work out what parameters a stored procedure expects,using ASP?I would like to take the name of a stored procedure, work out whatinput parameters it has and build a form based on them in ASP.Thanks,MB.

View 2 Replies View Related

SQL7 Job - Single/Multi-Instance

Jul 7, 2001

SQL7

If I have a job that runs every minute, and that job happens to take more than one minute to run on occassion, will SQL Server start a second instance of the job or will it be serial - one after another ?

Thanks,

Craig

View 2 Replies View Related

Applying Hotfix To A Single Instance

Aug 1, 2013

I've got a 4 node SQL 2008R2 cluster (configured 2 active - 2 passive), and 9 instances, of which all but one are on SP1 (the most recent addition is on SP2).

I need to apply a hotfix (Cumulative Update 6 for SP1) to just one instance. Can I do this by failing over the affected instance to one of the passive nodes, applying the hotfix, and failing it back again or do I need to apply the hotfix to all nodes as detailed in:

SQL Server failover cluster rolling patch and service pack process

i.e. will it involve a little downtime for all instances on the cluster?

View 1 Replies View Related

How-to Expose SQL Server To The Internet From Behind Firewall?

Jun 6, 2007

I cannot seem to find the definitive how-to guide for this. Can anyone point me in the right direction?

I have SQL Server 2005 (x64) already running on Windows 2003 R2 (x64). I'm having difficulty trying to expose it the Internet.

Using the Surface Area Configuration tool I can see that remote connections using TCP/IP is enabled. I also made the machine administrator a member of the SysAdmin role from here too.

In Windows Firewall "SQL Server" and "Web" are already checked as exceptions.

I know that SQL Server uses port 1433 and I also read somewhere that clients connecting to SQL Server communicate on a random port between 1024 and 5000. So, on my router (Netgear WNR854T) I'm forwarding ports 1024 through 5000 to the machine where SQL Server lives.

In my connection string I'm using the IP address of the SQL Server machine with ":1433" appended to the address. Yet I cannot connect to SQL Server. Am I missing anything?

View 9 Replies View Related

Mirroring Multiple Databases On A Single Instance

Jul 7, 2007

Can someone explain what does this mean? This is from http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx



<quote>However, all these techniques for coordinating client redirection with a database mirroring have an important limitation. Database mirroring occurs only at the database level, not the server level. Be careful if your application relies on querying several databases on a server, or uses multi-part object names to query across several databases. When several databases reside on one server, and they are mirrored to a standby server, it is possible that one of several databases might fail over to the standby but the others remain on the original server. In that case, you might need one connection per database that you are querying, so that you do not attempt cross-database queries on a standby server where only one database is a principal and the remaining are mirrors.</quote>

Also I read somewhere that if one mirrored DB fails, all other mirrored DB should also be transferred to the mirror.

For example: Let's say Srv1 (principle) and Srv2 (mirror) and Srv3(witness) are SQL servers with only default instances. The SQL instance has 4 DBs (DB1, DB2, DB3, DB4) and all of them are mirrored to Srv2.

An ASP.NET application has four seperate connection strings like:
objConn1 --> Data Source=Srv1;Failover Partner=Srv2;Initial Catalog=DB1;Integrated Security=True;
objConn1.connect();

objConn2 --> Data Source=Srv1;Failover Partner=Srv2;Initial Catalog=DB2;Integrated Security=True;
objConn2.connect();

objConn3 --> Data Source=Srv1;Failover Partner=Srv2;Initial Catalog=DB3;Integrated Security=True;
objConn3.connect();

objConn4 --> Data Source=Srv1;Failover Partner=Srv2;Initial Catalog=DB4;Integrated Security=True;
objConn4.connect();

If DB2 failsover to Srv2 (mirror), why should all other DBs be failedover?

Thanks

View 10 Replies View Related

SSIS Password Expose In SQL Agent Job Script??

Jan 4, 2007

Hi..

Isn't this a bug?



Step 1) Create a package with ProtectionLevel = EncryptAllwithPassword or EncryptSensitivewithPassword, and set password in package.



Step2) In SQL Server Agent, Create a Job to call a package.



Step 3) IN SQL Server Agent, Scripting Job. In script, package password shows up...





---------------------------------------------------------------------------------------------------------------------------

USE [msdb]
GO
... ...


@os_run_priority=0, @subsystem=N'SSIS',
@command=N'/FILE "D:PackageWithPassword.dtsx" /DECRYPT "P@ssw0rd" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF',
@database_name=N'master',
@flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave


... ...


View 1 Replies View Related

Enable AlwaysOn Availability On All Instances Or Single Instance?

Oct 17, 2014

Do you need to enable Always on Availabilty on all the instances or only the instance you need to ?. We have 4 instances on a 5 node cluster and we only need one instance for the Always on to be enabled. Do we need to enable on all 4 instances ?

View 4 Replies View Related

SQL 2012 :: Mirroring Multiple Databases On Single Instance?

Jun 10, 2014

I have to mirror 3 DBs on my sql server instance . I have restored there full backups and log backups on mirror.I have also created endpoints on principal and mirror using default ports 5022 and 5023.

know if i can use the same endpoint for the databases on principal instance ?

View 3 Replies View Related

SQL 2012 :: High CXPACKET On Single CPU Database Instance

Jul 2, 2015

Why would I see high CXPACKET waits on a database instance with only one CPU? Since the server only has 1 CPU parallelism can't be used, or are I'm missing something here!?

SQL version
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

max degree of parallelism is set to 0

View 5 Replies View Related

Recovery :: How Many Databases Can Be Configured In Log Shipping From A Single Instance

May 1, 2015

SQL Server 2012: Out of all the databases in the instance we have a requirement in which we need to maintain a high availability for the databases around (128). Our team believed log shipping will apt for this requirement but not sure on it's limitations, how many databases are allowed or supports this log shipping from a single instance.

View 7 Replies View Related

Transact SQL :: Find Single Largest Table In Entire Instance

Nov 16, 2015

I usually go for the largest datafile and then query in-there...But now I need to automate it for several instances... I need to be able with one script quickly retrieve the top 5 largest tables for the entire instance,not by database...

View 3 Replies View Related

Is It Possible To Create More Than One Instance In SQL 7.0?

Dec 8, 2000

Hi everybody,

In Oracle, we can create any no. of instances on a single machine and each instance will have
a separate database. Like that, is it possible to create more than one instance on a single machine.
and also is it possible to create instances in SQL Server Version 7.0.

Any help would be appreciated.

tks in advance,
Sri

View 2 Replies View Related

Create Second Instance

May 8, 2007

Hi to every one,

i am pavan working as Oracle DBA. now i am learning sqlserver2000.
b cos i need to maintain one sqlserver database.

i have one doubt. i installed sql server 2000 in my machine. now i want to creace second instance on same machie. how can i do it.

i heared we can maintain 32 servers in single machine in sql server

how can i create second instance.
and any one send me pdf /documentation on sqlserver 2000

thanks
pavan


pavan
Associate Oracle DBA

View 1 Replies View Related

Create A New Instance

Oct 18, 2007

Hi.

I have Ms project server 2007 and SQL Enterprise 2005. I want to create a OLAP cubes. I follow the installation guides but I don't have MSSQL.2 directory.

How i create this? I read it is necessary to create an instance, but how i do that? I'm not a expert in SQL.

Thanks
--
Hernandezz

View 1 Replies View Related

Can't Create A New Instance After SQL SP2

May 14, 2007

Hi I'm a newb with zero knowledge of SQL!

I have a SBS 2003 R2 Prem box with instances for Sharepoint, WSUS, MSFW and SBSMonitoring.

I have installed SP2 for SQL2005 but now I can't use the SBS CD to create a new instance or a default instance because it is an older version than SP2.



Can anyone advise how to create a default and/or new instance?



Many thanks in advance.

View 6 Replies View Related

Create New Instance

Nov 8, 2007

How i can create new instance for sqlserver 2005?

View 4 Replies View Related

When To Create A New Instance

Apr 25, 2007

I am using SQL Server 2005 and need to add a set of Database tables and other objects for each user of an application.



The simplest way seems to be to duplicate the database inside the same instance. What are the guidelines/pros/cons for determining when you should create a new named instance versus just adding more databases to the same instance.

Thanks,

Rick

View 5 Replies View Related

Help - How Do I Create A New Instance

Nov 16, 2006

Hi Guys



Im new to SQL and I need to create a new instance ???



Help

View 2 Replies View Related

How To Create A New Named Instance

Feb 3, 2006

Hi,

I did install SQL-server developer edition. During the installation it asked me the name of de instance. I let the installation create the default Named instance.

Now I want to add an instance with a new name. What is the best way to do this? Is this the same as creating a Notification service?

Doeb

View 6 Replies View Related

How To Create Instance Name And Password

Dec 26, 2007

In a previous answer about beginning to use SQL Server 2005 Studio you say "Mention your Instance name /user name and password to connect to the server. "

Please advise where I should go to creat the instance name and password. It appears my Studio is running but I have not been asked for an "Instance Name" or password. What, exactly, does instance name mean and how can I tell if I have everything installed correctly?
Thank you.

View 8 Replies View Related

Create SQL Server Instance

Feb 19, 2008

I've uninstalled SQL Server Express and installed SQL Server Enterprise, all the tools where installed, but it didn't installed any server (instance?), and the old {local}SQLEXPRESS is still there, but it really doesn't exist.

- I look up at mipc/manage and there's no sql server running.
- I try to add an instance using the surface configuration, but it gave my this error:





Code Snippet

No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)
How do I completly remove sql server from my computer, or, how do I add an instance of sql server?

View 4 Replies View Related

How Can I Create A New Instance Under SQL 2005?

Aug 10, 2006

I have a clean SQL 2005 install, and would like to setup a new/empty instance for an application suite (3rd party) to reside in.

Is there any way to do this?

View 5 Replies View Related







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