RDA With Terminal Service On PPC ?
Mar 14, 2008I need to know Terminal Service on ppc it bester than RDA ?
Some one use terminal service on ppc
some one use RDA
Brg ,
ADVERTISEMENT
Terminal Service Manager
Jul 18, 2006I opened up Terminal Service Manager on my SQL Server to close out someghost connections. Then I minimized the application. After working onsome other issues. I right clicked on the minimized icon of TerminalService Manager on my tool bar and closed it. Now when I go toStart/Admin Tools/Terminal Service Manager, it opens up minimized and Ican't get it to maximize to close out ghost connections. The only wayI can close it is to go to the task manager and kill it from there.I've rebooted my server and I still have this problem when I openTerminal Service Manager. Does anyone have a solution for this?
View 2 Replies View RelatedTerminal Service Cause TimeOut Expired
Nov 9, 2005Hi All,I have a problem with my Server since I've install Terminal Services.Sometimes my users get error 'Timeout expired' when trying to query oropen program. Whatshould I do to increase the performance?Thanks
View 1 Replies View RelatedSQL And Terminal On 2 Different PC's
Apr 21, 2006In the past I have had SQL and Terminal server on the same PC.With SQL and Windows 2003 Terminal server, you can not have them on thesame PC.How can I make this work with SQL and Terminal and 2 different PC's? Ihave 30 users that need to log on to my SQL database.
View 3 Replies View RelatedSQL 7.0 SP 3 And Terminal Server
Feb 27, 2001Has anyone else found problems with their Terminal server after installing SP 3 for SQL 7.0?
Our users permissions changed for their printers and ODBC was giving all kinds of cryptic
error messages. When the users rights were changed from Domain User to Domain Admin
everything works fine. We have been able to reproduce this on numerous servers.and always
after we applied the SP did the problems start.
SQL And Terminal Server On 2 Different PC's
Apr 21, 2006In the past I have had SQL and Terminal server on the same PC.With SQL and Windows 2003 Terminal server, you can not have them on thesame PC.How can I make this work with SQL and Terminal and 2 different PC's? Ihave 30 users that need to log on to my SQL database.
View 1 Replies View RelatedTerminal Session Name
May 9, 2006Is there any way in stored procedure to find out a name of terminal session initiated connection to SQL Server?
Thanks for response
SQL 2000/Terminal Services Compatability
Oct 11, 2001I need to know if Microsoft supports SQL Server 2000 running on the same server that functions as a Terminal Server (both NT and Windows 2000).
I checked out Microsoft.com and found that SQL Server 7 is supported with NT Terminal Services but can't locate any compatability information SQL 2000.
PS: I know this configuration doesn't make sense from a performance perspective but my customers will want to do this anyway.
Thanks!
Odbc Errors On Terminal Server
Jul 23, 2005We connect via terminal services to an excel spreadsheet that has anODBC link to an access database using a pivot table, when we try torefresh the data within the excel spreadsheet we receive the followingerror "the microsoft jet database engine cannot find the input table orquery....."this works ok if the user connects to terminal services as theadministrator however if they connect as any other issue it won't workAnyone got any ideas?(have tried 2000 ts and 2003 ts)
View 3 Replies View RelatedWindows Terminal Server 2000
Jun 26, 2007Hi,
I currently have a Compaq ProLiant DL360 server running with Windows Terminal Server 2000. I want to switch to a Dell server, but the old server contains 5 terminal users. How can I switch the license to the Dell server?
Font Dependencies Over Terminal Sessions?
Feb 15, 2008I just have a simple question on font dependencies in reference to deployed reports. In my company, we run citrix presentation servers feeding terminal sessions out to users in remote areas.
My question is, in a terminal session, do the fonts used in the reports need to be installed on the users' local machine (who is connecting via terminal session) or is it enough to just have it on the servers feeding out the terminal session?
For example, we create a report with Arial Narrow font. Our servers hosting citrix presentation server did not have this font installed, so we installed this font on the servers (thus they're displaying correctly). Obviously the server hosting our reporting services has the font. Now a user connects to the server, is granted a terminal session, launches reporting services, report is generated with the correct font displayed, and finally prints the report.
Will the report print in Arial Narrow if the users' local machine doesn't have this font install? I remember reading somewhere that the fonts do not embed, hence the reason for installing the font on our citrix servers.
I realize this is kinda out of the scope of this forum, but perhaps someone on here uses terminal services and can answer this for me. I do plan to test this out when I get home tonight. I'd test it right now, but my computer at home isn't on therefore I can't remote home (plus wake-on-lan isn't configured) to do an actual test. Just thought I'd get some insights from other people.
Thanks in advance!
ReportViewer Not Printing Under Terminal Services
Aug 16, 2007I have written an application with VB.Net. It display a report written using Reporting Rervices (rdl) in the ReportViewer Contol. When I run the application locally under windows, I can print the report just fine. When I run it under Terminal Services, sometimes it takes 2 or 3 times to print. Sometimes it never does. It looks like it prints the pages because the popup displays and it shows it is printing but it never does.
If I bring up the queue for the printer to watch when I print, then click the Print button on the the ReportView contol, I see the print enter the queue on the printer and then it is deleted but nothing prints. If I do it all again, the same thing happens but it may or may not print.
The applicatoin is written in VB.Net under Visual Studio Professional SP1.
Any and all assistance is greatly appreciated!!
SQL Server And Terminal Services Application Mode
Aug 11, 2006Hello!
I am specifically looking for a KB article, best practice, white paper etc, that states it is not recommended that SQL Server (either 2000 or 2005) is installed on a WIndows 2003 Server that is also running Terminal Services in application mode.
Is there such a document or reference?
Thanks,
David Noal
MCP
Hanging Or Lockup Issue With SQL Server And Terminal Services 2000 On NT 4 Domain Server
Jul 20, 2005Hi all,Have a situation that my company has never run across before. Clientis running NT4 for the domain server, using terminal services 2000 andrunning an application with a SQL Server backend and they areexperiencing locking problems. Once one person gets locked out theneveryone trying to access that tables is also locked out as a result.It is not specific to a certain User, or module within theapplication. It's not a specific time of the day (like when a backupwould be running) and sometimes it's in the middle of the night whenthere are actually less Users on the system.We have 500 customers using this application. Most are using SQLServer backend, alot of the newer customers are using TerminalServices, and the number of Users is not accessive as compared to ourother customers. THe only difference is that I do not specificallyknow of another client with an NT4 Domain server in the mix.We actually switched to SQL Server as the recommended back end due tolocking issues using SQLBase because SQL Server is row locking andSQLBase is page locking. Since making this change we have stoppedseeing the locking for years until now. Is this a SQLServer issue orissue with the NT Domain server?Anyone have any ideas???ThanksA
View 3 Replies View RelatedSQL Server &&<-&&> Terminal Server
May 25, 2006Hi,
Is it possible to setup terminal server on the box running SQL Server 2005 already.
And vice versa?
I have windows server 2003 standard edition.
Thanks
The SQL Server (SQLEXPRESS) Service Terminated With Service-specific Error 10013.
Jul 12, 2007I have an almost virgin install of SQLExpres running on a WIN2K Pro system.
Have been able to create and connect db to Access 2000 without problem.
Now I wish to extend to remote connections. Using Surface Area Configuration tool, I changed Remote Connections to Local and Remote.
Whenever this setting contains TCP/IP and I try to restart the service I receive the following errors:
System Log:
The SQL Server (SQLEXPRESS) service terminated with service-specific error 10013.
Application Log:
Server TCP provider failed to listen on [ 'any' <ipv4> 0]. Tcp port is already in use.
TDSSNIClient initialization failed with error 0x271d, status code 0xa.
TDSSNIClient initialization failed with error 0x271d, status code 0x1.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
If I change back to Local Connections Only or Local and Remote using named pipes only, the service starts up again without a problem.
After five days of investigating, researching, reinstalling and waiting I have to ask for help.
Any suggestions or leads?
Thank You in advance.
Power Pivot :: Cannot Create Service Instance Because Parent Service Does Not Exist
Sep 28, 2013I have a VM with SP2013 and SQL Server 2012 SP1. I have installed the powerpivot plugin SP1.But when I run the PowerPivot for SharePoint 2013 configuration tool.
View 3 Replies View RelatedWhat Permissions Are Required For SQL Server Service Account To Call Web Service Using CLR Integration?
May 18, 2007Hello! I have the following problem. I developed CLR Stored Procedure "StartNotification" and deploy it on db. This sp calls external web service. Furthermore, this sp is called according with SQL Server Agent Job's schedule. On my PC SQL Server works under Local System account and this web service is called correctly (Executed as user: NT AUTHORITYSYSTEM). But on ther other server the following exception is raised during job running:
Date 17.04.2007 16:42:10
Log Job History (FailureNotificationJob)
Step ID 1
Server MSK-CDBPO-01
Job Name FailureNotificationJob
Step Name MainStep
Duration 00:00:00
Sql Severity 16
Sql Message ID 6522
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: CORPmssqlserver.
A .NET Framework error occurred during execution
of user defined routine or aggregate 'StartNotification':
System.Security.SecurityException: Request for the permission of type
'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand,
StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.CodeAccessPermission.Demand()
at System.Net. The step failed.
What is the reason of this behaviour? Unfortunately I do not have direct access to this server.
I have the following guesses:
1) CORPmssqlserver may have not enough permissions to call web service
2) Something wrong with SQL Server account's permissions
2) Something wrong with SQL Server Agent account's permissions
I will take the will for the deed. Thanks.
X-ref Documentation For DTS-package,views,tables,Reporting Service,Analyze Service
Mar 27, 2006We are using the whole BI-package from Microsoft - from SQL, DTS-package,Raporting Service and Analyze Service.
It should be very helpful to be able to create a metadata databases where you could find all releations between different objects (tables,views,reports,cubes,DTS-package,Databases.
Just to get answer for: 'where is view xxx used', 'what are Report xxx depending upon'.
While everything exists in different SQL databases it should possible to do.
Has anyone any comments or the same needs ?
Conversation Handle Processed By An Activated Stored Procedure Service Can Not Be Invoked By A CLR Service Instance?
Dec 1, 2006I have a initiator and a target service broker peer.
Both are controlled by a C# unit test. The initiator uses the Microsoft.Samples.SqlServer class. The target service uses stored procedure activation.
Sending a message from the initiator to the target, saves the content of the message, along with its conversation handle in the target's database specific table.
The unit test needs - at a later time - to instruct the target to send a message back on the same conversation handle to the initiator service.
For this the C# unit test creates a Conversation off of the saved conversation handle:
Service client = new Service("cleintservicename", conn, tran);
Conversation dialog = null;
dialog = new Conversation(client, convHandle);
Sending the message on this dialog generates an error "Message body: <Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8495</Code><Description>The conversation has already been acknowledged by another instance of this service.</Description></Error>".
Is the error due to the fact that a service - using the activated stored procedure already picked up the conversation, so that a new reference to the service can not be created through the Service class in CLR?
If so, I might need then to skip the activated stored procedure in favor or a CLR service, alltogether?
Any help - greatly appreciated.
An Error 1069 - )The Service Did Not Start Due To Logon Failure) Occurred While Performing This Service Operation ...
Oct 10, 2007Hi All,
We seem to be being plagued by the error below by our SQL Server agent. This happens almost everytime we restart the server that has been running for a day or two.
Our SQL Server Agent uses a none expiring domain credential. I understand that this problem only happens when the profile being used by the SQL Servr Agent has changed (password change). What puzzles me is that the login is A ok and no changes has been made to it's password.
We always resolve this problem by changing the login used in the SQL Server Agent to local and after that, returning it back to it's original domain login. Unfortunately, we cant always do this everytime something goes wrong.
Can anyone please help us shed a light on this? We're using SQL2k with SP3a. Thanks!
Error:
An error 1069 - )The service did not start due to logon failure) occurred while performing this service operation on the SQLServerAgent service.
Regards,
Joseph
Service Broker TO Service Could Not Be Found Message Origin: Transport
Mar 30, 2007I am trying to send a message between to SQL Server 2005 instances on two different machines. I have checked all my routes and all my objects appear to be setup correctly. However, when running Profiler on the target machine, I receive the "This message has been dropped because the TO service could not be found. Service name: "[tcp://mydomain.com/TARGET/MyService]". Message origin: "Transport". This is my activated stored procedure that is sending the message to the target service. I am using certificate security. Any help appreciated....
CREATE PROCEDURE [usp_ProcessMessage]
AS
BEGIN
SET NOCOUNT ON;
DECLARE @conversation_handle uniqueidentifier
DECLARE @message_body AS VARBINARY(MAX)
WHILE (1=1)
BEGIN
BEGIN TRANSACTION;
WAITFOR(RECEIVE TOP (1)
@conversation_handle = conversation_handle,
@message_body = message_body
FROM [tcp://mydomain.com/INITIATE/MyQueue]
), TIMEOUT 1000;
IF (@@ROWCOUNT = 0)
BEGIN
COMMIT;
BREAK;
END
END CONVERSATION @conversation_handle
IF @message_body IS NOT NULL
BEGIN
BEGIN DIALOG CONVERSATION @conversation_handle
FROM SERVICE [tcp://mydomain.com/INITIATE/MyService]
TO SERVICE '[tcp://mydomain.com/TARGET/MyService]'
ON CONTRACT [tcp://mydomain.com/INITIATE/MyMessage/v1.0]
WITH ENCRYPTION = ON, LIFETIME = 600;
SEND ON CONVERSATION @conversation_handle
MESSAGE TYPE [tcp://mydomain.com/TARGET/VisitMessage]
(@message_body);
END
COMMIT;
END
END
GO
My endpoints are created like so:
CREATE ENDPOINT MyEndpoint
STATE = STARTED
AS TCP
(
LISTENER_PORT = 4022
)
FOR SERVICE_BROKER (AUTHENTICATION = CERTIFICATE MasterCertificate)
GO
GRANT CONNECT TO CertOwner
GRANT CONNECT ON ENDPOINT::MyEndpoint TO CertOwner
GO
And my routes like so:
GRANT SEND ON SERVICE::[tcp://mydomain.com/INITIATE/MyService] TO CertOwner
GO
CREATE REMOTE SERVICE BINDING [MyCertificateBinding]
TO SERVICE '[tcp://mydomain.com/TARGET/MyService]'
WITH USER = CertOwner,
ANONYMOUS=OFF
CREATE ROUTE [tcp://mydomain.com/INITIATE/MyRoute]
WITH SERVICE_NAME = '[tcp://mydomain.com/TARGET/MyService]',
BROKER_INSTANCE = N'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx',
ADDRESS = N'TCP://xxx.xx.xx.xx:4022'
GO
How To Use SSMSE To Connect To Instance Service Directly (without Going Through Browser Service)?
Apr 28, 2006I have configured an instance to use static port, say 1435, and I turned off the Browser service.
I would like to know if I can use SSMSE to connect to the instance database directly. The instance is listening at port 1435 and accepting connection requests from other methods.
What I need to put into the "Server name: " field?
Normally, it would be like: <serverIP><InstanceID> with Browser turned on.
Now how do I add the port information to it, I tried
<serverIP>:<portNumber><InstanceID>
<serverIP><InstanceID>:<portNumber>
<serverIP><InstanceID> <portNumber>
None of them worked.
Any suggestions?
Thanks.
Does The SSRS Web Service And Windows Service Share A Common Engine?
Sep 27, 2007All,
I am looking at implementing some sort of throttling whereby "expensive" reports are setup as Subscriptions (and hence are run by the Windows Service), while all other requests go the Web Service.
My question is:
Do the two systems share any underlying systems? I understand (of course) that they use the same DB, etc. etc. However, I can't quite tell whether there is an underlying engine that is a common base or if they really just spin up different instances of the same objects and essentially each host the application separately?
Any help is greatly appreciated!
Mark
SQL Security :: Default Login NT Service Required When Using Service Accounts?
Jul 9, 2015I am currently hardening our SQL 2012 (with AlwaysOn Availability Groups) environment. Both the SQL service and agent account are using service accounts (only domain user). SQL browser service is disabled. Permissions to all roles are handled by using domain groups.
Currently a lot of (default) NT Service accounts are listed (some with sysadmin privileges). Are there accounts that can be removed?
User Account Per SQL Server Service && SQL Agent Service, Why?
Jul 30, 2007Hi all,
I do understand that it is highly recomended to have aserprate user (perfered a domain user account) for each of the SQL Server service and SQL Agent service.
What is the reason behind that? (Someone told me to not run the service with an account that has a powerul privilegs! - I don't undrstanmd this point can you explain it please?)
What is the diffrent between: 1- Local System account 2 -Network Service account
Thanks in advanced!
CS4Ever
How To Connect To Analysis Service Database Through Reporting Service?
Mar 31, 2006Hello,
In our project, we would like to use the same data source for our analysis service database cubes and for our reporting service reports.
I created the analysis service project first, deployed successfully. When trying to setting up the data source in the report model project, I selected the "create a data source based on another object", and then selected the "create a data source based on an analysis service project". However, there is no analysis service project to select, and no browse button to see where the reporting service is looking for analysis service project either.
I have tried creating a new analysis service project with data source views, cubes, dimensions and all the stuff, but still cannot see the analysis service project in the drop down box to be selected for my reporting model project data source.
As I am fairly new to the reporting service, I'm sure I'm missing something, but couldn't find much information in the help or on the web. Any suggestion would be much appreciated.
Thank you very much,
Annie
SQLSERVERAGENT: The Specified Service Does Not Exist As An Installed Service.
May 18, 2007Hi,
I am trying to install MS Sql Server 2000 on my machine. The OS on my machine is Windows XP SP2. During the installation i keep getting an error message, "Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information." I have copied an extract from the sqlstp.log file below:
10:05:28 Process Exit Code: (-1)
10:05:31 Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information.
10:05:31 Action CleanUpInstall:
10:05:31 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
10:05:31 Process Exit Code: (1060) The specified service does not exist as an installed service.
10:05:31 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
10:05:31 Process Exit Code: (0)
10:05:31 StatsGenerate returned: 2
10:05:31 StatsGenerate (0x0,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0
10:05:31 StatsGenerate -1,531793)
10:05:31 Installation Failed.
Can someone please help me solve this problem?
Cheers...
Amazon Web Service Call With Web Service Task
May 4, 2006With the new improvments to the web service task, we can now use variables as arguments in web service calls. I am trying to setup a call to the amazon web service ECS. I am trying to do a simple sellerlookup. I have played with the settings and gotten nowhere. I get one of two error when I try to execute. I can always use a scripting task or write my own task, but I would like to use the built in task if it is possible. Has anyone used AWS with SSIS?
[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
or
[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.AWSECommerceService.SellerLookup' not found.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
Running SQL Service Under Network Service Account
May 15, 2007Microsoft recommends that you do not use the Network Service account to run the SQL Server service (see http://msdn2.microsoft.com/en-us/library/ms143504.aspx).
Can anyone tell me what the drawbacks are of doing this?
TFSREPORTS Service Account Does Not Have The Necessary User Right Log On As A Service.
Dec 12, 2007Okay now this is weird, today the Reporting Services was not running and here are the entries in the event log:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7041
Date: 12/12/2007
Time: 9:47:22
User: N/A
Computer: TFS
Description:
The ReportServer service was unable to log on as DOMAINTFSREPORTS with the currently configured password due to the following error:
Logon failure: the user has not been granted the requested logon type at this computer.
Service: ReportServer
Domain and account: DOMAINTFSREPORTS
This service account does not have the necessary user right "Log on as a service."
User Action
Assign "Log on as a service" to the service account on this computer. You can use Local Security Settings (Secpol.msc) to do this. If this computer is a node in a cluster, check that this user right is assigned to the Cluster service account on all nodes in the cluster.
If you have already assigned this user right to the service account, and the user right appears to be removed, a Group Policy object associated with this node might be removing the right. Check with your domain administrator to find out if this is happening.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp
I am the administrator of the machines and I can assure you that no domain policy has changed for a couple of weeks. What should I look for?
Service Broker And .net Windows Service
Sep 26, 2007I am doing some research to see if the Service Broker technology would help my company with our Enterprise application. Here is our scenario: We have a 3 tier system. The first tier needs to contact the second tier asynchronously. Hence, using queues is a good option. However, the process that needs to happen on the second tier is mostly process intensive with little database updates. Is it still worth our time to use Service Broker?
I like the concept of Activation that Service Broker provides. But, from what I am reading most of the documentation describes activation as a way to call another stored proc. I definitely dont' want to do any process intensive work on the SQL server. So here comes my question...
How would I use a windows service to listen to the activation event from the Service Broker. I could have multiple windows services watching the same queue (scalable). Would I have to handle collisions myself? If so, I think I would rather keep it simple, and just use a simple table as my queue.
Thanks for your comments in advance...
Vijay.
How To Prevent The Hang On The Initator Service Broker If The Target Service Broker Is Not Started?
Sep 10, 2007How to prevent the hang on the initator service broker if the target service broker is not started?
Our case has two service brokers (two databases), sometime, the target is need to turn off. But the sitation is the initator service broker (in fact, the message is sent from triggers) become hang, I want to prevent this case and continue to operation, and the messages should queue and will continue to send to target service broker when it startup. How should I do?